remove some but not all internal spaces
Thank you
"Dave Peterson" wrote:
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
|