[Hidden-tech] Results of Excel to InDesign like break suggestions

[Bobbi Melville]

Thanks to everyone who responded with ideas for adding line breaks when
copying an Excel file into InDesign.


The overall winner was the suggestion to convert the file to semi colon
delimited and, in InDesign, replace all the semi colons with line breaks.
Simple, fast, and easy if you want each field on a separate line in your
final list.


However, I needed to keep three fields on the same line, so I used the
suggestion to add columns to the Excel file only where I wanted a line
break. Put nonsense characters in those columns. In InDesign, replace those
nonsense strings with line breaks. Bam. Done.


I even went a little further with the columns, adding another one after the
first of the three fields that I needed to stay together on one line. I
filled this column with a different string of nonsense characters. In
InDesign, I replaced this string with a tab. I added another column where I
needed a space, filled it with yet another nonsense string, and replaced
that with an em space.


This suggestion turned out to be the most flexible, yet easy to use. Thank
you!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20190307/d3f82d2c/attachment.html>