Forum Discussion
Telephone Number Format
I received a file with phone numbers in excell, where the format is: + 551199713-2919 and I need to convert to the format +5511997132919, as I do in Excell
Hi guys
From what you have specified Toledo_63, you want the - and blank space to be deleted.
Try =SUBSTITUTE(SUBSTITUTE(F22,"-","")," ","")
This will remove the - and blank space in front of the +.
Cheers
Damien
You can also use the TRIM function to remove blank spaces ;)