ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Separating fields (https://www.excelbanter.com/excel-discussion-misc-queries/374898-separating-fields.html)

gwc

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"


All times are GMT +1. The time now is 09:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com