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
Is Flash Fill available in XL2010 ? ( see your profile) I doubt it
Hi,
I am using now Excel 2016
Try formula in B1
=LEFT(YEAR(A1),2)
/LGS
Flash Fill "not working" and working..
Attachment 854857
What did you do to make it work? Once again, not all members will be able to download attachments.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Explaining more clearly.
Excel 365 (Windows) 64 bit
Sheet: Planilha2
In my test if the date has a '0' before the number the problem with flash fill does not happen, also if the year has only 2 digits it does not happen.
Thanks - that's clear now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks