So when you do a data merge, it uses a character as a delimiter between fields. The default is a comma. If you just have one column of data, with no fields to separate, then you can check the Show Import Options button when selecting your data source and define the delimiter to be something -anything! - other than a comma. This will force InDesign to ignore the commas in your data.
Brilliant! It worked!
I guess if I had multiple fields I could make it a tab-delimited file so that commas would be seen as commas and not as delimiters ... but isn't there a way to mark those commas so they are seen as text rather than delimiters? I remember in the old Word mail merge days I could do that ...
Word is not normally the program of choice for making Data Merge source files. If you use Excel it will put any strings with commas into quotes when you save a .csv version, and ID will interpret them correctly.
Thanks Peter, this is exactly what I needed to know for future projects, not sure why I couldn't find it anywhere!
Sent from my iPad