Combining multiple cells of text

degz77

New Member
Joined
May 24, 2017
Messages
6
I have these 5 cells of data that I want to combine: [TABLE="width: 500"]
<tbody>[TR]
[TD]Location: NJ[/TD]
[TD]Organization: American Cancer Society[/TD]
[TD]Website:http://cancer. org[/TD]
[TD]Contact: Susan Connelly, susan.connelly@cancer.org[/TD]
[TD]Volunteer Activity: Special event volunteer[/TD]
[/TR]
</tbody>[/TABLE]

I want all this information in one cell that is stacked. For example:
Location: NJ
Organization: American Cancer Society
Website: http://cancer. org
Contact: Susan Connelly, susan.connelly@cancer.org
Volunteer Activity: Special event volunteer

I hope someone can help!
 
Last edited:

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Toggle Word-Wrap on for the cell, and try:


Excel 2013/2016
ABCDEF
1Location: NJOrganization: American Cancer SocietyWebsite:[url]http://cancer[/url]. orgContact: Susan Connelly, [email]susan.connelly@cancer.org[/email]Volunteer Activity: Special event volunteerLocation: NJ Organization: American Cancer Society Website:[url]http://cancer[/url]. org Contact: Susan Connelly, [email]susan.connelly@cancer.org[/email] Volunteer Activity: Special event volunteer
Sheet5
Cell Formulas
RangeFormula
F1=A1&CHAR(10)&B1&CHAR(10)&C1&CHAR(10)&D1&CHAR(10)&E1
 
Upvote 0

Forum statistics

Threads
1,223,905
Messages
6,175,297
Members
452,633
Latest member
DougMo

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