One way, using a helper cell with a formula.

=REPLACE(A1&" ",SEARCH(" ",A1&" "),1,"")
And drag down as far as you need.

JDUK wrote:

I have several hundred cells of postcode sector data in a column from which I
need to remove the first internal space but not the second. Is there an
automatic way to do this?
eg "SL 1 1" needs to be "SL1 1"

--

Dave Peterson