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

For instance, the function TEXTSPLIT (A1, {“,” , “.”}) will split the string in A1 using a comma or a period. The space characters between the two delimiters aren’t necessary but make ...

Microsoft Excel’s new text functions make working with strings a breeze. Image: IB Photography/Adobe Stock A common task is to parse or find characters within a delimited string in Microsoft Excel.

Let us now see how to use the new TEXTSPLIT () function in Excel for the web. Example 1: Using the col_delimiter argument In a new blank workbook, type ‘The Windows Club’ in cell A1.