0 of 135 lessons complete (0%)
Ultimate Excel Tool

Flash Fill- Examples

You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.

Flash Fill Ex 1

On the sheet

1- Split the name and surname and make it all upper case with Flash Fill

2- Split the names into Name, Initial and Surname. Look closely at the surname and make sure they are correct

3- Combine column A and B, then reverse the combine

4- Make sure Excel sees all the numbers as numbers (on our computers the 0,526 is seen as text)

5- Extract the surname (e.g. Boyo in the first row) and the bank account number (032716….). Make sure it starts with a 0

6- Extract the product code (the middle code between the 2 #’s

To see the full course contents click here.