N
notmrexcel
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<tab>a2<tab>a3<tab>
a<tab>b<tab> <- As expected 2 tabs
c<tab>b<tab>
17th row
p<tab>b <--Missing Tab
The 2nd tab does not exist from row 17 onwards.
Anybody have any ideas why Only the first 16 rows???
Cheers
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<tab>a2<tab>a3<tab>
a<tab>b<tab> <- As expected 2 tabs
c<tab>b<tab>
17th row
p<tab>b <--Missing Tab
The 2nd tab does not exist from row 17 onwards.
Anybody have any ideas why Only the first 16 rows???
Cheers