remove some but not all internal spaces

[JDUK]

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]

One way, using a helper cell with a formula.

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

 

[Teethless mama]

=SUBSTITUTE(D1," ","",1)

 

[JDUK]

Thank you

One way, using a helper cell with a formula.

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

 

[JDUK]

Thank you - very helpful

=SUBSTITUTE(D1," ","",1)

 

[Teethless mama]

You're Welcome!

Thank you - very helpful