I want to organize data into table format. the data I have on file is
not formated and has multiple information in single record field, and
info go on to multiple rows, for example:
customer name: abc age:x address: 123 all in one cell, no comma btw
those records, there is space btw those records but not consistent,
there are 1000 of those customers.
i want to display this data in table format having fields like
name,address, age,etc 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=543479