Bulleting a merged "List"

[BOBODD]

I've tried searching the forums for this, but it seems to be an odd one.

My excel spreadsheet is using the function:
=IF(ISBLANK(Clients!A2),NA(),CONCATENATE((IF(ISNUMBER(Clients!$B2),CONCATENATE(Coversheet!$B$14,"
"),"")),(IF(ISNUMBER(Clients!$C2),CONCATENATE(Coversheet!$B$15,"
"),"")),(IF(ISNUMBER(Clients!$D2),CONCATENATE(Coversheet!$B$16,"
"),"")),(IF(ISNUMBER(Clients!$E2),CONCATENATE(Coversheet!$B$17,"
"),"")),(IF(ISNUMBER(Clients!$F2),CONCATENATE(Coversheet!$B$18,"
"),""))))

This is generating a list of presentation titles within a single cell. There
are Alt-Enter characters between each title returned so that I can merge the
list as a single field.

They are being merged into a word document as below:
"Presentations:<<presentations>>"

My question is how do I tab or indent the subsequent lines in the merged
list so that it is in line with the first entry?

 

[Doug Robbins - Word MVP]

The most certain way to achieve the desired result is to put a two column,
one row table in the mailmerge main document and put
the "Presentations:" and "<<presentations>>" in separate cells. Remover the
border form the table so that it does not show.

If the data returned by "<<presentations>>" was all in one paragraph, you
could achieve the result by formatting the paragraph with a hanging indent.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP