Here is what I'm typing into the AI formula bar
"I want the column to only run if
contains {{The}}, {{Inc.}}, {{& co}}, {{Companies}}, {{Wholesale}} and the desired output is only the commonly known brand name with legal suffixes or extra descriptors removed. Example input {{Costco Wholesale}} should output to {{Costco}}"
Here is the code it's giving "/(The|Inc\.|& co|Companies|Wholesale)/i.test({{Name}}) && {{Name}}?.replace(/(The|Inc\.|& co|Companies|Wholesale)/gi, "").trim()"
But it's still not normalizing the company name to my liking.