'Code' or 'Function' to concatenate into single cell ?

[Maverick27]

Hi - anyone care to share a piece of code (or function) to "concatenate" the data in cell cols. from A to L into a single cell M that should read as below. It should also have commas, inverted commas & brackets.

('01','OSR00001','25W B22 GLS LAMP FROSTED','OSGL25B22','735','1617','Frosted','Pin','B22','-','-','25')

Worksheet sample link:
http://imageshack.us/photo/my-images/69/excelnz.jpg/

Thanks

 

[Maverick27]

I want to see the TEXT in the "Formula Bar" for me to be able to copy the TEXT into a Word Doc.

 

[Maverick27]

Easy as that - Thanks again.