View Single Post
 
Old 10-03-2013, 04:31 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
You can import a text file into Excel and specify the delimiters in excel from your text file. As for formatting it will use the default formatting in your worksheet. Follow these steps:
Click on the Data menu in your worksheet.
Click on From Text
Navigate to your text file
Click on Import
Choose Delimited
Click on Next
Choose the delimiter used in your text file
Click on Finish

Hope this helps.
Good luck.
Tony
Reply With Quote