View original (French)

Excel: remove phone number space

Papillon -  
 Alex -
Hello,
I have a list of phone numbers in Excel formatted as "0x xx xx xx xx"

I want to remove the spaces to get: 0xxxxxxxxx

Could you please tell me how to do this?

Thank you very much in advance

Configuration: Windows XP / Internet Explorer 6.0

2 réponses

Réponse 1 / 2
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
Hello
1°) Check that the cell format is set to standard; it might be in a special phone format that spaces the numbers every 2.
Set it back to standard to see what happens

If there are indeed spaces, two options:

Replace:

Select the list and
toolbar / edit / replace
replace: type a space
with leave it empty and click "replace all"

by formula:

crdlmnt
=SUBSTITUTE(Cell;" ";"") will also remove the blanks

crdlmnt

Let's ask ourselves if we are the only ones who understand what we are explaining?
18
Solène C
 
Thank you very much.
0
Alex
 
Thank you very much, sir, that helped me a lot.
0