Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
separating cells
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" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
separating cells
=CHAR(34) & SUBSTITUTE(A1," ",CHAR(34) & "," & CHAR(34)) & CHAR(34)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating data to put in seperate cells | Excel Discussion (Misc queries) | |||
Separating data from cells | Excel Worksheet Functions | |||
separating cells with text | Excel Discussion (Misc queries) | |||
separating text from cells | Excel Discussion (Misc queries) | |||
Separating information in one cell into several cells | Excel Discussion (Misc queries) |