Have a look at the =CONCATENATE function
or =A1&","&A2&","&... you get the idea

cheers
Simon

Blog: www.smurfonspreadsheets.net
Website: www.codematic.net Excel development, support and training


"Igneshwara reddy" wrote in
message ...
I need to run the script for concantenating the cells.

For eg: If I have 10 serial numbers in A1:A10, these numbers should
accompany with the ",". the result should come as 1,2,3,4,5,6,7,8,9,10

Often working with the formula is difficult, so I have planned to run
macros.

Could any one pls guide me with the script.