Transaction import from Wells Fargo paused. Please visit our status page for more details and to subscribe to updates.

Subcategories seperated in Excel output file

klohuisklohuis Expensify Customer Posts: 5

Hello,

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

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,

Koen

Answers

Sign In or Register to comment.