How to Format Phone Numbers in Excel - Tutorial

[@ezehsilvia3730]

Thank you. This is simple and straight forward

[@YAcostaSolutions]

I’m so happy you liked this! Thanks 🙂

[@luvbug862483]

This did not work for me. It didn't change a thing

[@magdikarem]

Very useful .. Thank you

[@YAcostaSolutions]

Thanks so much, Magdi! I’m happy this was useful for you 🙂

[@REZUANACHOWDHURY]

thanks! saved my life

[@YAcostaSolutions]

That’s great, Rezuana! So happy this helped you 🙂

[@matoketours10]

Thank you! Very helpful!

[@YAcostaSolutions]

Thanks so much. Glad it was helpful! 🙂

[@anoushka7022]

Thanks this is really helpful 🎉

[@YAcostaSolutions]

I’m so happy this tutorial helped you out! Thanks so much 🙂

[@MMohammad-ss9ef]

Thanks a lot . This video really helped me a lot. take Care

[@YAcostaSolutions]

That’s great! I’m so glad this helped you. And you take care as well 🙂

[@user-nz5yd8xo4w]

thanks it is very helpful

[@YAcostaSolutions]

Thank you! I'm so glad you found this helpful 🙂

[@BoxKingKevin]

What if I have a list of American numbers, Chinese numbers, Japanese numbers, etc. that all need their respective country codes fixed? Could you do another video demonstrating that?

[@zinimmortal107]

Thanks

[@YAcostaSolutions]

Thank you! So happy you liked this 🙂

[@lnordlinger]

Thank you Y! What would you like to be called? Great Excel tip! Will save me a 🙂lot of time.

[@YAcostaSolutions]

That’s excellent, Larry. I’m so happy this will help you save time 🙂 Thanks so much!
And people call me Yil (pronounced like “Jill”) 🙂

[@lousni6886]

What if I have to work with different country codes in the same spreadsheet?

[@Muddipaws1308]

Those options to select phone number do not appear

[@mtoush]

Hi, I Want To Know if WE Can Print the Snake Column Into One Page For Example I Have Data For Employee Contact (400 Members) As S/N, Name, and Mobile Number. For In One Page 1 To 50 The Next To It 50 To 100 Then Next 101 To 150 In One Page Without Using Any Formula.

[@zara330]

how do I do the reverse? Remove spaces and parenthesis?

[@YAcostaSolutions]

Hi. You could try using Flash Fill for this: ruclips.net/video/_8L1VAxTZNU/видео.html or ruclips.net/video/aMYg3q9kOZU/видео.html
You could also try Find and Replace. You would repeat the Find & Replace for each type of character you want to remove (once for the open parentheses, the close parentheses, and the space) and don't type anything in the "Replace" box: ruclips.net/video/inbaKMwzWA8/видео.html
Perhaps Text to Columns (although this might be a little more cumbersome). You could split the columns wherever there is a space or a parentheses, then use CONCAT or CONCATENATE to join only the portions you want. Text to Columns: ruclips.net/video/_1UmnKce-vs/видео.html CONCAT, CONCATENATE: ruclips.net/video/8wyGjqH8OTQ/видео.html
Hope one of these works for you and thank you for stopping by!