| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a formula using part of the data in 1 cell?
I am trying to create a conditional formula that will look at the first three
characters in a cell and determine a value based on that. Here are four examples of the data I am looking at and the values I need returned for each: Data Value returned should be TAD12345 Ab TED1263 Ed TAC25462 Ab CI TAT9456 Ab TRM I need a conditional formula that will look at the first three letters in each of these and return the value based on that. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Any cell containing formula seen as data instead of formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
