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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 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
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies