How to Insert a Phone Number in Google Spreadsheets

Save
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

Comments

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.

Featured

Related Searches

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