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 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor 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
    1. Solène C
       
      Thank you very much.
      0
    2. Alex
       
      Thank you very much, sir, that helped me a lot.
      0