I have a field called: Branch Name
I need to extract text from it using a formula field. I’m just not sure how.
Examples of data in the field:
#2828 - Clarksville Branch - Clarksville, TN
#4109 - Aiken Branch - Aiken, SC
What I need to extract:
Clark...