| 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) | |||
Linear Mode
