Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Want to split 922 037 022 into 3cols and recombine without spaces
I have some employee numbers in the format 923 022 033. I want to put the
numbers together without spaces. I split into cols and then recombined but the leading zeros were missing. So instead of getting 922037022 I get 9232233. Any solution |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove split a split window? | New Users to Excel | |||
how to set tab spaces in excel? | Excel Discussion (Misc queries) | |||
how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
Spaces | Excel Worksheet Functions | |||
spaces not recognized as spaces | Excel Worksheet Functions |