Find word within cell & put value in adjacent

January 2017

Microsoft Office Software provides Excel as the default tool for storing and analysing data. Built in functionalities such as formula, macros and data analysis add-ins make it a favorite tool with many people. It can be used for custom exercises such as finding a word within a cell and flagging it with a user specified value in a cell of choice anywhere in the worksheet. For this, users can combine multiple functions such as IF, ISERROR and SEARCH to find the relevant word within a cell and put a designated value in the adjacent cell.

Find word within cell & put value in adjacent




Issue


I'd like to scan a column for a certain word (e.g. "apple") and put a code (e.g. "A") in the cell next to it each time it finds it. In this case, "apple" might be by itself or in the middle of a sentence.

Solution

  • Suppose your data is from A1 to A100 or onward. Then in B1 copy this formula and drag it down!


=IF(ISERROR(SEARCH("*apple*",A1,1)),"","A ")

Note


Solved by mubashir aziz

Related


Published by aakai1056. Latest update on March 15, 2012 at 04:17 PM by Celia Gatward.
This document, titled "Find word within cell & put value in adjacent," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).