![]() ![]() csv or the final merged InDesign file, if you still hapen to have double or tripple word spaces. Sounds complex, but it is pretty fast and easy once you get the hang of it.ĮDIT: Do a find/replace for multiple spaces and convert them to single spaces in the. Then you can just datamerge this single column. In the Data Merge panel, click on the icon in the upper-right corner, and. Then delete the original colum A/B/C as the new column D has the merged title/name. In InDesign, open the Data Merge panel by clicking Window > Utility > Data Merge. One can then copy the formula and paste special (formula only) onto all the records (row 2 to 1300 etc). This formula will put a word space between each column. (Presuming that A1 is the title and B1 is the given name and C1 is the family name). Use the formula to combine row 1, column A/B/C into the newly inserted working column. So insert a new column to work in (say column D). In Excel/OpenOffice/NeoOffice the formula to merge three columns together is as follows: Selecting a region changes the language and/or content on way that I have dealt with this is to combine the title and name fields in the spreadsheet, before doing the data merge. csv and txt field in the above mentioned format with a # sign on their column name. To generate QR codes, follow these instructions: ![]()
0 Comments
Leave a Reply. |