How to Format Phone Numbers in Excel - Tutorial
Excel tutorial on how to format phone numbers in Excel. By applying phone formatting in Excel, you can make your phone number values easier to read - with parentheses, dashes, periods, country codes, etc.
In this tutorial, we’ll look at different ways that you can apply phone number formatting to your Excel sheet.
Important FYI: The methods used in this tutorial will NOT change the values entered in your spreadsheet. They will simply make the numbers display like phone numbers.
Click here to read our step-by-step article on applying phone number formats in Excel: yacostasolutions.com/excel-ph...
00:00 - Intro + About Formatting in Excel
00:30 - Apply Your Excel's Default Phone Format
01:41 - Select the Phone Format of a Different Country
02:57 - Create Custom Phone Formats in Excel
03:19 - Create a Custom Phone Format with Dashes
04:24 - Create a Custom Phone Format with Spaces
04:46 - Create a Custom Phone Format with a Country Code
05:27 - Create a Custom Phone Format with Periods
Have You Watched This One?:
How to Hard Code Phone Numbers in Excel by Using Flash Fill - Tutorial: • How to Hard Code Phone...
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends - it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
Пікірлер: 22
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?
This did not work for me. It didn't change a thing
Very useful .. Thank you
Thank you! Very helpful!
@YAcostaSolutions
6 ай бұрын
Thanks so much. Glad it was helpful! 🙂
Thanks this is really helpful 🎉
@YAcostaSolutions
3 ай бұрын
I’m so happy this tutorial helped you out! Thanks so much 🙂
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 🙂
thanks! saved my life
@YAcostaSolutions
Жыл бұрын
That’s great, Rezuana! So happy this helped you 🙂
What if I have to work with different country codes in the same spreadsheet?
thanks it is very helpful
@YAcostaSolutions
Жыл бұрын
Thank you! I'm so glad you found this helpful 🙂
Those options to select phone number do not appear
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.
Thank you Y! What would you like to be called? Great Excel tip! Will save me a 🙂lot of time.
@YAcostaSolutions
4 ай бұрын
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”) 🙂
Thanks
@YAcostaSolutions
Жыл бұрын
Thank you! So happy you liked this 🙂
how do I do the reverse? Remove spaces and parenthesis?
@YAcostaSolutions
Жыл бұрын
Hi. You could try using Flash Fill for this: kzread.info/dash/bejne/kWyAk7h6qLfAfrg.html or kzread.info/dash/bejne/k4GNyZWqac61irg.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: kzread.info/dash/bejne/m6KWw62Gp929cZs.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: kzread.info/dash/bejne/kWWJz9CEk8iTptY.html CONCAT, CONCATENATE: kzread.info/dash/bejne/aqutqcyqeJu1hLQ.html Hope one of these works for you and thank you for stopping by!