Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating fields
gwc explained :
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" Use double double quotes... ="""19837511600150000"",""751160015-8"",""751160015-8""" ...where the entire value is wrapped in quotes. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating fields | Excel Discussion (Misc queries) | |||
separating info in one column to different fields | Excel Programming | |||
separating fields | Charts and Charting in Excel | |||
separating fields | Charts and Charting in Excel | |||
Separating a string to two fields | Excel Programming |