I have an address list that isn't sorted into a table (see attached).
Instead they are typed in with a tab between the first name in the column and the second name in the column, etc. There is a paragraph character at the end of each line. Some addresses have three lines (name, address, city/state/ziphttps://www.pcreview.co.uk/forums/showthread.php?p=13104810#), and others have 4 lines (name, address, PO Box, city/state/zip). I can't figure out how to convert this to a list with rows in excel so that we can easily decide which people to send information to. This list comes to us once a month and we have to sort it and send out a mailing. Help us to streamline this process...
I tried using the tips outlined here:
https://www.pcreview.co.uk/forums/showthread.php?p=13104810#post13104810
but it doesn't apply to how our list is formatted...
THANKS!!
Nate
Instead they are typed in with a tab between the first name in the column and the second name in the column, etc. There is a paragraph character at the end of each line. Some addresses have three lines (name, address, city/state/ziphttps://www.pcreview.co.uk/forums/showthread.php?p=13104810#), and others have 4 lines (name, address, PO Box, city/state/zip). I can't figure out how to convert this to a list with rows in excel so that we can easily decide which people to send information to. This list comes to us once a month and we have to sort it and send out a mailing. Help us to streamline this process...
I tried using the tips outlined here:
https://www.pcreview.co.uk/forums/showthread.php?p=13104810#post13104810
but it doesn't apply to how our list is formatted...
THANKS!!
Nate
Attachments
Last edited: