GRINKLE "ONLY"

profileXEZEX
e10b2textflash.xlsx

Experiment

Text Functions Flash Fill
Invoices Year Month Invoice # Invoices Year Month Invoice #
20151201 20151201
20151202 20151202
20160101 20160101
20160102 20160102
20160103 20160103
20160104 20160104
20160105 20160105
20160201 20160201
20160202 20160202
20160203 20160203
20160204 20160204
20160205 20160205
20160206 20160206
Which text function per column and why? Does Flash Fill work? Why or why not?
Year
Month
Invoice #