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.

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

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

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

The new TRANSLATE function in Excel allows users to dynamically translate text into over 100 languages. This function can be particularly useful for ...