{"id":2314,"date":"2024-12-02T07:25:56","date_gmt":"2024-12-02T07:25:56","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-gop-nhieu-dong-thanh-mot-dong-trong-mot-o-tinh-excel\/"},"modified":"2024-12-02T07:25:56","modified_gmt":"2024-12-02T07:25:56","slug":"huong-dan-cach-gop-nhieu-dong-thanh-mot-dong-trong-mot-o-tinh-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-gop-nhieu-dong-thanh-mot-dong-trong-mot-o-tinh-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch g\u1ed9p nhi\u1ec1u d\u00f2ng th\u00e0nh m\u1ed9t d\u00f2ng trong m\u1ed9t \u00f4 t\u00ednh Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>C\u00f3 nhi\u1ec1u l\u00fd do \u0111\u1ec3 c\u00e1c n\u1ed9i dung \u0111\u01b0\u1ee3c t\u1ea1o th\u00e0nh c\u00e1c d\u00f2ng\u00a0trong m\u1ed9t \u00f4 t\u00ednh\u00a0c\u1ee7a b\u1ea1n. Ng\u1eaft d\u00f2ng th\u01b0\u1eddng x\u1ea3y ra khi b\u1ea1n sao ch\u00e9p \u0111o\u1ea1n v\u0103n b\u1ea3n t\u1eeb m\u1ed9t trang web, m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u00e3 ch\u1ee9a s\u1eb5n ng\u1eaft d\u00f2ng ho\u1eb7c do b\u1ea1n nh\u1ea5n <strong>Alt + Enter <\/strong>v\u00e0 c\u00e1c c\u00e1ch sau \u0111\u00e2y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u00fap b\u1ea1n lo\u1ea1i b\u1ecf \u0111c \u0111i\u1ec1u \u0111\u00f3.<\/em><\/p>\n<p>\u00a0<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/removed-line-breaks-excel.png\" alt=\"3 ways to remove carriage returns (line breaks) from your text in Excel\" title=\"removed-line-breaks-excel\"><\/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-674d6103aca89\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-gop-nhieu-dong-thanh-mot-dong-trong-mot-o-tinh-excel.html#Gop_nhieu_dong_thanh_mot_dong_theo_cach_thu_cong\" title=\"G\u1ed9p nhi\u1ec1u d\u00f2ng th\u00e0nh m\u1ed9t d\u00f2ng theo c\u00e1ch th\u1ee7 c\u00f4ng:\">G\u1ed9p nhi\u1ec1u d\u00f2ng th\u00e0nh m\u1ed9t d\u00f2ng theo c\u00e1ch th\u1ee7 c\u00f4ng:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-gop-nhieu-dong-thanh-mot-dong-trong-mot-o-tinh-excel.html#Gop_nhieu_dong_thanh_mot_dong_bang_Find_Replace\" title=\"G\u1ed9p nhi\u1ec1u d\u00f2ng th\u00e0nh m\u1ed9t\u00a0d\u00f2ng b\u1eb1ng Find &amp; Replace:\">G\u1ed9p nhi\u1ec1u d\u00f2ng th\u00e0nh m\u1ed9t\u00a0d\u00f2ng b\u1eb1ng Find &amp; Replace:<\/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\/huong-dan-cach-gop-nhieu-dong-thanh-mot-dong-trong-mot-o-tinh-excel.html#Gop_nhieu_dong_thanh_1_dong_bang_cong_thuc_Excel\" title=\"G\u1ed9p nhi\u1ec1u d\u00f2ng th\u00e0nh 1 d\u00f2ng\u00a0b\u1eb1ng c\u00f4ng th\u1ee9c Excel:\">G\u1ed9p nhi\u1ec1u d\u00f2ng th\u00e0nh 1 d\u00f2ng\u00a0b\u1eb1ng c\u00f4ng th\u1ee9c Excel:<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-gop-nhieu-dong-thanh-mot-dong-trong-mot-o-tinh-excel.html#Dung_VBA_macro_de_gop_nhieu_dong_thanh_1_dong_trong_1_o_tinh\" title=\"D\u00f9ng VBA macro \u0111\u1ec3\u00a0g\u1ed9p nhi\u1ec1u d\u00f2ng th\u00e0nh 1 d\u00f2ng trong 1 \u00f4 t\u00ednh:\">D\u00f9ng VBA macro \u0111\u1ec3\u00a0g\u1ed9p nhi\u1ec1u d\u00f2ng th\u00e0nh 1 d\u00f2ng trong 1 \u00f4 t\u00ednh:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Gop_nhieu_dong_thanh_mot_dong_theo_cach_thu_cong\"><\/span><strong>G\u1ed9p nhi\u1ec1u d\u00f2ng th\u00e0nh m\u1ed9t d\u00f2ng theo c\u00e1ch th\u1ee7 c\u00f4ng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong><em>\u01afu \u0111i\u1ec3m:<\/em><\/strong> C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 lo\u1ea1i b\u1ecf ng\u1eaft d\u00f2ng.<\/p>\n<p><strong><em>Nh\u01b0\u1ee3c \u0111i\u1ec3m:<\/em><\/strong> kh\u00f4ng c\u00f3 t\u00ednh n\u0103ng n\u00e0o kh\u00e1c.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Gop_nhieu_dong_thanh_mot_dong_bang_Find_Replace\"><\/span>G\u1ed9p nhi\u1ec1u d\u00f2ng th\u00e0nh m\u1ed9t\u00a0d\u00f2ng b\u1eb1ng <a href=\"http:\/\/blog.ezworkapp.com\/17-%e2%97%8f-cach-su-dung-ham-find-va-replace-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong><em>Find &amp; Replace<\/em><\/strong><\/a>:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>Ch\u1ecdn t\u1ea5t c\u1ea3 \u00f4 t\u00ednh b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf ho\u1eb7c thay th\u1ebf ng\u1eaft d\u00f2ng.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-all-cells.png\" alt=\"Select all cells where you want to remove or replace carriage returns.\" title=\"select-all-cells\"><\/p>\n<ol start=\"2\">\n<li>Nh\u1ea5n <strong><em>Ctrl + H<\/em><\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i.<\/li>\n<li>Trong \u00f4 <strong><em>Find What<\/em><\/strong>, nh\u1ea5n <strong><em>Ctrl + J<\/em><\/strong>. N\u00f3 tr\u00f4ng nh\u01b0 \u0111\u01b0\u1ee3c b\u1ecf tr\u1ed1ng, tuy nhi\u00ean, b\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t d\u1ea5u ch\u1ea5m nh\u1ecf.<\/li>\n<li>Trong \u00f4 <strong><em>Replace With<\/em><\/strong>, g\u00f5 v\u00e0o b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o \u0111\u1ec3 thay th\u1ebf d\u1ea5u ng\u1eaft d\u00f2ng. Th\u00f4ng th\u01b0\u1eddng, n\u00f3 l\u00e0 d\u1ea5u c\u00e1ch \u0111\u1ec3 tr\u00e1nh hai t\u1eeb d\u00ednh li\u1ec1n nhau. N\u1ebfu b\u1ea1n c\u1ea7n x\u00f3a ng\u1eaft d\u00f2ng, h\u00e3y \u0111\u1ec3 tr\u1ed1ng \u00f4 <strong><em>Replace With<\/em><\/strong>.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/replace-carriage-return-with-space.png\" alt=\"Eliminating line breaks using Excel Find and Replace\" title=\"replace-carriage-return-with-space\"><\/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-75.gif\" title=\"vba101_92019-nho-75\"><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-178.gif\" title=\"ex101_92019-nho-178\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol start=\"5\">\n<li>Nh\u1ea5n Replace All v\u00e0 t\u1eadn h\u01b0\u1edfng th\u00e0nh qu\u1ea3!<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/line-breaks-replaced.png\" title=\"line-breaks-replaced\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Gop_nhieu_dong_thanh_1_dong_bang_cong_thuc_Excel\"><\/span><strong>G\u1ed9p nhi\u1ec1u d\u00f2ng th\u00e0nh 1 d\u00f2ng\u00a0b\u1eb1ng c\u00f4ng th\u1ee9c Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong><em>\u01afu \u0111i\u1ec3m:<\/em><\/strong> B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t chu\u1ed7i c\u00f4ng th\u1ee9c \u0111\u1ed1i v\u1edbi \u00f4 t\u00ednh ph\u1ee9c t\u1ea1p. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 lo\u1ea1i b\u1ecf ng\u1eaft d\u00f2ng ho\u1eb7c kho\u1ea3ng tr\u1eafng \u0111\u1ea7u d\u00f2ng v\u00e0 cu\u1ed1i d\u00f2ng ho\u1eb7c gi\u1eefa c\u00e1c t\u1eeb.<\/p>\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 mu\u1ed1n x\u00f3a ng\u1eaft d\u00f2ng \u0111\u1ec3 s\u1eed d\u1ee5ng v\u0103n b\u1ea3n c\u1ee7a b\u1ea1n l\u00e0m tham s\u1ed1 m\u00e0 kh\u00f4ng thay \u0111\u1ed5i \u00f4 g\u1ed1c. V\u00ed d\u1ee5, b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 nh\u01b0 m\u1ed9t tham s\u1ed1 c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m <strong><em>LOOKUP<\/em><\/strong><\/a><\/p>\n<p><strong><em>Nh\u01b0\u1ee3c \u0111i\u1ec3m: <\/em><\/strong>B\u1ea1n c\u1ea7n t\u1ea1o th\u00eam c\u1ed9t ph\u1ee5 cho d\u1eef li\u1ec7u c\u0169a m\u00ecnh v\u00e0 c\u00f3 th\u1ec3 \u0111\u1eb7t t\u00ean n\u00f3 l\u00e0 \u201c1 line\u201d<\/p>\n<ol>\n<li>Th\u00eam c\u1ed9t ph\u1ee5 v\u00e0o d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n. \u0110\u1eb7t t\u00ean cho n\u00f3 l\u00e0 \u201c1 line\u201d<\/li>\n<li>Trong \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t ph\u1ee5 (C2), g\u00f5 v\u00e0o c\u00f4ng th\u1ee9c lo\u1ea1i b\u1ecf ho\u1eb7c thay th\u1ebf ng\u1eaft d\u00f2ng. \u0110\u00e2y l\u00e0 c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c nhau cho nh\u1eefng tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nhau:<\/li>\n<\/ol>\n<ul>\n<li>\u00a0X\u1eed l\u00fd ng\u1eaft d\u00f2ng trong c\u1ea3 Windows v\u00e0 UNIX.<\/li>\n<\/ul>\n<p><strong><em>=SUBSTITUTE(SUBSTITUTE(B2,CHAR(13),\u201d\u201d),CHAR(10),\u201d\u201d)<\/em><\/strong><\/p>\n<ul>\n<li>C\u00f4ng th\u1ee9c ti\u1ebfp theo s\u1ebd gi\u00fap b\u1ea1n thay th\u1ebf ng\u1eaft d\u00f2ng th\u00e0nh k\u00fd t\u1ef1 kh\u00e1c (d\u1ea5u ph\u1ea9y ho\u1eb7c ch\u1ea5m).<\/li>\n<\/ul>\n<p><strong><em>=TRIM(SUBSTITUTE(SUBSTITUTE(B2,CHAR(13),\u201d\u201d),CHAR(10),\u201d, \u201c)<\/em><\/strong><\/p>\n<ul>\n<li>N\u1ebfu b\u1ea1n mu\u1ed1n b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c k\u00ed t\u1ef1 kh\u00f4ng in ra \u0111\u01b0\u1ee3c, bao g\u1ed3m ng\u1eaft d\u00f2ng:<\/li>\n<\/ul>\n<p><strong>=CLEAN(B2)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5696\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-49.png\" width=\"600\" height=\"206\" title=\"excel-dialog-box-launcher-1-49\"><\/p>\n<ol start=\"3\">\n<li>Sao ch\u00e9p c\u00f4ng th\u1ee9c tr\u00ean c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t.<\/li>\n<li>T\u00f9y l\u1ef1a ch\u1ecdn, b\u1ea1n c\u00f3 th\u1ec3 thay th\u1ebf c\u1ed9t ban \u0111\u1ea7u b\u1eb1ng c\u1ed9t \u0111\u00e3 b\u1ecf ng\u1eaft d\u00f2ng:<\/li>\n<\/ol>\n<ul>\n<li>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong c\u1ed9t C v\u00e0 nh\u1ea5n <strong>Ctrl + C<\/strong> \u0111\u1ec3 sao ch\u00e9p d\u1eef li\u1ec7u v\u00e0o khay nh\u1edb t\u1ea1m.<\/li>\n<li>B\u00e2y gi\u1edd ch\u1ecdn \u00f4 B2 v\u00e0 nh\u1ea5n ph\u00edm t\u1eaft <strong>Shift + F10<\/strong>. Sau \u0111\u00f3, ch\u1ec9 c\u1ea7n nh\u1ea5n <strong>V<\/strong>.<\/li>\n<li>Lo\u1ea1i b\u1ecf c\u1ed9t tr\u1ee3 gi\u00fap.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Dung_VBA_macro_de_gop_nhieu_dong_thanh_1_dong_trong_1_o_tinh\"><\/span><strong>D\u00f9ng <\/strong><strong>VBA <\/strong><strong>macro<\/strong><strong> \u0111\u1ec3\u00a0<\/strong><strong>g\u1ed9p nhi\u1ec1u d\u00f2ng th\u00e0nh 1 d\u00f2ng trong 1 \u00f4 t\u00ednh:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>\u01afu \u0111i\u1ec3m<\/strong>: \u0110\u01b0\u1ee3c t\u1ea1o ra m\u1ed9t l\u1ea7n, c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u00e1i s\u1eed d\u1ee5ng trong b\u1ea5t k\u1ef3 b\u1ea3ng t\u00ednh n\u00e0o.<\/p>\n<p><strong>Nh\u01b0\u1ee3c \u0111i\u1ec3m:<\/strong> B\u1ea1n c\u1ea7n ph\u1ea3i c\u00f3 ki\u1ebfn \u200b\u200bth\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 VBA.<\/p>\n<p>VBA Macro t\u1eeb v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y s\u1ebd x\u00f3a ng\u1eaft d\u00f2ng trong t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u1ee7a t\u1ec7p \u0111ang m\u1edf (b\u1ea3ng ho\u1ea1t \u0111\u1ed9ng).<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/d8d0f701d60157467da175f96b58893c\">Gist<\/a>.<\/div>\n<p>Xem th\u00eam:<\/p>\n<p><strong>C\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/cach-tong-hop-nhieu-sheet-excel-vao-mot-sheet-tong-hop.html\">t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u sheet trong Excel<\/a> s\u1eed d\u1ee5ng VBA c\u1ef1c k\u1ef3 d\u1ec5 d\u00e0ng<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/find-va-replace-nang-cao-trong-excel-cach-su-dung-hieu-qua-nhat.html\">Find v\u00e0 Replace n\u00e2ng cao trong Excel \u2013 C\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3 nh\u1ea5t<\/a><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc<\/p>\n<p>Xem th\u00eam: <strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html\">C\u00c1CH G\u1ed8P \u00d4 TRONG EXCEL<\/a><\/strong> M\u00c0 KH\u00d4NG M\u1ea4T D\u1eee LI\u1ec6U<\/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-75.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2315,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2314","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\/2314","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=2314"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2314\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2315"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}