Hello there! I have a text file contains many members data with line breaks separate one from another. How can I extract the data from lines of txt file to form a data table to an excel file? I know I can use Import txt file wizard in excel. But what i faced is that, not all members details share the same width and digits as they are in free text file.

Would vba helps to extract the details and put them to a table with column heads like: Account#, Name, Contact Person, Tel#, Fax#(if any), Enrollment Date, Expiry Date, Shopping History, Product, Amount?

Thank you for solving my question!!!!

Example:
================================================== =
Member Profile ABC Company Created Date 10-Jul-13

Account #
A1234 Name Amy Inc Contact Person Amy xxxxx
Tel# 12345678901
Fex# 123456987

Enrollment Date 10-Jul-13 Expiry Date 10-Jul-18

Shopping History Product Amount
AAA Company AAA product 700
BBB Company BBB product 8000
CCC Company CCC product 900

------------------------------------------------------------------------------
Member Profile ABC Company Created Date 10-Jul-13

Account #
B1234 Name Becky Inc Contact Person Becky xxxxx
Tel# 12345678902

Enrollment Date 10-Jul-13 Expiry Date 10-Jul-18

Shopping History Product Amount
AAA Company AAA product 700
BBB Company BBB product 8000
------------------------------------------------------------------------------

Member Profile ABC Company Created Date 10-Jul-13

Account #
C1234 Name Charlie Inc Contact Person Charlie xxxxx
Tel# 12345678903
Fax# 12358546651


Enrollment Date 10-Jul-13 Expiry Date 10-Jul-18

Shopping History Product Amount
DDD Company DDD product 700
EEE Company EEE product 8000

------------------------------------------------------------------------------
Member Profile ABC Company Created Date 10-Jul-13

Account #
D1234 Name David Inc Contact Person David xxxxx
Tel# 12345678904

Enrollment Date 10-Jul-13 Expiry Date 10-Jul-18

Shopping History
AAA Company AAA product 700
FFF Company FFF product 400
GGG Company GGG product 3200
------------------------------------------------------------------------------
etc...