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.

Microsoft Excel is a great spreadsheet software for Windows computers. You can use it to manage data. While managing data, sometimes, you need to change the date format. You can do that easily by ...

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 ...