sorting

L

LMO

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
 
S

scubadiver

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)
 
Top