A list of addresses can easily be placed into columns using MS Excel. Putting the address information into columns does not require reentering them into separate columns in Excel, but it will require some time, depending upon how many addresses you have.

Here’s an example for you:

Address looks like this:
Fern Carbonell
Speedy Space Travel
1234 Speedy St.
Cockatiel, MD 09876

You want to separate the text to the corresponding columns:
LName| FName| Company| Address| City| ST| Zip|

Here are the steps to get there:
1. In Excel, create the column headings
2. In document, select the text to copy into the Excel worksheet
3. In Excel, place your mouse in the first cell and paste
4. Now that all the addresses are in this file you will begin separating the text into columns.
5. Highlight the first set of addresses and select Copy
6. Place your cursor in the first column
7. Select Edit, Paste Special, place a check next to Transpose
8. The text should now be in columns.

Now you might have some cleaning up to do. If the steps are repetitive, create a macro and you’ll be done in no time.

Please share any feedback or experiences with this quick tip. I would love to hear from you.