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