Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default Export to Tab Delimited Text Error

Hi,

I'm exporting a pile of data to tab delimited text and am getting an
extra row in my output that the next program is rejecting.

Is this maybe and EOF? If so, can I get rid of it? It appears to be one
character, which I can then delete in notepad and then save without it
returning.

I've tried moving the data to a new sheet and then saving, but I get
the same result.

Thank you for your help!

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Export to Tab Delimited Text Error

Try deleting all rows below your data (delete the entire row).

for example if your data ends in row 20, go to the namebox and enter

21:65536 and hit enter

then Edit=Delete

Now save the file as a workbook. Now try saving as tab delimited.

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
Hi,

I'm exporting a pile of data to tab delimited text and am getting an
extra row in my output that the next program is rejecting.

Is this maybe and EOF? If so, can I get rid of it? It appears to be one
character, which I can then delete in notepad and then save without it
returning.

I've tried moving the data to a new sheet and then saving, but I get
the same result.

Thank you for your help!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why can't I Export selected cells to tab-delimited text file? JE McGimpsey Excel Discussion (Misc queries) 1 November 28th 05 05:33 PM
How do I export Excel in a semi-colon delimited format? Robert1105 Excel Discussion (Misc queries) 4 May 28th 05 09:56 PM
Export excel file to semicolon delimited text file capitan Excel Discussion (Misc queries) 5 April 7th 05 03:06 AM
How do I export XLS to TXT delimited by '|'? Mohsin Ghani Excel Discussion (Misc queries) 2 February 11th 05 03:36 AM
Export specific cell data to txt delimited file Aldo Excel Programming 2 December 1st 04 02:02 AM


All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"