Formula

Today’s tutorial will show you how to find if a cell contains specific text using the ISNUMBER and SEARCH functions.

Learn how to split a text string at specific character in Excel using the LEFT, RIGHT, LEN, and FIND functions.

Use the SplitNumbers function to split text and numbers with different parameters depending on whether you want to extract the text or the number.

Learn how to remove text from a cell by position in Excel using the REPLACE, SUBSTITUTE, and TEXTRIGHT functions.

To remove text from a cell based on matching content in Excel (or replace multiple characters), use the SUBSTITUTE or MSUB functions.

This tutorial will show various ways and tips on how to remove the first character from a cell in Excel using formulas.

To find the first or last positive value in a list (row or column), use the XLOOKUP, SIGN, INDEX, or MATCH functions.

To sum multiple rows or columns based on a lookup value, you can use the SUM function with the XLOOKUP function. Even if we have a definitive XLOOKUP guide, we learn something special daily. Today’s example will be on how to find the matching value in a table and sum multiple rows or columns. The … Read more

Combine the LET and IF functions with XLOOKUP, and XLOOKUP will return blank if the lookup result is blank.

XLOOKUP can’t return all matches; this feature is currently not supported. Here is the workaround with the Excel FILTER function.

You can use the XLOOKUP function and a sorted list to look up values between two numerical values and return a corresponding result.

Learn how to create a nested XLOOKUP formula if you need two lookup values to find the matching record in Excel. We will show you how to use XLOOKUP to replace the INDEX and MATCH combination when you need a two-way lookup. For example, sometimes, we need two inputs to find the matching record in … Read more