How to collect data from many cells in a row into one cell?

**rcurious** · 01-18-2012, 08:11 AM

How to collect data from many cells in a row into one cell?

I provided and example, how I want it be:

	A	B	C	D	E	F	G	H	I	J	K	...
1	Diameter	List of elements										...
2	∅6	9 1 3 5	9		1				3		5	...
3	∅8	5 4 7 9	5	4				7			9	...
...	...	...	...	...	...	...	...	...	...	...	...	...

I have very long rows with many columns starting from column C, some cells are empty. In cell B2 I want to collect all data from cells of the row with single space between them. The same I want to do in cell B3 and downwards ...

I know in Excell 2010, the cell can contain 32767 characters maximum.
Maybe it's better to export that list of elements to text file or use aditional reserved cells C2; D2; E2 - if the text doesn't fit to B2.

Appreciate any help

**MaczaQ** · 01-18-2012, 08:53 AM

Hi,

Try to work with this code

Please Login or Register  to view this content.

I hope it helps.

**Whizbang** · 01-18-2012, 09:25 AM

You can use the concatenate function

=CONCATENATE(C2,D2,E2,...)

Or this works just as well

=C2&D2&E2...

If you want spaces between elements, it would be:
=CONCATENATE(C2," ",D2," ",E2,...)
Or
=C2&" "&D2&" "&E2...