How to separate CSV fields in Excel to be in separate boxes

For example, I have the following:

fname;lname;email

...and it's all in开发者_StackOverflow社区 one box.

I would like it to be separated in different boxes, like:

fname  lname  email

How can I do this?

Got it silly me,

use go to data, form data, delimited with semicolons

:)

figured it a 30 sec after post

How is this related to programming?

Anyway you can just open CSV files in Excel. It supports the CSV format as well. You might only need to specify the separator character. Sometimes it's the semicolon ;, sometimes it's the comma ,.

They need to be separated by commas (comma delimited) not semi-colons.

e.g. fname, lname, email

Quotes around text fields wouldn't hurt either.