D
Don Guillett
trim
K
Ken Wright
All the blanks?
=SUBSTITUTE(A1," ","")
Lots of cells and permanently - Select range and use Edit / Replace,
replacing space with nothing.
=SUBSTITUTE(A1," ","")
Lots of cells and permanently - Select range and use Edit / Replace,
replacing space with nothing.
D
David McRitchie
Hi Ray,
When posting please include the question in the text body.
Not everything that appears to be a space is a space, frequently
when copying from HTML you will copy a non-breaking space
character ( 
or char(160) also known as a required blank (RBL)
in some places.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
When posting please include the question in the text body.
Not everything that appears to be a space is a space, frequently
when copying from HTML you will copy a non-breaking space
character ( 
or char(160) also known as a required blank (RBL)in some places.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall