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
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
Originally Posted by moglione1
Yes try this =CONCATENATE(A1,";",A2,";",A3,";",A4,";",A5,";",A6,";",A7)
Paul
Take a look here:
http://www.mcgimpsey.com/excel/udfs/multicat.html
In article <[email protected]>,
moglione1 <[email protected]>
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
With the data in A1:A7 or any array, alter the cell references, try
=A1&";"&A2&";"&A3&";"&A4&";"&A5&";"&A6&";"&A7
Regards,
Alan.
"moglione1" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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.
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
<[email protected]>,
moglione1 <[email protected]>
wrote:
> Still no further with this. Forgot to mention there is about 2000
> rows of data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks