TEXTBEFORE function | Splitting names from professional designations

/in /by

The TEXTBEFORE functions was recently released in this video I show 3 uses for TEXTBEFORE, it’s strengths and limitations.

In this example we have names and professional designations. The problem is some people have more than one designations, some have 1 designation and some folks have no designations.

BUT! We have to be careful. We can’t target all suffixes for removal.
REMOVE:
CFP, VP, MD and DDS
KEEP:
Jr. and III

#TEXTBEFORE
#SplittingNames
#SplittingText
For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2