Let us see how to use the TEXTJOIN function in Excel. Example 1: Using TEXTJOIN using a single delimiter Suppose we have a workbook with employee data (employee names) of an organization, as shown ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

You can even merge and unmerge cells in Excel. How to use functions and formulas. The real power behind Microsoft Excel is the ability to manipulate data that includes using functions and formulas.