How to create addresses with flash fill, how to flash fill with a double-barrelled surname
Channel: Computer Tutoring
Date: 2020-03-22

How to create addresses with flash fill, how to flash fill with a double-barrelled surname? How to use flash fill in creating addresses? Learn how to create email addresses from names in Excel. Also, see how to make mailing labels from Excel. Want to know how to use flash fill in creating addresses or how to generate email addresses in Excel?

In this Excel Tutorial you will see 5 ways to use Flash Fill:

Sections
00:00 - Beginning
01:15 - How to flash fill with a double barrelled surname?
03:07 - Convert US to UK dates with flash fill
04:24 - Create email addresses from names in Excel
06:10 - Use flash fill in correcting date formats in Excel
07:38 - How to create addresses with flash fill

More details are at:
https://www.computertutoring.co.uk/excel-tutorials/flash-fill-excel/

So What is Flash Fill in Excel? The following shows 5 ways to use Flash Fill in Excel so strap in and crack on:

1. Using Flash Fill to Split Data into Separate Full Names
https://youtu.be/DspxFZHs9gw?t=65

You need to separate a column of full names into first and last name. What's more is that the column of full names is over 100 long. What do you do?
Using Flash Fill to split data makes this process is quite straightforward. 
Click the cell to the right of the first name you want to separate

2. Convert US to UK dates using Flash Fill in Excel
https://youtu.be/DspxFZHs9gw?t=187

Now we know that various countries around the world have various ways of displaying dates. But one of the most often encountered variation is the US/UK date divide. Basically, the US would display the 22nd of March 2020 as 03/22/2020. Whereas in the UK it would be displayed as 22/03/2020.
While neither of these is right or wrong, it is important to be consistent. Knowing how to convert US to UK dates using Flash Fill in Excel is one little trick you don't want to miss.

3. Create Email Address From Name
https://youtu.be/DspxFZHs9gw?t=264

Flash fill is a great way to automatically create email addresses from names. So long as there is a consistent pattern to the email. For example, if the company email address consisted of first name, then a period, then last name Flash Fill in Excel will have no problem bringing the names together in an email address.

4. How to Correct Date Format in Excel with Flash Fill?
https://youtu.be/DspxFZHs9gw?t=370

We often see dates entered in the incorrect format. This has either been entered incorrectly, or the date has been produced by a 3rd party database. However which way it happens if your date is the following format:
22.03.2020
Excel won't recognise the cell as a date; it will be classed as text. That being the case it means that all of those wonderful date calculations such as extracting the day of the week or month of the year won't work. What's more you will be unable to calculate the length of time between dates.
When entering a date in Excel should be in the following format:
22/03/2020

5. How to Create Addresses with Flash Fill?
https://youtu.be/DspxFZHs9gw?t=458

Sometimes you might want to add text together in Excel. Using Flash Fill this is possible. You might want to do this to create a list of addresses using flash fill. What's more you will then want to concatenate different address cells into one cell using flash fill while at the same time adding in a little word wrap.
#computertutoring

😊 Check out my website and social media to keep up to date - enjoy learning 😊 

📱  http://www.computertutoring.co.uk/  📱 
📽  https://www.tiktok.com/@thecomptutor  📽 
👨‍👩‍👧‍👦 https://www.facebook.com/ComputerTutoring.co.uk/  👨‍👩‍👧‍👦 
🦉 https://twitter.com/CT_Tutoring 🦉 
📷 https://www.instagram.com/computer_tutoring/  📷 
📌 https://www.pinterest.co.uk/CT_Training/  📌