How to generate random text using the RANDARRAY() function in Excel

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