Simple Mail Merge Question

[Ethanflux]

I imagine this is simple for the experienced mail merge folks. I have a column in Excel that has values say "Ind1 Ind3 Ind4". What I need to know is how to get a paragraph inserted for each value. I am not sure on how to do this because these 3 values are in one cell in Excel and cannot be split up. I was thinking that there maybe was a formula something to the effect of If Mergefield contains the number 1 then insert paragraph 1, if it contains 3 then insert paragraph 3. I'm sure there is a way I just don't know how and I can seem to nail down the search terms when looking for the solution. Your help is most appreciated.

[macropod]

Hi Ethanflux,

What you're asking for would require some fairly complex field coding, to test what's at the 4th, 9th & 14th character positions (plus however may other character positions might hold paragraph indicators). It'd be far simpler from a mailmerge & field coding standpoint to have separate columns in the data source for each of the variables.