sorting on text within a cell

clambson

New Member
Joined
Dec 15, 2005
Messages
2
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?
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

clambson

New Member
Joined
Dec 15, 2005
Messages
2
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

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
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

Legend
Joined
May 15, 2003
Messages
29,536
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

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
Try using another column with

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

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

Watch MrExcel Video

Forum statistics

Threads
1,118,799
Messages
5,574,380
Members
412,589
Latest member
ArtBOM
Top