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?