Find if a cell contains specific text in excel. To search the entire worksheet, select any cell.

Find if a cell contains specific text in excel To find the position of a substring in a text string, use the SEARCH function. Nov 25, 2024 · To filter data if a cell contains specific text in Excel, you can use a formula based on the FILTER, ISNUMBER, and SEARCH functions. Aug 17, 2007 · Using the code from earlier (=ADDRESS (. Put the following formula inside the cell: Jun 15, 2024 · Learn how to highlight a row if any cell contains any text by using the FIND, and SEARCH functions, and making a drop-down list in Excel. Apr 19, 2024 · Method 1 – Using SUMIF Function to Sum If Cell Contains a Text in Excel In the spreadsheet, we have a product price list with categories. 2 days ago · Learn how to use regex match in Excel XLOOKUP and XMATCH to search patterns, validate formats, and work with structured data, complete with formula examples and practical tips. 4 days ago · Learn how to extract specific text in Excel using LEFT, RIGHT, MID, TEXTBEFORE/AFTER, FIND, SEARCH, SUBSTITUTE, and delimiter-based formulas. In the example shown, the formula in C5 is: =IF(ISNUMBER(SEARCH("abc",B5)),B5,"") To test for "if cell equals" you can use a simpler formula. To test if a cell contains text and return a specified value you can apply Excel or VBA methods. Jun 22, 2023 · Example: How to Use INDEX MATCH if Cell Contains Text in Excel Suppose we have the following dataset in Excel that contains information about points scored by basketball players on various teams: Suppose we would like to look up the substring “Warr” in the Team column and return the corresponding value in the Points column. One of the major uses of Excel is to conduct efficient searches. Download the workbook, practice, and learn them. In the example shown, XLOOKUP is configured to match the value entered in cell E5, which may appear anywhere in the lookup values in B5:B15. We will cover case-sensitive and case-insensitive formula options, along with a May 25, 2023 · Learn how to test if a cell contains specific text using an Excel Formula. Jan 26, 2022 · This tutorial explains how to check if a cell contains text from a list in Excel, including an example. . Search, Find if cell contains specific text or string in a Cell. In the example shown, the formula in F5 is: =FILTER(B5:D14,ISNUMBER(SEARCH("rd",B5:B14)),"No results") Which retrieves data where the street column contains "rd". Sep 12, 2023 · Examples of Excel formula to sum or count if cell contains any text or specific text. The formula used to test if a cell contains text and return a specified value can be driven by multiple methods with the use of an Excel IF function combined with a COUNTIF, ISNUMBER or ISTEXT function. Video How to Check If Cell Contains Specific Text in Excel In this article, we will learn How to Check If Cell Contains Specific Text in Excel. Jan 18, 2024 · That is, if a cell contains some text, then return something, if it contains another text, then return something else, and so on. Dec 14, 2023 · To test for cells that contain specific text, you can use a formula based on the IF function combined with the SEARCH and ISNUMBER functions. Mastering these techniques is essential for efficient data analysis and management. We will start by using the SEARCH function to find cells that contain a specific word, then convert the results into TRUE / FALSE values, and finally apply conditional formatting to highlight these cells. This allows you to create a chain of checks, with each condition leading to a specific result. Aug 29, 2024 · If Cell Contains Text Then Return Value in Another Cell Excel is a very smart spreadsheet software. Scenario : Identify particular text in a cell or different word in given cells. Common Scenarios for Text Search in Aug 17, 2025 · Learn how to find specific text in a range and return its cell reference in Excel using CELL, INDEX, MATCH, and ADDRESS functions. It will Check any Cell in a Range for a specific text and return True or False. I would like to search one column for a cell containing a given string. Master flexible conditional logic Jul 31, 2024 · If you need to check if a cell contains a string in Excel, it’s simpler than you might think! By using Excel functions, you can easily determine whether a specific text string is present within any given cell. Feb 26, 2025 · Learn how to count cells with specific text using Excel formulas like COUNTIF & COUNTIFS to count cells containing or matching certain text. For instance, I would like to find cell number of the cell which contains Functionviel, For example, a cell is: Functionviel In this article, we will learn How to look up cells having certain text and return the Certain Text in Excel. In the Find what box, enter the text—or numbers—that you need to find. To check if a cell contains specific text, use ISNUMBER and SEARCH in Excel. May 21, 2024 · The goal is to do something if a cell contains one substring or another. Aug 16, 2025 · Learn how to check if a cell contains text from a list in Excel using SEARCH, COUNTIF, XLOOKUP, INDEX, and more powerful functions. This version is case-sensitive, meaning that only cells with an exact match will return the specified value. This guide will walk Jun 16, 2024 · Method 9 – Return TRUE If Cell Contains Text in Excel Using a Combination of IF, ISERROR, and FIND Functions Insert the following formula in cell D5 and press Enter. So, in this section, we will try to calculate the total price of the products under the Wafer category. And if you’re not using it to automate your tasks smartly – you’re not doing it right. Aug 6, 2024 · Here, you will find 7 ways to check if a cell contains text and then return value with multiple conditions in Excel using different functions. Steps: Select cell C15. This means we can't use IF by itself to test for a substring like "abc" or "xyz" that might appear anywhere in a cell. This guide will explore key functions to check if cell contains text in Excel. Compare one cell to another cell To do this task, use the EXACT function. There's no CONTAINS function in Excel. Aug 17, 2025 · To sum values when a cell contains specific text in Excel, use the SUMIF function with wildcards. Feb 13, 2023 · To filter data to include data based on a "contains specific text" logic, you can use the FILTER function with help from the ISNUMBER function and SEARCH function. Includes images and detailed explanations. Jul 4, 2024 · 2 suitable uses of VLOOKUP function if a cell contains a word within text in Excel. Microsoft Excel offers powerful methods to check and analyze cell contents, from verifying data to searching for specific strings and meeting criteria. Mastering these functions will help you manipulate and analyze data more efficiently. Jun 29, 2021 · Method 4 – Use an INDEX-MATCH Formula to Return a Value If a Cell Contains Specific Text We have fetched the cell values from the LIST column where they matched with the Product and showed them in the result column. Excel contains two functions designed to check the occurrence of one text string inside another: the SEARCH function and the FIND function. Jul 21, 2025 · Unlock Excel's IF Cell Contains power! Get 25 real-world formulas & examples to check for partial text, multiple words, numbers, & more. One option (seen in the example) is to create a logical test with Nov 10, 2020 · Excel Formula to check if a Range Contains specific text and return a value. Apr 14, 2025 · Learn how to check if a cell contains any text using Excel formulas like IF, ISTEXT, LEN, and COUNTIF. Mar 14, 2023 · The tutorial shows how to make Excel IF statement with wildcard text and get it to work for partial matches. Feb 6, 2025 · Checking if a cell contains specific text is a fundamental skill in Excel for anyone who needs to categorize, filter, or analyze data. Like searching for a specific text or just text in Excel and returning another value elsewhere 🧐 This process (if successfully worked Nov 9, 2024 · Today’s tutorial will show you how to find if a cell contains specific text using the ISNUMBER and SEARCH functions. Includes examples, VBA code, and a downloadable file. Find cells that contain text Follow these steps to locate cells containing specific text: Select the range of cells that you want to search. Jan 19, 2023 · This guide will walk you through two different methods for using Excel functions to determine if a cell or range of cells contains a specific string of text. This essential technique allows you to instantly hide irrelevant data and focus only on the information that matters most for your analysis. I would like to find the location of a cell that contains certain text. In the example shown, the formula in E5 is: =COUNTIF(B5:B15,"*a*") The result is 6, since there are six cells in B5:B15 that contain the letter "a". I think you must have thought to do it manually but time constraint. May 13, 2025 · Learn how to use a powerful LAMBDA function, TEXTMATCH, to check if a cell contains specific text (exact match or partial). Let's say you want to find text that begins with a standard company prefix, such as ID_ or EMP-, and this text must be in uppercase letters. Mar 21, 2021 · To determine if a range or column contains specific text (a specific substring or partial text), you can use a formula based on the COUNTIF function and wildcards. The syntax of the Excel Find function is as follows: Find if a cell or range of cells contains a specific value in Excel. Feb 12, 2025 · In this example, the goal is to test a value in a cell to see if it contains a specific substring. Apr 22, 2025 · To check a cell for several things at once, and return a list of things found, you can use a formula based on the TEXTJOIN and FILTER functions, with help from SEARCH and ISNUMBER. Formula examples for exact match, partial match and filtered cells. For example finding the department ID from a database. Download our Excel workbook, modify data & exercise! Sep 4, 2013 · Is there an in-built function to check if a cell contains a given character/substring? It would mean you can apply textual functions like Left / Right / Mid on a conditional basis without throwing errors when delimiting characters are absent. To find a cell that contains specific text, use the formula below. This formula allows you to look for partial text matches inside a cell. Jun 25, 2024 · In this tutorial, you will get to know how to find text in an Excel range and return the reference of the cell that holds the text in 3 ways. Apr 5, 2020 · 6 I've had a look around on google but have only been able to find formulae for checking whether or not a cell contains a given piece of text, however what I'm looking for is slightly different. 1. Following is the simple formula to find specific text in given cells and return its values. Jun 23, 2024 · This article shows 4 easy ways to find if a range of cells contains specific text in Excel. Nov 10, 2020 · Often, we need to search for a text in a cell or range of cells in the Excel, return if it contains a specific text or string. Aug 12, 2024 · Learn easy Excel formulas to check if a cell contains specific text. The formula in F5 is: = XLOOKUP ("*" & E5 & "*", code, quantity,"no match",2) // returns 50 lookup_value - E5 Apr 6, 2019 · Excel if cell contains text formula to Check if contains excel. This is a useful skill for anyone working with large data sets in Excel, as it allows you to quickly and easily identify and filter out specific information. Aug 1, 2023 · This tutorial will demonstrate how to highlight cells if they contain specific text using Conditional Formatting in Excel and Google Sheets. )), how can I change this formula so that I can get an actual cell reference, and not just the reference to a cell as text??? Trying to find and isolate rows in your spreadsheet based on a specific word, product name, or phrase? Knowing how to filter cells that contain specific text is one of the most fundamental yet powerful skills you can learn in Excel. Mar 14, 2023 · The tutorial shows how to count the number of cells with specific text in Excel. Jul 2, 2024 · In this article, you will find 9 easy ways to check if a cell contains text then return value using different functions in Excel. Whether you're checking for a keyword in customer feedback or flagging specific product types in an inventory list, this guide will walk you through the most effective methods. Most users will think first of the IF function. These functions can be used to find the position of a text string, check if a cell contains certain text, or even extract text based on your criteria. This method can be used on individual cells when you want to "mark" them or to find out how many cells in a range contain that specific value. Aug 17, 2022 · To count cells that contain certain text, you can use the COUNTIF function with a wildcard. However, one problem with IF is that it does not support wildcards like "?" and "*". Then if I find it, I would like to use a value in the next-door cell on the Aug 30, 2024 · Understanding Text Search in Excel Excel offers several functions that allow you to search for specific text within a cell. Mar 13, 2023 · This tutorial explains how to write a simple formula for "if cell contains" in VBA, including an example. Apr 16, 2024 · Method 2 – If Cell Contains Specific Text Then Add Text in Another Cell Using IF Function Suppose you want to look for a text value “shirt” in the Product Name column. To evaluate multiple conditions in a cell, you can use nested "if cell contains" statements. Apr 30, 2024 · You can return true if the cell contains text in Excel following these 8 ways. Oct 23, 2023 · The XLOOKUP function contains built-in support for wildcards, but this feature must be enabled explicitly by setting match mode to the number 2. There are several ways to check if a cell contains text and the case of the text matters to you. Among its multitude of applications, one of the common tasks is to identify cells that contains specific text. To search the entire worksheet, select any cell. Mar 21, 2023 · Excel FIND function The FIND function in Excel is used to return the position of a specific character or substring within a text string. In the example shown, the formula in C5, copied down, is: =TEXTJOIN(", ",1,FILTER(things,ISNUMBER(SEARCH(things,B5)),"")) where things is the named range E5:E9. Learn them, download the workbook and practice. See how to apply Excel conditional formatting, copy or delete rows based on cell value. Excel is a versatile spreadsheet software used in various industries and professions for data storage, management, and analysis. Discover how to use MATCH, SEARCH, and ISNUMBER functions with practical formula examples. Oct 17, 2023 · A number of 'Excel if cells contains' formula examples show how to return some value in another column if a target cell contains specific text, any text, any number or any value at all (not empty cell), test multiple criteria with OR as well as AND logic. Nov 14, 2023 · The objective of this tutorial is to learn how to write formulas in Excel that can identify specific text strings within cells. On the Home tab, in the Editing group, select Find & Select, and then select Find. May 10, 2024 · If a cell contains specific words of interest and does not contain other specific words, the result should be TRUE If a cell contains specific words of interest and does contain other specific words, the result should be FALSE This makes the problem a bit more challenging, but we can still use the same approach described above.