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.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>