Excel formula to remove space between words in a cell
Suppose the data is in the B column, write in the C column the formula: =SUBSTITUTE(B1,” “,””) Copy&Paste the formula in the whole C column. edit: using commas or semicolons as parameters separator depends on your regional settings (I have to use the semicolons). This is weird I think. Thanks to @tocallaghan and @pablete for … Read more