| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for a Function? similar to LEFT
I have a list of org unit names that are always preceded by a 3 digit number.
How can I just show the text and not the numbers? Example: 001 Org Unit Name *note* there is also always a space after the 3 digits. In this example I only want a column to display "Org Unit Name." Help? KR P.S. I looked through other posts and did not see anything readily similar. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LEFT function-all to left of a comma? | Excel Worksheet Functions | |||
| In Excel, can I use the VALUE() function or similar for text? | Excel Worksheet Functions | |||
| Left vs Left$ function | Excel Discussion (Misc queries) | |||
| Help with sumproduct or similar type of function | Excel Discussion (Misc queries) | |||
| A similar =proper function | Excel Discussion (Misc queries) | |||
Threaded Mode
