{"id":3058,"date":"2024-12-02T09:56:06","date_gmt":"2024-12-02T09:56:06","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-tach-roi-tung-ky-mot-tu-ra-khoi-chuoi\/"},"modified":"2024-12-02T09:56:06","modified_gmt":"2024-12-02T09:56:06","slug":"huong-dan-cach-tach-roi-tung-ky-mot-tu-ra-khoi-chuoi","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-tach-roi-tung-ky-mot-tu-ra-khoi-chuoi\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch r\u1eddi t\u1eebng k\u00fd m\u1ed9t t\u1ef1 ra kh\u1ecfi chu\u1ed7i"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y,<strong> <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online <\/a><\/strong>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 c\u00f3 th\u1ec3 x\u1eed l\u00fd chu\u1ed7i trong Excel : <a href=\"http:\/\/blog.ezworkapp.com\/tach-roi-ky-tu-ra-khoi-chuoi-don-gian.html\"><strong>t\u00e1ch 1 chu\u1ed7i ra t\u1eebng k\u00fd t\u1ef1<\/strong> <\/a>m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3, x\u1eed l\u00fd d\u1eef li\u1ec7u v\u1edbi chu\u1ed7i m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 h\u01a1n.<\/em><\/p>\n<p style=\"text-align: justify\">B\u00e0i to\u00e1n \u0111\u1eb7t ra \u1edf \u0111\u00e2y l\u00e0 ta s\u1ebd t\u00e1ch t\u1eeb 1 chu\u1ed7i b\u1ea5t k\u1ef3 ra t\u1eebng k\u00fd t\u1ef1 \u0111\u01a1n l\u1ebb b\u1eb1ng vi\u1ec7c v\u1eadn d\u1ee5ng h\u00e0m 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-674d84351908b\" 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\/tach-roi-ky-tu-ra-khoi-chuoi-don-gian.html#Ham_Excel_su_dung\" title=\"H\u00e0m Excel s\u1eed d\u1ee5ng\">H\u00e0m Excel s\u1eed d\u1ee5ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tach-roi-ky-tu-ra-khoi-chuoi-don-gian.html#Cach_thuc_hien\" title=\"C\u00e1ch th\u1ef1c hi\u1ec7n\">C\u00e1ch th\u1ef1c hi\u1ec7n<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/tach-roi-ky-tu-ra-khoi-chuoi-don-gian.html#Truong_hop_tach_ra_tren_mot_hang\" title=\"Tr\u01b0\u1eddng h\u1ee3p t\u00e1ch ra tr\u00ean m\u1ed9t h\u00e0ng\">Tr\u01b0\u1eddng h\u1ee3p t\u00e1ch ra tr\u00ean m\u1ed9t h\u00e0ng<\/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\/tach-roi-ky-tu-ra-khoi-chuoi-don-gian.html#Truong_hop_tach_ra_tren_mot_cot\" title=\"Tr\u01b0\u1eddng h\u1ee3p t\u00e1ch ra tr\u00ean m\u1ed9t c\u1ed9t\">Tr\u01b0\u1eddng h\u1ee3p t\u00e1ch ra tr\u00ean m\u1ed9t c\u1ed9t<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/tach-roi-ky-tu-ra-khoi-chuoi-don-gian.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_Excel_su_dung\"><\/span>H\u00e0m Excel s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m MID \u0111\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y, n\u1ebfu nh\u01b0 b\u1ea1n hay l\u00e0m vi\u1ec7c v\u1edbi Excel th\u00ec ch\u1eafc h\u1eb3n kh\u00f4ng c\u00f2n xa l\u1ea1\u00a0 g\u00ec v\u1edbi h\u00e0m x\u1eed l\u00fd chu\u1ed7i trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn n\u00e0y<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-mid-va-cach-su-dung-ham-mid-trong-excel.html\"><em><strong>H\u00e0m MID v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m mid trong Excel<\/strong><\/em><\/a><\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean,\u00a0ta s\u1ebd c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m MID n\u00e0y theo ki\u1ec3u m\u1ea3ng, trong ph\u1ea7n c\u00e1ch th\u1ef1c hi\u1ec7n s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n \u0111i\u1ec1u \u0111\u00f3.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_thuc_hien\"><\/span>C\u00e1ch th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u1ede \u0111\u00e2y m\u00ecnh c\u00f3 v\u00ed d\u1ee5 nh\u01b0 sau: Ta c\u00f3 m\u1ed9t chu\u1ed7i \u201cH\u1ecdc Excel Online\u201d trong \u00f4 A2, v\u00e0 \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i n\u00e0y l\u00e0 16 k\u00fd t\u1ef1 (v\u1edbi h\u00e0m LEN ta s\u1ebd d\u1ec5 d\u00e0ng bi\u1ebft \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3)<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html\"><em><strong>C\u00e1ch d\u00f9ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4<\/strong><\/em><\/a><\/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-97.gif\" title=\"vba101_92019-nho-97\"><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-231.gif\" title=\"ex101_92019-nho-231\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID v\u1edbi m\u1ea3ng ta s\u1ebd l\u00e0m \u0111\u00f3 kh\u00e1 \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Truong_hop_tach_ra_tren_mot_hang\"><\/span>Tr\u01b0\u1eddng h\u1ee3p t\u00e1ch ra tr\u00ean m\u1ed9t h\u00e0ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n t\u00e1ch chu\u1ed7i \u0111\u00f3 ra th\u00e0nh h\u00e0ng ta s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c cho v\u00f9ng t\u1eeb B5:Q5 nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=MID(A2,B4:Q4,1)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30970 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-7-3.png\" alt=\"xu-ly-chuoi-trong-excel-1\" width=\"1333\" height=\"367\" title=\"1-7-3\"><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">B\u1ea1n s\u1ebd th\u1ef1c hi\u1ec7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1eeb 1 t\u1edbi b\u1eb1ng \u0111\u00fang chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i m\u00e0 b\u1ea1n mu\u1ed1n t\u00e1ch (\u1edf \u0111\u00e2y chu\u1ed7i c\u1ee7a m\u00ecnh c\u00f3 \u0111\u1ed9 d\u00e0i 16 k\u00fd t\u1ef1 n\u00ean m\u00ecnh s\u1ebd \u0111\u00e1nh s\u1ed1 th\u1ee9\u00a0 t\u1ef1 t\u1eeb 1 -&gt; 16)<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-mid-va-cach-su-dung-ham-mid-trong-excel.html\"><em><strong>H\u00e0m MID v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID trong excel<\/strong><\/em><\/a><\/p>\n<p style=\"text-align: justify\">Ti\u1ebfp theo, b\u1ea1n ch\u1ecdn v\u00f9ng v\u00e0 v\u00f9ng n\u00e0y c\u0169ng \u0111\u00fang b\u1eb1ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i mu\u1ed1n t\u00e1ch nh\u00e9<\/p>\n<p style=\"text-align: justify\">G\u00f5 c\u00f4ng th\u1ee9c nh\u01b0 h\u00ecnh v\u00e0 b\u1ea1n k\u1ebft th\u00fac b\u1eb1ng t\u1ed5 h\u1ee3p ph\u00edm <strong>Ctrl + Shift + Enter<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c n\u00e0y l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng. Tuy nhi\u00ean, n\u1ebfu b\u1ea1n \u0111ang d\u00f9ng Excel 365 hay Excel 2019 th\u00ec b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 c\u1ea7n Enter th\u00f4i.<\/p>\n<p style=\"padding-left: 30px;text-align: justify\">Tham kh\u1ea3o: <em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html\">C\u00e1c h\u00e0m, c\u00f4ng th\u1ee9c v\u00e0 nh\u1eefng h\u1eb1ng s\u1ed1 m\u1ea3ng trong excel, v\u00ed d\u1ee5 v\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady th\u00f4i l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 k\u1ebft qu\u1ea3 r\u1ed3i, c\u00e1c k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c t\u00e1ch ra kh\u1ecfi chu\u1ed7i tr\u00ean 1 h\u00e0ng cho b\u1ea1n. Th\u1ebf n\u1ebfu b\u1ea1n mu\u1ed1n\u00a0 t\u00e1ch chu\u1ed7i \u0111\u00f3 theo c\u1ed9t th\u00ec sao???<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Truong_hop_tach_ra_tren_mot_cot\"><\/span>Tr\u01b0\u1eddng h\u1ee3p t\u00e1ch ra tr\u00ean m\u1ed9t c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u01a1n gi\u1ea3n l\u00e0 b\u1ea1n ch\u1ec9 c\u1ea7n l\u1ed3ng th\u00eam h\u00e0m\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-transpose-chuyen-doi-hang-thanh-cot-cot-thanh-hang-trong-excel.html\">TRANSPOSE <\/a>ngo\u00e0i h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/ham-mid-va-cach-su-dung-ham-mid-trong-excel.html\">MID <\/a>\u0111\u00f3 th\u00f4i, v\u00e0 thay v\u00ec ch\u1ecdn 1 v\u00f9ng tr\u00ean m\u1ed9t h\u00e0ng nh\u01b0 tr\u01b0\u1eddng h\u1ee3p t\u00e1ch ra tr\u00ean m\u1ed9t h\u00e0ng th\u00ec gi\u1edd b\u1ea1n s\u1ebd ch\u1ecdn 1 v\u00f9ng tr\u00ean 1 c\u1ed9t \u0111\u00fang b\u1eb1ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i m\u00e0 b\u1ea1n mu\u1ed1n t\u00e1ch.<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-transpose-chuyen-doi-hang-thanh-cot-cot-thanh-hang-trong-excel.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m TRANSPOSE chuy\u1ec3n \u0111\u1ed5i h\u00e0ng th\u00e0nh c\u1ed9t, c\u1ed9t th\u00e0nh h\u00e0ng trong excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Qu\u00e9t ch\u1ecdn v\u00f9ng, g\u00f5 h\u00e0m, Ctrl + Shift + Enter v\u00e0 Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 cho b\u1ea1n nh\u01b0 sau\u00a0<em>(Excel th\u1eadt l\u00e0 vi di\u1ec7u ph\u1ea3i kh\u00f4ng n\u00e0o )<\/em><\/p>\n<blockquote>\n<p style=\"text-align: justify\"><strong>=TRANSPOSE(MID(A2,B4:Q4,1))<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30971 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-7-1024x720-1.png\" alt=\"xu-ly-chuoi-trong-excel-2\" width=\"1024\" height=\"720\" title=\"2-7-1024x720-1\"><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>H\u1ecdc Excel Online<\/strong> hy v\u1ecdng b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 c\u00f3 th\u1ec3 x\u1eed l\u00fd chu\u1ed7i trong Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3<\/p>\n<blockquote>\n<p><em>\u0110\u00f3 ch\u1ec9 l\u00e0 m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n c\u1ea7n bi\u1ebft \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra \u0111\u01b0\u1ee3c s\u1ef1 linh ho\u1ea1t trong vi\u1ec7c k\u1ebft h\u1ee3p c\u00e1c h\u00e0m Excel. V\u1edbi s\u1ef1 ph\u00e1t tri\u1ec3n c\u1ee7a c\u00f4ng ngh\u1ec7 nh\u01b0 hi\u1ec7n nay, v\u1ea5n \u0111\u1ec1 c\u1ea7n \u0111\u1ed1i m\u1eb7t v\u1edbi x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 linh ho\u1ea1t \u0111\u00f2i h\u1ecfi nh\u1eefng k\u1ef9 n\u0103ng, ki\u1ebfn th\u1ee9c nh\u1ea5t \u0111\u1ecbnh. Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 gi\u00fap b\u1ea1n x\u1eed l\u00fd, th\u1ed1ng k\u00ea d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. Tham kh\u1ea3o <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-tu-co-ban-toi-nang-cao-danh-cho-dan-van-phong-2010-20132016\">kho\u00e1 h\u1ecdc Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn chuy\u00ean gia<\/a> d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong><\/em><\/p>\n<\/blockquote>\n<p><span style=\"font-size: 14pt\">C\u00e1c b\u00e0i vi\u1ebft kh\u00e1c li\u00ean quan<\/span><\/p>\n<hr>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-mid-va-cach-su-dung-ham-mid-trong-excel.html\">H\u00e0m MID v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m mid trong Excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html\">C\u00e1ch d\u00f9ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/substitute-va-40-ten-cuop.html\">Substitute v\u00e0 40 t\u00ean c\u01b0\u1edbp<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-replace-va-substitute-trong-excel-cong-thuc-vi-du.html\">S\u1eed d\u1ee5ng h\u00e0m replace v\u00e0 substitute trong excel \u2013 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html\">C\u00e1c h\u00e0m, c\u00f4ng th\u1ee9c v\u00e0 nh\u1eefng h\u1eb1ng s\u1ed1 m\u1ea3ng trong excel, v\u00ed d\u1ee5 v\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-transpose-chuyen-doi-hang-thanh-cot-cot-thanh-hang-trong-excel.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m TRANSPOSE chuy\u1ec3n \u0111\u1ed5i h\u00e0ng th\u00e0nh c\u1ed9t, c\u1ed9t th\u00e0nh h\u00e0ng trong excel<\/a><\/strong><\/em><\/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-97.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3059,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3058","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\/3058","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=3058"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3058\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3059"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3058"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3058"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}