Learn how to use the TEXTJOIN function in Excel. ... To merge date values with string values, you need to first convert the date into text format using the TEXT function.

This use is simple, but not intuitive because you must add the TEXT() function. Let’s look at another use that might not occur to you. How to ignore characters when using TEXTSPLIT() in Excel ...

If you have other editions of MS Excel, you can use the Text to Column wizard to split text in Excel. Let us now see how to use the new TEXTSPLIT() function in Excel for the web. Example 1: Using ...