Hey all!
I have a very long list of employees in which I need to extract their names into a consistent format.
I'm using the below formulas with a 99% success rate, however employees with a suffix of "JR" or "II" (etc) are throwing a monkey wrench in the calculation.
First...