Sort Addresses by Last Name

Paste addresses with a blank line between each one. They’re sorted by the last name on their first line, and every address stays in one piece.

Advertisement

Getting your addresses in

Put a blank line between addresses. Copying from a spreadsheet where each address is one row? Sort those with Sort by last name instead, since a row already is a single line.

The first line of each address is read the same way as the last name sorter, so titles, couples, “& Guest” and “The Smith Family” are all handled.

Holiday card list

Before
Mr. and Mrs. Tom Smith
12 Main Street
Springfield, IL 62701

Dr. Ann Baker
4 Elm Avenue
Shelbyville, IL 62565

The Jones Family
9 Oak Road
Capital City, IL 62702
After
Dr. Ann Baker
4 Elm Avenue
Shelbyville, IL 62565

The Jones Family
9 Oak Road
Capital City, IL 62702

Mr. and Mrs. Tom Smith
12 Main Street
Springfield, IL 62701

Questions

My addresses got mixed together. What happened?

Make sure there’s an empty line between every address and no empty lines inside one. Then press Undo and try again.