| 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
Try
=SUBSTITUTE(A1," ",) If this post helps click Yes --------------- Jacob Skaria "Confused" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
