Copying in data from text files

  • Thread starter Thread starter David Lloyd
  • Start date Start date
D

David Lloyd

Hi, I'd like to copy and paste the data in this web page:

ftp://ftp.ngdc.noaa.gov/paleo/icecore/antarctica/vostok/deutnat.txt

into excel.

Trouble is, I'm just getting it all in one column. For example, the
first row "0 0 -438 0.00" is all in one cell, rather than four
separate cells. How would I go about automatically inserting them into
seperate columns.

Thanks for any help
 
Copy and paste the data into a text file, then open the text file in Excel.
You will be prompted with the Text Import Wizard. In Step 1 choose delimited
(already selected here), step 2 tab delimiter(again, it's the default), step
3 select format for each column (though General is probably your best
option).

Ian
 

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 Help to copy information from one row at a time to another sheet 1
Copy data from unlocked cells 3
Copy paste data from a column to a row 0
VBA - retrieve data on last create named range from previous inserted named range 0
Copy & Paste cell that has alt + enter 2
Table copied from PDF goes into 1 Column 1
Getting Text data using the Data - Subtotal feature 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top