This article may be out of date!
Visit the New Knowledge Center

How to Separate Matter Name From Matter Description in Some Exports


  • Break out Matter from Description in .CSV exports 
  • After importing no Matter is assigned


  • Excel

Additional Information:

Many Exports concatenate the Matter Name and the Matter Description using a colon (for example 00001-Smith becomes 00001-Smith: Breaking and Entering.

If your Matters contain colons (:'s), this process cannot be used to separate Matter names from descriptions. 


  1. Export source data
  2. Open CSV in Excel
  3. Select the Matter Column
  4. Click the Data tab
  5. Click the Text to Columns button
  6. Click the Delimited radio button
  7. Click Next
  8. Click Other
  9. Type ":" into the Other text field
  10. Click Next
  11. Click Finish
  12. Click OK
Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality