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

Learn about 10 Text functions in Excel with examples, including Find, Len, Left, Right, Mid, Substitute, Upper, Trim, Concatenate, and Text.

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

Learn how to find and replace Text Color in Excel. The classic Find and Replace feature can be used to change the color of text in Excel.