Ethnicity - Match code to a word in Excel
I know itís probably easy, but I have been asked to collect all the data we hold on staff and their ethnicity, age, etc. and dump it into a spreadsheet.
I have managed to get all of the information out of our 15 year old database system, but it records ethnicity as a code, rather than an actual word. I know this is quite common in these systems.
I know what code stands for what ethnicity, 1=white British for example, But does anyone know how to make Excel match up a number with a word and produce the result in a new cell?
It would save me a lot of time and I would really appreciate if someone could help on this.