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.