{"id":4561,"date":"2019-08-19T15:23:47","date_gmt":"2019-08-19T15:23:47","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=4561"},"modified":"2024-03-26T16:37:38","modified_gmt":"2024-03-26T16:37:38","slug":"combine-cells","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/","title":{"rendered":"Combine Cells in Excel"},"content":{"rendered":"\n
Combine-Cells-in-Excel<\/a>Download File<\/a><\/div>\n\n\n\n

When you work with Excel, you probably have to deal with\ndata separated into multiple rows. For example name, city, age, etc.<\/p>\n\n\n\n

But sometimes you may want to combine cells from two different columns into a single column \u2013 for example, you have the First Name<\/strong> and Last Name<\/strong> columns and you want to merge them into a single Name<\/strong>.<\/p>\n\n\n\n

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

Ampersand (&)<\/h2>\n\n\n\n

One of the quickest and most popular ways to combine two cells into one is by using an ampersand (&).<\/p>\n\n\n\n

We are going to check it on our example and try to concatenate the first and last names into a single column.<\/p>\n\n\n\n

Here\u2019s what our example looks like.<\/p>\n\n\n\n

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

Insert a new column<\/a> between rows B <\/strong>and C <\/strong>and call it Name<\/strong>. In cell C2<\/strong>, enter the following formula:<\/p>\n\n\n\n

=A2&\" \"&B2<\/code><\/pre>\n\n\n\n
It means: join A2<\/strong>\nwith space<\/strong> and with B2<\/strong>.<\/p>\n\n\n\n
 Autofill<\/a> the rest of the cells in the column.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Now, if you try to remove columns A and B, you are going to get the reference error.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
It happens because the cells are not values, but formulas referencing\nto cells you\u2019ve just canceled. What you have to do before canceling these\ncells, is to convert them to values.<\/p>\n\n\n\n
You can easily do it by clicking cell C2<\/strong> and using the Ctrl +\nShift + Down Arrow<\/strong> keyboard shortcut. It will select all the cells inside\nthat column, without a header.<\/p>\n\n\n\n
When you have these cells selected, copy them (Ctrl + C<\/strong>), right-click to open the contextual menu and click the Paste As Values<\/strong> button.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
The CONCAT function<\/h2>\n\n\n\n
The CONCAT<\/strong> function\nis the same as CONCATENATE<\/strong>. CONCAT\nis the newer version, and you should use it instead of CONCATENATE. This\nfunction can merge up to 30 text items together and return the result as text.<\/p>\n\n\n\n
Here\u2019s what you need to insert into cell C2<\/strong> if you don\u2019t want to use ampersand.<\/p>\n\n\n\n
=CONCAT(A2,\" \",B2)<\/code><\/pre>\n\n\n\n
The result is exactly the same.<\/p>\n\n\n\n
Combine text with numbers<\/h2>\n\n\n\n
You can easily combine text with numbers. There is no need to change the data type<\/a> Excel will take care of that.<\/p>\n\n\n\n
Let\u2019s try this example.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Try this formula:<\/p>\n\n\n\n
=A2&\" \"&B2&\" is \"&D2&\" and lives in \"&C2&\".\"<\/code><\/pre>\n\n\n\n
This is what it looks like with CONCAT<\/strong>.<\/p>\n\n\n\n
=CONCAT(A2,\" \",B2,\" is \",D2,\" and lives in \",C2,\".\")<\/code><\/pre>\n\n\n\n
Both methods return this message:<\/p>\n\n\n\n
Art Venere is 31 and lives in New York.<\/code><\/pre>\n\n\n\n
Combine text with dates<\/h2>\n\n\n\n
It\u2019s a bit more complicated when it comes to dates. <\/p>\n\n\n\n
Let\u2019s try it on the following example.<\/p>\n\n\n\n
Run this formula.<\/p>\n\n\n\n
=A2&\" \"&B2&\" was born in \"&D2&\" and lives in \"&C2&\".\"<\/code><\/pre>\n\n\n\n
This is the result it returns.<\/p>\n\n\n\n
Art Venere was born in 32363 and lives in New York.<\/code><\/pre>\n\n\n\n
You can try to run the CONCAT<\/strong>\nfunction.<\/p>\n\n\n\n
And it will give you the same result.<\/p>\n\n\n\n
The problem is that Excel stores dates as numbers<\/a> and convert them to dates. If you try to concatenate the date<\/a> it will display a number instead.<\/p>\n\n\n\n
You can modify the formula, so it will display a date instead of a number. Here\u2019s how to do it.<\/p>\n\n\n\n
=A2&\" \"&B2&\" was born in \"&TEXT(D2,\"mm\/dd\/yyyy\")&\" and lives in \"&C2&\".\"<\/code><\/pre>\n\n\n\n
=CONCAT(A2,\" \",B2,\" was born in \",TEXT(D2,\"mm\/dd\/yyyy\"),\" and lives in \",C2,\".\")<\/code><\/pre>\n\n\n\n
This is the result.<\/p>\n\n\n\n
Art Venere was born in 08\/08\/1988 and lives in Bridgeport.<\/code><\/pre>\n\n\n\n
You can also use just a year, instead of the full date.<\/p>\n\n\n\n
=A2&\" \"&B2&\" was born in \"&YEAR(D2)&\" and lives in \"&C2&\".\"<\/code><\/pre>\n\n\n\n
=CONCAT(A2,\" \",B2,\" was born in \",YEAR(D2),\" and lives in \",C2,\".\")<\/code><\/pre>\n\n\n\n
Result:<\/p>\n\n\n\n
Art Venere was born in 1988 and lives in Bridgeport.<\/code><\/pre>\n\n\n\n
Use notepad to combine cells<\/h2>\n\n\n\n
Another way you can easily combine cells is to use a notepad. Copy the first and last names (A2:B10), and paste them into the notepad.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Now, if you copy contents inside a notepad, you are going to\nhave the first name and the last name in different columns.<\/p>\n\n\n\n
What you have to do, is to copy a tab between the first and\nlast name. Press Ctrl + H<\/strong> to open\nthe Replace<\/strong> window.<\/p>\n\n\n\n
Copy the tab into the Find what<\/strong> textbox, and type space into Replace With<\/strong>.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Click the Replace All<\/strong>\nbutton.<\/p>\n\n\n\n
Now, instead of tabs between words, you have spaces.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Copy everything and paste<\/a> it into a column.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Because there are no tabs between words, Excel doesn\u2019t move\nthem into separate cells.<\/p>\n\n\n\n
Separators (space, dash)<\/h2>\n\n\n\n
Now, let\u2019s talk about separators. Usually, the separators between words are spaces.<\/p>\n\n\n\n
=A1&\" \"&B1&\" \"&C1&\" \"&D1&\" \"&E1&\".\"<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
If you want to use a different separator, for example, a dash, you can replace all spaces with dashes.<\/p>\n\n\n\n
=A1&\"-\"&B1&\"-\"&C1&\"-\"&D1&\"-\"&E1&\".\"<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Changing each separator is very tedious, so instead of adding separators between each word, you can insert a space into cell A2<\/strong> and use the following formula.<\/p>\n\n\n\n
=A1&A2&B1&A2&C1&A2&D1&A2&E1&\".\"<\/code><\/pre>\n\n\n\n
This will give us the same result as before.<\/p>\n\n\n\n
If you want a dash as a separator, you have to add an\napostrophe before the dash, otherwise, Excel will treat this as a formula.\nApostrophe tells Excel<\/a> that it should treat everything in that cell as text.<\/p>\n\n\n\n
Type this into cell A2<\/strong>.<\/p>\n\n\n\n
\u2018-<\/code><\/pre>\n\n\n\n
Now, the text changed to:<\/p>\n\n\n\n
This-is-a-simple-text.<\/code><\/pre>\n\n\n\n
Separators (line break)<\/h2>\n\n\n\n
If you want to separate words into different rows, you have\nto use line breaks. You can\u2019t add line breaks using a keyboard, at least not\ndirectly.<\/p>\n\n\n\n
To achieve it you have to get a character from the character\nset. A line break is number 10.<\/p>\n\n\n\n
Let\u2019s create a formula to split the words into new lines.<\/p>\n\n\n\n
=A1&CHAR(10)&B1&CHAR(10)&C1&CHAR(10)&D1&CHAR(10)&E1<\/code><\/pre>\n\n\n\n
When you execute the formula, you will notice that it didn\u2019t change a thing.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
But when you navigate to Home >> Alignment<\/strong>, there is a feature called Wrap Text<\/strong>. Click it, and It will wrap text in the exact places the CHAR(10)<\/strong> functions are inserted.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Creating a VBA function (Separators)<\/h2>\n\n\n\n
Even if you add a separator to a cell, you have to remember\nwhere the separator is, or lock cells<\/a>, so you won\u2019t delete it by accident. It\u2019s\nstill not the best option.<\/p>\n\n\n\n
Where Excel is not enough, VBA will take care of it. That\u2019s\nwhy we are going to create a function that will help us to deal with the\nproblem.<\/p>\n\n\n\n
First, open the VBA code editor (Left Alt + F11<\/strong>) and create a new module.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Inside this module insert the following code.<\/p>\n\n\n\n
Function CONCATSEP(ParamArray var() As Variant) As String\n    Dim i As Integer\n    Dim result As String\n    Dim separator As String\n    \n    separator = var(UBound(var))\n    \n    If UBound(var) > 1 Then\n        For i = LBound(var) To UBound(var) - 1\n            If i > 0 Then\n                result = result + separator + var(i)\n            Else\n                result = result + var(i)\n            End If\n        Next\n    End If\n    CONCATSEP = result\nEnd Function<\/code><\/pre>\n\n\n\n
Code explanation:<\/strong><\/p>\n\n\n\n
We use ParamArray\nvar() As Variant<\/strong> because we don\u2019t know how many arguments will be inside\nthe function. This allows us to take any number.<\/p>\n\n\n\n
separator = var(UBound(var))<\/strong> – This part of the code get values from the last element and assigns it to the separator<\/strong> variable.<\/p>\n\n\n\n
If UBound(var) > 1\nThen<\/strong> – If there are at least three arguments (two strings + separator) use\nthe code inside. Counting starts from 0 and then 1, 2. That\u2019s why we are\ntalking about three arguments and not two.<\/p>\n\n\n\n
Inside the If<\/strong> function, the program checks whether we are dealing with the first argument. We don\u2019t want to add a separator at the beginning of the first argument, because it will return a string with the separator at the beginning.<\/p>\n","protected":false},"excerpt":{"rendered":"
When you work with Excel, you probably have to deal with data separated into multiple rows. For example name, city, age, etc. But…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nCombine Cells in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to combine cells in Excel using an ampersand (&) with this step-by-step guide. Download the example file to follow along.\" \/>\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\/combine-cells\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Combine Cells in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to combine cells in Excel using an ampersand (&) with this step-by-step guide. Download the example file to follow along.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-19T15:23:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T16:37:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/08\/first-last-name-to-name-1.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\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\/examples\/combine-cells\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Combine Cells in Excel\",\"datePublished\":\"2019-08-19T15:23:47+00:00\",\"dateModified\":\"2024-03-26T16:37:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/\"},\"wordCount\":1059,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/08\/first-last-name-to-name-1.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/\",\"name\":\"Combine Cells in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/08\/first-last-name-to-name-1.png\",\"datePublished\":\"2019-08-19T15:23:47+00:00\",\"dateModified\":\"2024-03-26T16:37:38+00:00\",\"description\":\"Learn how to combine cells in Excel using an ampersand (&) with this step-by-step guide. Download the example file to follow along.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/08\/first-last-name-to-name-1.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/08\/first-last-name-to-name-1.png\",\"width\":685,\"height\":240},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Combine Cells 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.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Combine Cells in Excel","description":"Learn how to combine cells in Excel using an ampersand (&) with this step-by-step guide. Download the example file to follow along.","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\/combine-cells\/","og_locale":"en_US","og_type":"article","og_title":"Combine Cells in Excel","og_description":"Learn how to combine cells in Excel using an ampersand (&) with this step-by-step guide. Download the example file to follow along.","og_url":"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/","article_published_time":"2019-08-19T15:23:47+00:00","article_modified_time":"2024-03-26T16:37:38+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/08\/first-last-name-to-name-1.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Combine Cells in Excel","datePublished":"2019-08-19T15:23:47+00:00","dateModified":"2024-03-26T16:37:38+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/"},"wordCount":1059,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/08\/first-last-name-to-name-1.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/","url":"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/","name":"Combine Cells in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/08\/first-last-name-to-name-1.png","datePublished":"2019-08-19T15:23:47+00:00","dateModified":"2024-03-26T16:37:38+00:00","description":"Learn how to combine cells in Excel using an ampersand (&) with this step-by-step guide. Download the example file to follow along.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/combine-cells\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/08\/first-last-name-to-name-1.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/08\/first-last-name-to-name-1.png","width":685,"height":240},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/combine-cells\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Combine Cells 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."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/4561"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=4561"}],"version-history":[{"count":15,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/4561\/revisions"}],"predecessor-version":[{"id":17309,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/4561\/revisions\/17309"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=4561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=4561"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=4561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}