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:

Caller Name	John Doe
Caller Type	Pharmacist
Reason for Call	Needs information required to fill prescriptions.
Action Taken	Provided necessary information.
Date/Time	March 10, 2012

<tbody>
</tbody>

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.