remove space in excel data 2

[leyland]

Hi
I have several phone numbers in the form of 01228 4554388. I want to remove the space and hence have another column with 012284554388 in. How can I do that in excel?

thanks in advance

 

[SkipVought]

Hi,

Edit>Replace

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}

 

[AnotherHiggins]

Seeing how these are phone numbers, they should always contain the same number of digits. Because of that, this will work:
=left(A1,5)&right(a1,7)

[tab]or you could use this:
=Substitute(A1," ","")

There are many other ways as well

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[firefytr]

If you have the ASAP Utilities addin (

http://www.asap-utilities.com)

you can go to the Text submenu and do an advanced character removal as well.

-----------
Regards,
Zack Barresse

 

[leyland]

many thanks for your help guys!!!!!!!!!!!1

 

[AnotherHiggins]

Nice solutions, Skip and Zack.

->

s from me

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.