Forum Discussion
autofilling from multiple columns
Monyca For some reason, the Flash Fill feature doesn't recognise the pattern you are trying to create. Difficult to judge why without seeing your real data. But, since you already know exactly how you want to build the passwords, you could use a formula. Assume column A holds the dates (in date format mm/dd/yyyy) and column B holds the Student IDs, with a header on the first row.
=TEXT(A2,"mmdd")&RIGHT(B2,4)Enter the above in G2 (your 7th column) and copy it down.
Monyca For some reason, the Flash Fill feature doesn't recognise the pattern you are trying to create. Difficult to judge why without seeing your real data. But, since you already know exactly how you want to build the passwords, you could use a formula. Assume column A holds the dates (in date format mm/dd/yyyy) and column B holds the Student IDs, with a header on the first row.
=TEXT(A2,"mmdd")&RIGHT(B2,4)Enter the above in G2 (your 7th column) and copy it down.
- Thank you!
