Is there a way to "tag" text in MS Excel so that when a table is imported into InDesign each tagged item automatically takes on the style of that "tag"?
I'm working on a project where I'm importing a file of 200+ line entries from MS Excel into an InDesign table, with 3 different font styles in each line. I need to find a way to be able to format all of the entries as they are imported into the InDesign table so tat I don't have to format each word individually afterward.
Each entry needs to look like this:
Section One - Section Two - Section 3 with one to four lines of text that will typically need to wrap
something similar to this so that it wraps under Section One and Section Two.
I want to avoid them looking like this:
Section One - Section Two - Section 3 with one to four lines of text that will only wrap inside
the third column. This needs to wrap under Section One and
Section Two like the sample above.
So basically I have 3 different font styles in each line: bold, bold italics, an then the rest of the text is regular. I know I can set up 3 separate columns, each with their own text style, but I need the text to wrap in a column under Section One and Section Two.
I wasn't sure if I could "tag" the sections somehow in MS Excel to adopt a paragraph style set in InDesign.
Any suggestions would be very appreciated.
If you're placing the tables, place them with formatting preserved. Then do 2 find/change operations to find your bold and bold-italics text, and replace with 2 specially created character styles. That will "tag" those style runs.
Now you can remove all formatting from the tables, apply paragraphs as per your design, and the character styles will still be there, so you won't have lost your formatting.
If the pattern of your text is consistent, (with space dash space between each section) you could do this with nested styles.
Thank you so much!! I'll try this!!