lists

[Guest]

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.

 

[squenson via OfficeKB.com]

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.