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