Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel mailing list in wrong format for mail merge
I have been handed a list that I need to convert and I am stumped.
The worksheet contains three columns of addresses. The addresses are generally in one of three formats: Company Contact Street number and name City State Zip or Name Street number and name City State Zip or The repeat of the above with two lines for street information. As far as I can tell so far, these four are the only the different formats. Some of the addresses have a comma between the city and state. One final complication, some addresses use the 5 digit zip, some use the zip+4 with a dash. Is there a way to convert these columns into approptiate rows so this can be used as a mail merge? Loren |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel merge mailing list template? | Excel Discussion (Misc queries) | |||
How do I merge an Excel mailing List with Microsoft Word Document | Excel Discussion (Misc queries) | |||
How do I format an excel document to transfer to mail merge? | Excel Discussion (Misc queries) | |||
Mailing labels, mail merge | Excel Discussion (Misc queries) | |||
Mail Merge - format of numbers | Excel Discussion (Misc queries) |