{"id":186,"date":"2021-07-02T15:14:45","date_gmt":"2021-07-02T15:14:45","guid":{"rendered":"https:\/\/excelforgbs.com\/?page_id=186"},"modified":"2022-06-10T17:28:14","modified_gmt":"2022-06-10T17:28:14","slug":"text-functions","status":"publish","type":"page","link":"https:\/\/excelforgbs.com\/?page_id=186","title":{"rendered":"Text Functions"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The simplest function for text strings is to &#8220;add&#8221; them together &#8212; concatenation:   <a href=\"https:\/\/excelforgbs.com\/?p=159\">Basic text functions<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Extract part of a text string with LEFT(), RIGHT(), MID(), LEN() and FIND():  <a href=\"https:\/\/excelforgbs.com\/?p=162\">Working with parts of a text string<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Control the case of strings with LOWER(), UPPER() and PROPER(): <a href=\"https:\/\/excelforgbs.com\/?p=165\">Adjusting the case of a text string<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Find and replace parts of text strings with SUBSTITUTE():  <a href=\"https:\/\/excelforgbs.com\/?p=203\">Find and replace in text strings<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/excelforgbs.com\/?page_id=188\">Next Page:  Date and Time Functions<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The simplest function for text strings is to &#8220;add&#8221; them together &#8212; concatenation: Basic text functions Extract part of a text string with LEFT(), RIGHT(), MID(), LEN() and FIND(): Working with parts of a text string Control the case of strings with LOWER(), UPPER() and PROPER(): Adjusting the case of a text string Find and &hellip; <a href=\"https:\/\/excelforgbs.com\/?page_id=186\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Text Functions<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":30,"menu_order":20,"comment_status":"closed","ping_status":"closed","template":"","meta":{"nf_dc_page":"","_monsterinsights_skip_tracking":false,"footnotes":""},"class_list":["post-186","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=186"}],"version-history":[{"count":5,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/186\/revisions"}],"predecessor-version":[{"id":331,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/186\/revisions\/331"}],"up":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/30"}],"wp:attachment":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}