Parsing for keywords, and returning the keyword

Svend

New Member
Joined
Aug 25, 2002
Messages
1
I'm trying to parse through cells looking for keywords. When a key word is found I'd like an adjoing cell to indicate which word is found. For example: Column A has the full names of random people. Everytime one of the names Bill, Bob, or Brent are found in one of the cells in column A I want column B to indicate which name was found. I could use nested "If" statements but the list of names (Bill, Bob, Brent, etc) I'm looking for is huge and I'm hoping to do it with a named list range. Furthermore, if someones name is Bill Brent, I need column B to state Bill Brent, not just Bill or just Brent.
This message was edited by Svend on 2002-08-26 10:30
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,191,707
Messages
5,988,192
Members
440,138
Latest member
yanaa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top