R
ROLG
within a cell how do you remove spaces betwwen numbers??
1 2 3 4 to 1234
thankeveryone for their help
1 2 3 4 to 1234
thankeveryone for their help
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
Otto Moehrbach
You can do it several ways. The easiest is to select the cells to which you
want to do this. Then do Edit - Replace. In the "Find what:" box, type a
space. Just hit the space bar once. In the "Replace with:" box, do
nothing. Click OK. That's it. HTH Otto
want to do this. Then do Edit - Replace. In the "Find what:" box, type a
space. Just hit the space bar once. In the "Replace with:" box, do
nothing. Click OK. That's it. HTH Otto
M
mzehr
In addition to what Otto suggested, consider using the
Trim() and Clean() Functions.
Also check out:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
Trim() and Clean() Functions.
Also check out:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
O
Otto Moehrbach
Mzer
I haven't tried it but I think the Trim command will leave one space
between any two characters that have one or more spaces between them. Otto
I haven't tried it but I think the Trim command will leave one space
between any two characters that have one or more spaces between them. Otto