September 15th, 2003, 09:44 AM
|
|
Trim function limitations
=SUBSTITUTE(A1," ","")
"Boz.theale" wrote in message
...
I have imported text from another application and want to convert the
contents of cells into a continuous string - ie like trim but removing
all spaces, including those between words.
Eg I want a formula that will convert ABC 123 into ABC123.
Can anyone suggest a solution?
Thanks in advance
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
|