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?