| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search for a partial number
I have account numbers and the first three numbers determine the location of
the account. What I would like is to have a formula that reads the first three numbers of the of all the account number and then assign the name of the account in an adjacent cell. 9895254 would be a "Retail" account 8892532 would be an "Expense" account etc... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search string for number value | Excel Discussion (Misc queries) | |||
| Search number within a database | Excel Worksheet Functions | |||
| Partial string search w/o VBA? | Excel Discussion (Misc queries) | |||
| search for number in excel | Excel Discussion (Misc queries) | |||
| Partial search and replace? | Excel Discussion (Misc queries) | |||
Threaded Mode
