Deleting all the entire rows below your data and then saving the workbook
should reset the 'used range' of the sheet (the cell you go to by pressing
the End and then Home keys should not go beyond the last row/column with
data). Once the used range is reset you should not have this problem.

--
Jim
"JeffEE" wrote in message
...
| When I save an Excel worksheet as a tab-delimited text file, I get
additional
| carriage returns in rows below the data I'm interested in exporting. When
I
| view the text file in Word, I see all the additional tabs and carriage
| returns.
|
| I've tried going back and clearing (tried Edit/Clear/All and Edit/Delete)
| those rows from the spreadsheet and then creating a new text file but the
| tabs and carriage returns are still there.
|
| Can anybody help me eliminate these control characters? I guess I could
| just copy the cells of interest to a new spreadsheet but I'd like to know
how
| to eliminate them (in the spreadsheet)....for future reference.
|
| Thanks.