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

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

Learn about 10 Text functions in Excel with examples, including Find, Len, Left, Right, Mid, Substitute, Upper, Trim, Concatenate, and Text.

By default, references in Excel use the A1 reference style, which means that it refers to the column first, and then the row number. However, the INDIRECT function enables you to switch these around.

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

CONCATENATE, an Excel function used to join various text strings into one, is available in Excel 2007 and later versions. The syntax for the CONCATENATE function is CONCATENATE (text1, [text2], …), ...

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.

Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.

Microsoft is adding a COPILOT function to Excel, letting you use natural language prompts inside formulas to analyze, summarize, and categorize data.