Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |