If I understand your problem, your data is seperated by semi-colons. When
using the 'Wizard' did you select 'Delimited' then 'Semicolon?' If not, this
could do the trick.
--
T Tipsy


"lorraine knight" 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


--
lorraine knight
------------------------------------------------------------------------
lorraine knight's Profile: http://www.excelforum.com/member.php...o&userid=35294
View this thread: http://www.excelforum.com/showthread...hreadid=557321