Solved: eliminating blank spaces inside string

[philfer]

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

[Oorang]

Ctrl H replace all spaces with nothing.
Or you can use a formula:

=SUBSTITUTE(A1," ","")

[Simon Lloyd]

why not use find n replacelike this: In the find what type +44 with one space after it in the replace type +44 but no space, hey presto all spaces gone!