| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove spaces at the beginning of cells?
I have a column of names I need to sort. Unfortunately, some of the cells
have 1 or 2 leading spaces, which cause the zero-leading spaces to be sorted, then the one-leading space, then two-leading space. And since there are over 3000 names to be sorted, doing them by hand is problematic. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you remove leading spaces etc in cells? | New Users to Excel | |||
| how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
| How can I insert 2 spaces at the beginning of each of 1300 cells? | Excel Discussion (Misc queries) | |||
| Remove Spaces beginning Time entry | Excel Discussion (Misc queries) | |||
| how do I remove spaces from cells that were pasted | Excel Discussion (Misc queries) | |||
Threaded Mode
