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
If the cell with the phone number with - is A1, use in B1: =SUBSTITUTE(A1;"-";"") to have the number without -; this will remove all "-" in the cell A1.