Import txt file

  • Thread starter Thread starter Billy Leung
  • Start date Start date
B

Billy Leung

Hi all,

How can I import a text file (tab delimited) with over 400 columns. (Excel
only contain 200 something). Your help will be appreciated.


Billy
 
Hi
you can't in Excel. You have to split the data at least in two
worksheets
 
Thanks, Frank,

But, how can I split the text file in the first place?

Billy

************************************************
 
You must log in or register to reply here.

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

Auto Open Macro of external .txt file based on cell reference 1
Importing Text Files Into Access 1
Importing text with text qualifier 2
how to use 1st row for field names when importing? 1
Vlookup or similar 7
Import txt data with vlookup 2
Import txt files 1
Importing PDF files into Excel 2003 1

Back
Top