Excel: Find/Replace Question 1

[Airbiskit]

Hi,

I have a column of numbers ranging from 1 to 15. Each number indicates a location name. I would like to conducted a find/replace on each of these numbers and change it to the location name. e.g. the number "1" becomes "London"

If I try to find the number "1" its replaces every "1" in the column, replacing say "11" with "LondonLondon".

Would you happen to know the correct syntax for doing this ?

Many Thanks

 

[GlennUK]

Change the 2 digit numbers first!

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Airbiskit]

Thanks Glenn, Why didn't I think of that!!! /bow