Wednesday, November 3, 2010

Put Double quotes in excel data

How to put quotes in excel data:- copy double quote in a cell and in another cell put ", after that user this formula  =CONCATENATE(F2,A2,G2) in a cell you will get following data , If you want this data to use in sql-server just do find and replace " with with single quote ' and you dont have to put quotes start and end of the data.








2063719971
"2063719971",

" ",
2063719997
"2063719997",

" ",
2063720425
"2063720425",

" ",
2063720466
"2063720466",

" ",
2063720789
"2063720789",

" ",
2063720797
"2063720797",

" ",

No comments: