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!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
convert text file to csv file
- Thread starter takyan
- Start date
RobBroekhuis
Technical User
Depends on what's in the text file. You should be able to read it into Excel, use TextToColumns to parse the text data, then Save As a .csv file. If the information is not amenable to TextToColumns treatment, you can use the VBA file handling commands to programmatically read in, parse and write the data (but that's a lot more work).
Rob
![[flowerface]](/data/assets/smilies/flowerface.gif "[flowerface] [flowerface]")
Rob
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question
