What is IS function in Excel?
IS functions, ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, … Read More
How to test a range for numbers in Excel
To test a range for numbers, you can use a formula based on the ISNUMBER … Read More
Split numbers from units of measure in Excel
To split a number from a unit value, you need to determine the position of … Read More
How to check cell that contains specific text in Excel
To check if a cell contains specific text, you can use the SEARCH function together … Read More
How to check cell that contains one of many with exclusions in Excel
To test a cell for one of many strings, while excluding others, you can use … Read More
How to check if cell contains number in Excel
To test if a cell (or any text string) contains a number, you can use … Read More
How to check if cell contains one of many things in Excel
This tutorial shows how to check if cell contains one of many things in Excel … Read More
How to check if cell contains all of many things in Excel
If you want to test a cell to see if it contains all items in … Read More
How to abbreviate names or words in Excel
To abbreviate text that contains capital letters, you can try this array formula based on … Read More
How to check cell contains which things in Excel
If you have a list of things (words, substrings, etc) and want to find out … Read More
How to count keywords in a range of cell
To count the number of specific words or keywords that appear in a given cell, … Read More
Excel Data validation require unique number
Set criteria to accept only unique number, ie no duplicate.
To allow only unique numbers
Excel Data validation must not contain
Set criteria to reject specific data in Excel
To disallow input that contains one of
Excel Data validation must contain specific text
How to set criteria in Excel to accept specific text.
To allow only values that … Read More
Highlight numbers that include symbols in Excel
This tutorial shows how to Highlight numbers that include symbols in Excel using the example … Read More
Excel Data validation allow numbers only
This tutorial shows how to create Data validation to allow numbers only in Excel using … Read More
Highlight cells that contain one of many in Excel
This tutorial shows how to Highlight cells that contain one of many in Excel using … Read More
Highlight cells that contain in Excel
This tutorial shows how to Highlight cells that contain in Excel using the example below;… Read More
Categorize text with keywords in Excel
This tutorial shows how to Categorize text with keywords in Excel using the example below;… Read More
IF with wildcards in Excel
This tutorial shows how to calculate IF with wildcards in Excel using the example below;… Read More
If cell contains in Excel
This tutorial shows how to calculate If cell contains in Excel using the example below;… Read More