String Magic

  • Thread starter Thread starter John Michl
  • Start date Start date
J

John Michl

I have a list of a few thousand names and titles. I needed to create a
standardized list of functions so I'll need to search the title field to
determine which standarized title to use. How can I use a formula that is
able to differentiate between senior level titles that may have a "Vice"
before them? Example:


Title Standard Function
President President
CEO & President President
Vice President Vice President
First Vice President Vice President
Vice President Ops Vice President

In this example, if I search the title string for the term "President" it
would be found in all five. So I need to differentiate between those that
are President and those that are Vice President.

Thanks - John
 
John,

For a title in cell A2, try the formula (all on one line):

=IF(AND(NOT(ISERROR(SEARCH("vice",A2))),
NOT(ISERROR(SEARCH("president",A2)))),
"Vice President",IF(NOT(ISERROR(SEARCH("president",A2))),
"President","Some Other Title"))

HTH,
Bernie
MS Excel MVP
 
Back
Top