I am having to add thousands of addresses to newsletters that I am doing for work. The addresses were given to us in a Microsoft Exel file, and I copied and pasted them into a word document then placed into Indesign. I am trying to figure out a way to auto format the addresses so that I do not have to individually format each address, which would take hours. I'm sure there is something fabulous indesign can do to help me out!
The addresses are currenty in one line... for example "John Smith 1212 Main St. Utopia, California 55555" and they need to be:
1212 Main St.
Utopia, California 55555
I have been trying different things for a while now. Any ideas on formatting that could save me a lot of time? I'll try anything!
It's not the "formatting" that's wrong here, or anything you could fix with a style.
Are those a single tab between name and address, and address and city? Search for these, replace with a hard return, and you're done.
Why don't you import directly your Excel file as a table, then convert your table to text?
You will be asked to choose what character you want to use to replace the column separator. Choose tab and then replace the tabs with a hard return. Depending on how your table is set, you may be able to choose directly a hard return to replace the column separator
Europe, Middle East and Africa