{"id":56,"date":"2011-04-18T15:39:10","date_gmt":"2011-04-18T15:39:10","guid":{"rendered":"http:\/\/www.edcortes.ph\/?p=63"},"modified":"2021-07-11T08:08:26","modified_gmt":"2021-07-11T08:08:26","slug":"left-function-in-excel","status":"publish","type":"post","link":"https:\/\/emcortes.com\/?p=56","title":{"rendered":"LEFT Function in Excel"},"content":{"rendered":"<p>The LEFT function is helpful if you want to return the first character or characters in a text string from the left, based on the number of characters you specify.<\/p>\n<p>Syntax<\/p>\n<p>LEFT(text,num_chars)<\/p>\n<p>Text   is the text string that contains the characters you want to extract.<\/p>\n<p>Num_chars   specifies the number of characters you want LEFT to extract.<\/p>\n<p>Num_chars must be greater than or equal to zero.<\/p>\n<p>If num_chars is greater than the length of text, LEFT returns all of text.<\/p>\n<p>If num_chars is omitted, it is assumed to be 1.<\/p>\n<p>Example 1: <\/p>\n<p>Data in A1: Sale Price<\/p>\n<p>Formula: =LEFT(A1,4)   <\/p>\n<p>Result: Sale<\/p>\n<p>Example 2: <\/p>\n<p>Data in A2: Sweden<\/p>\n<p>Formula: =LEFT(A2)   <\/p>\n<p>Result: S<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The LEFT function is helpful if you want to return the first character or characters in a text string from the left, based on the number of characters you specify. Syntax LEFT(text,num_chars) Text is the text string that contains the characters you want to extract. Num_chars specifies the number of characters you want LEFT to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,4],"tags":[],"class_list":["post-56","post","type-post","status-publish","format-standard","hentry","category-excel","category-programming-notes"],"_links":{"self":[{"href":"https:\/\/emcortes.com\/index.php?rest_route=\/wp\/v2\/posts\/56","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/emcortes.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/emcortes.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/emcortes.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/emcortes.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=56"}],"version-history":[{"count":1,"href":"https:\/\/emcortes.com\/index.php?rest_route=\/wp\/v2\/posts\/56\/revisions"}],"predecessor-version":[{"id":354,"href":"https:\/\/emcortes.com\/index.php?rest_route=\/wp\/v2\/posts\/56\/revisions\/354"}],"wp:attachment":[{"href":"https:\/\/emcortes.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=56"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/emcortes.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=56"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/emcortes.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=56"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}