Hi to all,
Flash fill is used to sense a pattern in Excel. It was easy to see the pattern in separating names from numbers like in house numbers and street names.
I was able to use it for separating values in dates.
Can any one figure out the result I have in the following (Why it did not show 20 in all cells):
Khalil
Bookmarks