Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In my spreadsheet there is a column that contains number, 3 on the left,
space, 3 on the right. I want to remove that space. Rather than doing this in three steps, taking left, then taking right, then joining those together, is there an easier way to accomplish the same thing. It currently looks like this 216 123 I want it to be this 216123 I'm sure there is an easier way, but I only know how in three steps. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
removing all spaces | Excel Discussion (Misc queries) | |||
Removing spaces in cell | Excel Worksheet Functions | |||
removing spaces | Excel Discussion (Misc queries) | |||
how to remove spaces in a middle of a cell example '25 566 589. | Excel Discussion (Misc queries) | |||
Removing Spaces in a Cell | Excel Worksheet Functions |