Export to Tab Delimited Text Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

reitanospa1@yahoo.com - 24 Jan 2006 15:04 GMT

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 to this Message

Tom Ogilvy - 24 Jan 2006 15:23 GMT

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.

Signature

Regards,
Tom Ogilvy

> Hi,
>
[quoted text clipped - 9 lines]
>
> Thank you for your help!

Reply to this Message