How can I find and delete tabs and carriage returns ?

[Guest]

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.

 

[Jim Rech]

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
| 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.