WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to check if a cell contains text in Excel

August 1, 2022
4.1K Views

Suppose you want to make sure a column only contains text and not numbers. You might also wish to locate all orders that are associated with a particular salesperson. There are a number of techniques to determine whether text is there in a cell if you don't care about capitalization or lowercase letters.

Hoe to find cells that contain text?

To discover cells with a certain text, follow these steps:

1. Choose the cell range you wish to search in.

2. Click any cell to conduct a worksheet-wide search.

3. Click Find & Select in the Editing group data-imgw=269 data-imgh=135 data-src="//res-academy.cache.wpscdn.com/images/seo_posts/20220728/d288780a7c5a2339e9439054f9c627f3.png" data-test="skks" style="max-width: 100%; width: 720px; max-height: 135px; height: calc(100vw *(135/269)); text-align:center;" >

4.   Enter the words or numbers you need to locate in the Find what box. Alternatively, select a recent search from the Find What drop-down menu.

5  Click Format and make your selections in the Find Format popup window to set a format for your search.

6. Click Options to narrow down your search even more. For instance, you can look for all the cells that have the same kind of information, like formulas.

7. To search for a worksheet or a workbook in its whole, choose Sheet or Workbook from the Within box.

8. Select Find Next or Find All.

Make a cell active by picking a specific instance from a list of all instances of the object you're looking for in Find All. By selecting a header, you can sort the outcomes of a Find All search.

If Cell Contains Text Then TRUE

=IF(ISNUMBER(FIND(“How”,A1,1)),TRUE,FALSE)

The Excel formula to return True if a Cell contains Specify Text is shown below. If a specified string is present in a cell, you can check it and return True or False.

If a match is found, the formula yields true; otherwise, it returns False.

How to find for Case Sensitive Match?

=IF(ISERROR(FIND($E$1,A2,1)),”Not Found”,”Found”)

Using an Excel formula, we may determine whether a cell has partial text before returning something. The straightforward example to locate the partial text in a cell is provided below. If you wish to make the criteria case-sensitive, we can use it.

Search for Not Case Sensitive Match

=IF(ISERROR(SEARCH($F$1,A2,1)),”Not Found”,”Found”)

To determine whether a cell contains partial text, we can utilize the search function. If you want to create the checking criteria, the search feature is helpful. Ignore case when using.

If Range of Cells Contains Text

= If (COUNTIF(A2:A21, *Region 1d*)>0), then *Region 1d*), Range Contains Text, and Text Not Found in the Given Range will be displayed.We can search a set of cells for the strings. The formula to determine whether a range of cells contains text is shown below. To determine whether a set of cells in Excel contain a specific text and return Text.

If Cell Has Text, Return a Value

=IF(ISNUMBER(SEARCH(“How”,A1,1)),”Found”,”Not Found”)If the cell has a string, we can return some value. The Excel formula to return a value when a cell has text is shown below. You can return a string or value to another column after determining whether a cell has a particular string.

Did you learn how to delete spaces from Excel after text? To discover more about the functionality of Word documents, Excel spreadsheets, and PowerPoint slides, follow WPS Academy. To edit word, excel, and PowerPoint documents for free, you may also download WPS Office. Get it now! and have a pleasant and straightforward working experience.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.