-
1. Re: Data merge skipping one cell
macinbytes May 27, 2009 12:10 PM (in response to mikejasinski)I'll hop on the obvioius guess and ask "Does that title have a comma in it?"
When building data merge CSV files I make a textbox on the pasteboard, paste all of the data out of excel, do a find for the comma character and replace it with a word I know isn't used in my file "marklar" from south park, then replace the tabs with commas and paste that into a plain text editor, save that out as CSV. In any case I suggest when working with data merge to never use CSV as your working editing file as Excel has a tendency to format cells for no apparent reason when opening CSV. Short of having manual calculation set and knowing that everyone who touches the files also does there is room to be burned.
Edit: Mac 2008 Excel is what I have.
-
2. Re: Data merge skipping one cell
mikejasinski May 27, 2009 12:21 PM (in response to macinbytes)nope, no commas in the file, or in that skipped cell.
when i have the title in a text box by itself it works fine.
i did convert everything to plain text, before importing so it shouldn't have any excel issues...
-
3. Re: Data merge skipping one cell
mikejasinski May 27, 2009 12:22 PM (in response to macinbytes)i'll try it the CSV format and see what happens

