View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gwc gwc is offline
external usenet poster
 
Posts: 62
Default Separating fields

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"