remove some but not all internal spaces

  • Thread starter Thread starter JDUK
  • Start date Start date
J

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"
 
One way, using a helper cell with a formula.

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