{"id":1768,"date":"2022-08-17T14:39:27","date_gmt":"2022-08-17T19:39:27","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1768"},"modified":"2022-08-17T14:39:27","modified_gmt":"2022-08-17T19:39:27","slug":"cuts-string-of-list-of-items","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1768","title":{"rendered":"Cuts string of list of items"},"content":{"rendered":"\n<p>An old lesson to one of my early classes to show how can we cut a string having list of items into its parts. (At least 1st three parts) using formulas only.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<!--more-->\n\n\n\n<p>If we put the character that is the separator of the string in cell D5. we can get 1st part using:<\/p>\n\n\n\n<p><code>=LEFT( C8, SEARCH( D5, C8)-1)<\/code><\/p>\n\n\n\n<p>2nd part will be with longer formula:<\/p>\n\n\n\n<p><code>=MID( C8, SEARCH( D5, C8)+1, SEARCH( D5, C8, SEARCH( D5, C8)+1)-SEARCH( D5, C8)-1)<\/code><\/p>\n\n\n\n<p>While the leftover of this string using:<\/p>\n\n\n\n<p><code>=MID( C8, SEARCH( D5, C8, SEARCH( D5, C8)+1)+1,500)<\/code><\/p>\n\n\n\n<p>My plan is to keep working on it to work on other parts.<\/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-full is-style-default\"><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/08\/2009-01-22-Lessons.jpg\"><img decoding=\"async\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2022\/08\/2009-01-22-Lessons.jpg\" alt=\"\" class=\"wp-image-1769\"\/><\/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!An4iomsT7EVO65VwNOaFgSEFC9_8kA?e=S4BKSX\" 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\/08\/2009-01-22-Lessons.xls\" style=\"border-radius:4px\">Download Excel file<\/a><\/div>\n<\/div>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>An old lesson to one of my early classes to show how can we cut a string having list of items into its parts. (At least 1st three parts) using formulas only.<\/p>\n","protected":false},"author":1,"featured_media":1769,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,33,40,52,6,8],"tags":[154,161,183],"class_list":["post-1768","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas","category-left","category-mid","category-search","category-standard_functions","category-texts-and-strings","tag-left","tag-mid","tag-search"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1768","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=1768"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1768\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1769"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}