{"id":186500,"date":"2021-02-22T13:24:58","date_gmt":"2021-02-22T10:24:58","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-use-the-trim-function-in-microsoft-excel\/"},"modified":"2021-02-22T13:24:58","modified_gmt":"2021-02-22T10:24:58","slug":"how-to-use-the-trim-function-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-trim-function-in-microsoft-excel\/","title":{"rendered":"#How to Use the TRIM Function in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 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-6a36ea7d7d326\" 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-6a36ea7d7d326\" 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-use-the-trim-function-in-microsoft-excel\/#What_Is_the_TRIM_Function\" >What Is the TRIM Function?<\/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-use-the-trim-function-in-microsoft-excel\/#How_to_Use_the_TRIM_Function_in_Microsoft_Excel\" >How to Use the TRIM Function in Microsoft Excel<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Use the TRIM Function in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-435491\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2019\/07\/stock-lede-microsoft-office_excel-1.png\" alt=\"Excel Logo on a gray background\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you copy text into Microsoft Excel, it can occasionally come with characters you\u2019d prefer to see removed, such as unnecessary spaces. Rather than remove these manually, you can use the TRIM function to do it for you.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"What_Is_the_TRIM_Function\"><\/span>What Is the TRIM Function?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>TRIM is a very simple Microsoft Excel function that removes any extra spaces from a specific text string or from a cell containing text, leaving only a single space between words.<\/p>\n<p>For instance, let\u2019s assume that a cell in Excel contains a text string like this:<\/p>\n<pre>This is a text string.<\/pre>\n<p>This string itself contains a single space between each word. However, if there were additional spaces in your text string before the first word (eg. \u201d\u00a0 \u00a0 This is a text string.\u201d) or if it had multiple spaces between words (eg. \u201cThis\u00a0\u00a0 is\u00a0\u00a0 a\u00a0 \u00a0 text\u00a0 \u00a0 string.\u201d), then you could use the TRIM function to remove these for you.<\/p>\n<p>While you could do this manually, TRIM allows you to quickly remove unnecessary spaces from large sets of data, saving you time in the process.<\/p>\n<p>There is one limitation, however. TRIM removes the ASCII space character (decimal value 32) from text strings, which is the standard space character used in most text.<\/p>\n<p>The exception to this is for text on web pages, where the Unicode non-breaking space character (decimal value 160) is often used for spaces. TRIM won\u2019t remove this, so if this character exists in your text, you\u2019ll need to remove it manually.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>What Are Character Encodings Like ANSI and Unicode, and How Do They Differ?<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Use_the_TRIM_Function_in_Microsoft_Excel\"><\/span>How to Use the TRIM Function in Microsoft Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To help you understand how to use the TRIM function in Excel, we\u2019ll explore the two main methods for <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>lying it in a new formula using sample data.<\/p>\n<p>If you\u2019re creating a formula using TRIM, it has only a single argument\u2014the text itself. This can be text you insert into the formula directly or a cell reference to a cell that contains your text.<\/p>\n<p>For example, the following formula uses TRIM to remove unnecessary space characters from cell A2. To use this formula yourself, replace the cell reference \u201cA2\u201d with your own.<\/p>\n<pre>=TRIM(A2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-710733\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/Excel-TRIM-Using-Cell-Reference.png\" alt=\"To use the TRIM function in Excel using a cell reference, use the formula =TRIM(A2), replacing A2 with your own cell reference.\" width=\"632\" height=\"172\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To remove extra spaces from a text string directly, you could use the following formula, replacing the example string with your own text.<\/p>\n<pre>=TRIM(\" This text string contains unnecessary spaces\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-710734\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/Excel-TRIM-Text-String.png\" alt=\"To use the TRIM function in Excel with a text string, use the formula =TRIM(&quot;text&quot;), replacing &quot;text&quot; with your own text string.\" width=\"622\" height=\"154\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>As previously mentioned, TRIM is only designed to remove additional ASCII space characters (decimal value 32) from text strings.\u00a0If you\u2019re still seeing unnecessary spaces, this is likely caused by a non-breaking space character (Unicode decimal value 160) in your text.<\/p>\n<p>TRIM doesn\u2019t support these, so you\u2019ll need to manually check and remove these characters from your text if you\u2019d prefer to use it.<\/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\/710718\/how-to-use-the-trim-function-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Use the TRIM Function in Microsoft Excel&#8221; When you copy text into Microsoft Excel, it can occasionally come with characters you\u2019d prefer to see removed, such as unnecessary spaces. Rather than remove these manually, you can use the TRIM function to do it for you. What Is the TRIM Function? TRIM is a&#8230;<\/p>\n","protected":false},"author":1,"featured_media":186501,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2019\/07\/stock-lede-microsoft-office_excel-1.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-186500","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\/186500","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=186500"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/186500\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/186501"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=186500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=186500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=186500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}