Find word within cell & put value in adjacent

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

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
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 (