Convert rows into 1 cell or 1 string
 

If I have a worksheet with 10 rows going down, how can I join all of
them into 1 cell.

Ex)
123 - aaa;
354 - ghg;
246 - hbf;
234 - ggd;

I want the above 4 to fit into one cell like 123 - aaa; 354 - ghg; 246
- hbf; 234 - ggd;

Can someone offer any options. I am also open to any programming
language I could do this in where convert a row into one cell or one
continuous string.


--
Yagnesh
------------------------------------------------------------------------
Yagnesh's Profile: http://www.excelforum.com/member.php...o&userid=25661
View this thread: http://www.excelforum.com/showthread...hreadid=390758

Read up on CONCATENATE() function. That should do it.


Yagnesh Wrote:
If I have a worksheet with 10 rows going down, how can I join all of
them into 1 cell.

Ex)
123 - aaa;
354 - ghg;
246 - hbf;
234 - ggd;

I want the above 4 to fit into one cell like 123 - aaa; 354 - ghg; 246
- hbf; 234 - ggd;

Can someone offer any options. I am also open to any programming
language I could do this in where convert a row into one cell or one
continuous string.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390758

I tried the Concatenate function but it only limits 30 cells I could
merge. I have a row of about 1,000.


--
Yagnesh
------------------------------------------------------------------------
Yagnesh's Profile: http://www.excelforum.com/member.php...o&userid=25661
View this thread: http://www.excelforum.com/showthread...hreadid=390758

This is a round about way to do it...

Copy the 1000 cells and paste into Microsoft Word
From the Table menu, select Convert...Table to Text

From Edit menu, select Replace..
click on the More button
With the cursor in "Find what" section, click on the "Special" button,
then select Paragraph Mark
With the cursor in "Replace with" section, type a space (or a space and
semicolon, if that's what you want in between the entries)
Click on Replace All

Copy the result and paste into a cell in Excel

Assume A1:A1000 is your data:

B1000 = CONCATENATE(A1000,B1001) (Copy up)

Then B1 should be what you are looking for.


Hope this helps.


Yagnesh Wrote:
I tried the Concatenate function but it only limits 30 cells I could
merge. I have a row of about 1,000.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390758

Both suggestions worked.


--
Yagnesh
------------------------------------------------------------------------
Yagnesh's Profile: http://www.excelforum.com/member.php...o&userid=25661
View this thread: http://www.excelforum.com/showthread...hreadid=390758