{"id":102,"date":"2015-11-01T17:10:45","date_gmt":"2015-11-02T01:10:45","guid":{"rendered":"http:\/\/www.susmg.info\/alandale\/tips\/?p=102"},"modified":"2016-09-02T01:14:39","modified_gmt":"2016-09-02T01:14:39","slug":"how-to-make-your-excel-functions-easier-to-read","status":"publish","type":"post","link":"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/","title":{"rendered":"How to make your Excel functions easier to read"},"content":{"rendered":"<div class=\"content\">\n<div class=\"element element-textarea first last\">\n<p>As you work with Excel you might occasionally create more complex formulas and functions.\u00a0 When you later come back to look at them they can be difficult to read as there are no spaces between the various components.\u00a0 All the characters run together and it can be tricky figuring out what the function or formula is doing.<\/p>\n<p>A simple solution is to add spaces to the formula or function when you are creating it.<\/p>\n<p>Here are a couple of before and after examples.<br \/>\n<img decoding=\"async\" loading=\"lazy\" id=\"_x0000_i1025\" src=\"https:\/\/gallery.mailchimp.com\/5c16d0e346608f70d4fd0c58c\/images\/eca17361-f571-49b0-bc01-f5967093ade1.jpg\" alt=\"\" width=\"145\" height=\"18\" align=\"none\" \/><br \/>\n<img decoding=\"async\" loading=\"lazy\" id=\"_x0000_i1026\" src=\"https:\/\/gallery.mailchimp.com\/5c16d0e346608f70d4fd0c58c\/images\/ee190059-e638-4940-8360-6cfa7dd7e288.jpg\" alt=\"\" width=\"164\" height=\"20\" align=\"none\" \/><br \/>\n<img decoding=\"async\" loading=\"lazy\" id=\"_x0000_i1027\" src=\"https:\/\/gallery.mailchimp.com\/5c16d0e346608f70d4fd0c58c\/images\/49559481-f563-495c-9a2b-29af1ae768ab.jpg\" alt=\"\" width=\"405\" height=\"16\" align=\"none\" \/><br \/>\n<img decoding=\"async\" loading=\"lazy\" id=\"_x0000_i1028\" src=\"https:\/\/gallery.mailchimp.com\/5c16d0e346608f70d4fd0c58c\/images\/e278564e-c34a-402b-9e0c-a531dd0cde68.jpg\" alt=\"\" width=\"434\" height=\"21\" align=\"none\" \/><\/p>\n<\/div>\n<\/div>\n<div class=\"bottom-a\">\n<p>Any questions, please <a href=\"http:\/\/www.alandaletraining.com\/contact.html\">let me know<\/a>.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>As you work with Excel you might occasionally create more complex formulas and functions.\u00a0 When you later come back to look at them they can be difficult to read as &#8230;<\/p>\n","protected":false},"author":2,"featured_media":67,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-102","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to make your Excel functions easier to read - Alandale Training Software Tips<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to make your Excel functions easier to read - Alandale Training Software Tips\" \/>\n<meta property=\"og:description\" content=\"As you work with Excel you might occasionally create more complex formulas and functions.\u00a0 When you later come back to look at them they can be difficult to read as ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/\" \/>\n<meta property=\"og:site_name\" content=\"Alandale Training Software Tips\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-02T01:10:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-09-02T01:14:39+00:00\" \/>\n<meta name=\"author\" content=\"John Chandler\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Chandler\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to make your Excel functions easier to read - Alandale Training Software Tips","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/","og_locale":"en_US","og_type":"article","og_title":"How to make your Excel functions easier to read - Alandale Training Software Tips","og_description":"As you work with Excel you might occasionally create more complex formulas and functions.\u00a0 When you later come back to look at them they can be difficult to read as ...","og_url":"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/","og_site_name":"Alandale Training Software Tips","article_published_time":"2015-11-02T01:10:45+00:00","article_modified_time":"2016-09-02T01:14:39+00:00","author":"John Chandler","twitter_card":"summary_large_image","twitter_misc":{"Written by":"John Chandler"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/#article","isPartOf":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/"},"author":{"name":"John Chandler","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/3d915833a2c762b11624ae07740300e8"},"headline":"How to make your Excel functions easier to read","datePublished":"2015-11-02T01:10:45+00:00","dateModified":"2016-09-02T01:14:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/"},"wordCount":98,"image":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/#primaryimage"},"thumbnailUrl":"","articleSection":["Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/","url":"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/","name":"How to make your Excel functions easier to read - Alandale Training Software Tips","isPartOf":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/#primaryimage"},"image":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/#primaryimage"},"thumbnailUrl":"","datePublished":"2015-11-02T01:10:45+00:00","dateModified":"2016-09-02T01:14:39+00:00","author":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/3d915833a2c762b11624ae07740300e8"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2015\/11\/01\/how-to-make-your-excel-functions-easier-to-read\/#primaryimage","url":"","contentUrl":""},{"@type":"WebSite","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#website","url":"https:\/\/www.alandaletraining.com\/software-tips\/","name":"Alandale Training Software Tips","description":"Weekly Software Tips","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.alandaletraining.com\/software-tips\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/3d915833a2c762b11624ae07740300e8","name":"John Chandler","url":"https:\/\/www.alandaletraining.com\/software-tips\/author\/d5afe\/"}]}},"_links":{"self":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/comments?post=102"}],"version-history":[{"count":1,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/102\/revisions"}],"predecessor-version":[{"id":159,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/102\/revisions\/159"}],"wp:attachment":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/media?parent=102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/categories?post=102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/tags?post=102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}