Formula for take a cell, make a comma and one than another cell ? =A1&","&A2

[zeko90]

Hi !

First, I'am really sorry for strange Title. I don't know how to describe this.
the best thing will be that i show it on case

Column A/Code
A
B
C

Final result will be: A,B,C (in one cell)
Now i have formula like this : =A1&","&A2&","&A3

But, know i have too many rows to do it like that any solution (it would be great is formula for that... i don't like macro )
I don't know from this to this range.. separate cell,,, make comma and go one go one...

Really tnx for help
have a nice day ahead !!

[:) Sixthsense :)]

Refer the below link for details...

http://www.excelforum.com/tips-and-t...geravatar.html

[benishiryo]

hi zeko90. without macro, you would have to accept doing it the hard way. in B1:
=A1

in B2:
=B1&","&A2

copy down until the row ends

[:) Sixthsense :)]

Or

Use =MCONCAT() function of Morfunc addin