Round Conference Tables

Importing a met office tables into excel?

Hi I'm trying to run some statistical analysis on the table from this link http://www.metoffice.gov.uk/climate/uk/stationdata/stornowaydata.txt When i try and import it into excel (through copy and paste , or the import table option), it puts all the columns into one column which means i can't run any stats on it. Is there a way i can import it so each colum has its own column in excel? Thanks

Public Comments

1. First copy the data into Excel. Then select all the data. Then click on Data -> Text to columns. Choose fixed width. There are options to rename each column and you can trim the data using the Trim function.
2. You actually have several options: 1- Before you paste the data in Excel, select "Paste Special" and choose "Text only" 2- Use a macro to read that particular file into Excel automatically (HEre is when you need to contact me with more details on what you want from that page if you want me to do it for you) 3- Use Excel text functions to automatically cut that one column inot several columns based on what you need (Again, contact me with more details if you like) 4- Do the "Text-To-Column" wizard, which is in Data >Text to column if you have Excel2003 or in Data tab > Text to Columns if you have Excel2007 VBAXLMan is here to feed your Excel needs