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.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.