Search

NO FORMULAS! Concatenate First & Last Name - Detect pattern - Excel

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.


#Excel #NoFormulas #Formulas #DetectPattern #Pattern #FlashFill #Feature #Function #Microsoft #Amazing #Trick #Concatenate

12 views0 comments

Recent Posts

See All