trim

--
Don Guillett
SalesAid Software

"rayhollidge" wrote in message
...

All the blanks?

=SUBSTITUTE(A1," ","")

Lots of cells and permanently - Select range and use Edit / Replace,
replacing space with nothing.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"rayhollidge" wrote in message
...

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"rayhollidge" wrote in message ...