I have a list of company names in excel and need to remove all spacing. e.g.
"care homes ltd" needs to be "carehomesltd" if there a formula that will
remove this spacing?

=SUBSTITUTE(A1," ","")

--
Gary''s Student
gsnu200711

One way:

=SUBSTITUTE(A1," ","")

In article ,
jamesea wrote:

I have a list of company names in excel and need to remove all spacing. e.g.
"care homes ltd" needs to be "carehomesltd" if there a formula that will
remove this spacing?

How about just selecting the range to fix and
Edit|Replace
what: (spacebar)
with: (leave blank)
replace all



jamesea wrote:

I have a list of company names in excel and need to remove all spacing. e.g.
"care homes ltd" needs to be "carehomesltd" if there a formula that will
remove this spacing?

--

Dave Peterson

One last thought on removing spaces from Excel: If the spaces are normal
spaces, use Ctrl+H (Replace), "Find What": [enter a single 'space' here]
"Replace With": [leave blank] will work fine. HOWEVER, if the spaces are
"protected spaces" (e.g., Ctrl+Shift+space), that procedure WILL NOT WORK.
Use the same procedure above, but instead of entering a single 'space' under
"Find What", you must enter Alt+0160 (using the numbers on the NumPad only).
You can't see "protected spaces" in Excel (you can copy and paste a section
into word and click on the Paragraph Icon to see if the spaces are
protected... they will appear as little circles instead of dots). Good luck.
P.S. Thank you "Cliff" for the latter tip.

"Dave Peterson" wrote:

How about just selecting the range to fix and
Edit|Replace
what: (spacebar)
with: (leave blank)
replace all



jamesea wrote:

I have a list of company names in excel and need to remove all spacing. e.g.
"care homes ltd" needs to be "carehomesltd" if there a formula that will
remove this spacing?

--

Dave Peterson