John Doe
John J Doe
Jonh Jason Doe
John Jason Lee Doe
I've already stripped out all of the suffixes (Jr., Sr, CFA, MD, etc) and am using the following formula. The problem is, for some reason some of the results are blank. I copied this formula from another sheet, but am having trouble following exactly what it's doing. Any help is GREATLY appreciated!
Expand|Select|Wrap|Line Numbers
- = RIGHT(J2,LEN(J2)-FIND("*",SUBSTITUTE(J2," ","*",LEN(J2)-LEN(SUBSTITUTE(J2," ",""))))))
THANK YOU!