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

Sniper671

New Member
Joined
Apr 19, 2013
Messages
1
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
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Use word (I'm assuming you have word) and create a named range and mail merge file in excel to feed to word.
 
Upvote 0

Forum statistics

Threads
1,226,693
Messages
6,192,464
Members
453,725
Latest member
cvsdatreas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top