Subcategories seperated in Excel output file

klohuis Expensify Customer Posts: 5


As I would like to make use of the subcategories function, I would also like the subcategory to show up in one seperate column when exporting to Excel. Unfortunately I haven't found a formula for this yet.

For example, let's say the subcategories are set up as:


Advertising: TV

Advertising: Radio

Then TV and Radio are the subcategories that show with an indent below the main Advertising category.

However, when exporting this to Excel, I would like one column to only show the part behind the ":", so only TV or Radio. Right now it is showing the full Advertising: TV or Advertising: Radio. Is there a formula so that only the part behind the ":" is shown in the excel column?

Many thanks in advance.

Kind regards,