Normally you would extract the word you want to sort on into another
helper column and sort on that column. However, it would be difficult
to write a formula to do this from your examples - in the first example
you want to extract the last word in column B, in the second example it
is the third word from four, and in the third example it is the first
word. How would any formula know where to get the word from in such a
diverse spread?

Pete

Scott G wrote:
Scott G wrote in
8.18:


1410 Mr & Mrs Dennis D Kaney;226 Triton Rd;Ormond Beach;FL;32724
1418 Mrs Brendan Sayers Jr; 500 N Oleander Avenue;DeLand; FL;32724
1419 Microsoft Corporation; 1 Gates Way; Redmond; WA 11152

The first column is account number. Columns B through F contain the name,
address, city, state and zip code.

Sort Order would be by name. Desired results would be Kaney, Microsoft,
Sayers.

Thanks for the help!