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
Published by aakai1056
Latest update on March 15, 2012 at 04:17 PM by Celia Gatward.