I have a field called “Category” where each of the categories are plural (i.e., “Widgets”, “Cogs”, etc.)

In the first field (record) i have a formula that grabs a product name, concatenated with the “Category” at the end.

I would like to have the “s” removed from the category name.

Here’s my current formula:

`MFR & " " & {Model} & " " & {Category}`

So essentially, I would like to remove the last letter, from the {Categroy} name.

Thanks in advance for any help on this!!