{"id":8170,"date":"2021-10-12T14:02:30","date_gmt":"2021-10-12T14:02:30","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=8170"},"modified":"2024-03-30T11:05:35","modified_gmt":"2024-03-30T11:05:35","slug":"return-multiple-values-in-one-cell","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/","title":{"rendered":"How to Return Multiple Values in One Cell in Excel"},"content":{"rendered":"\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-b840724b-6322-4a7e-ab85-1e6ddd09a9c3\" href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Return-Multiple-Values-in-One-Cell.xlsx\">Return-Multiple-Values-in-One-Cell<\/a><a href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Return-Multiple-Values-in-One-Cell.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-b840724b-6322-4a7e-ab85-1e6ddd09a9c3\">Download File<\/a><\/div>\n\n\n\n<p>We often find ourselves in a situation where we want to have a different view of existing data. As you probably know, Excel has a solution for this as well.<\/p>\n\n\n\n<p>The example below will show how to return multiple values from the table in one cell.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Return Multiple Values in One Cell<\/h2>\n\n\n\n<p>For our example, we will use the table with NBA players with several statistics: points, rebounds, assists, and turnovers.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"459\" height=\"438\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/table-description-automatically-generated-5.png\" alt=\"Table\n\nDescription automatically generated\" class=\"wp-image-8172\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/table-description-automatically-generated-5.png 459w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/table-description-automatically-generated-5-300x286.png 300w\" sizes=\"(max-width: 459px) 100vw, 459px\" \/><\/figure>\n\n\n\n<p>To list out any statistical category for any player, we will use the <strong>TEXTJOIN<\/strong> formula.<\/p>\n\n\n\n<p>This formula is only available in <strong>Excel 2019<\/strong> and <strong>Excel 365<\/strong>.<\/p>\n\n\n\n<p>What this formula does: it uses and then combines the text from the ranges of your choosing, and then puts up the delimiter you determine between each of the text values that are going to be combined. If you choose the delimiter to be an empty string, it will return multiple values one after the other one.<\/p>\n\n\n\n<p>This formula has several arguments:<\/p>\n\n\n\n<ul>\n<li><strong>delimiter<\/strong>&#8211; We can choose anything to be a delimiter. It separates our text.<\/li>\n\n\n\n<li><strong>ignore_empty- We choose if we want to <a href=\"https:\/\/officetuts.net\/excel\/examples\/chart-ignore-blank-cells\/\">ignore cells that are empty<\/a> or not.<\/strong><\/li>\n\n\n\n<li><strong><strong>text1<\/strong>&#8211; First range or text value.<\/strong><\/li>\n\n\n\n<li><strong><strong>text2<\/strong>&#8211; Second range or text value.<\/strong><\/li>\n<\/ul>\n\n\n\n<p>We will prepare the names of the player and define the column points:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"204\" height=\"85\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/a-picture-containing-box-and-whisker-chart-descri.png\" alt=\"A picture containing box and whisker chart\n\nDescription automatically generated\" class=\"wp-image-8173\"\/><\/figure>\n\n\n\n<p>Our formula in <strong>cell K2<\/strong> will be:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=TEXTJOIN(\", \",TRUE,IF(J2=$A$2:$A$28,$D$2:$D$28,\"\"))<\/code><\/pre>\n\n\n\n<p>In this formula, we first define our delimiter to be comma and space, i.e. <strong>\u201c, \u201d.<\/strong><\/p>\n\n\n\n<p>Then we, choose<strong> TRUE<\/strong> for ignoring empty cells.<\/p>\n\n\n\n<p>Next, we define our text with the <strong>IF formula<\/strong>. The logical test in this formula checks if the value in <strong>cell J2<\/strong> (Lebron James in our example) is the same as in the range of our player&#8217;s names- <strong>range A2:A28<\/strong>.<\/p>\n\n\n\n<p>This formula goes into every cell in our range and checks if the value is the same or not. If yes, it returns <strong>TRUE<\/strong>. If not, it returns <strong>FALSE<\/strong>.<\/p>\n\n\n\n<p>The next part of the formula returns all the points that a certain player (located in <strong>cell J2<\/strong> in this case) had in all games. We do that by making sure that the <strong>value_if_true<\/strong> part of this formula equals the range where points are found (that is range <strong>D2:D28<\/strong>).<\/p>\n\n\n\n<p>So, if the name in <strong>cell J2<\/strong> corresponds to the name in our range, then the points for this player will be presented and will be separated by a comma and space.<\/p>\n\n\n\n<p>The results are as follows:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"686\" height=\"120\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/graphical-user-interface-application-table-desc.png\" alt=\"Graphical user interface, application, table\n\nDescription automatically generated\" class=\"wp-image-8174\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/graphical-user-interface-application-table-desc.png 686w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/graphical-user-interface-application-table-desc-300x52.png 300w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/figure>\n\n\n\n<p>All we need to do to apply the same concept for Anthony Davis is to drag the formula to <strong>cell K2<\/strong>. Since we have the defined ranges locked, we will get the right numbers:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"206\" height=\"87\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/a-picture-containing-diagram-description-automati-1.png\" alt=\"A picture containing diagram\n\nDescription automatically generated\" class=\"wp-image-8175\"\/><\/figure>\n\n\n\n<p>This formula is different for <strong>Excel 2019<\/strong> and <strong>Microsoft 365<\/strong> users. If you are using <strong>Excel 2019<\/strong>, you need to enter the formula, and then hold <strong>CTRL + SHIFT,<\/strong> and then press <strong>ENTER<\/strong>. The reason for this is that we are dealing with dynamic arrays in this formula.<\/p>\n\n\n\n<p><strong>Microsoft 365<\/strong> has them incorporated, so all you need to do is input the formula and then press <strong>ENTER<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We often find ourselves in a situation where we want to have a different view of existing data. As you probably know, Excel&#8230;<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170,190],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Return Multiple Values in One Cell in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to return multiple values in one cell using Excel\u2019s TEXTJOIN formula. Download the example file and follow the steps.\" \/>\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\/return-multiple-values-in-one-cell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Return Multiple Values in One Cell in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to return multiple values in one cell using Excel\u2019s TEXTJOIN formula. Download the example file and follow the steps.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-12T14:02:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-30T11:05:35+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/table-description-automatically-generated-5.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"How to Return Multiple Values in One Cell in Excel\",\"datePublished\":\"2021-10-12T14:02:30+00:00\",\"dateModified\":\"2024-03-30T11:05:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/\"},\"wordCount\":511,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/table-description-automatically-generated-5.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/\",\"name\":\"How to Return Multiple Values in One Cell in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/table-description-automatically-generated-5.png\",\"datePublished\":\"2021-10-12T14:02:30+00:00\",\"dateModified\":\"2024-03-30T11:05:35+00:00\",\"description\":\"Learn how to return multiple values in one cell using Excel\u2019s TEXTJOIN formula. Download the example file and follow the steps.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/table-description-automatically-generated-5.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/table-description-automatically-generated-5.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Return Multiple Values in One Cell 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\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Return Multiple Values in One Cell in Excel","description":"Learn how to return multiple values in one cell using Excel\u2019s TEXTJOIN formula. Download the example file and follow the steps.","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\/return-multiple-values-in-one-cell\/","og_locale":"en_US","og_type":"article","og_title":"How to Return Multiple Values in One Cell in Excel","og_description":"Learn how to return multiple values in one cell using Excel\u2019s TEXTJOIN formula. Download the example file and follow the steps.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/","article_published_time":"2021-10-12T14:02:30+00:00","article_modified_time":"2024-03-30T11:05:35+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/table-description-automatically-generated-5.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"How to Return Multiple Values in One Cell in Excel","datePublished":"2021-10-12T14:02:30+00:00","dateModified":"2024-03-30T11:05:35+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/"},"wordCount":511,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/table-description-automatically-generated-5.png","keywords":["file","pinterest"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/","url":"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/","name":"How to Return Multiple Values in One Cell in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/table-description-automatically-generated-5.png","datePublished":"2021-10-12T14:02:30+00:00","dateModified":"2024-03-30T11:05:35+00:00","description":"Learn how to return multiple values in one cell using Excel\u2019s TEXTJOIN formula. Download the example file and follow the steps.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/table-description-automatically-generated-5.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2021\/10\/table-description-automatically-generated-5.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/return-multiple-values-in-one-cell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"How to Return Multiple Values in One Cell 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\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/8170"}],"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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=8170"}],"version-history":[{"count":6,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/8170\/revisions"}],"predecessor-version":[{"id":15385,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/8170\/revisions\/15385"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=8170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=8170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=8170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}