{"id":76,"date":"2012-01-26T04:15:47","date_gmt":"2012-01-26T10:15:47","guid":{"rendered":"http:\/\/xlfxs.com\/?p=76"},"modified":"2012-01-26T04:15:47","modified_gmt":"2012-01-26T10:15:47","slug":"camelcase-to-camel-case","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=76","title":{"rendered":"CamelCase to Camel Case"},"content":{"rendered":"<p>Here is a good practice for combining functions to get a full smartsheet<\/p>\n<p>It basically add a space before any capital letter in a text, helpful when you have strings without spaces and want to convert them.<\/p>\n<p><span style=\"font-size: small;\">It is all in formulas. Put additional spaces before any upper case letter. made specially for custom request. Uses functions <em><strong>LEFT<\/strong><\/em>, <em><strong>MID<\/strong><\/em>, <em><strong>FIND<\/strong><\/em>, <em><strong>SMALL<\/strong><\/em>, <em><strong>COUNT<\/strong><\/em>, <em><strong>COLUMN<\/strong><\/em>, <em><strong>IF<\/strong><\/em>, <em><strong>CHAR<\/strong><\/em>, <em><strong>ISERROR<\/strong><\/em>, <em><strong>TRIM<\/strong><\/em><\/span><\/p>\n<p>I used here three formulas, first one in column C:<\/p>\n<pre>=TRIM(LEFT(B4,AE4-1)&amp;\" \"&amp;MID(B4,AE4,IF(AF4=\"\",500,AF4-AE4))&amp;\" \"&amp;IF(N(AF4)&gt;0,MID(B4,AF4,IF(AG4=\"\",500,AG4-AF4)),\"\")&amp;\" \"&amp;IF(N(AG4)&gt;0,MID(B4,AG4,IF(AH4=\"\",500,AH4-AG4)),\"\"))<\/pre>\n<p>And another one for columns E through AD:<\/p>\n<pre>=IF(ISERROR(FIND(CHAR(COLUMN()+60),$B4,1)),\"\",FIND(CHAR(COLUMN()+60),$B4,1))<\/pre>\n<p>And a third one in columns AE through AH<\/p>\n<pre>=IF(COUNT($D4:$AD4)&gt;=COLUMN()-29,SMALL($D4:$AD4,COLUMN()-29),\"\")<\/pre>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2012\/01\/Zip_0104.zip\"><img decoding=\"async\" class=\"aligncenter\" src=\"\/wp-content\/uploads\/2014\/12\/Download1.png\" alt=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>Here is a good practice for combining functions to get a full smartsheet It basically add a space before any capital letter in a text, helpful when you have strings without spaces and want to convert them. It is all in formulas. Put additional spaces before any upper case letter. made specially for custom request&#8230;.<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=76\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;CamelCase to Camel Case&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":77,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,26,3,80,31,32,35,38,40,53,6,8,9],"tags":[],"class_list":["post-76","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-char","category-find","category-formulas","category-if","category-information","category-iserror","category-logical","category-math-and-trig","category-mid","category-small","category-standard_functions","category-texts-and-strings","category-trim"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/76","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=76"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/76\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/77"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}