Get Data From Text File And Convert To Excel File

Hi Everybody...

I'm really need your expertise in Excel and VB Script.

I have a data in .txt file and try to export to excel file. The data in .txt file looks like below:

============================================================================

User John Marshall
Designation Senior Operation Manager
Desktop Yes
Laptop No
Desktop Model Dell Optiplex GX280
Laptop Model N/A
Contact Number
Fixed Line +60342910606
Mobile +60122323456
Remarks User currently attending training from 21st May 2011 to 22nd June 2012.
!
User Chan Liu Fan
Designation HR Manager
Desktop Yes
Laptop No
Desktop Model Dell Optiplex GX280
Laptop Model N/A
Contact Number
Fixed Line +60342910610
Mobile +60122347471
Remarks User is active
!
User Ahmad Fahmi Bin Alwi
Designation Operation Supervisor
Desktop No
Laptop Yes
Desktop Model N/A
Laptop Model IBM Lenovo ThinkPad L412
Contact Number
Fixed Line +60342910616
Mobile +60123431010
Remarks User is active

..........
!
!
User Access-Right Access-to-all-Site Access-to-HQ

John Marshall Full Yes Yes
Chan Liu Fan Limited No Yes
Ahmad Fahmi Bin Alwi Limited Yes (Limited) Yes

........
!

============================================================================


Now i try to export some of the data in this .txt to excel file. And that excel file should be looks like below:

User Datails.xlsx

Anyway, I'm very new in Excel and VB Scripting.

Can You upload text file? I think We can get VBScript.RegExp to solve this case

Hi nmhung49,

Here's that .txt file:

test.txt