Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.

How to compare Microsoft Excel columns with VLOOKUP Lookup functions in MS Excel find specific information within your spreadsheet based on criteria you define. They aren't ideal for matching ...

To get started, ask a friend who may know how or seek help from online MS Excel forums. Or perhaps enroll in a course. Experiment with functions and formulas until you find what you need.