How To Remove Spaces?

**Dno** · 12-21-2006, 06:44 PM

Hi,

I have a column with serveral rows. In each row there is a Letter and a Number with a space in between.

I'd like to remove all the spaces all the way down the column.

Example:

F 21
F 44
F 66
F 84

I'd like it to look like this:

F21
F44
F66
F84

Thanks!

**VBA Noob** · 12-21-2006, 06:47 PM

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