{"id":242876,"date":"2022-08-10T22:33:19","date_gmt":"2022-08-10T22:33:19","guid":{"rendered":"https:\/\/vmlogger.com\/excel\/?p=242876"},"modified":"2022-08-11T10:25:30","modified_gmt":"2022-08-11T10:25:30","slug":"difference-between-text-value-and-value2-in-excel-vba","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/","title":{"rendered":"Difference between .Text, .Value and .Value2 in Excel VBA"},"content":{"rendered":"

One of you raised a question about which property should I be using to get the value of a cell or range – . Text, .Value or .Value2<\/span> Most of the time you might have seen all 3 methods being used interchangeably. Rather than answering them in a comment, I thought of writing an article here so that you all can benefit from it and learn something interesting and new. <\/p>\n

Before we look into the differences between these 3 – let’s what is common about them. : Well, they all 3 are used to fetch the data from a cell or cell range.<\/span><\/p>\n

What is .Text<\/code><\/strong> property in Excel VBA<\/h1>\n

In simple language, .text() brings the string that is literally visible<\/strong> in a cell.The reason why I say literally visible<\/strong> is because .Text<\/code><\/strong> returns the formatted value from a cell. Note that .Text<\/code><\/strong> is a read-only property.<\/strong> It means you can not set it programmatically. Let’s take an example:<\/p>\n

Example:<\/h2>\n

If cell B1 has a long date format but the column width is not adjusted to fit the entire date, what we see is a #<\/strong> hash symbol filled in the cell. Even though if we click on the cell we can see the correct date inside. That means, in such a case, if you are using the following statement in your VBA code Range(\"B1\").Text<\/code><\/strong> will return the exact number of # keys<\/strong> that are visible on the screen as you can see in the below picture.
\n

\"What

What is returned by .Text<\/p><\/div><\/p>\n

From the above picture it is quite clear what .Text<\/code><\/strong> returns in Excel VBA programming.
\nAs I mentioned before, .Text<\/code><\/strong> returns the formatted value of a cell, that means, if your cell is formatted for Long Date and it is visible on the screen, then it will return the same long format value.<\/p>\n

One of the major drawbacks of .Text<\/code><\/strong> property is that it can return all #####<\/strong> values if a column or row width and height is not adjusted according to the data and cell is displaying ###<\/strong> keys. We have already seen that in the above example.<\/p>\n

What is .Value<\/code><\/strong> property in Excel VBA<\/h1>\n

To understand the difference, it is easier, if we take the same example and run our same code, this time with .Value<\/code><\/strong>
\n.Value<\/code><\/strong> returns the exact value what is stored in the cell. Unlike .Text<\/code><\/strong> property, .Value<\/code><\/strong> does not care about the formatting of the cell rather it returns the exact value [Native excel value] that is stored in the cell. You can see that in the below picture:
\n

\"What

What is .Value in Excel VBA<\/p><\/div><\/p>\n

\nAs mentioned before, .Value<\/code><\/strong> property returns values stored in Native Excel data types which are: Decimal [double precision], Boolean, Empty, Text and Error.
\nBut in case of Currency and Date formatting<\/strong>, .Value<\/code><\/strong> property returns the value in date and currency format after converting its native type Double precision numbers to Data or currency.
\nThe drawback of using .Value<\/code><\/strong> in the case of currency is that: In excel currency has a limit of 4 decimal points and therefore, you might lose precision beyond 4 digits after the decimal.
\nFor example: If you have a number 3.68686868<\/strong>, stored in a cell formatted as currency, then .Value<\/code><\/strong> will return 3.6869<\/strong> only. It will round up the value up to 4 digits after decimal before passing it.\n<\/div>\n

What is .Value2<\/code><\/strong> property in Excel VBA<\/h1>\n

.Value2<\/code><\/strong> returns mostly the same result as .Value<\/code><\/strong> except the fact that it does not convert to Currency or Date format too. That means .Value2<\/code><\/strong> is the property that always returns the exact value which is stored in a Native Excel format which is either of the following: Double Precision, Text, Boolean, Error, or Empty.
\nYou can refer the bellow image to see the difference between .Value<\/code><\/strong> and .Value2<\/code><\/strong> properties of Excel VBA.
\n

\"What

What is Value2 in Excel VBA<\/p><\/div><\/p>\n

\n

Bonus tip<\/h2>\n\n

Apart from all the above differences, there is one more difference related to their performance. That means how fast do they return the value?<\/p>\n

.Text<\/code><\/strong>: This is the slowest and the reason is obvious. Before returning the values it looks into formatting of the cell and then converts it accordingly before returning it.<\/p>\n

\n.Value<\/code><\/strong> : This is faster than .Text<\/code><\/strong> because it converts only in case of formatting is done for currency or date. In all other cases, it returns the value as it is. Therefore, It is little faster than .Text<\/code><\/strong>\n<\/p>\n

.Value2<\/code><\/strong> This is the fastest and reason is obvious too. This does not convert any value at all. It returns every cell value in its native data type irrespective of any formatting done on a cell.<\/p>\n<\/div>\n<\/span>","protected":false},"excerpt":{"rendered":"

One of you raised a question about which property should I be using to get the value of a cell or range – . Text, .Value or .Value2 Most of the time you might have seen all 3 methods being used interchangeably. Rather than answering them in a comment, I thought of writing an article […]<\/p>\n","protected":false},"author":45,"featured_media":242885,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1246],"tags":[],"class_list":["post-242876","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-macro"],"yoast_head":"\nDifference between .Text, .Value and .Value2 in Excel VBA - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"What is .Text, .Value and .Value2 property in Excel VBA? Difference between 3 excel VBA properties : .Text, .Value and .Value2. Which one should I use?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Difference between .Text, .Value and .Value2 in Excel VBA\" \/>\n<meta property=\"og:description\" content=\"What is .Text, .Value and .Value2 property in Excel VBA? Difference between 3 excel VBA properties : .Text, .Value and .Value2. Which one should I use?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-10T22:33:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-11T10:25:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/difference-between-text-value-value2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Difference between .Text, .Value and .Value2 in Excel VBA\",\"datePublished\":\"2022-08-10T22:33:19+00:00\",\"dateModified\":\"2022-08-11T10:25:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/\"},\"wordCount\":763,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/difference-between-text-value-value2.png\",\"articleSection\":[\"Excel Macro\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/\",\"name\":\"Difference between .Text, .Value and .Value2 in Excel VBA - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/difference-between-text-value-value2.png\",\"datePublished\":\"2022-08-10T22:33:19+00:00\",\"dateModified\":\"2022-08-11T10:25:30+00:00\",\"description\":\"What is .Text, .Value and .Value2 property in Excel VBA? Difference between 3 excel VBA properties : .Text, .Value and .Value2. Which one should I use?\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/difference-between-text-value-value2.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/difference-between-text-value-value2.png\",\"width\":400,\"height\":250,\"caption\":\"Difference between Text, Value and Value2\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Difference between .Text, .Value and .Value2 in Excel VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Difference between .Text, .Value and .Value2 in Excel VBA - Let's excel in Excel","description":"What is .Text, .Value and .Value2 property in Excel VBA? Difference between 3 excel VBA properties : .Text, .Value and .Value2. Which one should I use?","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:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/","og_locale":"en_US","og_type":"article","og_title":"Difference between .Text, .Value and .Value2 in Excel VBA","og_description":"What is .Text, .Value and .Value2 property in Excel VBA? Difference between 3 excel VBA properties : .Text, .Value and .Value2. Which one should I use?","og_url":"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2022-08-10T22:33:19+00:00","article_modified_time":"2022-08-11T10:25:30+00:00","og_image":[{"width":400,"height":250,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/difference-between-text-value-value2.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Difference between .Text, .Value and .Value2 in Excel VBA","datePublished":"2022-08-10T22:33:19+00:00","dateModified":"2022-08-11T10:25:30+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/"},"wordCount":763,"commentCount":0,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/difference-between-text-value-value2.png","articleSection":["Excel Macro"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/","url":"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/","name":"Difference between .Text, .Value and .Value2 in Excel VBA - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/difference-between-text-value-value2.png","datePublished":"2022-08-10T22:33:19+00:00","dateModified":"2022-08-11T10:25:30+00:00","description":"What is .Text, .Value and .Value2 property in Excel VBA? Difference between 3 excel VBA properties : .Text, .Value and .Value2. Which one should I use?","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/difference-between-text-value-value2.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/difference-between-text-value-value2.png","width":400,"height":250,"caption":"Difference between Text, Value and Value2"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2022\/08\/difference-between-text-value-and-value2-in-excel-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"Difference between .Text, .Value and .Value2 in Excel VBA"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/242876"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=242876"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/242876\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242885"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=242876"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=242876"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=242876"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}