My solution is not ideal, but it'll be quick and efficient:

Create another column next to the Name column and name it Surname. Then
in the first cell of that column (let's assume C2) enter this formula:

=RIGHT(B2, LEN(B2)-FIND("Alfred", B2, 1)+1)

all you need to change in the above formula is B2, which is the first
cell that has the name in the list and the "Alfred" which is the
surname. Once you do this copy the formula down for all the rows, now
all the cells in column C will have the surname you were looking for.
Just sort your list and you'll have all the rows you want.

Hope this helps.

Anar


--
anar_baku
------------------------------------------------------------------------
anar_baku's Profile: http://www.excelforum.com/member.php...o&userid=18259
View this thread: http://www.excelforum.com/showthread...hreadid=509708