LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 18th 07, 07:50 PM posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Aug 2006
Posts: 76
Default tab delimited adding extra tabs

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!


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
adding extra digits to columns Graham at Mac's Excel Discussion (Misc queries) 2 August 21st 06 11:24 AM
adding extra digits to columns Muhammed Rafeek M Excel Discussion (Misc queries) 0 August 21st 06 10:35 AM
adding extra marker styles Grizzabella Charts and Charting in Excel 4 September 15th 05 04:31 AM
adding extra text into an existing column Zach Excel Worksheet Functions 2 August 11th 05 05:26 PM
Adding an extra validation to this formula. Mindie Excel Discussion (Misc queries) 1 March 8th 05 12:49 AM

All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017