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

How to Find & Replace Text Parts in MS Excel. Manually finding and replacing parts of text can be exceedingly tedious for lengthy Excel spreadsheets. Luckily, Microsoft included a couple of useful ...

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.