How To Remove Spaces Between Characters And Numbers In Excel

For example, if you want to remove spaces from column C, and C’s first row of data is in row 2 (C2), click the second cell in your blank column (e. g. E2, F2, G2, etc).

If you clicked cell C2, the formula should now look like this: =Substitute(C2 .

The formula should now look like this: =Substitute(C2," “,.

The formula should now look like this: =Substitute(C2,” “,””).

For example, if C2 said w ww . wikih ow . com, your new cell will say www. wikihow. com.