I am new to these forums and haven't searched through threads much so let me apologize if this has already been answered numerous times.
I frequently save .xls sheets as tab and comma delimited files for uploading to a database. When saving as a tab delimited, excel loves to put quotation marks EVERYWHERE. Everywhere I have a " it wants to put another one, then another behind the text in that cell. If i have a dimensions field like 12 x 12 it likes to put "12 x "12....and if I call it 12" x 12"...well that's a whole other can of worms.
What 3rd party products are out there and work well for eliminating the step of me saving as tab delimited, opening it up in wordpad, and find/replace hundreds of " marks?
Thanks
Bookmarks