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!
Solved by mubashir aziz