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




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
Published by aakai1056. Latest update on March 15, 2012 at 04:17 PM by Celia Gatward.
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 (https://ccm.net/).
Lost my ms office word key
Word - Select text vertically