View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
notmrexcel notmrexcel is offline
external usenet poster
 
Posts: 1
Default Exporting tab-delimiter file - 16 rows

Excel 2003:
1. Create 3 column headers a1, a2 and a3
2. Populate column a1 and a2 only, updating say 30 rows
3. Export as a Tab delimiter file.
4. Only the first 16 rows have the correct number of expected delimiters
e.g a1<taba2<taba3<tab
a<tabb<tab <- As expected 2 tabs
c<tabb<tab
17th row
p<tabb <--Missing Tab

The 2nd tab does not exist from row 17 onwards.
Anybody have any ideas why Only the first 16 rows???
Cheers