How to Hard Code Phone Numbers in Excel by Using Flash Fill - Tutorial
Trying to hard-code phone numbers in Excel can be tricky (if you don't want to do it manually!).
To be honest, I don't know (as of this recording) of a perfect tool to do this. But there is one that works most of the time; this is Flash Fill.
In this Excel tutorial, you'll see examples of how you can use Flash Fill to hard-code phone values in Excel. Followed by some examples where Flash Fill doesn't work for this.
00:00 - Intro
00:20 - Example of Excel's Phone Number Formatting Option
01:07 - Quick Overview of How Flash Fill Works
01:28 - Create Hard-coded Phone Numbers with Dashes Using Flash Fill (example 1)
02:27 - Create Hard-coded Phone Numbers that Contain Multiple Types of Characters (example 2)
02:55 - Create Hard-coded Phone Numbers From an Inconsistent List of Values (example 3)
03:43 - Note About How When Flash Fill Detects a Pattern can Vary
04:13 - Example of When Flash Fill Doesn't Work for Hard-coding Phone Number Values
Click here to read our step-by-step article on this: https://yacostasolutions.com/hard-cod...
Helpful Tutorials:
To learn more about Flash Fill watch: • How to Use Flash Fill in Excel - Tuto...
For more about phone number formatting in Excel watch: • How to Format Phone Numbers in Excel ...
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: https://yacostasolutions.com/newsletter/
*FYI: This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: https://yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: https://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: https://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
