on 2/3/2012, gary supposed :
In an Excel formula, how do I add the quotation marks and the commas
between fields?

The result must look like this:

"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"

(I don't want a macro, just a formula).

Answered in other forum!!!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc