{"id":9680,"date":"2022-05-16T12:16:04","date_gmt":"2022-05-16T12:16:04","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=9680"},"modified":"2024-02-19T14:52:25","modified_gmt":"2024-02-19T14:52:25","slug":"trim-and-combine-spaces","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/","title":{"rendered":"Trim and Combine Spaces in Excel"},"content":{"rendered":"\n
Trim-and-Combine-Spaces<\/a>Download File<\/a><\/div>\n\n\n\n

If you import data from legacy systems and external databases into Excel, you most likely will find that the data contains extra spaces.<\/p>\n\n\n\n

These extra spaces may be leading, trailing, or between data.<\/p>\n\n\n\n

These extra spaces have to be removed because they can cause problems in lookup formulas, printing, charting, and column sizing.<\/p>\n\n\n\n

In this tutorial, we will look at the 5 ways of removing and or combining these extra spaces.<\/p>\n\n\n\n

Method 1 \u2013 Apply the TRIM function<\/h2>\n\n\n\n

The TRIM function<\/strong> removes all spaces from a text string except for single spaces between words. It deletes all leading, trailing, and in-between spaces except for single-space characters between words.<\/p>\n\n\n\n

It was designed to trim only the ASCII space character<\/strong> which has the code value of 32 from text strings.<\/p>\n\n\n\n

We will use the following example dataset of popular English proverbs to show how the TRIM function can be used to remove extra spaces from data. We have intentionally inserted extra spaces in the beginning, middle, or end of the proverbs.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We will do the following steps to remove the extra spaces we have intentionally inserted:<\/p>\n\n\n\n

Step 1<\/strong> \u2013 Select Cell B2<\/strong> and type in the formula =TRIM(A2) as follows:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 2<\/strong> \u2013 Press the Enter key. You will notice that the extra spaces between the word “not” and “gold” in the first proverb have been removed. Only a single space remains:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 3<\/strong> \u2013 Drag down the Fill Handle<\/strong> to copy the formula down the column:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You will notice that all the extra spaces in the proverbs have been removed.<\/p>\n\n\n\n

Method 2 \u2013 Use the combination of the TRIM function and CLEAN function<\/h2>\n\n\n\n

Sometimes the TRIM function alone cannot remove all the extra spaces. This happens when the data has text strings that are broken into different lines like in the example dataset below where the song titles and the years of release are in different lines:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Some of the song titles also have extra spaces.<\/p>\n\n\n\n

To deal with these issues and make the data more organized we are going to utilize the combination of the TRIM function<\/strong> and the CLEAN function<\/strong>. The CLEAN function removes all nonprintable characters from text.<\/p>\n\n\n\n

We will do the followings steps to remove all the unwanted spaces from our dataset:<\/p>\n\n\n\n

Step 1<\/strong> \u2013 Select Cell B2<\/strong> and key in the formula =TRIM(CLEAN(A2)) as below:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 2<\/strong> \u2013 Press the Enter key. The line breaks and all the extra spaces have been removed from the first song title and the data is organized:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 3<\/strong> \u2013 Copy the formula down the column by dragging down the Fill Handle<\/strong>. There are no extra spaces or line breaks in the data and it is now organized:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Method 3 \u2013 Employ the combination of the VALUE function and TRIM function<\/h2>\n\n\n\n

If we apply the TRIM function alone on numeric values it removes the unwanted spaces but returns text strings that we cannot manipulate as numbers for example find their average or sum.<\/p>\n\n\n\n

We will have to use the VALUE function<\/strong> to convert the strings back to numbers.<\/p>\n\n\n\n

The VALUE function converts a text string that represents a number to a numeric value.<\/p>\n\n\n\n

We will use the following dataset of random numbers<\/a> to show how we can apply the combination of the VALUE function and TRIM function to remove extra spaces from numeric values:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We are going to achieve this by doing the following steps:<\/p>\n\n\n\n

Step 1<\/strong> \u2013 Select Cell B2<\/strong> and key in the formula =TRIM(A2) as below:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 2<\/strong> \u2013 Press the Enter key and drag down the Fill Handle<\/strong> to copy the formula down the column to cell B5<\/strong>. The extra spaces have been stripped from the values:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 3<\/strong> \u2013 Select Cell B6<\/strong> and key in the formula =SUM(B2:B5) as follows:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 4<\/strong> \u2013 Press the Enter key. You will notice that the SUM function<\/strong> returned a zero because the values in range B2:B5<\/strong> that were returned by the TRIM function are text values and not numeric:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 5<\/strong> \u2013 Select Cell C2<\/strong> and key in the formula =VALUE(TRIM(A2)) as below:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 6<\/strong> \u2013 Press the Enter key and drag down the Fill Handle to copy the formula<\/a> down the column to Cell C5<\/strong>:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 7<\/strong> \u2013 Select Cell B6 and copy the formula to Cell C6 by dragging the Fill Handle across to Cell C6:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You will notice that the SUM function has returned the correct value because the values in the range C2:C5 are numbers.<\/p>\n\n\n\n

Explanation of the Formula<\/h3>\n\n\n\n
=VALUE(TRIM(A2))<\/code><\/pre>\n\n\n\n
    \n
  1. TRIM(A2) stripped the numeric value of all extra spaces but converted it to a text string.<\/li>\n\n\n\n
  2. In VALUE(TRIM(A2)) the VALUE function converted the text string to a numeric value.<\/li>\n<\/ol>\n\n\n\n
    Method 4 \u2013 Use the combination of the SUBSTITUTE function and TRIM function<\/h2>\n\n\n\n
    The TRIM function<\/strong> removes all spaces from a text string except for single spaces between words. It deletes all leading, trailing, and in-between spaces except for single-space characters between words.<\/p>\n\n\n\n
    It was designed to trim only the ASCII space character<\/strong> which has a code value of 32.<\/p>\n\n\n\n
    In the Unicode character set, however, there is an additional space character called the nonbreaking space character<\/strong>. This character is usually used on web pages and has a Unicode value of 160.<\/p>\n\n\n\n
    This means that the TRIM function<\/strong> which was designed to handle only CHAR(32)<\/strong> space characters and cannot handle CHAR(160)<\/strong> space characters. To handle this kind of space, we will have to employ the SUBSTITUTE function<\/strong> to find CHAR(160)<\/strong> space characters and replace them with CHAR(32)<\/strong> space characters so that the TRIM function can fix them.<\/p>\n\n\n\n
    We will use the following example dataset to explain how nonbreaking space characters can be removed from data:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    In this dataset, the First Name and Last Name columns have invisible nonbreaking space characters. They however become apparent when we combine the names in Column C<\/strong>.<\/p>\n\n\n\n
    Step 1<\/strong> – Select Cell C2<\/strong> and type in the formula =A2&” “&B2 as follows:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    Step 2<\/strong> \u2013 Press the Enter key and drag down the Fill Handle to copy the formula down the column:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    You notice that the full names in Column C<\/strong> have extra spaces. This is because of the nonbreaking character spaces in the data in Column A<\/strong> and Column B<\/strong>.<\/p>\n\n\n\n
    Let\u2019s see if the TRIM function will remove these extra spaces.<\/p>\n\n\n\n
    Step 3<\/strong> \u2013 Select Cell D2<\/strong> and type in the formula =TRIM(A2&” “&B2) as follows:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    Step 4<\/strong> \u2013 Press the Enter key and drag down the Fill Handle to copy the formula down the column. The result will appear as follows:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    You will notice that the TRIM function has not been able to remove the nonbreaking space characters from the data.<\/p>\n\n\n\n
    To remove these nonbreaking space characters we have to use the combination of the SUBSTITUTE function and TRIM function.<\/p>\n\n\n\n
    Step 5<\/strong> \u2013 Select Cell E2 and type in the formula =TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32)))&” “&TRIM(SUBSTITUTE(B2,CHAR(160),CHAR(32))) as follows:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    Step 6<\/strong> \u2013 Press the Enter key and drag down the Fill Handle to copy the formula down the column. The result will appear as follows:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    Notice that all the extra spaces in Column E<\/strong> have been removed.<\/p>\n\n\n\n
    Explanation of the formula<\/h3>\n\n\n\n
    =TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32)))&\" \"&TRIM(SUBSTITUTE(B2,CHAR(160),CHAR(32)))<\/code><\/pre>\n\n\n\n
      \n
    1. In SUBSTITUTE(A2,CHAR(160),CHAR(32)) and SUBSTITUTE(B2,CHAR(160),CHAR(32)) the SUBSTITUTE function replaces the nonbreaking space characters in Cell A2 and Cell B2 with ASCII space characters. The nonbreaking space characters are represented by code value 160 and the ASCII space characters are represented by code value 32.<\/li>\n\n\n\n
    2. The extra space characters are then removed by the TRIM function.<\/li>\n<\/ol>\n\n\n\n
      Method 5 \u2013 Free Excel Add-in for SEO<\/h2>\n\n\n\n
      If you don’t want to use functions and formulas, you can use a free add-in<\/a> that can trim and combine spaces.<\/p>\n\n\n\n
      After you install the plugin and select the text you want to manipulate, you can navigate to SEO >> Text >> Trim and Combine >> Trim Spaces<\/strong>.<\/p>\n\n\n\n
      \"Graphical<\/figure>\n\n\n\n
      All whitespace from the beginning and the end of the sentences are removed.<\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      But there are still multiple spaces between words. For this reason, we are going to use the next button, called Combine Spaces<\/strong>.<\/p>\n\n\n\n
      After you click it, multiple adjacent spaces are combined into one.<\/p>\n\n\n\n
      \"Table\n\nDescription<\/figure>\n","protected":false},"excerpt":{"rendered":"
      If you import data from legacy systems and external databases into Excel, you most likely will find that the data contains extra spaces….<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170,150],"yoast_head":"\nTrim and Combine Spaces in Excel<\/title>\n<meta name=\"description\" content=\"Remove extra spaces in Excel data with 5 methods - including applying the TRIM function. Download example file for easy understanding.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Trim and Combine Spaces in Excel\" \/>\n<meta property=\"og:description\" content=\"Remove extra spaces in Excel data with 5 methods - including applying the TRIM function. Download example file for easy understanding.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-16T12:16:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-19T14:52:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-54.png\" \/>\n<meta name=\"author\" content=\"Christopher Sirali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Sirali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/\"},\"author\":{\"name\":\"Christopher Sirali\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\"},\"headline\":\"Trim and Combine Spaces in Excel\",\"datePublished\":\"2022-05-16T12:16:04+00:00\",\"dateModified\":\"2024-02-19T14:52:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/\"},\"wordCount\":1329,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-54.png\",\"keywords\":[\"file\",\"SEO\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/\",\"name\":\"Trim and Combine Spaces in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-54.png\",\"datePublished\":\"2022-05-16T12:16:04+00:00\",\"dateModified\":\"2024-02-19T14:52:25+00:00\",\"description\":\"Remove extra spaces in Excel data with 5 methods - including applying the TRIM function. Download example file for easy understanding.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-54.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-54.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Trim and Combine Spaces in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\",\"name\":\"Christopher Sirali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"caption\":\"Christopher Sirali\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Trim and Combine Spaces in Excel","description":"Remove extra spaces in Excel data with 5 methods - including applying the TRIM function. Download example file for easy understanding.","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:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/","og_locale":"en_US","og_type":"article","og_title":"Trim and Combine Spaces in Excel","og_description":"Remove extra spaces in Excel data with 5 methods - including applying the TRIM function. Download example file for easy understanding.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/","article_published_time":"2022-05-16T12:16:04+00:00","article_modified_time":"2024-02-19T14:52:25+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-54.png"}],"author":"Christopher Sirali","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christopher Sirali","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/"},"author":{"name":"Christopher Sirali","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370"},"headline":"Trim and Combine Spaces in Excel","datePublished":"2022-05-16T12:16:04+00:00","dateModified":"2024-02-19T14:52:25+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/"},"wordCount":1329,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-54.png","keywords":["file","SEO"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/","url":"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/","name":"Trim and Combine Spaces in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-54.png","datePublished":"2022-05-16T12:16:04+00:00","dateModified":"2024-02-19T14:52:25+00:00","description":"Remove extra spaces in Excel data with 5 methods - including applying the TRIM function. Download example file for easy understanding.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-54.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-54.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/trim-and-combine-spaces\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Trim and Combine Spaces in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370","name":"Christopher Sirali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","caption":"Christopher Sirali"}}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9680"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=9680"}],"version-history":[{"count":6,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9680\/revisions"}],"predecessor-version":[{"id":15774,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9680\/revisions\/15774"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=9680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=9680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=9680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}