sorting on text within a cell

[clambson]

Normal sort occurs on the first word of the text string within a cell, I think. I want to find all the occurences of the word 'President' in column E, and then sort on columns A,B,C, which is company name, first name, last name, etc.

any ideas?

 

[clambson]

I forgot the hard bit.....even if the text string in column E says Assistant Vice President, or Vice President, etc., where President is not the first word in the text string.

 

[acw]

Hi

How about sorting by columns A, B and C then using a filter (autofilter???) to filter out all those items that have "President" in column E.


Tony

 

[Smitty]

Welcome to the Board!

It might be easiest to add an intermediate column and use =RIGHT(E1,9) to isolate the word "President", then sort on that column.

Hope that helps,

Smitty

 

[barry houdini]

Try using another column with

=ISNUMBER(SEARCH("president",E1))

this will give TRUE or FALSE, sort on that and then sort the rest