| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trim
Hello,
I have hundreds of accounts listed in a column that look like this: 02172-LIPOSCIENCE-02172 I need to pull out the first five digits from the column 02172 I cannot drop the first digit (zero), so I guess it would need to be trimed As a text? Can someone help me with this formula? Thanks so much |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =TRIM | Excel Discussion (Misc queries) | |||
| Using =TRIM() | Excel Worksheet Functions | |||
| Trim | Excel Worksheet Functions | |||
| Trim if? | Excel Worksheet Functions | |||
| Trim help please | New Users to Excel | |||
Threaded Mode
