View original (French)

How to remove dots in excel

sonia -  
 sonia -
Hello,

here's my problem: I have a list of phone numbers, but the numbers are separated by dots, for example: 06.00.00.00.00, while I would like a list of numbers like this: 0600000000

how can I do this, please

thank you

2 answers

  1. Patrice67
     
    Hello Sonia

    You select the numbers. You use find/replace (shortcut keys Ctrl + H)
    You search for the periods and replace them with nothing. Normally, all the periods disappear and the numbers stick together.

    Best regards
    7
    1. Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784
       
      Before deleting the dots, change the corresponding cells to text format; otherwise, you will lose the leading zeros in the numbers.
      0
    2. Anonymous user
       
      Very good comments Patrice337740, I had forgotten them.
      0