remove blanks from a string of chars within a cell?

trim

--
Don Guillett
SalesAid Software
donaldb@281.com
"rayhollidge" <rayhollidge@discussions.microsoft.com> wrote in message
news:846DD838-1EA5-42F3-BD8B-D1AD481D181F@microsoft.com...
>

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" <rayhollidge@discussions.microsoft.com> wrote in message
news:846DD838-1EA5-42F3-BD8B-D1AD481D181F@microsoft.com...
>

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 (&nbsp 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" <rayhollidge@discussions.microsoft.com> wrote in message news:846DD838-1EA5-42F3-BD8B-D1AD481D181F@microsoft.com...
>