How to get data from text file to excel

Hello Everyone,
I need code for getting dta from text file to excel. i want the text to be appear like this.

eg: Organisation Name : ALPHA CELSIUS PTE LTD
Business Address : #02-42 Woodlands East Industrial Estate
Singapore 738734
Tel : (65) 6753 6177
Fax : (65) 6753 6788
E-mail : [email protected]
Website : -
Contact Person : MR DICKY LOW - Engineer
Business Description : Industrial, commercial, refrigeration, air-conditioning, refrigeration plant equipment & coldroom, design, supply, installation & service


the text is like this in notepad. I need them to split this data into corresponding columns like

Organisation Name Business Address Tel : Fax : E-mail Website Contact Person Business Description
ALPHA CELSIUS PTE LTD #02-42 Woodlands East Industrial Estate (65) 6753 6177
Singapore 738734


I want code for this can anyone help me?

I have one solution that reads the text file
in the exact format you have it: 9 rows of data
in each set, followed by sets of data with
nine rows each, and all rows except the country/zip
row are delimited by one occurrence of " : "
This may work for you if your data is consistent
with the format you provided. My attachment
includes two sets of records for testing purposes.

Copy both the Excel file and text file to the same folder
to try it out. Open up Module1 and run the Test_GetData
function to bring your data into Sheet1.

Good luck with your project.

Please Login or Register  to view this content.