Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Leading Spaces
I am trying to create a formula to remove the leading space and 0 from a
series of numbers imported into Excel from a Purchase Order. I have tried using the trim function, but it didn't work. I could easily correct with the replace function, but I want a formula that I can use repeatedly (some of the POs can be quite large) to quickly clear the import error. example: I import: 01827245 02445313 I need: 1827245 2445313 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
Trim Leading Spaces | Excel Worksheet Functions | |||
Removing leading/trailing spaces | Excel Discussion (Misc queries) | |||
How do I add leading spaces to a value? | Excel Worksheet Functions | |||
Remove Leading Spaces | Excel Discussion (Misc queries) |