I want to know how to use flash fill with excel 2016
if you have excel 2010 then what is the alternative to flash fill.
Alternative to flash fill are as follows:
1. Text To Column
2. Functions Such as ( LEFT, RIGHT, MID, SUBSTITUTE, CHAR, TRIM)
3. Tools such as (Find & Replace)
You can use Flash Fill using CTRL+E
I have Excel 2007 so there is any other method which works the same as flash fill feature