Subcategories seperated in Excel output file
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:
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.