Sorting Addresses

[Roxy]

I have a question about sorting in excel. Is there an
easy way to sort a mailing/address list with the last
name being the second or third "word?" Also, does the
entire address need to be in the same cell? There's got
to be an easier way to do this instead of one by
one . . .

 

[Don Guillett]

a dummy column with the last name only & sort by that
or in different columns

Last Name
First Name
123
Second St
Your City
Your State
your zip