Objective:
- Convert a LEDES Bill to a readable format
- Convert a LSA Trust Report to a readable format
- View a text file within Excel
Environment:
- Excel
Additional Information:
Please note that the LEDES Bills and LSA Trust Reports will still need to be uploaded to their respective destinations in the original downloaded format.
Procedure:
- Open the file within Excel
- Select column "A"
- Select the Data tab
- Select "Text to Columns"
- Select "Delimited"
- Select "Next"
- Check the box for the appropriate delimiter(For LEDES and the LSA Report this will be "Other", and the field for "Other" should be "|")
- Select "Next"
- Select "Finish"