Change the *.csv filename to *.txt

Open that *.txt file in Excel and you should get the Text Import Wizard which
allows you to split the data into the 10 columns via the "delimited by" which in
your case would be the ;


Gord Dibben MS Excel MVP

On Fri, 30 Jun 2006 08:57:59 -0500, lorraine knight
<lorraine.knight.2a7xa1_1151676004.6492@excelfor um-nospam.com wrote:


I have a csv file seperated by a ; in a notepad. one line has 10 bits of
data, there are upto 40 lines or records. I want to import the data to
excel, when I use the Data/Import wizard, it places each record within
the notepad to one column, how do I get it to split the data within
each of the ; into a seperate column, using one row for each record.

Lorraine