#Split_Text_and_Number
#Array_in_Excel #Min_function_with_search
Through this video you will learn and understand how to separate text from numbers and vice versa. Excel 2013 and above have a beautiful feature of FLASH FILL which obviates the need of these techniques. But what important is to empower yourself with the algorithm which Excel works around. It's a don't miss video if you want to learn VBA in future.
Google Drive link of the practice sheet.
https://drive.google.com/file/d/1ofSb5xLZB-Wfa-9Uk02WkH91RHlbPFmV/view?usp=sharing