I have a txt file that needs to be converted from txt to csv with excel. Process needs to be automated and I am not sure how to do this at all.
Any input would be a big help. The deliminator is a |
What did you expect?
You can upload 2 files to the cloud, a txt file with the original data and a csv file with the result of the first file conversion.
You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.