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