Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

convert ascii text file to excel

Status
Not open for further replies.
tek2002

tek2002

Programmer
Aug 21, 2001
67
US
i have this ascii text file and i have this excel template.
i need to convert and move the data in the ascii text file to the excel spreadsheet.

can anyone point me to where i can get help and instructions on how to do this?

thanks!
 
Sort by date Sort by votes
The easiest thing to do is to record an Excel Macro which loads the text file. it can then be modified to make it more general purpose if required.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
645
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
588
SkipVought
S
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
1K
bs6600
bs6600
techguy2010
  • Locked
  • Question
Excel macro to send e-mail to multiple agents with a different body for each 1
Replies
3
Views
822
techguy2010
techguy2010
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
2K
shytott
shytott

Part and Inventory Search

Sponsor

Back
Top