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

Often known as the universal data munging tool, Excel is trying out new options for processing messy text as well as entering it more quickly and accurately in the first place.

Excel’s new COPILOT function uses AI to analyze, summarize, and generate content directly in the spreadsheet grid.