lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

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