Home

Telephone Number Format

Toledo_63
Occasional Visitor

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

3 Replies

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.

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 ;)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies