Merge from excel to InDesign - it is common to use excel as a source for Data Merge. Is this relevant to your question?
Or are you asking about Excel files used in InDesign for live type?
Are the bullet characters in the Excel document or part of InDesign bullet feature?
Yes Daniel, I currently have all my text laid out in excel and put the data merge fields in InDesign. I have a column for each bullet (which are in InDesign, not excel) and if I leave the column blank in the excel document, I get a empty bullet space when I do the merge. The crazy part is that I have done this for another section and if I didn't have anything in the spot in excel, the bullet doesn't show up. I hope that makes sense.
I would think you must use a Paragraph Style for the bullets.
If you have a text bullet Data Merge will retain the bullet.
If you define a Style you will instruct Data Merge to Remove Blank Lines for Empty Fields (Options tab in Create Merged Document).
Study my Story Editor view to see the difference. The right column picks up the bullet from the style.
So I have paragraph styles in place. As you can see I add in the merge field data
I have the space in between the information and link (which causes the extra bullet spaces...see pic 2). If I take the space out, then I don't have the extra bullet spaces. Is there a way to do a Find/Change once the document is merged?
Sure. You can do a GREP search for ^\s+$ and leave the change field blank. That will remove any paragraph that contains only white space.
I do not GREP
I would use Find/Replace
(^p is the entry for Paragraph Return)
But if you defined the Style to include Space After than you would not need to use double returns
Daniel, that isn't going to help. If the paragraph was empty, the remove blank lines feature would have worked, but in this case there must be some sort of white space character.
You really should learn GREP. In this case it's a whole lot better sins the \s meta-character matches ALL the possible white space characters, and adding the + lets it match one ore more than one (and mix and match, to boot). You just can't do this with a plain text search.