LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Yagnesh
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I convert text string into a cell reference Dave Davis Excel Discussion (Misc queries) 4 May 18th 23 11:48 AM
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 07:11 PM
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
How to make a cell return the formatted value in a text string (i. n.almeida Excel Worksheet Functions 3 February 2nd 05 01:59 PM


All times are GMT +1. The time now is 04:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"