Flash Fill- Examples

Please sign up for the course before starting the lesson.

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.

Back to: Intermediate Excel Course > Ultimate Excel Tool