Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Concatenate multiple cells
Does anybody know if you can concatenate multiple rows. E.g. I have 12 13 70 99 01 02 76 I want to put these into one cell seperated by ; E.g. 12;13;70;99;01;02;76 -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=396874 |
#2
|
|||
|
|||
Take a look he
http://www.mcgimpsey.com/excel/udfs/multicat.html In article , moglione1 wrote: Does anybody know if you can concatenate multiple rows. E.g. I have 12 13 70 99 01 02 76 I want to put these into one cell seperated by ; E.g. 12;13;70;99;01;02;76 |
#3
|
|||
|
|||
With the data in A1:A7 or any array, alter the cell references, try
=A1&";"&A2&";"&A3&";"&A4&";"&A5&";"&A6&";"&A7 Regards, Alan. "moglione1" wrote in message ... Does anybody know if you can concatenate multiple rows. E.g. I have 12 13 70 99 01 02 76 I want to put these into one cell seperated by ; E.g. 12;13;70;99;01;02;76 -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=396874 |
#4
|
|||
|
|||
moglione1 Wrote: Does anybody know if you can concatenate multiple rows. E.g. I have 12 13 70 99 01 02 76 I want to put these into one cell seperated by ; E.g. 12;13;70;99;01;02;76 Yes try this =CONCATENATE(A1,";",A2,";",A3,";",A4,";",A5,";",A6 ,";",A7) Paul -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=396874 |
#5
|
|||
|
|||
Ok. Still no further with this. Forgot to mention there is about 2000 rows of data. And they are going to change sometime depending on the filter in place. Any more ideas please. -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=396874 |
#6
|
|||
|
|||
You're probably not going to get much help if you don't say why the
previous suggestions won't work for you. Why would anyone want to put more time into playing "bring me a rock"? The macro I suggested will easily concatenate 2000 rows in less than a second. The number of In article , moglione1 wrote: Still no further with this. Forgot to mention there is about 2000 rows of data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add the same character(s) to multiple cells in a column (or row) . | Excel Discussion (Misc queries) | |||
Concatenate cells in Pocket Excel | Excel Discussion (Misc queries) | |||
Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
How do I insert a symbol BEFORE text for multiple cells in Excel? | Excel Worksheet Functions | |||
how do i add the same text after current text in multiple cells | Excel Discussion (Misc queries) |