Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

Google Sheets offers many of the same features as Microsoft Excel. The SUMIF function allows you to quickly sum rows that meet certain criteria.

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.

The LAMBDA function in Microsoft 365 Excel is a fantastic option for advanced users, empowering them to create custom, reusable functions that significantly boost productivity and precision.

Microsoft Excel’s new text functions make working with strings a breeze. Find out how to use TEXTAFTER() and TEXTBEFORE() in this tutorial.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.