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
This message was edited by Svend on 2002-08-26 10:30
