Auto copy from multiple cells into a paragraph (Concatenation?)

[Sniper671]

I need to take data from several cells on a form-type worksheet and have it copied to another cell and/or word document in a paragraph-ish format.
For instance:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Caller Name[/TD]
[TD]John Doe[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Caller Type[/TD]
[TD]Pharmacist[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Reason for Call[/TD]
[TD]Needs information required to fill prescriptions.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Action Taken[/TD]
[TD]Provided necessary information.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date/Time[/TD]
[TD]March 10, 2012[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

On March 10, 2012
John Doe, a Pharmacist, needs information requires to fill prescriptions. Provided necessary information.

The resulting paragraph should be able to be copied into a single cell and/or a word document without being pasted as a cell.
Additionally, if there is no information,i.e. no Caller Type, then nothing will be grabbed so the paragraph would be adjusted accordingly.

I have been able to use a concatenate formula but when the cell is copied, it grabs either the formula or it adds N/A where it should be blank.


I'd appreciate all help.

Sin Cera,

drey

 

[s hal]

Use word (I'm assuming you have word) and create a named range and mail merge file in excel to feed to word.