I need to find out if a company name starts with ‘The’ and if so remove it.
i.e. If a company name is ‘The Breakfast Club’ then the result will be ‘Breakfast Club’
I believe the ‘StartsWith’ formula should do this but I can’t work out how.
Here’s my attempt: IF([Company Name]=StartsWith(“The”), )
I don’t think i’m even close.