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

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

REGEXEXTRACT: Find Specific Pieces of Text This function returns parts of text in a cell according to a specified pattern. For example, you might want to separate numbers and text.