philfer
05-15-2008, 08:07 AM
Hello,
I know Excel has trim functions to remove leading, following (or both) spaces from a string.
However is there a snazzy way to remove spaces in the middle.
I have loads of phone numbers some as
+44 208 448 5996
and others as
+44 2084485996
and I want them all to be
+442084485996
Is there an easy way to do this that I can take all the credit for!!!
Cheers
Phil
I know Excel has trim functions to remove leading, following (or both) spaces from a string.
However is there a snazzy way to remove spaces in the middle.
I have loads of phone numbers some as
+44 208 448 5996
and others as
+44 2084485996
and I want them all to be
+442084485996
Is there an easy way to do this that I can take all the credit for!!!
Cheers
Phil