tag:blogger.com,1999:blog-1585105787473796476.post5116817880982414408..comments2024-03-29T10:50:44.713+00:00Comments on keyliner.blogspot.com: Excel Parse First Name, Last Nametraywolfhttp://www.blogger.com/profile/06205565591880314520noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-1585105787473796476.post-89102914797202013172013-06-11T05:19:36.049+01:002013-06-11T05:19:36.049+01:00Multiword suffixes are now support, provided they ...Multiword suffixes are now support, provided they have a leading comma. For example: John Q. Smith, Jr. MD Esq. will parse "Jr. MD Esq" as the suffix. A240 updated on 2013.06.10.<br /><br />without the comma, suffixes only detect common (Single-word) suffixes, as in John Q. Smith III (detects "III" properly). Similarly, John Q. Smith Jr. will work.<br /><br />I would still appreciate a comprehensive list of suffixes, including multi-worded; I could improve the routine further with this information.<br />traywolfhttps://www.blogger.com/profile/06205565591880314520noreply@blogger.comtag:blogger.com,1999:blog-1585105787473796476.post-91562952976515646762011-12-11T02:22:46.470+00:002011-12-11T02:22:46.470+00:00Oh, and don't forget to click the file-menu (o...Oh, and don't forget to click the file-menu (orb), "Excel Options", Trust Center, Trust Center Settings, and Enable all macros.traywolfhttps://www.blogger.com/profile/06205565591880314520noreply@blogger.comtag:blogger.com,1999:blog-1585105787473796476.post-81541102718115065892011-12-11T02:21:39.874+00:002011-12-11T02:21:39.874+00:00CoreEquity: If I understood your message correctly...CoreEquity: If I understood your message correctly, the macro-code was pasted properly.<br /><br />These macros are not ones you "Run" from the Macro-Run window. instead, they are called as a formula in a cell, such as =ReturnLastName.<br /><br />Hope this helps.traywolfhttps://www.blogger.com/profile/06205565591880314520noreply@blogger.comtag:blogger.com,1999:blog-1585105787473796476.post-85405805626235538162011-12-10T01:15:53.884+00:002011-12-10T01:15:53.884+00:00I can't see the macro's to start them. Bl...I can't see the macro's to start them. Blank macro window even though I have imported them and can look at the script<br /><br />excel 2010<br /> <br />thanks for any suggestions<br /><br />robertlcolby@gmail.comCorequity Valuationshttps://www.blogger.com/profile/13918004408326187248noreply@blogger.com