Updated: Jun 16, 2020
Excel can scare people with its extensive use of formulas.
Yes, it is great. No doubt about that. But it can get overwhelming for some.
So, Microsoft has a function called Flash Fill which is AMAZING! It ca detect patters in your column and replicate that. You can even use it to create Invoice No's and so much more!
Check out its use to concatenate first and last name without any formulas!
Pretty great right? Every time I explore Excel I learn something new. Is this also the case with you? Let me know by leaving your comment in the above video.