sorting
 

Does any one know how to take a column in a worksheet that has several words
in it and sort them by a specific word?

eg; M Walter c/o ABC
I dont know
please help c/o ABC

I want all of the ABC to appear together

sorting
 

An easier thing to do would be to find "ABC" anywhere in the string and
place it in another column then you can sort the columns on that.

=FIND("ABC",B4,1)

"LMO" wrote:

Does any one know how to take a column in a worksheet that has several words
in it and sort them by a specific word?

eg; M Walter c/o ABC
I dont know
please help c/o ABC

I want all of the ABC to appear together