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