tab delimited adding extra tabs

M

maryj

I am entering data into Excel - have tried in both Excel 2000 and 2003 and
get the same results.

For example,
A1: <NetworkName> (press tab)
B1: 3MDS (press Enter)
(press Enter)
A3: <LocationName> (press tab)
B3: 235 Cafeteria (press Enter)
A4: <PlayerName> (press Tab)
B4: <StartTime> (press Tab)
C4: <EndTime> (press Tab)
D4: <Duriation> (press Tab)
E4: <Content> (press Enter)
A5: player1 (press Tab)
B5: data1 (press Tab)
B6: data1 (press Enter)

I then save the file as .txt - tab delimited.
When I open the file in Word, there are extra tabs (2 or 3) at the end of
rows 1,3, and 5 and then a paragraph.
Rows 2 and 4 have only a paragraph mark at the end - this is I need it to be.

Any ideas why I am getting he extra tabs? Even more so, how can I prevent
them from occurring?

Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 convert into tab delimeter text file with extra tab spa 0
Generate a TAB When Converting From Excel to Delimited Text 1
Automating references to tabs in formulas 4
Tab Delimited Query 5
creating summary table of input from other worksheets 1
Macro to force text to rol to next cell 2
Can I easily create a tab-delimited file from plain text in Word? 1

Top