Forum Discussion

Toledo_63's avatar
Toledo_63
Copper Contributor
Jan 24, 2019

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

excel

3 Replies

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Jan 24, 2019

    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

    • Arul Tresoldi's avatar
      Arul Tresoldi
      Iron Contributor
      Feb 12, 2019

      You can also use the TRIM function to remove blank spaces ;)

  • Arul Tresoldi's avatar
    Arul Tresoldi
    Iron Contributor
    Jan 24, 2019

    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.