# Find word within cell & put value in adjacent

Solved/Closed
Related:

- Excel if cell contains word then assign value
- Vlookup if cell contains a word within text - Best answers
- Excel formula find text in cell - Best answers
- Formula for if cell contains word, assign value for multiple - Forum - Excel
- If a cell contains any text then add a value ✓ - Forum - Excel
- Excel if range of cell contain a text put a cell value in ✓ - Forum - Excel
- Excel - IF function with multiple words ✓ - Forum - Excel
- Pop up message in excel if a specific word is entered into a cell ✓ - Forum - Excel

## 10 replies

mubashir aziz

Updated on Dec 21, 2018 at 04:21 AM

- Posts
- 190
- Registration date
- Sunday April 12, 2009
- Status
- Member
- Last seen
- February 16, 2010

Updated on Dec 21, 2018 at 04:21 AM

Hi,

Suppose your data is from A1 to A100 or onward. Then in B1, copy this formula and drag it down:

Hope, it will help!

Never ashamed to get or give Advise.

Muhammad Mubashir Aziz , Lodhran, Pakistan

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 ")

Hope, it will help!

Never ashamed to get or give Advise.

Muhammad Mubashir Aziz , Lodhran, Pakistan

Sep 3, 2009 at 05:04 PM

the formula [=IF(OR(ISERROR(SEARCH("*apple*",a1,1)),"","A ")] works great, but what if I want to use multiple criteria with wild characters.

EG: *apple* = A

*orange* = B

*grapes* = C

if any thing other than apple, orange or grapes, it should show 'D'

Hope you would respond.

Thanks in advance

Configuration: Windows XP Internet Explorer 7.0

Sep 4, 2009 at 12:58 AM

Nov 18, 2009 at 11:51 AM

Put

Apple 1

Apple 2

Apple 3

---------------

into Group 1

Orange 1

Orange 2

Orange 3

---------------

into Group 2

Berries 1

Berries 2

Berries 3

---------------

into Group 3

Lastly, what if Apples contain characters/symbols such as %$@!(), how do you make VBA treat these symbols as text?

Mar 21, 2010 at 09:05 AM

Aug 10, 2010 at 04:09 AM