LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kate
 
Posts: n/a
Default Excel Text import wizard

Hello,

When you open up a .txt file in Excel, this starts up the Text import
wizard. On the second screen of the wizard, you get a set of delimiters to
choose from - Tab being the default. I have two people in which this is in
fact set to Comma delimited by default. Any ideas how to change the actual
default setting? (They want to get back to Tab delimited permanently!).
This is Excel2002 running on XP Professional, without SP2.

Cheers Mark


 
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
import .CSV file to XP EXcel 2003 worksheet, the seperator is com. ML New Users to Excel 1 January 22nd 05 05:23 PM
How can I import a text file into excel with each field as a sepe. [email protected] Excel Discussion (Misc queries) 8 January 18th 05 02:31 AM
How do I import a Windows Explorer list into Excel? Gord Dibben Excel Discussion (Misc queries) 0 December 1st 04 10:20 PM
How do i increase the size of numbers in a text in Excel. Harry Cross Excel Worksheet Functions 1 November 6th 04 09:24 PM
Parsing text in Excel Jack Edwards Excel Worksheet Functions 3 November 4th 04 03:54 PM


All times are GMT +1. The time now is 03:06 PM.

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

About Us

"It's about Microsoft Excel"