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

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

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 do I ignore all numbers stored as text in Excel? To ignore all numbers stored as text, you need to open the Data tab and select the Text to Columns option.