{"id":29754,"date":"2023-07-07T22:03:18","date_gmt":"2023-07-07T20:03:18","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=29754"},"modified":"2024-06-09T11:40:25","modified_gmt":"2024-06-09T09:40:25","slug":"cell-contains-specific-text","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cell-contains-specific-text\/","title":{"rendered":"Top 3 Methods to Locate Cell that Contains Specific Text in Excel"},"content":{"rendered":"

\"Top<\/a><\/p>\n

Excel is a versatile spreadsheet<\/a> software<\/strong> used in various industries and professions for data storage, management, and analysis<\/strong>. Among its multitude of applications, one of the common tasks<\/strong> is to identify cells that contains specific text<\/strong>.<\/p>\n

Although there isn’t a dedicated in-built Excel formula<\/strong>, there have 3 different ways <\/strong>that can be used to check what a cell contains\u00a0 –<\/p>\n

Let us delve into these functions thoroughly.<\/p>\n

Download the Excel Workbook below to follow along and understand how to locate cell that contains specific text in Excel \u2013<\/h4>\n

download excel workbook<\/strong><\/span>Excel-IF-Cell-Contains.xlsx<\/span><\/a><\/h4>\n

 <\/p>\n

Using Find Feature<\/span><\/strong><\/p>\n

By following the steps provided below, it is possible to effectively locate positive feedback by utilizing a find feature in Excel.<\/strong><\/p>\n

STEP 1:<\/span> Select the range<\/strong> that contains all the feedback (i.e. Column B).
\n\"Top<\/a><\/p>\n

STEP 2:<\/span> <\/strong>Go to Home<\/strong>\u00a0> Find & Select<\/strong> > Find<\/strong>. Or, simply press Ctrl + F<\/strong> to open the Find dialog box.<\/p>\n

\"Top<\/a><\/p>\n

STEP 3:<\/span><\/strong> In the Find dialog box, enter the specific text you want to search.\u00a0<\/strong>Here, it is the word “good”.<\/p>\n

\"Top<\/a><\/p>\n

STEP 4: <\/span><\/strong>Click on the Find All<\/strong> button to display a list of all the cells containing the specified text.<\/p>\n

\"Top<\/a><\/p>\n

All the cells that contain specific word i.e. good are displayed.<\/p>\n

\"Top<\/a><\/p>\n

 <\/p>\n

SEARCH Function<\/span><\/strong><\/p>\n

The SEARCH function is a text function in Excel used to get the starting position of a specified text in a text string<\/strong>. If the text is found<\/strong>, it returns the position<\/strong> or else<\/strong> it returns an error<\/strong>.<\/p>\n

The syntax<\/strong> of the SEARCH function is –<\/p>\n

=SEARCH(find_text, within_text, [start_num])<\/strong><\/p>\n

where,<\/p>\n