Please follow following steps
Suppose that the names are in column A, Now in column B, apply the following
formula to extract the names excluding €˜the as
=MID(A1,FIND("The",A1)+3,LEN(A1))
Then
1.Select column B
2.Click DataSort from the toolbar
3.In the sort dialog box, select Column B from sort by drop down list
4.Click OK

You will get it!

Have a nice time€¦.


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1