How To Remove Spaces?

Hi,

Select the column. Then press Ctrl + H. In the find what field enter a space by pressing the spacebar once. Then leave the replace with box blank and click replace all.

VBA Noob

or with a formula

=SUBSTITUTE(A1," ","")

Then paste special values and delete the original columns

VBA Noob

Indeed

You too

VBA Noob