Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but ...

Microsoft Excel’s new text functions make working with strings a breeze. Find out how to use TEXTAFTER () and TEXTBEFORE () in this tutorial.

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.

To capitalize the first letter of a text string in Excel, you can use a formula that combines multiple functions. We show you how to do it.