Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

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

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], …), ...

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.

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.