Скачать с ютуб TEXTBEFORE function | Splitting names from professional designations в хорошем качестве

TEXTBEFORE function | Splitting names from professional designations

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:   / oz-du-soleil   There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday. Website: http://ozdusoleil.com My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analy... My old blog: http://datascopic.net/blog-2-2