Partial Text Match Formula - Name Contains

[brightvessel]

Hi all,

Airtable Table Newbie, but feel in love.

I want to group rows by partial text in the field.

(CDPA) Campaign 1
(CDPA) Campaign 2
(CDPA) Campaign 3

I want to group all three above using the (CDPA).

I assume it would create a formula row to do this, but I do not know how to create the formula

Can someone help?

Thanks,

Judd

[brightvessel]

Here is some more context. The column is a campaign name, and I want to group by a specific location, which titles differ except for the acronym, ex, CDPA.

[brightvessel · Accepted solution]

I believe this would be the answer. I thought I needed a new column when it was just a duplicate current and filter in the column.