{"id":1668,"date":"2022-07-07T10:29:10","date_gmt":"2022-07-07T15:29:10","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1668"},"modified":"2022-07-07T10:29:10","modified_gmt":"2022-07-07T15:29:10","slug":"value-of-left","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1668","title":{"rendered":"VALUE() of LEFT()"},"content":{"rendered":"\n<p>I have been in a lot of situation needing to convert a number came out from a string into actual numbers. Sometimes N() worked, sometimes not, others VALUE() worked, but I did not see a function-does-all solution.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Looks like this is it. Not N() alone, not VALUE() alone, it is the combination of VALUE() and LEFT(), especially when you enclose them with IFERROR(), and this is the proof.<\/p>\n\n\n\n<p>_<\/p>\n\n\n\n<div class=\"wp-block-buttons is-vertical is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-4649e89c wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button has-custom-font-size has-medium-font-size\"><a class=\"wp-block-button__link\" href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/N-of-VALUE-VAL.xlsx\" style=\"border-radius:3px\">Download<\/a><\/div>\n<\/div>\n\n\n\n<p> _<\/p>\n\n\n<div class=\"wp-block-image is-style-default\">\n<figure class=\"aligncenter size-full\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/N-of-Value.jpg\"><img decoding=\"async\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/07\/N-of-Value.jpg\" alt=\"\" class=\"wp-image-1670\"\/><\/a><\/figure><\/div>","protected":false},"excerpt":{"rendered":"<p>I have been in a lot of situation needing to convert a number came out from a string into actual numbers. Sometimes N() worked, sometimes not, others VALUE() worked, but I did not see a function-does-all solution.<\/p>\n","protected":false},"author":1,"featured_media":1670,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,80,81,31,33,35,43,6,8,11],"tags":[147,154,165,172,203],"class_list":["post-1668","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas","category-if","category-iferror","category-information","category-left","category-logical","category-n","category-standard_functions","category-texts-and-strings","category-value","tag-if","tag-left","tag-n","tag-number","tag-value"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1668","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=1668"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1668\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1670"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}