{"id":3152,"date":"2024-12-03T01:15:27","date_gmt":"2024-12-03T01:15:27","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/dao-nguoc-chuoi-trong-excel-bang-ham-textjoin\/"},"modified":"2024-12-03T01:15:27","modified_gmt":"2024-12-03T01:15:27","slug":"dao-nguoc-chuoi-trong-excel-bang-ham-textjoin","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/dao-nguoc-chuoi-trong-excel-bang-ham-textjoin\/","title":{"rendered":"\u0110\u1ea3o ng\u01b0\u1ee3c chu\u1ed7i trong Excel b\u1eb1ng h\u00e0m TEXTJOIN"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>H\u00f4m nay <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng <strong>h\u00e0m textjoin<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c \u0111\u1ea3o ng\u01b0\u1ee3i chu\u1ed7i trong excel nh\u00e9!<\/em><\/p>\n<p>\u00a0<\/p>\n<p>H\u00e3y gi\u1ea3 s\u1eed ta c\u00f3 m\u1ed9t chu\u1ed7i \u201cA B C D\u201d, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ea3o ng\u01b0\u1ee3c chu\u1ed7i th\u00e0nh \u201cD C B A\u201d?<\/p>\n<p>C\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 t\u1eebng \u0111\u1ecdc b\u00e0i vi\u1ebft: <strong><a href=\"http:\/\/blog.ezworkapp.com\/dao-nguoc-ho-va-ten-trong-excel-don-gian.html\">\u0110\u1ea3o ng\u01b0\u1ee3c h\u1ecd v\u00e0 t\u00ean trong Excel<\/a>\u00a0<\/strong>tuy nhi\u00ean c\u00e1ch l\u00e0m \u0111\u00f3 c\u00f3 th\u1ec3 kh\u00f4ng s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y. C\u1ee5 th\u1ec3, \u0111\u1ec3 \u0111\u1ea3o ng\u01b0\u1ee3c chu\u1ed7i ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m TEXTJOIN k\u1ebft h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c. C\u1ee5 th\u1ec3 h\u00e3y xem b\u00ean d\u01b0\u1edbi:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674e5bae5de40\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/dao-nguoc-chuoi-trong-excel.html#Dao_nguoc_chuoi_voi_ham_TEXTJOIN_ket_hop_MID\" title=\"\u0110\u1ea3o ng\u01b0\u1ee3c chu\u1ed7i v\u1edbi h\u00e0m TEXTJOIN k\u1ebft h\u1ee3p MID\">\u0110\u1ea3o ng\u01b0\u1ee3c chu\u1ed7i v\u1edbi h\u00e0m TEXTJOIN k\u1ebft h\u1ee3p MID<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/dao-nguoc-chuoi-trong-excel.html#Su_dung_mang_dong_dao_nguoc_chuoi_tu_dong_thay_doi_theo_so_luong_ky_tu\" title=\"S\u1eed d\u1ee5ng m\u1ea3ng \u0111\u1ed9ng \u0111\u1ea3o ng\u01b0\u1ee3c chu\u1ed7i t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i theo s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1\">S\u1eed d\u1ee5ng m\u1ea3ng \u0111\u1ed9ng \u0111\u1ea3o ng\u01b0\u1ee3c chu\u1ed7i t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i theo s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/dao-nguoc-chuoi-trong-excel.html#Su_dung_ham_SEQUENCE_tao_danh_sach_so_lien_tiep_trong_mang_theo_thu_tu_giam_dan\" title=\"S\u1eed d\u1ee5ng h\u00e0m SEQUENCE t\u1ea1o danh s\u00e1ch s\u1ed1 li\u00ean ti\u1ebfp trong m\u1ea3ng theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n\">S\u1eed d\u1ee5ng h\u00e0m SEQUENCE t\u1ea1o danh s\u00e1ch s\u1ed1 li\u00ean ti\u1ebfp trong m\u1ea3ng theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/dao-nguoc-chuoi-trong-excel.html#ROW_INDIRECT_va_ung_dung_dao_nguoc_chuoi_trong_Excel\" title=\"ROW, INDIRECT v\u00e0 \u1ee9ng d\u1ee5ng \u0111\u1ea3o ng\u01b0\u1ee3c chu\u1ed7i trong Excel\">ROW, INDIRECT v\u00e0 \u1ee9ng d\u1ee5ng \u0111\u1ea3o ng\u01b0\u1ee3c chu\u1ed7i trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Dao_nguoc_chuoi_voi_ham_TEXTJOIN_ket_hop_MID\"><\/span>\u0110\u1ea3o ng\u01b0\u1ee3c chu\u1ed7i v\u1edbi h\u00e0m TEXTJOIN k\u1ebft h\u1ee3p MID<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p><em>\u0110\u1ecdc th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ghep-noi-ky-tu-voi-ham-concat-va-textjoin-trong-excel.html\"><strong>H\u00e0m TEXTJOIN<\/strong><\/a>,\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-mid-trong-excel-nhung-phep-toan-co-ban-va-nang-cao.html\">H\u00e0m MID<\/a><\/strong><\/em><\/p>\n<\/blockquote>\n<p>V\u00ed d\u1ee5 nh\u01b0 ta c\u00f3 chu\u1ed7i \u201c<strong>ABCD<\/strong>\u201d t\u1ea1i \u00f4 A1. Ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m TEXTJOIN k\u1ebft h\u1ee3p MID \u0111\u1ec3 \u0111\u1ea3o chu\u1ed7i nh\u01b0 sau:<\/p>\n<p><strong>=TEXTJOIN(\u201c\u201d,TRUE,MID(A1,{4,3,2,1},1))<\/strong><\/p>\n<p>K\u1ebft qu\u1ea3 ta s\u1ebd thu \u0111\u01b0\u1ee3c l\u00e0 <strong>DCBA<\/strong><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-239.gif\" title=\"ex101_92019-nho-239\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><em>Gi\u1ea3i th\u00edch:<\/em><strong>\u00a0<\/strong><\/p>\n<p>H\u00e0m\u00a0<strong>MID<\/strong> s\u1eed d\u1ee5ng d\u1ea1ng m\u1ea3ng s\u1ebd l\u1ea5y 1 k\u00fd t\u1ef1 t\u1eeb \u00f4 A1 v\u00e0 tr\u1ea3 v\u1ec1 m\u1ea3ng theo th\u1ee9 t\u1ef1 \u0111\u1ea3o \u0111\u1ea7u cu\u1ed1i:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29195 size-full\" title=\"dao-nguoc-chuoi-su-dung-hame-textjoin-1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dao-nguoc-chuoi-1.png\" alt=\"dao-nguoc-chuoi-su-dung-hame-textjoin-1\" width=\"410\" height=\"109\"><\/p>\n<p>\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 xem v\u00ed d\u1ee5 v\u1ec1 h\u00e0m\u00a0<strong>CHOOSE<\/strong> t\u01b0\u01a1ng t\u1ef1 trong b\u00e0i vi\u1ebft sau:\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ket-hop-vlookup-va-choose-tim-kiem-tu-phai-qua-trai.html\">H\u00e0m CHOOSE \u0111\u1ea3o m\u1ea3ng k\u1ebft h\u1ee3p VLOOKUP, tra c\u1ee9u ng\u01b0\u1ee3c t\u1eeb ph\u1ea3i sang<\/a>.<\/strong><\/p>\n<p>Sau khi \u0111\u00e3 s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>MID<\/strong>, ta \u0111\u1eb7t v\u00e0o trong\u00a0<strong>TEXTJOIN\u00a0<\/strong>v\u00e0 ti\u1ebfn h\u00e0nh n\u1ed1i chu\u1ed7i l\u1ea1i b\u00ecnh th\u01b0\u1eddng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_mang_dong_dao_nguoc_chuoi_tu_dong_thay_doi_theo_so_luong_ky_tu\"><\/span>S\u1eed d\u1ee5ng m\u1ea3ng \u0111\u1ed9ng \u0111\u1ea3o ng\u01b0\u1ee3c chu\u1ed7i t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i theo s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, s\u1ed1 trong m\u1ea3ng ch\u00ednh l\u00e0 s\u1ed1 k\u00fd t\u1ef1 b\u1ecb gi\u1edbi h\u1ea1n v\u1edbi chu\u1ed7i, c\u00f3 ngh\u0129a l\u00e0 n\u1ebfu chu\u1ed7i l\u1edbn h\u01a1n 4 k\u00fd t\u1ef1, ta s\u1ebd ph\u1ea3i th\u00eam s\u1ed1 trong m\u1ea3ng. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 m\u1ea3ng c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng co b\u00f3p v\u1eeba k\u00edch c\u1ee1?<\/p>\n<p><em>\u0110\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1, h\u00e3y nh\u1edb t\u1edbi h\u00e0m\u00a0<strong>LEN:\u00a0<\/strong><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html\">H\u00e0m LEN \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 trong \u00f4<\/a><\/strong><\/em><\/p>\n<p>T\u01b0 duy c\u1ee7a ta s\u1ebd theo h\u01b0\u1edbng k\u1ebft h\u1ee3p \u0111\u01b0a h\u00e0m LEN v\u00e0o trong m\u1ea3ng v\u00e0 tr\u1ea3 v\u1ec1 th\u1ee9 t\u1ef1 t\u1eeb\u00a0<strong>LEN(A1)\u00a0<\/strong>v\u1ec1 1. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, ta c\u00f3 th\u1ec3 ch\u1ecdn 1 trong 2 ph\u01b0\u01a1ng \u00e1n sau:\u00a0<strong>S\u1eed d\u1ee5ng h\u00e0m SEQUENCE (ch\u1ec9 c\u00f3 trong phi\u00ean b\u1ea3n Office 365)<\/strong> ho\u1eb7c\u00a0<strong>k\u1ebft h\u1ee3p c\u00f9ng ROW v\u00e0 INDIRECT<\/strong>. Ta s\u1ebd \u0111\u1ebfn v\u1edbi t\u1eebng ph\u01b0\u01a1ng \u00e1n ngay sau \u0111\u00e2y.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_SEQUENCE_tao_danh_sach_so_lien_tiep_trong_mang_theo_thu_tu_giam_dan\"><\/span>S\u1eed d\u1ee5ng h\u00e0m SEQUENCE t\u1ea1o danh s\u00e1ch s\u1ed1 li\u00ean ti\u1ebfp trong m\u1ea3ng theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p><em>H\u00e0m SEQUENCE:\u00a0<\/em><a href=\"http:\/\/blog.ezworkapp.com\/ham-sequence-co-ban-trong-excel.html\"><em><strong>S\u1eed d\u1ee5ng h\u00e0m SEQUENCE trong Excel<\/strong><\/em><\/a><\/p>\n<\/blockquote>\n<p>V\u1edbi h\u00e0m SEQUENCE ta c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t m\u1ea3ng t\u1ef1 thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc theo s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u00f4. K\u1ebft h\u1ee3p v\u1edbi h\u00e0m <strong>LEN<\/strong> v\u00e0 b\u01b0\u1edbc \u0111\u1ebfm\u00a0<strong>-1<\/strong>, ta c\u00f3 c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<p><em>=SEQUENCE(LEN(A1),,LEN(A1),-1)<\/em><\/p>\n<\/blockquote>\n<p>ho\u1eb7c<\/p>\n<blockquote>\n<p><em>=SEQUENCE(,LEN(A1),LEN(A1),-1)<\/em><\/p>\n<\/blockquote>\n<p>\u0110\u1eb7t h\u00e0m SEQUENCE v\u00e0o trong h\u00e0m MID c\u1ee7a c\u00f4ng th\u1ee9c tr\u00ean ta c\u00f3:<\/p>\n<p><em><strong>=TEXTJOIN(\u201c\u201d,TRUE,MID(A1,SEQUENCE(,LEN(A1),LEN(A1),-1),1))<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29196 size-full\" title=\"dao-nguoc-chuoi-su-dung-hame-textjoin-2\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dao-nguoc-chuoi-2.png\" alt=\"dao-nguoc-chuoi-su-dung-hame-textjoin-2\" width=\"650\" height=\"132\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"ROW_INDIRECT_va_ung_dung_dao_nguoc_chuoi_trong_Excel\"><\/span>ROW, INDIRECT v\u00e0 \u1ee9ng d\u1ee5ng \u0111\u1ea3o ng\u01b0\u1ee3c chu\u1ed7i trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u01b0\u1edbc khi \u0111i v\u00e0o ph\u1ea7n ti\u1ebfp theo, b\u1ea1n h\u00e3y xem c\u00e1ch t\u1ea1o ra m\u1ed9t m\u1ea3ng s\u1ed1 b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p ROW v\u00e0 INDIRECT:\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/tao-mang-so-trong-excel.html\">K\u1ebft h\u1ee3p ROW v\u00e0 INDIRECT t\u1ea1o m\u1ea3ng s\u1ed1<\/a>.<\/strong><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ta c\u00f3 th\u1ec3 t\u1ea1o ra 1 m\u1ea3ng g\u1ed3m c\u00e1c s\u1ed1 t\u1eeb 1 \u0111\u1ebfn LEN(A1) nh\u01b0 sau:<\/p>\n<blockquote>\n<p><em>=ROW(INDIRECT(\u201c1:\u201d&amp;LEN(A1)))<\/em><\/p>\n<\/blockquote>\n<p>M\u1ea3ng n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng ti\u1ebfn d\u1ea7n. \u0110\u1ec3 \u0111\u1ea3o ng\u01b0\u1ee3c, ta s\u1ebd s\u1eed d\u1ee5ng m\u1ed9t ph\u00e9p tr\u1eeb trong m\u1ea3ng nh\u01b0 sau:<\/p>\n<blockquote>\n<p><em>=LEN(A1)\u00a0\u2013\u00a0ROW(INDIRECT(\u201c1:\u201d&amp;LEN(A1))) +1\u00a0<\/em><\/p>\n<\/blockquote>\n<p>\u0110\u01b0a v\u00e0o trong h\u00e0m MID, TEXTJOIN v\u00e0 k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng:<\/p>\n<blockquote>\n<p><strong><em>=TEXTJOIN(\u201c\u201d,TRUE,MID(A1,LEN(A1) \u2013 ROW(INDIRECT(\u201c1:\u201d&amp;LEN(A1))) +1,1))<\/em><\/strong><\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29202 size-full\" title=\"dao-nguoc-chuoi-su-dung-hame-textjoin-3\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dao-nguoc-chuoi-3.png\" alt=\"dao-nguoc-chuoi-su-dung-hame-textjoin-3\" width=\"879\" height=\"130\"><\/p>\n<p>Ngo\u00e0i ra ta c\u0169ng c\u00f3 th\u1ec3 \u0111\u1ea3o chu\u1ed7i b\u1eb1ng h\u00e0m <strong>CONCAT<\/strong> nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong><em>=CONCAT(MID(A1,1+LEN(A1)-ROW(INDIRECT(LEN(A1)&amp;\u201d:1\u2033)),1))<\/em><\/strong><\/p>\n<\/blockquote>\n<p>\u00a0<\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-textjoin-ghep-chuoi-thoa-man-dieu-kien.html\">H\u00e0m TEXTJOIN gh\u00e9p chu\u1ed7i th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n<\/a><\/strong><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-indirect-trong-excel-de-hieu-nhat.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m INDIRECT trong Excel<\/a><\/strong><\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-239.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3153,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3152","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=3152"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3152\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3153"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}