1. Right click and choose to open your ledesfilename.txt with Excel
2. Copy the “|” symbol from anywhere in the Excel spreadsheet
3. Select all of Column “A” (Click the letter A)
4. Click “Data” from the menu
5. Select “Text to Columns”
6. Select the “Delemited” radio button
7. Click “Next”
8. Uncheck the “Tab” Delimiter and check “Other”
9. Place the “|” symbol in the text box
10. Click “Next” then “Finish”
11. Save your new spreadsheet as Yourfilename.xls to your desired location.




Recent Comments