Any way to reduce/limit text in description field on a transaction report?

[ArtSpace-HF]

On a transaction report, the description field can get quite extensive because it's tied to the online description we have for related online events/programs (lots of details mentioned).

Is there anyway to limit/reduce/alter the amount of text that will show on a report for this field?

At the moment, when looking at a report, the description column can just get so big because of the text it's tied to, and accounting folks would love if there's a way to limit this, so the the reports are much cleaner and easier to read.

Thank you!

[Donnie-M]

@ArtSpace-HF Are you pulling the report from your online dashboard?

[ArtSpace-HF]

Yes, running a transactions CSV report.

[Donnie-M · Accepted solution]

@ArtSpace-HF You can do a quick trick to fix it so to speak.  Copy this and paste it in a new column in the 2nd cell down:  "=LEFT(AE2,30)"  This will truncate the description to 30 characters and you can put description above it in the header. The "AE" is the column of the description (at least on my report)  Then you can right click on the big description column and "hide" and get it out of there.  This is a low tech solution, and you could always record a macro.

[ArtSpace-HF]

Got it, thanks very much!

[Summer2024]

Thanks for providing the best answer here @Donnie-M ! 😃