| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Converting values to text
=LOOKUP(A1,{1,2,3,4,5},{"Dog","Cat","Rat","Pig","D ugong"})
Gord Dibben MS Excel MVP On Sat, 4 Oct 2008 20:26:42 +0100, "Keith Rathband" wrote: I have a load of values which i want to convert to text, the text will depend on the value. ie If value=1, text = DOG If value=2, text = CAT If value=4, text = PIG Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting hourly values into daily values | Excel Worksheet Functions | |||
| Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
| Converting Numeric values to Text | Excel Worksheet Functions | |||
| Converting Text Values to Dates | Excel Discussion (Misc queries) | |||
| Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) | |||
Hybrid Mode
