Operations in Excel
Excel
How to Round to Significant Figures in Excel
Often you may want to round a value to a certain number of significant figures in Excel.
You can use the following formula to do...
Excel
Excel: How to Check if Cell Contains Partial Text
You can use the following formula in Excel to determine if a cell contains specific partial text:
=IF(COUNTIF(A1,"*abc*"),"Yes","No")
In this example, if cell A1 contains the...
Excel
Excel: How to Check if Cell Contains Text from List
You can use the following formula in Excel to check if a cell contains text from a list:
=IF(OR(COUNTIF(A1,"*"&$E$2:$E$8&"*")), "Yes", "No")
In this example, if cell...
Excel
Excel: A Simple Formula for “If Contains”
You can use the following formula in Excel to determine if a cell contains a certain string:
=IF(ISNUMBER(SEARCH("this",A1)), "Yes", "No")
In this example, if cell A1...
Excel
How to Replace Blank Cells with Zero in Excel
The easiest way to replace blank cells with zeros in Excel is to use the Go To Special function.
The following example shows how to...
Excel
Excel Advanced Filter: How to Use “Does Not Contain”
You can use the following syntax to filter for rows that do not contain specific text in an Excel Advanced Filter:
*sometext*
The following examples show...
Excel
How to Filter Multiple Columns in Excel (With Example)
The easiest way to filter multiple columns in Excel is to use the Advanced Filter function.
The following examples show how to use this function...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read