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