{"id":358501,"date":"2021-10-26T21:00:17","date_gmt":"2021-10-26T18:00:17","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-remove-extra-spaces-in-your-google-sheets-data\/"},"modified":"2021-10-26T21:00:17","modified_gmt":"2021-10-26T18:00:17","slug":"how-to-remove-extra-spaces-in-your-google-sheets-data","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-remove-extra-spaces-in-your-google-sheets-data\/","title":{"rendered":"#How to Remove Extra Spaces in Your Google Sheets Data"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6aec47a2f37f2\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6aec47a2f37f2\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-remove-extra-spaces-in-your-google-sheets-data\/#Remove_Spaces_Using_Trim_Whitespace\" >Remove Spaces Using Trim Whitespace<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-remove-extra-spaces-in-your-google-sheets-data\/#Remove_Spaces_Using_the_Trim_Function\" >Remove Spaces Using the Trim Function<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-remove-extra-spaces-in-your-google-sheets-data\/#Trim_Cells\" >Trim Cells<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-remove-extra-spaces-in-your-google-sheets-data\/#Trim_Text\" >Trim Text<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Remove Extra Spaces in Your Google Sheets Data&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Have you ever had extra spaces <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ear in your Google Sheets data? Whether this happens after importing a file, mistakenly pressing the Space bar, or\u00a0pasting data, unnecessary spaces in your text can turn into a problem.<\/p>\n<p>If you use formulas or data validation in your sheet, extra spaces in the text can cause those things to either not work or not work correctly. Google Sheets gives you two quick ways to remove leading, repeated, and trailing spaces in your data, and we\u2019ll show you how to use both.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Remove_Spaces_Using_Trim_Whitespace\"><\/span>Remove Spaces Using Trim Whitespace<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to remove the spaces within your text and keep that data in the existing cells, you can use the handy Trim Whitespace feature.<\/p>\n<p>Select the cells with the text you want to remove the spaces from. Then click Data &gt; Trim Whitespace from the menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756269\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/DataTrimWhitespace-GoogleSheetsRemoveSpaces.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Data, Trim Whitespace in Google Sheets\" width=\"382\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see a pop-up message letting you know the number of cells that were trimmed. Click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756268\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/TrimWhitespace-GoogleSheetsRemoveSpaces.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Selected cells trimmed message\" width=\"384\" height=\"140\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And just like that, those extra spaces vanish!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756267\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/TrimmedWhitespace-GoogleSheetsRemoveSpaces.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Whitespace trimmed in Google Sheets\" width=\"388\" height=\"224\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Remove_Spaces_Using_the_Trim_Function\"><\/span>Remove Spaces Using the Trim Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can also use the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/support.google.com\/docs\/answer\/3094140\">TRIM function in Google Sheets<\/a> to remove excess spaces in your text. With this function, you can select the cell containing the text or enter the text you want to adjust.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Trim_Cells\"><\/span>Trim Cells<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Select a cell where you want to place the function. This is also the cell where the result will display. Then enter the following replacing the A2 cell reference with your own.<\/p>\n<pre>=TRIM(A2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756272\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/TrimFunctionCell-GoogleSheetsRemoveSpaces.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Trim function for a cell\" width=\"329\" height=\"46\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Press Enter or Return and you\u2019ll see the result in the function\u2019s cell. It should display the text from your referenced cell without any extra spaces.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756271\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/TrimFunctionCellResult-GoogleSheetsRemoveSpaces.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Trim function for a cell result\" width=\"329\" height=\"49\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Trim_Text\"><\/span>Trim Text<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Another way to use the TRIM function is for specific text. As with the former, select a cell for the function and note that this places the result in that same cell. Then enter the following replacing the text with your own inside quotes.<\/p>\n<pre>=TRIM(\"\u00a0 Marge\u00a0\u00a0\u00a0 Simpson\u00a0\u00a0 \")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756275\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/TrimFunctionText-GoogleSheetsRemoveSpaces.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Trim function for text\" width=\"429\" height=\"48\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Press Enter or Return and you\u2019ll see the result in the function\u2019s cell. Again, this should provide you with text that doesn\u2019t contain leading, repeated, or trailing spaces.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-756273\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/TrimFunctionTextResult-GoogleSheetsRemoveSpaces.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Trim function for text result\" width=\"429\" height=\"50\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To avoid issues with validation or formulas in Google Sheets, or to simply ensure a consistent appearance, remember these methods for removing extra spaces in your text.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/756263\/how-to-remove-extra-spaces-in-your-google-sheets-data\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Remove Extra Spaces in Your Google Sheets Data&#8221; Have you ever had extra spaces appear in your Google Sheets data? Whether this happens after importing a file, mistakenly pressing the Space bar, or\u00a0pasting data, unnecessary spaces in your text can turn into a problem. If you use formulas or data validation in your&#8230;<\/p>\n","protected":false},"author":1,"featured_media":358502,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-358501","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/358501","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=358501"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/358501\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/358502"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=358501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=358501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=358501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}