From your example it looks like your data is semicolon delimited. There is
an option to use semicolon as a delimiter in the import wizard. Try that

"hasn7" wrote:


I want to organize data into table format. the data I have on csv file
is not formated and has multiple information in single record field,
and info go on to multiple rows, for example:

NAME: abc AGE:x ADDRESS: 123

all this info is in one cell, no comma btw the info, there is space but
its not consistent, there are 1000 of those customers.Some customer info
cover multiple lines.
i want to display this data in table format having fields like
name,address, age with info stored in rows and columns.
Can somebody help!!



--
hasn7
------------------------------------------------------------------------
hasn7's Profile: http://www.excelforum.com/member.php...o&userid=34577
View this thread: http://www.excelforum.com/showthread...hreadid=543495