Convert numbers to words, 3=ship, so if I enter 3, it says ship.

[Erin Briana]

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.

 

[Sam Wilson]

Ctrl + H is find and replace, find "3", replace with "Ship" etc.

 

[Peter T]

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

 

[Gord Dibben]

VLOOKUP formula and a lookup table?

Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on
value. Note the downloadable sample workbooks.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for info on Data Validation selection lists for inputting
the data if need be.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 07:45:01 -0700, Erin Briana <Erin