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 réponses

Réponse 1 / 2
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
Patrice33740 Posted messages 8400 Registration date   Status Membre Last intervention   1 781
 
Before deleting the dots, change the corresponding cells to text format; otherwise, you will lose the leading zeros in the numbers.
0
Anonymous user
 
Very good comments Patrice337740, I had forgotten them.
0
Réponse 2 / 2
sonia
 
Thank you very much :) I did it!
0