View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JBeaucaire[_85_] JBeaucaire[_85_] is offline
external usenet poster
 
Location: Bakersfield, CA
Posts: 45
Send a message via Skype™ to JBeaucaire[_85_]
Default Convert excel (.xls) to tab delimited (.txt) without double quotat

Yes, but it involves another step outside of Excel. When you select
tab-delimited, that is the behavior you get.

As soon as you save your file, open it in NotePad or EditPad (an even more
robust notepad program) and do a Search/Replace.

Ctrl-H usually brings up the window.

Search: ","
Replace: ,
Replace All

Then save the document again.

Will this work for you?
--
"Actually, I AM a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Andrea" wrote:

When converting my excel spreadsheet to tab delimited, I get double quotation
marks around anything that has a comma. This is making the datafeed in my
website appear unclean. Is there any way around this?
--
Andrea