| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lists
I have a column of text data that I would like to format - comma then
enclose the text in quotes. If there is a way, it would save me a lot of work when I copy the text to sql. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lists
Please be more precise. If you want to add quotes around the text, you can
have a formula like ="""" & A2 & """" """" is four time the double quotes. If your text is of fixed length and you want to split it, the use of MID function will certainly be needed. Shari wrote: I have a column of text data that I would like to format - comma then enclose the text in quotes. If there is a way, it would save me a lot of work when I copy the text to sql. -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
| LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
| Lists referencing lists...is it possible? | Excel Worksheet Functions | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| lists from other lists in excel | Excel Worksheet Functions | |||
Linear Mode
