| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
remove leading zeros from text strings
I have a long list of text strings and would like to remove leading zeros,
returning each string with zeros removed. Is there an easy way to do this using excel text functions? ie. 00234 234 02569 2569 etc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leading zeros | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
| remove spaces in text in excel | Excel Discussion (Misc queries) | |||
| Remove single text characters | Excel Discussion (Misc queries) | |||
| Displaying leading zeros in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
