lists

S

Shari

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.
 
S

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.
 
Top