Column A has a prefix: CAT
Column B has a category #: can be up to 3 digits (for example, 22)
Column C is the year: needs to be in 4-digit format for chronological sorting (for example, 2000)
Column D is the concatenated results: Column A + " " + Column B + "/" + last 2 digits of Column C (CAT 22/00)
I know how to concatenate, but not how to truncate the year within the concatenated formula.
I have attached a sample spreadsheet to help illustrate what I'm after.