remove some but not all internal spaces
Thank you - very helpful
"Teethless mama" wrote:
=SUBSTITUTE(D1," ","",1)
"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"
|