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

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

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 ...

Unlike Microsoft Word, Excel 2007 does not include a Change Case feature for quickly converting capitalization styles. However, Excel does have functions that convert text to lowercase, uppercase ...