I have first name and last name, with special characters, and can't figure out a formula. In the majority of cases I want to keep the format as is in SFDC (often spaces). Assume (first name) Mary Ann and (last name) Williams Smith. The resulting NE...
Anthony, first I appreciate this work very much. My second reaction is I referred to myself as not versed in formulas and how comical that is. Your formulas encourage me that in a year, I may be able to write it. Wow! Thank you very much.
Yes, that's the complexity. Looking at the data patterns, I would like to accomplish conditions and formulas for If 3 words: First-Last-Last....If 4 words: First-First-Last-Last, If 5 or more First-First-Last-Last-Last. I would view modified, expor...
Hi Anthony,Yes, you've described it perfectly. In fact, even in cases of more than four words, e.g. Mary Jo van der Maten, Maten is the last name. Those cases are fewer.