Search our Help.

How to Fix an Excel Template with Collapsed Columns

Follow

Summary: 

To rectify an excel template that has been saved incorrectly and has collapsed to a single column.

Platform: 

  •  Microsoft Excel

Steps:

 

  1. Click Data tab at the top menu
  2. Click Text to Column
  3. Check Delimited on the window popup
  4. Click Next
  5. Check Comma as delimiters
  6. Review the preview data
  7. 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.

 

Was this article helpful?
0 out of 0 found this helpful