AVERAGEIF and AVERAGEIFS aren't the only functions in Excel that calculate the average of a dataset. For example, the AVERAGE function produces a straightforward arithmetic mean of a set of data, and ...

Learn how to use the TEXTJOIN function in Excel. ... (10) as the delimiter and turn on the ‘Wrap Text’ format for the cell. 10 is the ASCII character code for linefeed.

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’d like to learn about XLOOKUP(), read How to use the newish XLOOKUP() dynamic array function in Excel. I’m using Microsoft 365 on a Windows 10 64-bit system.

Adding text after a specific number of characters in Excel is a possibility if you know what to do. In this situation, we will be using the LEFT, RIGHT, and LEN functions instead of CONCAT. They ...