separating cells

[gwc]

Please give me an Excel formula to add quotation marks and commas
between these cells:

a b c
19837511600150000 751160015-8 751160015-8
19840100087290000 010008729-3 010008729-3
19850100397300000 010039730-9 010039730-9
19855160600250000 516060025-9 516060025-9
19860104767500000 010476750-8 010476750-8


so the result is:


"19837511600150000","751160015-8","751160015-8"
"19840100087290000","010008729-3","010008729-3"
"19850100397300000","010039730-9","010039730-9"
"19855160600250000","516060025-9","516060025-9"
"19860104767500000","010476750-8","010476750-8"

 

[James Ravenswood]

=CHAR(34) & SUBSTITUTE(A1," ",CHAR(34) & "," & CHAR(34)) & CHAR(34)