Importing a text file, and converting specific columns

Right chaps.

i've tried a few methods, but nothing that works right yet.

i need to import a text file into a spreadsheet that already contains the header row.

the spreadsheet has 50 columns, semi colon seperated.

columns 1-10 need to be text,11-20 as number /general, and everything afterwards as text again.

let's see your magic, guys

When I've done this, I've used the "import external data" command. After specifying the text file, it will bring up the text import wizard. As you work through the wizard, you'll have the opportunity to specify the semicolon as your delimiter, and be able to specify how it should treat each column. It will then import the file using those specifications.