{"id":7144,"date":"2024-12-21T16:59:36","date_gmt":"2024-12-21T16:59:36","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-xoa-nhanh-phan-van-ban-truoc-sau-mot-ky-tu-cu-the-trong-excel\/"},"modified":"2024-12-21T16:59:36","modified_gmt":"2024-12-21T16:59:36","slug":"cach-xoa-nhanh-phan-van-ban-truoc-sau-mot-ky-tu-cu-the-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-xoa-nhanh-phan-van-ban-truoc-sau-mot-ky-tu-cu-the-trong-excel\/","title":{"rendered":"C\u00e1ch xo\u00e1 nhanh ph\u1ea7n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau m\u1ed9t k\u00fd t\u1ef1 c\u1ee5 th\u1ec3 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\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-6766f3f806b5b\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-xoa-nhanh-phan-van-ban-truocsau-mot-ky-tu-cu-the-trong-excel.html#Xoa_doan_van_ban_truocsau_mot_ky_tu_bang_Find_Replace\" title=\"X\u00f3a \u0111o\u1ea1n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau m\u1ed9t k\u00fd t\u1ef1 b\u1eb1ng Find &amp; Replace\">X\u00f3a \u0111o\u1ea1n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau m\u1ed9t k\u00fd t\u1ef1 b\u1eb1ng Find &amp; Replace<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-xoa-nhanh-phan-van-ban-truocsau-mot-ky-tu-cu-the-trong-excel.html#Xoa_phan_van_ban_truocsau_ky_tu_bang_cong_thuc\" title=\"X\u00f3a ph\u1ea7n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau k\u00fd t\u1ef1 b\u1eb1ng c\u00f4ng th\u1ee9c\">X\u00f3a ph\u1ea7n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau k\u00fd t\u1ef1 b\u1eb1ng c\u00f4ng th\u1ee9c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-xoa-nhanh-phan-van-ban-truocsau-mot-ky-tu-cu-the-trong-excel.html#Xoa_phan_van_ban_truocsau_ky_tu_bang_VBA\" title=\"X\u00f3a ph\u1ea7n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau k\u00fd t\u1ef1 b\u1eb1ng VBA\">X\u00f3a ph\u1ea7n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau k\u00fd t\u1ef1 b\u1eb1ng VBA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Xoa_doan_van_ban_truocsau_mot_ky_tu_bang_Find_Replace\"><\/span><strong>X\u00f3a \u0111o\u1ea1n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau m\u1ed9t k\u00fd t\u1ef1 b\u1eb1ng Find &amp; Replace<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\"><strong><em>Find &amp; Replace <\/em><\/strong>l\u00e0 m\u1ed9t t\u00ednh n\u0103ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong Excel. B\u1eb1ng c\u00f4ng c\u1ee5 n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a \u0111o\u1ea1n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau m\u1ed9t k\u00fd t\u1ef1 c\u1ee5 th\u1ec3.<\/p>\n<p style=\"text-align: justify\">Nh\u1ea5n <strong><em>Ctrl + F <\/em><\/strong>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong><em>Find &amp; Replace<\/em><\/strong>, nh\u1ea5p v\u00e0o th\u1ebb <strong><em>Replace<\/em><\/strong>, g\u00f5 <strong><em>*, <\/em><\/strong>v\u00e0o h\u1ed9p <strong><em>Find What<\/em><\/strong>, \u0111\u1ec3 tr\u1ed1ng h\u1ed9p <strong><em>Replace with<\/em><\/strong>, sau \u0111\u00f3 nh\u1ea5n <strong><em>Replace All<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-remove-text-15.png\" title=\"doc-remove-text-15\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, b\u1ea1n th\u1ea5y \u0111o\u1ea1n v\u0103n b\u1ea3n \u0111\u1eb1ng tr\u01b0\u1edbc d\u1ea5u ph\u1ea9y \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00f3a.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong><\/p>\n<ol style=\"text-align: justify\">\n<li>N\u1ebfu b\u1ea1n mu\u1ed1n x\u00f3a \u0111o\u1ea1n v\u0103n b\u1ea3n sau d\u1ea5u ph\u1ea9y, h\u00e3y g\u00f5 ,* v\u00e0o \u00f4 <strong><em>Find what<\/em><\/strong>.<\/li>\n<li>B\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i d\u1ea5u ph\u1ea9y th\u00e0nh k\u00fd t\u1ef1 kh\u00e1c.<\/li>\n<li>Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y s\u1ebd x\u00f3a t\u1ea5t c\u1ea3 ph\u1ea7n v\u0103n b\u1ea3n \u0111\u1eb1ng tr\u01b0\u1edbc d\u1ea5u ph\u1ea9y cu\u1ed1i c\u00f9ng trong \u00f4 t\u00ednh \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/li>\n<\/ol>\n<h1 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Xoa_phan_van_ban_truocsau_ky_tu_bang_cong_thuc\"><\/span><strong>X\u00f3a ph\u1ea7n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau k\u00fd t\u1ef1 b\u1eb1ng c\u00f4ng th\u1ee9c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Trong Excel, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng d\u1ea5u ph\u1ea9y \u0111\u1ec3 x\u00f3a ph\u1ea7n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau m\u1ed9t k\u00fd t\u1ef1 c\u1ee5 th\u1ec3 b\u1eb1ng vi\u1ec7c \u00a0s\u1eed d\u00f9ng c\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/ham-left-right-va-cach-su-dung-ham-left-right-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m Left v\u00e0 Right<\/a>\u00a0nh\u01b0 sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng v\u00e0 g\u00f5 c\u00f4ng th\u1ee9c <strong><em>=RIGHT(A1,LEN(A1)-FIND(\u201c,\u201d,A1))<\/em><\/strong>, nh\u1ea5n Enter.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-remove-text-16.png\" title=\"doc-remove-text-16\"><\/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-286.gif\" title=\"vba101_92019-nho-286\"><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-645.gif\" title=\"ex101_92019-nho-645\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c d\u00f2ng tr\u01b0\u1edbc khi t\u1ea5t c\u1ea3 ph\u1ea7n v\u0103n b\u1ea3n tr\u01b0\u1edbc d\u1ea5u ph\u1ea9y \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-remove-text-17.png\" title=\"doc-remove-text-17\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong><\/p>\n<ol style=\"text-align: justify\">\n<li>Lo\u1ea1i b\u1ecf v\u0103n b\u1ea3n sau d\u1ea5u ph\u1ea9y b\u1eb1ng <strong><em>=LEFT(A1,FIND(\u201c,\u201d,A1)-1)<\/em><\/strong><\/li>\n<li>Trong c\u00f4ng th\u1ee9c, A1 l\u00e0 \u00f4 t\u00ednh b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf \u0111o\u1ea1n v\u0103n b\u1ea3n, v\u00e0 \u2018,\u2019 l\u00e0 k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf ph\u1ea7n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau n\u00f3.<\/li>\n<li><strong><em>=RIGHT(A1,LEN(A1)-FIND(\u201c,\u201d,A1))<\/em><\/strong> s\u1ebd lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 v\u0103n b\u1ea3n \u0111\u1eb1ng tr\u01b0\u1edbc d\u1ea5u ph\u1ea9y th\u1ee9 nh\u1ea5t trong \u00f4 A1, trong khi <strong><em>=LEFT(A1,FIND(\u201c,\u201d,A1)-1)<\/em><\/strong> s\u1ebd lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 v\u0103n b\u1ea3n \u0111\u1eb1ng sau d\u1ea5u ph\u1ea9y th\u1ee9 nh\u1ea5t trong \u00f4 A1.<\/li>\n<\/ol>\n<h1 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Xoa_phan_van_ban_truocsau_ky_tu_bang_VBA\"><\/span><strong>X\u00f3a ph\u1ea7n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau k\u00fd t\u1ef1 b\u1eb1ng <a href=\"http:\/\/blog.ezworkapp.com\/bat-dau-voi-lap-trinh-vba-tu-dong-hoa-excel-voi-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener noreferrer\">VBA<\/a><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<ol style=\"text-align: justify\">\n<li style=\"text-align: left\">Nh\u1ea5n <strong><em>Alt + F11 <\/em><\/strong>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i<strong><em> Microsoft Visual Basic for Applications<\/em><\/strong>.<\/li>\n<li style=\"text-align: left\">Trong c\u1eeda s\u1ed5, nh\u1ea5n <strong><em>Insert &gt; Module<\/em><\/strong> \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Module m\u1edbi, sau \u0111\u00f3 sao ch\u00e9p \u0111o\u1ea1n m\u00e3 VBA sau v\u00e0o c\u1eeda s\u1ed5 Module.<\/li>\n<\/ol>\n<div class=\"line number1 index0 alt2\" style=\"text-align: justify\"><code class=\"vb keyword\">Sub<\/code> <code class=\"vb plain\">RemoveAllButLastWord()<\/code><\/div>\n<div class=\"line number2 index1 alt1\" style=\"text-align: justify\"><code class=\"vb comments\">'Updateby20140612<\/code><\/div>\n<div class=\"line number3 index2 alt2\" style=\"text-align: justify\"><code class=\"vb keyword\">Dim<\/code> <code class=\"vb plain\">Rng <\/code><code class=\"vb keyword\">As<\/code> <code class=\"vb plain\">Range<\/code><\/div>\n<div class=\"line number4 index3 alt1\" style=\"text-align: justify\"><code class=\"vb keyword\">Dim<\/code> <code class=\"vb plain\">WorkRng <\/code><code class=\"vb keyword\">As<\/code> <code class=\"vb plain\">Range<\/code><\/div>\n<div class=\"line number5 index4 alt2\" style=\"text-align: justify\"><code class=\"vb keyword\">Dim<\/code> <code class=\"vb plain\">xChar <\/code><code class=\"vb keyword\">As<\/code> <code class=\"vb keyword\">String<\/code><\/div>\n<div class=\"line number6 index5 alt1\" style=\"text-align: justify\"><code class=\"vb keyword\">On<\/code> <code class=\"vb keyword\">Error<\/code> <code class=\"vb keyword\">Resume<\/code> <code class=\"vb keyword\">Next<\/code><\/div>\n<div class=\"line number7 index6 alt2\" style=\"text-align: justify\"><code class=\"vb plain\">xTitleId = <\/code><code class=\"vb string\">\"KutoolsforExcel\"<\/code><\/div>\n<div class=\"line number8 index7 alt1\" style=\"text-align: justify\"><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">WorkRng = Application.Selection<\/code><\/div>\n<div class=\"line number9 index8 alt2\" style=\"text-align: justify\"><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">WorkRng = Application.InputBox(<\/code><code class=\"vb string\">\"Range\"<\/code><code class=\"vb plain\">, xTitleId, WorkRng.Address, Type:=8)<\/code><\/div>\n<div class=\"line number10 index9 alt1\" style=\"text-align: justify\"><code class=\"vb plain\">xChar = Application.InputBox(<\/code><code class=\"vb string\">\"String\"<\/code><code class=\"vb plain\">, xTitleId, <\/code><code class=\"vb string\">\"\"<\/code><code class=\"vb plain\">, Type:=2)<\/code><\/div>\n<div class=\"line number11 index10 alt2\" style=\"text-align: justify\"><code class=\"vb keyword\">For<\/code> <code class=\"vb keyword\">Each<\/code> <code class=\"vb plain\">Rng <\/code><code class=\"vb keyword\">In<\/code> <code class=\"vb plain\">WorkRng<\/code><\/div>\n<div class=\"line number12 index11 alt1\" style=\"text-align: justify\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">xValue = Rng.Value<\/code><\/div>\n<div class=\"line number13 index12 alt2\" style=\"text-align: justify\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Rng.Value = VBA.Right(xValue, VBA.Len(xValue) - VBA.InStrRev(xValue, xChar))<\/code><\/div>\n<div class=\"line number14 index13 alt1\" style=\"text-align: justify\"><code class=\"vb keyword\">Next<\/code><\/div>\n<div class=\"line number15 index14 alt2\" style=\"text-align: justify\"><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">Sub<\/code><\/div>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Nh\u1ea5n n\u00fat <strong><em>Run<\/em><\/strong>. M\u1ed9t h\u1ed9p tho\u1ea1i hi\u1ec7n ra y\u00eau c\u1ea7u b\u1ea1n nh\u1eadp v\u00e0o m\u1ed9t \u00f4 hay v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n x\u00f3a \u0111o\u1ea1n v\u0103n b\u1ea3n tr\u01b0\u1edbc d\u1ea5u ph\u1ea9y, nh\u1ea5n OK.<\/li>\n<\/ol>\n<p style=\"text-align: justify;padding-left: 30px\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-remove-text-18.png\" title=\"doc-remove-text-18\">4. Sau \u0111\u00f3 h\u1ed9p tho\u1ea1i bi\u1ebfn m\u1ea5t, nh\u1eadp k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n x\u00f3a v\u0103n b\u1ea3n d\u1ef1a v\u00e0o n\u00f3, nh\u1ea5n OK.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-remove-text-19.png\" title=\"doc-remove-text-19\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, t\u1ea5t c\u1ea3 v\u0103n b\u1ea3n tr\u01b0\u1edbc d\u1ea5u ph\u1ea9y \u0111\u1ec1u \u0111\u01b0\u1ee3c x\u00f3a ngay l\u1eadp t\u1ee9c.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>VBA ch\u1ec9 x\u00f3a ph\u1ea7n v\u0103n b\u1ea3n tr\u01b0\u1edbc k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng (v\u00ed d\u1ee5 d\u1ea5u ph\u1ea9y) trong \u00f4 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: left\">Excel r\u1ea5t nhi\u1ec1u \u1ee9ng d\u1ee5ng m\u00e0 c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft ph\u1ea3i kh\u00f4ng? Excel c\u00f2n v\u00f4 v\u00e0n t\u00ednh n\u0103ng kh\u00e1c m\u00e0 b\u1ea1n n\u00ean bi\u1ebft \u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 c\u00f4ng vi\u1ec7c kh\u00e1c. N\u1ebfu b\u1ea1n \u0111ang g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c h\u1ecdc Excel, h\u00e3y tham kh\u1ea3o kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2mWmtzP\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. T\u1ea1i kh\u00f3a h\u1ecdc n\u00e0y, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u1ecdc to\u00e0n b\u1ed9 ki\u1ebfn th\u1ee9c v\u1ec1 Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao qua b\u00e0i gi\u1ea3ng c\u1ee7a c\u00e1c chuy\u00ean gia v\u1ec1 Excel m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng. Chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: left\">\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-286.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7145,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7144","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\/7144","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=7144"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7144\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7145"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}