How to Insert a Phone Number in Google Spreadsheets

Next Video:
Changing the Installation Theme of Chrome in Mac OS....5

Inserting a phone number in Google spreadsheets is something that you can do automatically with a specific formula. Insert a phone number into Google spreadsheets with help from an experienced computer professional in this free video clip.

Part of the Video Series: Google & Internet Browser Tips
Promoted By Zergnet


Video Transcript

Hi. I'm Skylar. Google spreadsheets don't actually have a way to format phone numbers automatically. But you could write a little formula to do it for you. Let you show you what I mean. Let me type in just ten digits. In column B I'm going to type in our formula. It looks a little complex but it does the job. Now we see that column B has the properly formatted ten digit US phone number. Now I'll just drag this handle down and now I can type in as many phone numbers as I want all of which will be formatted correctly. Just like that. So it all comes down to this formula which is just a concatenation. It allows you to determine how these special characters are interspersed with the data from the user. Thanks for watching. I'm Skylar.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!