Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert numbers to words, 3=ship, so if I enter 3, it says ship.
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert numbers to words, 3=ship, so if I enter 3, it says ship.
Ctrl + H is find and replace, find "3", replace with "Ship" etc.
"Erin Briana" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert numbers to words, 3=ship, so if I enter 3, it says ship.
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert numbers to words, 3=ship, so if I enter 3, it says ship.
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 wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Take one sales order and compare all ship dates for that order. | Excel Discussion (Misc queries) | |||
List items with different ship dates separate on pivot table | Excel Discussion (Misc queries) | |||
numbers convert into words | Excel Discussion (Misc queries) | |||
How do I save Ship to and Bill to information? | New Users to Excel | |||
UPS Ship Log | Excel Discussion (Misc queries) |