{"id":24059,"date":"2021-05-07T09:56:16","date_gmt":"2021-05-07T02:56:16","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24059"},"modified":"2021-08-13T16:05:15","modified_gmt":"2021-08-13T09:05:15","slug":"ham-noi-chuoi-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-noi-chuoi-trong-excel\/","title":{"rendered":"4 H\u00e0m n\u1ed1i chu\u1ed7i trong Excel c\u1ef1c h\u1eefu \u00edch b\u1ea1n n\u00ean xem"},"content":{"rendered":"<p>H\u00e0m Concatenate \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 <strong>h\u00e0m n\u1ed1i chu\u1ed7i trong Excel<\/strong>. Ngo\u00e0i h\u00e0m n\u00e0y, Excel c\u00f2n h\u1ed7 tr\u1ee3 m\u1ed9t lo\u1ea1t c\u00e1c h\u00e0m \u0111\u1ec3 n\u1ed1i chu\u1ed7i v\u0103n b\u1ea3n kh\u00e1c, ch\u1eb3ng h\u1ea1n nh\u01b0 h\u00e0m Concat hay h\u00e0m TEXTJOIN. Tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c <strong>h\u00e0m n\u1ed1i chu\u1ed7i Excel<\/strong> n\u00e0y.<\/p>\n<h2><strong>4 H\u00e0m n\u1ed1i chu\u1ed7i trong Excel c\u01a1 b\u1ea3n<\/strong><\/h2>\n<p>Excel \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p nhi\u1ec1u h\u00e0m cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng gh\u00e9p, n\u1ed1i chu\u1ed7i v\u0103n b\u1ea3n trong b\u1ea3ng t\u00ednh. Trong \u0111\u00f3 c\u00e1c h\u00e0m Excel n\u1ed1i chu\u1ed7i v\u0103n b\u1ea3n, d\u1eef li\u1ec7u ph\u1ed5 bi\u1ebfn h\u01a1n c\u1ea3 l\u00e0 h\u00e0m CONCAT, CONCATENATE v\u00e0 TEXTJOIN.<\/p>\n<p>Ngo\u00e0i c\u00e1c h\u00e0m Excel, ng\u01b0\u1eddi d\u00f9ng c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng to\u00e1n t\u1eed (&amp;) \u0111\u1ec3 th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng n\u1ed1i chu\u1ed7i v\u0103n b\u1ea3n t\u01b0\u01a1ng t\u1ef1. \u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m, c\u00fa ph\u00e1p c\u0169ng nh\u01b0 v\u00ed d\u1ee5 minh h\u1ecda c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m n\u1ed1i chu\u1ed7i trong Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o ti\u1ebfp ph\u1ea7n n\u1ed9i dung d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"1080\" class=\"alignnone wp-image-24061 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-noi-chuoi-trong-excel.png\" alt=\"H\u00e0m n\u1ed1i chu\u1ed7i trong Excel\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-noi-chuoi-trong-excel.png 1920w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-noi-chuoi-trong-excel-300x169.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-noi-chuoi-trong-excel-1024x576.png 1024w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-noi-chuoi-trong-excel-768x432.png 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-noi-chuoi-trong-excel-1536x864.png 1536w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-noi-chuoi-trong-excel-750x422.png 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-noi-chuoi-trong-excel-1140x641.png 1140w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/p>\n<h3><strong>1. H\u00e0m Concat &#8211; H\u00e0m n\u1ed1i nhi\u1ec1u chu\u1ed7i trong Excel<\/strong><\/h3>\n<p>H\u00e0m Concat \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u \u0111\u1ea7u ti\u00ean tr\u00ean Excel 2016 v\u00e0 kh\u00f4ng c\u00f3 s\u1eb5n tr\u00ean c\u00e1c phi\u00ean b\u1ea3n Excel c\u0169 h\u01a1n, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 thay th\u1ebf h\u00e0m Concatenate, h\u1ed7 tr\u1ee3 \u00edt nh\u1ea5t 1 tham s\u1ed1 v\u00e0 t\u1ed1i \u0111a 254 tham s\u1ed1. H\u00e0m Excel n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c \u00f4 ri\u00eang bi\u1ec7t c\u0169ng nh\u01b0 ph\u1ea1m vi c\u00e1c \u00f4. Ngo\u00e0i ra ch\u00fang ta c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p c\u00e1c \u00f4 ri\u00eang l\u1ebb v\u1edbi ph\u1ea1m vi c\u00e1c \u00f4, ch\u1eb3ng h\u1ea1n nh\u01b0 <strong>=CONCAT (B4, C4: D4)<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"400\" class=\"aligncenter wp-image-28870 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-noi-nhieu-chuoi-trong-excel.png\" alt=\"H\u00e0m n\u1ed1i nhi\u1ec1u chu\u1ed7i trong Excel\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-noi-nhieu-chuoi-trong-excel.png 600w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-noi-nhieu-chuoi-trong-excel-300x200.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><strong>2. H\u00e0m CONCATENATE c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/strong><\/h3>\n<p><strong>H\u00e0m n\u1ed1i chu\u1ed7i<\/strong> Concatenate c\u00f3 s\u1eb5n tr\u00ean c\u00e1c phi\u00ean b\u1ea3n Excel c\u0169 h\u01a1n, bao g\u1ed3m Excel 2010, 2007, \u2026 . V\u1ec1 c\u01a1 b\u1ea3n h\u00e0m Concatenate c\u00f3 c\u00fa ph\u00e1p v\u00e0 ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m Concat tr\u00ean c\u00e1c phi\u00ean b\u1ea3n Excel 2016 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n m\u1edbi h\u01a1n. Ch\u1ec9 c\u00f3 \u0111i\u1ec1u, h\u00e0m Concatenate kh\u00f4ng h\u1ed7 tr\u1ee3 tham chi\u1ebfu l\u00e0 ph\u1ea1m vi c\u00e1c \u00f4 m\u00e0 ch\u1ec9 h\u1ed7 tr\u1ee3 c\u00e1c \u00f4 ri\u00eang l\u1ebb. Tham chi\u1ebfu \u00f4 t\u1ed1i \u0111a 255.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1280\" height=\"610\" class=\"wp-image-24062 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-concatenate.jpg\" alt=\"H\u00e0m n\u1ed1i chu\u1ed7i trong Excel - H\u00e0m Concatenate \" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-concatenate.jpg 1280w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-concatenate-300x143.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-concatenate-1024x488.jpg 1024w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-concatenate-768x366.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-concatenate-750x357.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-concatenate-1140x543.jpg 1140w\" sizes=\"auto, (max-width: 1280px) 100vw, 1280px\" \/><\/p>\n<p>C\u00fa ph\u00e1p h\u00e0m CONCATENATE c\u00f3 d\u1ea1ng:<\/p>\n<blockquote><p><strong>=CONCATENATE(text1,text2\u2026)<\/strong><\/p><\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li>Tham s\u1ed1<strong>\u00a0text1<\/strong>\u00a0l\u00e0 b\u1eaft bu\u1ed9c v\u00e0 l\u00e0 m\u1ee5c, v\u0103n b\u1ea3n \u0111\u1ea7u ti\u00ean c\u1ea7n gh\u00e9p n\u1ed1i.<\/li>\n<li><strong>Text2<\/strong>\u00a0l\u00e0 m\u1ed9t tham s\u1ed1 t\u00f9y ch\u1ecdn, l\u00e0 v\u0103n b\u1ea3n \u0111\u1ec3 gh\u00e9p n\u1ed1i.<\/li>\n<\/ul>\n<p><strong>L\u01b0u \u00fd:<\/strong> Ch\u00fang ta ch\u1ec9 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c nh\u1eadp t\u1ed1i \u0111a l\u00e0 255 tham s\u1ed1.<\/p>\n<h3><strong>3. H\u00e0m TEXTJOIN<\/strong><\/h3>\n<p>H\u00e0m TEXTJOIN l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m m\u1edbi, \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u \u0111\u1ea7u ti\u00ean tr\u00ean Excel 2016. H\u00e0m Excel n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 n\u1ed1i v\u0103n b\u1ea3n t\u1eeb nhi\u1ec1u ph\u1ea1m vi v\u00e0 \/ ho\u1eb7c c\u00e1c chu\u1ed7i.<\/p>\n<ul>\n<li>H\u00e0mTEXTJOIN g\u1ed3m m\u1ed9t d\u1ea5u ph\u00e2n c\u00e1ch gi\u1eefa gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c n\u1ed1i.<\/li>\n<li>H\u00e0m n\u1ed1i chu\u1ed7i trong Excel n\u00e0y c\u00f3 kh\u1ea3 n\u0103ng t\u1ef1 \u0111\u1ed9ng b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"500\" class=\"alignnone wp-image-24063 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-textjoin.png\" alt=\"H\u00e0m n\u1ed1i chu\u1ed7i trong Excel - H\u00e0m TextJoin\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-textjoin.png 800w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-textjoin-300x188.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-textjoin-768x480.png 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-textjoin-750x469.png 750w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>C\u00fa ph\u00e1p h\u00e0m TEXTJOIN Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<blockquote><p><strong>TEXTJOIN(delimiter, ignore_empty, text1, [text2], \u2026)<\/strong><\/p><\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><strong>Delimiter<\/strong>\u00a0(d\u1ea5u ph\u00e2n c\u00e1ch): l\u00e0 k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c th\u00eam, ch\u00e8n v\u00e0o gi\u1eefa c\u00e1c v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p. D\u1ea5u ph\u00e2n c\u00e1ch ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 d\u1ea5u ph\u1ea9y.<\/li>\n<li><strong>Ignore empty:<\/strong>\u00a0tham s\u1ed1 n\u00e0y s\u1eed d\u1ee5ng c\u00e1c gi\u00e1 tr\u1ecb l\u00e0 TRUE ho\u1eb7c FALSE. N\u1ebfu gi\u00e1 tr\u1ecb l\u00e0 TRUE ho\u1eb7c b\u1ecf qua, c\u00e1c \u00f4 tr\u1ed1ng kh\u00f4ng \u0111\u01b0\u1ee3c xem x\u00e9t. N\u1ebfu gi\u00e1 tr\u1ecb n\u00e0y l\u00e0 FALSE, c\u00e1c \u00f4 tr\u1ed1ng s\u1ebd \u0111\u01b0\u1ee3c xem x\u00e9t v\u00e0 ph\u00e2n t\u00e1ch b\u1eb1ng d\u1ea5u ph\u00e2n c\u00e1ch.<\/li>\n<\/ul>\n<p><strong>L\u01b0u \u00fd:<\/strong> H\u00e0m TEXTJOIN trong Excel y\u00eau c\u1ea7u \u00edt nh\u1ea5t m\u1ed9t tham s\u1ed1 \u0111\u1ec3 n\u1ed1i, k\u1ebft h\u1ee3p c\u00e1c chu\u1ed7i trong c\u00e1c \u00f4. Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed1i \u0111a 252 \u0111\u1ed1i s\u1ed1 v\u0103n b\u1ea3n.<\/p>\n<h3><strong>4. D\u00f9ng h\u00e0m to\u00e1n t\u1eed &#8220;&amp;&#8221; \u0111\u1ec3 n\u1ed1i chu\u1ed7i trong Excel<\/strong><\/h3>\n<p>C\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 n\u1ed1i c\u00e1c chu\u1ed7i trong Excel l\u00e0 s\u1eed d\u1ee5ng h\u00e0m to\u00e1n t\u1eed &#8220;&amp;&#8221;. T\u01b0\u01a1ng t\u1ef1 <strong>h\u00e0m n\u1ed1i chu\u1ed7i<\/strong> CONCATENATE, h\u00e0m to\u00e1n t\u1eed &#8220;&amp;&#8221; c\u0169ng h\u1ed7 tr\u1ee3 c\u00e1c \u00f4 ri\u00eang l\u1ebb v\u00e0 kh\u00f4ng h\u1ed7 tr\u1ee3 d\u1ea3i \u00f4. \u0110\u1ed5i l\u1ea1i \u01b0u \u0111i\u1ec3m c\u1ee7a h\u00e0m n\u00e0y l\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n v\u00e0 s\u1eed d\u1ee5ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"264\" class=\"aligncenter wp-image-28871 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/noi-chuoi-trong-excel-voi-toan-tu.jpg\" alt=\"D\u00f9ng h\u00e0m to\u00e1n t\u1eeb \u0111\u1ec3 n\u1ed1i chu\u1ed7i\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/noi-chuoi-trong-excel-voi-toan-tu.jpg 650w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/noi-chuoi-trong-excel-voi-toan-tu-300x122.jpg 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/p>\n<h2><strong>K\u1ebft lu\u1eadn<\/strong><\/h2>\n<p>B\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba gi\u1edbi thi\u1ec7u cho b\u1ea1n 4<strong> h\u00e0m n\u1ed1i chu\u1ed7i trong Excel<\/strong>. Ngo\u00e0i ra b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam nh\u1eefng ki\u1ebfn th\u1ee9c hay ho v\u1ec1 Excel nh\u00e9.<\/p>\n<ul>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-rank-trong-excel\/\">H\u00e0m rank trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-index-trong-excel\/\">H\u00e0m Index trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-lay-thang-nam-trong-excel\/\">H\u00e0m l\u1ea5y th\u00e1ng n\u0103m trong Excel<\/a><\/li>\n<\/ul>\n<p>\u0110\u1eebng qu\u00ean chia s\u1ebb \u00fd ki\u1ebfn, \u0111\u00e1nh gi\u00e1 c\u1ee7a b\u1ea1n cho Ben Computer nh\u00e9. M\u1ed7i \u00fd ki\u1ebfn, \u0111\u00f3ng g\u00f3p c\u1ee7a b\u1ea1n s\u1ebd gi\u00fap Ben Computer c\u1ea3i thi\u1ec7n ch\u1ea5t l\u01b0\u1ee3ng b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh t\u1ed1t h\u01a1n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Concatenate \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 h\u00e0m n\u1ed1i chu\u1ed7i trong Excel. Ngo\u00e0i h\u00e0m n\u00e0y, Excel c\u00f2n h\u1ed7 tr\u1ee3 m\u1ed9t lo\u1ea1t c\u00e1c h\u00e0m \u0111\u1ec3 n\u1ed1i chu\u1ed7i v\u0103n b\u1ea3n kh\u00e1c, ch\u1eb3ng h\u1ea1n nh\u01b0 h\u00e0m Concat hay h\u00e0m TEXTJOIN. Tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":24061,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24059","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24059","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24059"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24059\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24061"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}