Find word within cell & put value in adjacent

December 2016

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


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.


  • 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 ")


Solved by mubashir aziz

Related :

This document entitled « Find word within cell & put value in adjacent » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.