Concatenate multiple cells

M

moglione1

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
 
A

Alan

With the data in A1:A7 or any array, alter the cell references, try
=A1&";"&A2&";"&A3&";"&A4&";"&A5&";"&A6&";"&A7
Regards,
Alan.
 
P

Paul Sheppard

moglione1 said:
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
Click to expand...


Yes try this
=CONCATENATE(A1,";",A2,";",A3,";",A4,";",A5,";",A6,";",A7)

Paul
 
M

moglione1

Ok.

Still no further with this. Forgot to mention there is about 2000 row
of data.

And they are going to change sometime depending on the filter in place


Any more ideas please
 
J

JE McGimpsey

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
 
Top