{"id":9650,"date":"2022-05-13T15:15:48","date_gmt":"2022-05-13T15:15:48","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=9650"},"modified":"2024-03-28T13:26:44","modified_gmt":"2024-03-28T13:26:44","slug":"remove-excess-tab-symbols-from-an-excel-spreadsheet","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/","title":{"rendered":"Remove Excess Tab Symbols from an Excel Spreadsheet"},"content":{"rendered":"\n
Remove-Excess-tab-Symbols-from-an-Excel-Spreadsheet<\/a>Download File<\/a><\/div>\n\n\n\n

It is easy to import data into Excel from other sources such as MS Access, Oracle, or MySQL databases. However, many times the imported data is poorly formatted and difficult to work in Excel.<\/p>\n\n\n\n

One cause of the poorly formatted data is the Tab symbols that display excessive unwanted spaces in the dataset. Sometimes these Tab symbols are invisible and other times they may be displayed as little squares.<\/p>\n\n\n\n

In this tutorial, we will demonstrate how the following 4 easy methods can be used to remove excess Tab symbols from an Excel spreadsheet:<\/p>\n\n\n\n

    \n
  1. Use the CLEAN function<\/strong><\/li>\n\n\n\n
  2. Use a combination of the SUBSTITUTE function<\/strong> and CHAR function<\/strong><\/li>\n\n\n\n
  3. Use the Excel VBA code<\/strong><\/li>\n\n\n\n
  4. Free SEO Plugin<\/strong><\/li>\n<\/ol>\n\n\n\n

    We will use the following dataset that has invisible Tab spaces in Column B to show how these methods can be applied:<\/p>\n\n\n\n

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

    When you look at it, this dataset looks good but when you print preview the worksheet you will find out that it has unneeded extra Tab spaces in column B as follows:<\/p>\n\n\n\n

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

    It is these extra Tab spaces that usually make it hard to sort the data, return erroneous results in VLOOKUP<\/strong>, and otherwise make it difficult to work with and analyze the data.<\/p>\n\n\n\n

    Method 1 \u2013 Use the CLEAN function<\/h2>\n\n\n\n

    The CLEAN function<\/strong> removes all nonprintable characters from text. These nonprinting characters such as Tab symbols are usually found in files imported from other applications that will not print with your operating system.<\/p>\n\n\n\n

    We use the CLEAN function to remove the Tab spaces which are nonprinting characters from the dataset, by doing the following steps:<\/p>\n\n\n\n

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

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

    Step 2 <\/strong>\u2013 Press the Enter key and use the Fill Handle <\/strong>to copy the formula down the column:<\/a><\/p>\n\n\n\n

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

    Step 3<\/strong> \u2013 Go to File >> Print<\/strong> on the Excel Ribbon to Print Preview the dataset and confirm that the extra Tab spaces have been removed:<\/p>\n\n\n\n

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

    Step 4<\/strong> \u2013 Select range D2:D7<\/strong> and press Ctrl + C<\/strong> to copy the data without extra Tabs:<\/p>\n\n\n\n

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

    Step 5<\/strong> \u2013 Select range B2:B7<\/strong> and go to Paste >> Paste Special\u2026 <\/strong>to open the Paste Special dialog box<\/strong>.<\/p>\n\n\n\n

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

    Alternatively, you can open the Paste Special dialog box<\/strong> by pressing the keyboard shortcut Ctrl + Alt + V<\/strong>.<\/p>\n\n\n\n

    Step 6<\/strong> \u2013 In the Paste Special dialog box select Values<\/strong> and press OK:<\/strong><\/p>\n\n\n\n

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

    The Paste Values will paste only the values in the range D2:D7<\/strong> without the formulas.<\/p>\n\n\n\n

    The data with extra Tabs will be replaced by the one without Tabs:<\/p>\n\n\n\n

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

    Step 7<\/strong> \u2013 Delete Column D<\/strong> for it is no longer needed.<\/p>\n\n\n\n

    Method 2 \u2013 Use a combination of the SUBSTITUTE function and CHAR function<\/h2>\n\n\n\n

    The SUBSTITUTE function<\/strong> replaces existing text with new text in a text string. This function does not support wildcards and is case-sensitive.<\/p>\n\n\n\n

    The CHAR function<\/strong> returns the character specified by the code number from the character set of the computer. It returns a character when a valid character code is passed to it for example CHR(9)<\/strong> returns a Tab and can be used to add a Tab space to text in a formula.<\/p>\n\n\n\n

    By the use of the combination of these functions, we can remove excess Tab symbols from an Excel dataset. We achieve this by doing the following steps:<\/p>\n\n\n\n

    Step 1<\/strong> \u2013 Select Cell D2<\/strong> and key in the formula =SUBSTITUTE(B2, CHAR(9),””) 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<\/strong> to copy the formula down the column:<\/p>\n\n\n\n

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

    Step 3<\/strong> – Go to File >> Print<\/strong> to Print Preview<\/strong> the dataset and confirm that the extra Tab spaces have been removed:<\/p>\n\n\n\n

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

    Step 4<\/strong> \u2013 Copy the data in range D2:D7<\/strong> and paste it into range B2:B7<\/strong> as Values.<\/p>\n\n\n\n

    Step 5<\/strong> \u2013 Delete Column D<\/strong> for it is no longer needed.<\/p>\n\n\n\n

    Explanation of the formula<\/h3>\n\n\n\n
    =SUBSTITUTE(B2, CHAR(9),\"\")<\/code><\/pre>\n\n\n\n
      \n
    1. In CHAR(9) the CHAR function returns the Tab character which is the character specified by the ASCII number 9 which has been passed to it.<\/li>\n\n\n\n
    2. In SUBSTITUTE(B2, CHAR(9),””) the SUBSTITUTE function replaces the Tab character with an empty string (“”).<\/li>\n<\/ol>\n\n\n\n
      Method 3 \u2013 Use the Excel VBA Code<\/h2>\n\n\n\n
      Using the Excel VBA code can make the work of removing excess Tab symbols from a large dataset easy and fast.<\/p>\n\n\n\n
      Do the following steps to remove the excess Tab symbols:<\/p>\n\n\n\n
      Step 1<\/strong> \u2013 Press Alt + F11<\/strong> to open the Visual Basic Editor<\/strong>. Alternatively, go to Developer >> Code >> Visual Basic<\/strong>.<\/p>\n\n\n\n
      Step 2<\/strong> \u2013 In the Project Window right click your workbook and insert a new module by going to Insert >> Module<\/strong>:<\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      Step 3<\/strong> \u2013 In the new module key in the following code:<\/p>\n\n\n\n
      Sub RemoveTabsFromSelection()\n\tSelection.Replace Chr(9), vbNullString\nEnd Sub\n<\/code><\/pre>\n\n\n\n
      Step 4<\/strong> \u2013 Press Alt + F11<\/strong> to switch back to the active worksheet. Alternatively, you can switch back to the active worksheet by clicking on the View Microsoft Excel button<\/strong> as shown below:<\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      Step 5<\/strong> \u2013 Select the range B2:B7<\/strong> in the active worksheet.<\/p>\n\n\n\n
      Step 6<\/strong> \u2013 Press the keyboard shortcut Alt + F8<\/strong> to open the Macro dialog box<\/strong>. Alternatively, you can open the Macro dialog box by going to Developer >> Code >> Macros<\/strong> on the Excel Ribbon. Select the RemoveTabsFromSelection<\/strong> macro from the Macro dialog box and click Run<\/strong>:<\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      Step 7<\/strong> \u2013 Print Preview the results to confirm that all the excess Tabs have been removed:<\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      Notice that in this method that the excess Tabs were removed from the range B2:B7<\/strong> directly.<\/p>\n\n\n\n
      Explanation of the Code<\/h3>\n\n\n\n
        \n
      1. The replace method is applied to the range B2:B7 <\/strong>selection.<\/strong><\/li>\n\n\n\n
      2. The Chr <\/strong>function returns Tab which is the character which is specified by the code number 9.<\/li>\n\n\n\n
      3. The Tabs in the selection are then replaced by empty strings as specified by the vbNullString constant.<\/li>\n<\/ol>\n\n\n\n
        Method 4 \u2013 Use the Free Excel SEO Add-in<\/h2>\n\n\n\n
        This add-in<\/a> offers two methods to remove tabs and other whitespace characters.<\/p>\n\n\n\n
        Look at this example:<\/p>\n\n\n\n
        \"Graphical<\/figure>\n\n\n\n
        There are a lot of tabs and spaces in front and at the end of the sentence. To remove them navigate to SEO >> Text >> Trim and Combine >> Trim Whitespaces<\/strong>.<\/p>\n\n\n\n
        \"Graphical<\/figure>\n\n\n\n
        After you click it, whitespace characters will be removed from the beginning and the end of the sentence.<\/p>\n\n\n\n
        \"A<\/figure>\n\n\n\n
        Now we have to combine them into a single space between words. For this, we can use the second option from the dropdown: Combine Spaces<\/strong>.<\/p>\n\n\n\n
        This is the result:<\/p>\n\n\n\n
        \"Graphical<\/figure>\n\n\n\n
        Conclusion<\/h2>\n\n\n\n
        Data from different databases can be easily imported into MS Excel. But many times these imported data come with nonprinting characters such as excessive Tab symbols.<\/p>\n\n\n\n
        If these excess Tab symbols are not removed, they will make the data difficult to work with for example sort and analyze.<\/p>\n\n\n\n
        In this tutorial, we have looked at three methods that can be used to remove the excess Tab symbols. The methods are applying the CLEAN function, using a combination of the SUBSTITUTE and CHAR functions, and using the Excel VBA Code.<\/p>\n\n\n\n
        If you prefer the quickest way, you can use the free Excel add-in.<\/p>\n\n\n\n
        You can use the method that best fits your situation.<\/p>\n","protected":false},"excerpt":{"rendered":"
        It is easy to import data into Excel from other sources such as MS Access, Oracle, or MySQL databases. However, many times the…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190,150],"yoast_head":"\nRemove Excess Tab Symbols from an Excel Spreadsheet<\/title>\n<meta name=\"description\" content=\"Learn 4 easy methods to remove excess Tab symbols from an Excel spreadsheet. Use the CLEAN function, SUBSTITUTE+CHAR, Excel VBA, or a free SEO Plugin.\" \/>\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\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Remove Excess Tab Symbols from an Excel Spreadsheet\" \/>\n<meta property=\"og:description\" content=\"Learn 4 easy methods to remove excess Tab symbols from an Excel spreadsheet. Use the CLEAN function, SUBSTITUTE+CHAR, Excel VBA, or a free SEO Plugin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-13T15:15:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T13:26:44+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-38.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=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/\"},\"author\":{\"name\":\"Christopher Sirali\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\"},\"headline\":\"Remove Excess Tab Symbols from an Excel Spreadsheet\",\"datePublished\":\"2022-05-13T15:15:48+00:00\",\"dateModified\":\"2024-03-28T13:26:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/\"},\"wordCount\":1142,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-38.png\",\"keywords\":[\"file\",\"pinterest\",\"SEO\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/\",\"name\":\"Remove Excess Tab Symbols from an Excel Spreadsheet\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-38.png\",\"datePublished\":\"2022-05-13T15:15:48+00:00\",\"dateModified\":\"2024-03-28T13:26:44+00:00\",\"description\":\"Learn 4 easy methods to remove excess Tab symbols from an Excel spreadsheet. Use the CLEAN function, SUBSTITUTE+CHAR, Excel VBA, or a free SEO Plugin.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-38.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-38.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Remove Excess Tab Symbols from an Excel Spreadsheet\"}]},{\"@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":"Remove Excess Tab Symbols from an Excel Spreadsheet","description":"Learn 4 easy methods to remove excess Tab symbols from an Excel spreadsheet. Use the CLEAN function, SUBSTITUTE+CHAR, Excel VBA, or a free SEO Plugin.","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\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/","og_locale":"en_US","og_type":"article","og_title":"Remove Excess Tab Symbols from an Excel Spreadsheet","og_description":"Learn 4 easy methods to remove excess Tab symbols from an Excel spreadsheet. Use the CLEAN function, SUBSTITUTE+CHAR, Excel VBA, or a free SEO Plugin.","og_url":"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/","article_published_time":"2022-05-13T15:15:48+00:00","article_modified_time":"2024-03-28T13:26:44+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-38.png"}],"author":"Christopher Sirali","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christopher Sirali","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/"},"author":{"name":"Christopher Sirali","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370"},"headline":"Remove Excess Tab Symbols from an Excel Spreadsheet","datePublished":"2022-05-13T15:15:48+00:00","dateModified":"2024-03-28T13:26:44+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/"},"wordCount":1142,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-38.png","keywords":["file","pinterest","SEO"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/","url":"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/","name":"Remove Excess Tab Symbols from an Excel Spreadsheet","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-38.png","datePublished":"2022-05-13T15:15:48+00:00","dateModified":"2024-03-28T13:26:44+00:00","description":"Learn 4 easy methods to remove excess Tab symbols from an Excel spreadsheet. Use the CLEAN function, SUBSTITUTE+CHAR, Excel VBA, or a free SEO Plugin.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-38.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/word-image-38.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/remove-excess-tab-symbols-from-an-excel-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Remove Excess Tab Symbols from an Excel Spreadsheet"}]},{"@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\/9650"}],"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=9650"}],"version-history":[{"count":5,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9650\/revisions"}],"predecessor-version":[{"id":15773,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9650\/revisions\/15773"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=9650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=9650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=9650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}