Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to save an Excel spreadsheet to a delimited text file, (either tab or
comma). The last 2 columns are blank on the spreadsheet. The delimiters for the blank fields stop showing on the text file after 15 records. I went back into the 16th row on spreadsheet and typed a space in each of the last 2 columns. When I save that as a delimited text file, the delimiters were at the end of the records for the 1st 15, the 16th, and the next 15, but then they stop again. I need those delimiters for those blank fields. Any help will be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check and Remove Records | Excel Discussion (Misc queries) | |||
How to sort/synchronise 2 data columns with missing records? | Excel Discussion (Misc queries) | |||
Retrieve only missing records from two spreadsheet | Excel Discussion (Misc queries) | |||
Top 90% of records - Bring out number | Excel Discussion (Misc queries) | |||
Deleting specific records | Excel Discussion (Misc queries) |