| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Using a function with numbers & text
I have 6 columns, B has numbers + text (3d, 6c, ad, kd) C has numbers + text
( 3 down, 6 cube, alternate dialog) I want to input into D 6c and have the return in E be 6 cube, or ad input/alternate dialog output. I have over 60 input/output codes. I tried the IF function but it won't work with text. Is there a function that will accomplish this? TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating function using numbers & text | Excel Worksheet Functions | |||
| does an IF function only look up numbers & not text? | Excel Discussion (Misc queries) | |||
| function to convert whole numbers to written text | Excel Worksheet Functions | |||
| How do I set up an IF function with text and numbers? | Excel Worksheet Functions | |||
| numbers to text function | Excel Worksheet Functions | |||
Threaded Mode
