A simple way would be with a Lookup formula in an adjacent (or nearby)
column to your numbers. Eg enter your number in A1 and put this in B1 and
copy down.
=VLOOKUP(A1,List,2)
"List" is a 2 column wide named range that contains your numbers and words
Later you could copy the formula cells and pastespecial values back if you
want.
Regards,
Peter T
"Erin Briana" <Erin
wrote in message
...
I have a huge list of numbers that each signify a different place. How can
I
covert this is excel without doing it myself- looking up the location from
the code and typing it in- too time consuming.