How to Fix an Excel Template with Collapsed Columns
FollowSummary:
To rectify an excel template that has been saved incorrectly and has collapsed to a single column.
Steps:
- Click Data tab at the top menu
- Click Text to Column
- Check Delimited on the window popup
- Click Next
- Check Comma as delimiters
- Review the preview data
- Click Finish
Additional Information:
The file can sometimes be separated by semicolons depending on what the customer saved. In this case, review the data and select the delimiter to be semicolons.