LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Read text into Excel

I have a text file that looks like this:

Company Name
Name of Person
Telephone Number
Street Address
City, State Zip
Business Type

Company Name
Name of Person
Telephone Number
etc.....

How can I read these blocks of data into and Excel spreadsheet organized in
columns by Company Name, Name of Person, Telephone Number, etc.

Thanks
Brad
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I enter (5) in Excel and read as text? jinxMN Excel Discussion (Misc queries) 4 February 11th 06 10:33 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
numbers and text in Excel to read as text keeping the leading zer. Ralph Excel Discussion (Misc queries) 2 December 10th 04 07:05 PM
How to read multiple text files into excel? Together Excel Programming 3 February 29th 04 09:00 AM
How do I read text file in an EXCEL SHEET AMIT Excel Programming 2 December 31st 03 04:27 AM


All times are GMT +1. The time now is 06:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"