{"id":7545,"date":"2024-12-21T17:56:12","date_gmt":"2024-12-21T17:56:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-trich-xuat-ten-mien-tu-url-trong-excel\/"},"modified":"2024-12-21T17:56:12","modified_gmt":"2024-12-21T17:56:12","slug":"cach-trich-xuat-ten-mien-tu-url-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-trich-xuat-ten-mien-tu-url-trong-excel\/","title":{"rendered":"C\u00e1ch tr\u00edch xu\u1ea5t t\u00ean mi\u1ec1n t\u1eeb URL trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n l\u1ea5y t\u00ean mi\u1ec1n t\u1eeb danh s\u00e1ch c\u00e1c URL b\u1eb1ng c\u00f4ng th\u1ee9c Excel. Hai bi\u1ebfn c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y cho ph\u00e9p b\u1ea1n l\u1ea5y t\u00ean mi\u1ec1n c\u00f3 ch\u1ee9a ho\u1eb7c kh\u00f4ng ch\u1ee9a \u201cwww.\u201d v\u1edbi b\u1ea5t k\u1ef3 giao th\u1ee9c n\u00e0o (http, https, fpt\u2026). Gi\u1ea3i ph\u00e1p c\u00f3 hi\u1ec7u qu\u1ea3 trong m\u1ecdi phi\u00ean b\u1ea3n Excel hi\u1ec7n \u0111\u1ea1i t\u1eeb 2010-2016.<\/p>\n<p style=\"text-align: justify\"><strong>5 b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 l\u1ea5y t\u00ean mi\u1ec1n t\u1eeb danh s\u00e1ch c\u00e1c URL<\/strong><\/p>\n<p style=\"text-align: justify\">Ta c\u00f3 b\u1ea3ng sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5809\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-72.png\" width=\"600\" height=\"243\" title=\"excel-dialog-box-launcher-1-72\"><\/p>\n<ol style=\"text-align: justify\">\n<li>Th\u00eam c\u1ed9t \u2018Domain\u2019 v\u00e0o cu\u1ed1i b\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Ch\u00fang ta xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb t\u1ec7p CSV, \u0111\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao d\u1eef li\u1ec7u Excel c\u1ee7a ch\u00fang ta ch\u1ec9 \u1edf d\u1ea1ng c\u01a1 b\u1ea3n. Nh\u1ea5n <strong><em>Ctrl + T <\/em><\/strong>\u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i ch\u00fang th\u00e0nh b\u1ea3ng bi\u1ec3u Excel ho\u00e0n ch\u1ec9nh.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5810\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-73.png\" width=\"600\" height=\"247\" title=\"excel-dialog-box-launcher-1-73\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Trong \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t \u2018Domain\u2019 (B2), nh\u1eadp c\u00f4ng th\u1ee9c \u0111\u1ec3 xu\u1ea5t t\u00ean mi\u1ec1n:<\/li>\n<\/ol>\n<ul style=\"text-align: justify\">\n<li>Xu\u1ea5t t\u00ean mi\u1ec1n c\u00f3 ch\u1ee9a \u2018www.\u2019 n\u1ebfu hi\u1ec3n th\u1ecb trong URL\u00a0:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><em>=MID(A2,FIND(\u201c:\u201d,A2,4)+3,FIND(\u201c\/\u201d,A2,9)-FIND(\u201c:\u201d,A2,4)-3)<\/em><\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>Lo\u1ea1i b\u1ecf \u2018www.\u2019, ch\u1ec9 l\u1ea5y t\u00ean mi\u1ec1n:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><em>=IF(ISERROR(FIND(\u201c\/\/www.\u201d,A2)), MID(A2,FIND(\u201c:\u201d,A2,4)+3,FIND(\u201c\/\u201d,A2,9)-FIND(\u201c:\u201d,A2,4)-3), MID(A2,FIND(\u201c:\u201d,A2,4)+7,FIND(\u201c\/\u201d,A2,9)-FIND(\u201c:\u201d,A2,4)-7))<\/em><\/strong><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-304.gif\" title=\"vba101_92019-nho-304\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-676.gif\" title=\"ex101_92019-nho-676\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5811\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-74.png\" width=\"600\" height=\"115\" title=\"excel-dialog-box-launcher-1-74\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>V\u1ec1 m\u1eb7t k\u1ef9 thu\u1eadt, \u2018www\u2019 l\u00e0 t\u00ean mi\u1ec1n c\u1ea5p 3, m\u1eb7c d\u00f9 v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c trang web b\u00ecnh th\u01b0\u1eddng, \u2018www.\u2019 ch\u1ec9 l\u00e0 m\u1ed9t b\u00ed danh c\u1ee7a mi\u1ec1n ch\u00ednh.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u1ea7n \u0111\u1ec3 l\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c t\u00ean mi\u1ec1n c\u1ea5p 3 kh\u00e1c, n\u1ebfu kh\u00f4ng b\u1ea1n s\u1ebd khi\u1ebfn c\u00e1c li\u00ean k\u1ebft tr\u1edf n\u00ean l\u1eabn l\u1ed9n, v\u00ed d\u1ee5: v\u1edbi t\u00ean mi\u1ec1n \u201cco.uk\u201d ho\u1eb7c t\u1eeb c\u00e1c t\u00e0i kho\u1ea3n kh\u00e1c nhau tr\u00ean blogspot.com\u2026<\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Sau khi ch\u00fang ta c\u00f3 m\u1ed9t b\u1ea3ng ho\u00e0n ch\u1ec9nh, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c \u00f4 t\u00ednh kh\u00e1c trong c\u1ed9t. Nh\u01b0 v\u1eady, ch\u00fang ta c\u00f3 m\u1ed9t c\u1ed9t ch\u1ee9a t\u00ean mi\u1ec1n tr\u00edch xu\u1ea5t.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5813\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-76.png\" width=\"600\" height=\"247\" title=\"excel-dialog-box-launcher-1-76\"><\/p>\n<p style=\"text-align: justify\">Trong ph\u1ea7n ti\u1ebfp theo, b\u1ea1n s\u1ebd h\u1ecdc c\u00e1ch x\u1eed l\u00fd m\u1ed9t danh s\u00e1ch URL d\u1ef1a tr\u00ean c\u1ed9t \u2018Domain\u2019.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong> N\u1ebfu b\u1ea1n c\u1ea7n ch\u1ec9nh s\u1eeda t\u00ean mi\u1ec1n ho\u1eb7c sao ch\u00e9p k\u1ebft qu\u1ea3 v\u00e0o m\u1ed9t trang t\u00ednh Excel kh\u00e1c, h\u00e3y thay th\u1ebf k\u1ebft qu\u1ea3 c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1c gi\u00e1 tr\u1ecb. \u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong c\u1ed9t \u2018Domain\u2019 v\u00e0 nh\u1ea5n <strong><em>Ctrl + Space<\/em><\/strong> \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong c\u1ed9t \u0111\u00f3.<\/li>\n<li>Nh\u1ea5n <strong><em>Ctrl + C<\/em><\/strong> \u0111\u1ec3 sao ch\u00e9p d\u1eef li\u1ec7u v\u00e0o <strong><em>Clipboard<\/em><\/strong>, sau \u0111\u00f3 di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>Home<\/em><\/strong>, nh\u1ea5n <strong><em>Paste <\/em><\/strong>v\u00e0 ch\u1ecdn <strong><em>Value <\/em><\/strong>trong danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5814\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-77.png\" width=\"600\" height=\"344\" title=\"excel-dialog-box-launcher-1-77\"><\/p>\n<p style=\"text-align: justify\"><strong>X\u1eed l\u00fd m\u1ed9t danh s\u00e1ch URL d\u1ef1a tr\u00ean c\u1ed9t Domain<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Nh\u00f3m c\u00e1c URL b\u1eb1ng t\u00ean mi\u1ec1n<\/strong><\/p>\n<ol style=\"text-align: justify\">\n<li>Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u00f4 t\u00ednh n\u00e0o trong c\u1ed9t \u2018Domain\u2019.<\/li>\n<li>S\u1eafp x\u1ebfp b\u1ea3ng d\u1eef li\u1ec7u theo t\u00ean mi\u1ec1n: di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>Data<\/em><\/strong> v\u00e0 nh\u1ea5n n\u00fat <strong><em>A-Z<\/em><\/strong>.<\/li>\n<li>Chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u d\u1ea1ng b\u1ea3ng th\u00e0nh d\u1ea1ng b\u00ecnh th\u01b0\u1eddng: nh\u1ea5p v\u00e0o \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng, di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>Design<\/em><\/strong> v\u00e0 nh\u1ea5n n\u00fat <strong><em>Convert to the range<\/em><\/strong>.<\/li>\n<li>Di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>Data<\/em><\/strong> v\u00e0 nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong><em>Subtotal<\/em><\/strong>.<\/li>\n<li>Trong h\u1ed9p tho\u1ea1i <strong><em>Subtotal<\/em><\/strong>, ch\u1ecdn c\u00e1c t\u00f9y ch\u1ecdn sau: ch\u1ecdn <strong><em>Domain <\/em><\/strong>trong <strong><em>At each change in:<\/em><\/strong>, ch\u1ecdn <strong><em>Count <\/em><\/strong>trong <strong><em>Use function:<\/em><\/strong>, \u0111\u00e1nh d\u1ea5u ch\u1ecdn <strong><em>Domain <\/em><\/strong>trong <strong><em>Add subtotal to:<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong><em><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5815\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-78.png\" width=\"600\" height=\"330\" title=\"excel-dialog-box-launcher-1-78\"><\/em><\/strong><\/p>\n<ol style=\"text-align: justify\" start=\"6\">\n<li>Nh\u1ea5n OK.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Excel \u0111\u00e3 t\u1ea1o m\u1ed9t ph\u1ee5 l\u1ee5c cho d\u1eef li\u1ec7u \u1edf ph\u00eda b\u00ean tr\u00e1i m\u00e0n h\u00ecnh. C\u00f3 3 c\u1ea5p \u0111\u1ed9 kh\u00e1c nhau v\u00e0 nh\u1eefng g\u00ec b\u1ea1n nh\u00ecn th\u1ea5y tr\u00ean h\u00ecnh l\u00e0 ch\u1ebf \u0111\u1ed9 xem m\u1edf r\u1ed9ng, (ho\u1eb7c c\u1ea5p \u0111\u1ed9 3). Nh\u1ea5p v\u00e0o s\u1ed1 2 \u1edf g\u00f3c tr\u00ean b\u00ean tr\u00e1i \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u cu\u1ed1i c\u00f9ng theo t\u00ean mi\u1ec1n, sau \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o d\u1ea5u c\u1ed9ng v\u00e0 d\u1ea5u tr\u1eeb (+\/-) \u0111\u1ec3 m\u1edf r\u1ed9ng\/thu g\u1ecdn chi ti\u1ebft \u0111\u1ed1i v\u1edbi m\u1ed7i t\u00ean mi\u1ec1n.<strong>\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5816\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-79.png\" width=\"600\" height=\"236\" title=\"excel-dialog-box-launcher-1-79\"><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Highlight URL th\u1ee9 hai v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c URL trong c\u00f9ng m\u1ed9t t\u00ean mi\u1ec1n<\/strong><\/p>\n<p style=\"text-align: justify\">Trong ph\u1ea7n tr\u01b0\u1edbc, ch\u00fang t\u00f4i \u0111\u00e3 ch\u1ec9 ra c\u00e1ch nh\u00f3m URL theo t\u00ean mi\u1ec1n. Thay v\u00ec nh\u00f3m, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng t\u00f4 m\u00e0u c\u00e1c m\u1ee5c tr\u00f9ng l\u1eb7p c\u1ee7a c\u00f9ng m\u1ed9t t\u00ean mi\u1ec1n trong URL.<\/p>\n<p style=\"text-align: justify\">Chi ti\u1ebft h\u01a1n, m\u1eddi c\u00e1c b\u1ea1n xem b\u00e0i <strong><em>C\u00e1ch highlight t\u1ef1 \u0111\u1ed9ng nh\u1eefng m\u1ee5c trung l\u1eb7p trong Excel<\/em><\/strong><strong><em>\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5817\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-80.png\" width=\"600\" height=\"237\" title=\"excel-dialog-box-launcher-1-80\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>So s\u00e1nh URL t\u1eeb c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u kh\u00e1c nhau b\u1eb1ng c\u1ed9t domain<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>\u00a0<\/strong>B\u1ea1n c\u00f3 th\u1ec3 c\u00f3 m\u1ed9t ho\u1eb7c nhi\u1ec1u trang t\u00ednh Excel ri\u00eang bi\u1ec7t, n\u01a1i b\u1ea1n l\u01b0u gi\u1eef m\u1ed9t danh s\u00e1ch c\u00e1c t\u00ean mi\u1ec1n. C\u00e1c b\u1ea3ng bi\u1ec3u c\u00f3 th\u1ec3 ch\u1ee9a c\u00e1c li\u00ean k\u1ebft m\u00e0 b\u1ea1n kh\u00f4ng mu\u1ed1n s\u1eed d\u1ee5ng, nh\u01b0 li\u00ean k\u1ebft r\u00e1c ho\u1eb7c nh\u1eefng t\u00ean mi\u1ec1n \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng. Ho\u1eb7c b\u1ea1n mu\u1ed1n gi\u1eef danh s\u00e1ch ch\u1ec9 g\u1ed3m c\u00e1c li\u00ean k\u1ebft h\u1eefu \u00edch v\u00e0 x\u00f3a to\u00e0n b\u1ed9 nh\u1eefng li\u00ean k\u1ebft c\u00f2n kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: nhi\u1ec7m v\u1ee5 c\u1ee7a t\u00f4i l\u00e0 t\u00f4 m\u00e0u \u0111\u1ecf t\u1ea5t c\u1ea3 c\u00e1c t\u00ean mi\u1ec1n trong danh s\u00e1ch \u0111en c\u1ee7a m\u00ecnh:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5818\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-81.png\" width=\"600\" height=\"221\" title=\"excel-dialog-box-launcher-1-81\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 kh\u00f4ng l\u00e3ng ph\u00ed th\u1eddi gian, b\u1ea1n c\u00f3 th\u1ec3 so s\u00e1nh b\u1ea3ng bi\u1ec3u c\u1ee7a m\u00ecnh v\u1edbi danh s\u00e1ch nh\u1eefng li\u00ean k\u1ebft kh\u00f4ng c\u1ea7n thi\u1ebft. Chi ti\u1ebft h\u01a1n, m\u1eddi c\u00e1c b\u1ea1n \u0111\u1ecdc b\u00e0i vi\u1ebft <strong><em>C\u00e1ch so s\u00e1nh hai c\u1ed9t trong Excel v\u00e0 x\u00f3a nh\u1eefng c\u1ed9t tr\u00f9ng l\u1eb7p (b\u00f4i \u0111\u1eadm, t\u00f4 m\u00e0u, x\u00f3a b\u1ecf)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Ngu\u1ed3n: Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-304.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7546,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7545","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7545","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=7545"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7545\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7546"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}