How to use Flash fill?
Hello friends, in this blog I
will teach you how you can use Flash fill option in MS Excel.
Friend it is a magical
option/tool.
It follows the pattern and
takes action as per this pattern.
In below example, I have a
column having complete name; first and last name in single cell.
I want to set First name and
Last name in separate cells.
In Column C ( First Name) I
write the first name; Suresh and hit the enter button.
Now go to ‘Data >> Flash
Fill’ & click over there or just press ‘Ctrl + E’ and it will put the First names
in the respective Rows.
Now type Last Name in column
D, ‘Sharma’ and press enter.
Press ‘Ctrl + E’ and like
before all last names will be set in column D in respective Rows.
