{"id":1725,"date":"2022-07-23T13:02:00","date_gmt":"2022-07-23T18:02:00","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1725"},"modified":"2022-07-23T13:02:00","modified_gmt":"2022-07-23T18:02:00","slug":"always-get-1st-name-or-last","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1725","title":{"rendered":"Always get 1st name (or last)"},"content":{"rendered":"\n<p>Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>You can then have a formula to show it in the format you need.<\/p>\n\n\n\n<p>This one uses an old technique using function ISERROR, since it was created before the formula IFERROR was added to Excel. I bet we can have a better version now \ud83d\ude42<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/1stlast.jpg\"><img decoding=\"async\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/1stlast-1024x406.jpg\" alt=\"\" class=\"wp-image-1727\"\/><\/a><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"https:\/\/1drv.ms\/x\/s!An4iomsT7EVO65NH2qlcA1toDcqOSQ?e=FdAFTO\" style=\"border-radius:4px\">Excel Online<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/FirstLastName_Extract.xlsx\" style=\"border-radius:4px\">Download<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats.<\/p>\n","protected":false},"author":1,"featured_media":1727,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,80,87,33,34,35,50,52,6,8,9],"tags":[147,152,154,155,181,183,200],"class_list":["post-1725","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas","category-if","category-iserror-logical","category-left","category-len","category-logical","category-right","category-search","category-standard_functions","category-texts-and-strings","category-trim","tag-if","tag-iserror","tag-left","tag-len","tag-right","tag-search","tag-trim"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1725","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1725"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1725\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1727"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1725"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}