Removing spaces

I want to completely remove space from the following assuming DATA starting from A1 downwards

GCT 03
GHF 05
GIH 02
GIH 05

select data (whole column perhapes or whole sheet) Ctrl+H

Replace (enter space)
with (leave empty)

In B1:

Formula:

Please Login or Register  to view this content.

Drag down as desired.

Originally Posted by zbor

select data (whole column perhapes or whole sheet) Ctrl+H

Replace (enter space)
with (leave empty)

Have to click "Replace All" also...

Thank you all , I was actually looking for the SUBSTITUTE formula that skipped my brains