Remove Spaces from String

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

I have a cell that contains text and I want to use that text in another cell, but
I want to remove all spaces from that text. Is there a function that does this?

Example: Fond du Lac

I want it to read: FondduLac
 
Hi

Try this:
=SUBSTITUTE(A2," ","")
Once you are happy with the result you can 'fix' the values, if necessary,
by copying the range and then using Paste Special . . Values

--
Andy.


I have a cell that contains text and I want to use that text in another
cell, but
I want to remove all spaces from that text. Is there a function that does
this?

Example: Fond du Lac

I want it to read: FondduLac
 
Try: =SUBSTITUTE(A1," ","")
where A1 contains the text
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
I have a cell that contains text and I want to use that text in another
cell, but
I want to remove all spaces from that text. Is there a function that does
this?

Example: Fond du Lac

I want it to read: FondduLac
 
How about using Find - Replace (Ctrl-H), and make it find " " an
replace with "" (remove quotes)? If you only want it to change fo
specific cells, simply highlight them
 
Edit>replace, find what <space>, leave replace with empty

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


I have a cell that contains text and I want to use that text in another
cell, but
I want to remove all spaces from that text. Is there a function that does
this?

Example: Fond du Lac

I want it to read: FondduLac
 
Back
Top