Find word within cell & put value in adjacent

Latest update on March 15, 2012 at 04:17 PM by Celia Gatward .

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