Excel is a great program for manipulating data and then using it to concatenate a SQL string. Recently, I've found that when I copy concatenated string which looks perfect in excel, it adds quotes around the text when I try and paste them into a text editor or SQL manager. These quotes are unnecessary and I don't want them there.

Why does this happen?

I've found that if there are line breaks in your concatenated text, then excel will try and preserve the string by adding surrounding quotes.

How do I fix it?

I've found that by removing the line breaks - Excel will paste un-quoted text. If this doesn't help you and excel is still randomly quoting your text, let me know and maybe we can figure it out together.

Labels: Social-Learning