{"id":3509,"date":"2014-06-05T23:41:25","date_gmt":"2014-06-05T23:41:25","guid":{"rendered":"http:\/\/affirmativeaction.com\/news\/?p=3509"},"modified":"2020-08-09T09:40:48","modified_gmt":"2020-08-09T16:40:48","slug":"excel-tutorial-removing-blank-spaces","status":"publish","type":"post","link":"https:\/\/biddle.com\/blog\/2014\/06\/05\/excel-tutorial-removing-blank-spaces\/","title":{"rendered":"Excel Tutorial: Removing Blank Spaces"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-3605\" src=\"\/blog\/wp-content\/uploads\/2014\/07\/excel.png\" alt=\"Excel Tips and Tutorials\" width=\"128\" height=\"128\">This is the first in a series of Excel tutorials. These tutorials share tips on how to use Excel to better prepare your data for use in an Affirmative Action&nbsp;Plan.<\/p>\n<p>This video demonstrates&nbsp;how to remove blank spaces in your Excel data using <a href=\"http:\/\/www.ablebits.com\/excel-trim-spaces\/\" target=\"_blank\" rel=\"noopener noreferrer\">Trim Spaces by Ablebits.com<\/a>.<\/p>\n<p><!--more--><\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/7oToaAEOhzs?rel=0\" width=\"640\" height=\"480\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is the first in a series of Excel tutorials. These tutorials share tips on how to use Excel to better prepare your data for use in an Affirmative Action&nbsp;Plan. This video demonstrates&nbsp;how to remove blank spaces in your Excel data using Trim Spaces by Ablebits.com.<\/p>\n","protected":false},"author":101026,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[11],"tags":[184,55],"class_list":{"0":"post-3509","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-training","7":"tag-data-preparation","8":"tag-excel","9":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Tutorial: Removing Blank Spaces &#187; Biddle Consulting Group News<\/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:\/\/biddle.com\/blog\/2014\/06\/05\/excel-tutorial-removing-blank-spaces\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Tutorial: Removing Blank Spaces &#187; Biddle Consulting Group News\" \/>\n<meta property=\"og:description\" content=\"This is the first in a series of Excel tutorials. These tutorials share tips on how to use Excel to better prepare your data for use in an Affirmative Action&nbsp;Plan. This video demonstrates&nbsp;how to remove blank spaces in your Excel data using Trim Spaces by Ablebits.com.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/biddle.com\/blog\/2014\/06\/05\/excel-tutorial-removing-blank-spaces\/\" \/>\n<meta property=\"og:site_name\" content=\"Biddle Consulting Group News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/pages\/Biddle-Consulting-Group-Inc\/283128085965\" \/>\n<meta property=\"article:published_time\" content=\"2014-06-05T23:41:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-09T16:40:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/biddle.com\/blog\/wp-content\/uploads\/2014\/07\/excel.png\" \/>\n<meta name=\"author\" content=\"Jeff Davies, M.A.\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@BiddleCG\" \/>\n<meta name=\"twitter:site\" content=\"@BiddleCG\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Davies, M.A.\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/06\\\/05\\\/excel-tutorial-removing-blank-spaces\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/06\\\/05\\\/excel-tutorial-removing-blank-spaces\\\/\"},\"author\":{\"name\":\"Jeff Davies, M.A.\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#\\\/schema\\\/person\\\/e60b7ef3c24a54fa39bd0f3a8f0342e7\"},\"headline\":\"Excel Tutorial: Removing Blank Spaces\",\"datePublished\":\"2014-06-05T23:41:25+00:00\",\"dateModified\":\"2020-08-09T16:40:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/06\\\/05\\\/excel-tutorial-removing-blank-spaces\\\/\"},\"wordCount\":56,\"publisher\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#organization\"},\"keywords\":[\"data preparation\",\"excel\"],\"articleSection\":[\"Training\"],\"inLanguage\":\"en\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/06\\\/05\\\/excel-tutorial-removing-blank-spaces\\\/\",\"url\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/06\\\/05\\\/excel-tutorial-removing-blank-spaces\\\/\",\"name\":\"Excel Tutorial: Removing Blank Spaces &#187; Biddle Consulting Group News\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#website\"},\"datePublished\":\"2014-06-05T23:41:25+00:00\",\"dateModified\":\"2020-08-09T16:40:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/06\\\/05\\\/excel-tutorial-removing-blank-spaces\\\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/06\\\/05\\\/excel-tutorial-removing-blank-spaces\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/06\\\/05\\\/excel-tutorial-removing-blank-spaces\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/biddle.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Tutorial: Removing Blank Spaces\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/biddle.com\\\/blog\\\/\",\"name\":\"Biddle Consulting Group News\",\"description\":\"EEO, Affirmative Action, Pay Equity &amp; Employee Testing Solutions\",\"publisher\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/biddle.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#organization\",\"name\":\"Biddle Consulting Group, Inc.\",\"url\":\"https:\\\/\\\/biddle.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/biddle.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/logo-biddle.png\",\"contentUrl\":\"https:\\\/\\\/biddle.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/logo-biddle.png\",\"width\":154,\"height\":48,\"caption\":\"Biddle Consulting Group, Inc.\"},\"image\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/pages\\\/Biddle-Consulting-Group-Inc\\\/283128085965\",\"https:\\\/\\\/x.com\\\/BiddleCG\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/biddle-consulting-group\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/biddletube01\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#\\\/schema\\\/person\\\/e60b7ef3c24a54fa39bd0f3a8f0342e7\",\"name\":\"Jeff Davies, M.A.\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g\",\"caption\":\"Jeff Davies, M.A.\"},\"description\":\"Jeff Davies is an EEO\\\/AA Consultant at Biddle Consulting Group. He assists federal contractors in developing and maintaining compliant Affirmative Action Plans and navigating OFCCP audits. Jeff also manages all AAP software clients at Biddle and routinely presents on various industry topics.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Tutorial: Removing Blank Spaces &#187; Biddle Consulting Group News","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:\/\/biddle.com\/blog\/2014\/06\/05\/excel-tutorial-removing-blank-spaces\/","og_locale":"en_US","og_type":"article","og_title":"Excel Tutorial: Removing Blank Spaces &#187; Biddle Consulting Group News","og_description":"This is the first in a series of Excel tutorials. These tutorials share tips on how to use Excel to better prepare your data for use in an Affirmative Action&nbsp;Plan. This video demonstrates&nbsp;how to remove blank spaces in your Excel data using Trim Spaces by Ablebits.com.","og_url":"https:\/\/biddle.com\/blog\/2014\/06\/05\/excel-tutorial-removing-blank-spaces\/","og_site_name":"Biddle Consulting Group News","article_publisher":"https:\/\/www.facebook.com\/pages\/Biddle-Consulting-Group-Inc\/283128085965","article_published_time":"2014-06-05T23:41:25+00:00","article_modified_time":"2020-08-09T16:40:48+00:00","og_image":[{"url":"https:\/\/biddle.com\/blog\/wp-content\/uploads\/2014\/07\/excel.png","type":"","width":"","height":""}],"author":"Jeff Davies, M.A.","twitter_card":"summary_large_image","twitter_creator":"@BiddleCG","twitter_site":"@BiddleCG","twitter_misc":{"Written by":"Jeff Davies, M.A."},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/biddle.com\/blog\/2014\/06\/05\/excel-tutorial-removing-blank-spaces\/#article","isPartOf":{"@id":"https:\/\/biddle.com\/blog\/2014\/06\/05\/excel-tutorial-removing-blank-spaces\/"},"author":{"name":"Jeff Davies, M.A.","@id":"https:\/\/biddle.com\/blog\/#\/schema\/person\/e60b7ef3c24a54fa39bd0f3a8f0342e7"},"headline":"Excel Tutorial: Removing Blank Spaces","datePublished":"2014-06-05T23:41:25+00:00","dateModified":"2020-08-09T16:40:48+00:00","mainEntityOfPage":{"@id":"https:\/\/biddle.com\/blog\/2014\/06\/05\/excel-tutorial-removing-blank-spaces\/"},"wordCount":56,"publisher":{"@id":"https:\/\/biddle.com\/blog\/#organization"},"keywords":["data preparation","excel"],"articleSection":["Training"],"inLanguage":"en"},{"@type":"WebPage","@id":"https:\/\/biddle.com\/blog\/2014\/06\/05\/excel-tutorial-removing-blank-spaces\/","url":"https:\/\/biddle.com\/blog\/2014\/06\/05\/excel-tutorial-removing-blank-spaces\/","name":"Excel Tutorial: Removing Blank Spaces &#187; Biddle Consulting Group News","isPartOf":{"@id":"https:\/\/biddle.com\/blog\/#website"},"datePublished":"2014-06-05T23:41:25+00:00","dateModified":"2020-08-09T16:40:48+00:00","breadcrumb":{"@id":"https:\/\/biddle.com\/blog\/2014\/06\/05\/excel-tutorial-removing-blank-spaces\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/biddle.com\/blog\/2014\/06\/05\/excel-tutorial-removing-blank-spaces\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/biddle.com\/blog\/2014\/06\/05\/excel-tutorial-removing-blank-spaces\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/biddle.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel Tutorial: Removing Blank Spaces"}]},{"@type":"WebSite","@id":"https:\/\/biddle.com\/blog\/#website","url":"https:\/\/biddle.com\/blog\/","name":"Biddle Consulting Group News","description":"EEO, Affirmative Action, Pay Equity &amp; Employee Testing Solutions","publisher":{"@id":"https:\/\/biddle.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/biddle.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/biddle.com\/blog\/#organization","name":"Biddle Consulting Group, Inc.","url":"https:\/\/biddle.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/biddle.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/biddle.com\/blog\/wp-content\/uploads\/2017\/09\/logo-biddle.png","contentUrl":"https:\/\/biddle.com\/blog\/wp-content\/uploads\/2017\/09\/logo-biddle.png","width":154,"height":48,"caption":"Biddle Consulting Group, Inc."},"image":{"@id":"https:\/\/biddle.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/pages\/Biddle-Consulting-Group-Inc\/283128085965","https:\/\/x.com\/BiddleCG","https:\/\/www.linkedin.com\/company\/biddle-consulting-group","https:\/\/www.youtube.com\/user\/biddletube01"]},{"@type":"Person","@id":"https:\/\/biddle.com\/blog\/#\/schema\/person\/e60b7ef3c24a54fa39bd0f3a8f0342e7","name":"Jeff Davies, M.A.","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/secure.gravatar.com\/avatar\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g","caption":"Jeff Davies, M.A."},"description":"Jeff Davies is an EEO\/AA Consultant at Biddle Consulting Group. He assists federal contractors in developing and maintaining compliant Affirmative Action Plans and navigating OFCCP audits. Jeff also manages all AAP software clients at Biddle and routinely presents on various industry topics."}]}},"_links":{"self":[{"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/posts\/3509","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/users\/101026"}],"replies":[{"embeddable":true,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/comments?post=3509"}],"version-history":[{"count":1,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/posts\/3509\/revisions"}],"predecessor-version":[{"id":5008,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/posts\/3509\/revisions\/5008"}],"wp:attachment":[{"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/media?parent=3509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/categories?post=3509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/tags?post=3509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}