Objective:
- How do I import things when the Matter column has both the Matter and Matter Description together with a colon?
Environment:
- Microsoft Excel
Additional Information:
When splitting text into columns, Excel will overwrite other adjacent columns with the split information. To avoid this, insert a column to the right of the Matter column first.
Procedure:
- Open the CSV in Excel
- Click the Matter Column Header (selecting the entire column)
- Click the Data tab
- Click Text to Columns
- Click Delimited
- Click Next
- Under Other type ":"
- Click Next
- Click Finish