Learn how to find text inside cells, when the case of the text doesn't particularly matter.

Learn how to check if a cell contains text, when the case of the text is important.

In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.

In its simplest form, COUNTIF says: =COUNTIF (Where do you want to look?, What do you want to look for?) For example: The group of cells you want to count. Range can contain numbers, …

This article describes the formula syntax and usage of the FIND function in Microsoft Excel. FIND locates one text string within a second text string, and return the number of the starting …

How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.

This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result. This …

Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These …

A query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value. For example, = "Chicago" is an …

Learn how to find text inside cells, when the case of the text doesn't particularly matter.

Use the Find pane to find text in a document. Or press Ctrl+H to open the Find and Replace box.