{"id":3850,"date":"2024-12-03T09:42:33","date_gmt":"2024-12-03T09:42:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-doi-so-dien-thoai-tu-11-so-thanh-10-so-tren-excel-chi-tiet-nhat\/"},"modified":"2024-12-03T09:42:33","modified_gmt":"2024-12-03T09:42:33","slug":"huong-dan-cach-doi-so-dien-thoai-tu-11-so-thanh-10-so-tren-excel-chi-tiet-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-doi-so-dien-thoai-tu-11-so-thanh-10-so-tren-excel-chi-tiet-nhat\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ed5i s\u1ed1 \u0111i\u1ec7n tho\u1ea1i t\u1eeb 11 s\u1ed1 th\u00e0nh 10 s\u1ed1 tr\u00ean Excel chi ti\u1ebft nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>T\u1eeb ng\u00e0y\u00a015\/09\/2018 c\u00e1c nh\u00e0 m\u1ea1ng\u00a0t\u1ea1i Vi\u1ec7t Nam\u00a0\u0111\u1ec1u ph\u1ea3i\u00a0\u0111\u1ed5i c\u00e1c\u00a0\u0111\u1ea7u s\u1ed1\u00a0t\u1eeb 11 s\u1ed1 v\u1ec1 10 s\u1ed1. Vi\u1ec7c n\u00e0y tr\u00ean\u00a0\u0111i\u1ec7n tho\u1ea1i c\u1ee7a b\u1ea1n c\u00f3 r\u1ea5t nhi\u1ec1u ph\u1ea7n m\u1ec1m c\u00f3 th\u1ec3 h\u1ed7 tr\u1ee3\u00a0\u0111\u01b0\u1ee3c. Nh\u01b0ng v\u1edbi nh\u1eefng danh s\u00e1ch\u00a0\u0111i\u1ec7n tho\u1ea1i\u00a0\u0111\u01b0\u1ee3c l\u01b0u tr\u1eef tr\u00ean\u00a0Excel th\u00ec ch\u00fang ta l\u00e0m th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch l\u00e0m nh\u00e9.<\/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-674ed2888a08c\" 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-doi-dien-thoai-tu-11-so-thanh-10-so-tren-excel-chi-tiet-nhat.html#Cach_viet_cong_thuc_tren_Excel_de_chuyen_so_dien_thoai_tu_11_so_ve_10_so\" title=\"C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c tr\u00ean\u00a0Excel\u00a0\u0111\u1ec3 chuy\u1ec3n s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i t\u1eeb 11 s\u1ed1 v\u1ec1 10 s\u1ed1\">C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c tr\u00ean\u00a0Excel\u00a0\u0111\u1ec3 chuy\u1ec3n s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i t\u1eeb 11 s\u1ed1 v\u1ec1 10 s\u1ed1<\/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-doi-dien-thoai-tu-11-so-thanh-10-so-tren-excel-chi-tiet-nhat.html#Xu_ly_du_lieu_trong_Bang_chuyen_doi_dau_so\" title=\"X\u1eed l\u00fd d\u1eef li\u1ec7u trong B\u1ea3ng chuy\u1ec3n\u00a0\u0111\u1ed5i\u00a0\u0111\u1ea7u s\u1ed1\">X\u1eed l\u00fd d\u1eef li\u1ec7u trong B\u1ea3ng chuy\u1ec3n\u00a0\u0111\u1ed5i\u00a0\u0111\u1ea7u s\u1ed1<\/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-doi-dien-thoai-tu-11-so-thanh-10-so-tren-excel-chi-tiet-nhat.html#Xay_dung_cong_thuc_chuyen_dau_so\" title=\"X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c chuy\u1ec3n\u00a0\u0111\u1ea7u s\u1ed1\">X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c chuy\u1ec3n\u00a0\u0111\u1ea7u s\u1ed1<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_viet_cong_thuc_tren_Excel_de_chuyen_so_dien_thoai_tu_11_so_ve_10_so\"><\/span>C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c tr\u00ean\u00a0Excel\u00a0\u0111\u1ec3 chuy\u1ec3n s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i t\u1eeb 11 s\u1ed1 v\u1ec1 10 s\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 b\u1ea3ng danh s\u00e1ch s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i v\u00e0 b\u1ea3ng\u00a0\u0111\u1ea7u s\u1ed1\u00a0chuy\u1ec3n\u00a0\u0111\u1ed5i nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23089\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-so-dt-bang-data.png\" width=\"860\" height=\"536\" title=\"doi-so-dt-bang-data\"><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu\u00a0Excel c\u1ee7a b\u00e0i vi\u1ebft t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2P53V0c\">http:\/\/bit.ly\/2P53V0c<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xu_ly_du_lieu_trong_Bang_chuyen_doi_dau_so\"><\/span>X\u1eed l\u00fd d\u1eef li\u1ec7u trong B\u1ea3ng chuy\u1ec3n\u00a0\u0111\u1ed5i\u00a0\u0111\u1ea7u s\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i l\u00e0 c\u00f3 s\u1ed1 0\u00a0\u1edf k\u00fd t\u1ef1\u00a0\u0111\u1ea7u ti\u00ean. Do\u00a0\u0111\u00f3 th\u00f4ng th\u01b0\u1eddng s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i\u00a0\u1edf d\u1ea1ng <strong>Text<\/strong> ch\u1ee9 kh\u00f4ng ph\u1ea3i d\u1ea1ng <strong>S\u1ed1<\/strong> (Number).<\/p>\n<p>Trong b\u1ea3ng chuy\u1ec3n\u00a0\u0111\u1ed5i\u00a0\u0111\u1ea7u s\u1ed1 E1:G22 ch\u00fang ta th\u1ea5y c\u1ed9t\u00a0<strong>\u0110\u1ea7u s\u1ed1 c\u0169<\/strong> v\u00e0 <strong>Chuy\u1ec3n\u00a0\u0111\u1ed5i<\/strong> ch\u1ee9a d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 v\u00e0 kh\u00f4ng c\u00f3 s\u1ed1 0. Do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 th\u00eam s\u1ed1\u00a00 v\u00e0o ph\u00eda tr\u01b0\u1edbc c\u00e1c con s\u1ed1 n\u00e0y nh\u01b0 sau:<\/p>\n<p>T\u1ea1i \u00f4\u00a0I1 nh\u1eadp s\u1ed1 0<\/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-304.gif\" title=\"ex101_92019-nho-304\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>T\u1ea1i\u00a0\u00f4 I2 nh\u1eadp c\u00f4ng th\u1ee9c =$I$1&amp;F2<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23090\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/them-so-0-truoc-cac-dau-so.png\" width=\"1049\" height=\"536\" title=\"them-so-0-truoc-cac-dau-so\"><\/p>\n<p>L\u01b0u\u00a0\u00fd: C\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u00f4 I1\u00a0\u0111\u1ec3 kh\u00f4ng thay\u00a0\u0111\u1ed5i gi\u00e1 tr\u1ecb n\u00e0y khi sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c d\u00f2ng kh\u00e1c, c\u1ed9t kh\u00e1c.<\/p>\n<p>Ti\u1ebfp theo ch\u00fang ta k\u00e9o c\u00f4ng th\u1ee9c sao ch\u00e9p xu\u1ed1ng d\u01b0\u1edbi (fillDown) v\u00e0 sao ch\u00e9p sang ph\u1ea3i (fillRight)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23091\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fill-cong-thuc-xu-ly-dau-so.png\" width=\"624\" height=\"538\" title=\"fill-cong-thuc-xu-ly-dau-so\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y\u00a0\u1edf v\u00f9ng I2:J22 c\u00e1c s\u1ed1\u00a0\u0111\u1ec1u c\u00f3 k\u00e8m theo s\u1ed1 0\u00a0\u1edf tr\u01b0\u1edbc.<\/p>\n<p>Copy k\u1ebft qu\u1ea3\u00a0\u1edf I2:J22 v\u00e0 d\u00e1n tr\u1edf l\u1ea1i v\u00e0o v\u00f9ng F2:G22, nh\u01b0ng ch\u1ec9 d\u00e1n ph\u1ea7n gi\u00e1 tr\u1ecb (Paste Special \/ Paste Value)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23092\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dan-gia-tri-co-so-0-phia-truoc.png\" width=\"361\" height=\"214\" title=\"dan-gia-tri-co-so-0-phia-truoc\"><\/p>\n<p>Sau khi xong b\u01b0\u1edbc n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 x\u00f3a d\u1eef li\u1ec7u\u00a0\u1edf c\u1ed9t I v\u00e0 J\u00a0\u0111\u01b0\u1ee3c r\u1ed3i. Ch\u1ec9 c\u1ea7n thu\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 c\u00e1c\u00a0\u0111\u1ea7u s\u1ed1 c\u00f3 k\u00e8m s\u1ed1\u00a00 ph\u00eda tr\u01b0\u1edbc l\u00e0\u00a0\u0111\u01b0\u1ee3c. Khi\u00a0\u0111\u00f3 d\u1eef li\u1ec7u trong b\u1ea3ng chuy\u1ec3n\u00a0\u0111\u1ed5i\u00a0\u0111\u1ea7u s\u1ed1 tr\u1edf th\u00e0nh d\u1ea1ng Text.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xay_dung_cong_thuc_chuyen_dau_so\"><\/span>X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c chuy\u1ec3n\u00a0\u0111\u1ea7u s\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u01b0\u1edbc h\u1ebft ch\u00fang ta ch\u1ec9 th\u1ef1c hi\u1ec7n chuy\u1ec3n\u00a0\u0111\u1ea7u s\u1ed1 cho c\u00e1c s\u1ed1 c\u00f3 11 ch\u1eef s\u1ed1. V\u00ec v\u1eady t\u1ea1i c\u1ed9t B \u2013 c\u1ed9t S\u1ed1 k\u00fd t\u1ef1 \u2013 ch\u00fang ta d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html\">h\u00e0m LEN<\/a>\u00a0\u0111\u1ec3\u00a0\u0111o\u00a0\u0111\u1ed9 d\u00e0i s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a c\u1ed9t S\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23093\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-do-dai-so-ky-tu-bang-ham-len.png\" width=\"449\" height=\"579\" title=\"dem-do-dai-so-ky-tu-bang-ham-len\"><\/p>\n<p>T\u1ea1i c\u1ed9t C \u2013 S\u1ed1\u00a0\u0110i\u1ec7n tho\u1ea1i m\u1edbi \u2013 ch\u00fang ta s\u1ebd b\u1eaft\u00a0\u0111\u1ea7u th\u1ef1c hi\u1ec7n vi\u1ebft <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html\">h\u00e0m\u00a0IF<\/a>\u00a0\u0111\u1ec3 bi\u1ec7n lu\u1eadn:<\/p>\n<ul>\n<li>logical_test: So s\u00e1nh xem s\u1ed1 k\u00fd t\u1ef1\u00a0\u1edf c\u1ed9t B c\u00f3 l\u1edbn h\u01a1n 10 kh\u00f4ng<\/li>\n<li>value_if_true: N\u1ebfu k\u1ebft qu\u1ea3 l\u00e0\u00a0\u0111\u00fang (c\u00f3 11 s\u1ed1) th\u00ec s\u1ebd s\u1eed d\u1ee5ng h\u00e0m chuy\u1ec3n\u00a0\u0111\u1ed5i\u00a0\u0111\u1ea7u s\u1ed1<\/li>\n<li>value_if_false: N\u1ebfu k\u1ebft qu\u1ea3 l\u00e0 sai (ch\u1ec9 c\u00f3 10 s\u1ed1) th\u00ec s\u1ebd gi\u1eef nguy\u00ean gi\u00e1 tr\u1ecb s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i c\u0169.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady c\u1ea5u tr\u00fac h\u00e0m\u00a0IF t\u1ea1i\u00a0\u00f4 C2 c\u00f3 th\u1ec3 vi\u1ebft l\u00e0:<\/p>\n<p style=\"padding-left: 30px\">=IF(B2&gt;10,\u00a0chuy\u1ec3n\u00a0\u0111\u1ea7u s\u1ed1 c\u1ee7a A2, A2)<\/p>\n<p>V\u1eady <strong>Chuy\u1ec3n\u00a0\u0111\u1ea7u s\u1ed1\u00a0c\u1ee7a A2<\/strong> th\u1ef1c hi\u1ec7n th\u1ebf n\u00e0o?<\/p>\n<p>M\u1ed7i s\u1ed1 \u0111i\u1ec7n tho\u1ea1i 11 s\u1ed1 s\u1ebd g\u1ed3m 2 ph\u1ea7n:<\/p>\n<ul>\n<li>Ph\u1ea7n b\u00ean tr\u00e1i 4 ch\u1eef s\u1ed1: l\u00e0\u00a0\u0111\u1ea7u s\u1ed1 c\u1ea7n chuy\u1ec3n\u00a0\u0111\u1ed5i =&gt; <a href=\"http:\/\/blog.ezworkapp.com\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html\">H\u00e0m LEFT<\/a>, l\u1ea5y 4 ch\u1eef s\u1ed1 =LEFT(A2,4)<\/li>\n<li>Ph\u1ea7n c\u00f2n l\u1ea1i (7 ch\u1eef s\u1ed1): l\u00e0 ph\u1ea7n gi\u1eef nguy\u00ean =&gt; <a href=\"http:\/\/blog.ezworkapp.com\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html\">H\u00e0m RIGHT<\/a>, l\u1ea5y 7 ch\u1eef s\u1ed1 =RIGHT(A2,7)<\/li>\n<\/ul>\n<p>Khi chuy\u1ec3n\u00a0\u0111\u1ed5i, ch\u00fang ta s\u1ebd d\u00f2 t\u00ecm xem k\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c b\u1edfi h\u00e0m LEFT\u00a0\u1edf tr\u00ean l\u00e0 v\u1ecb tr\u00ed n\u00e0o trong B\u1ea3ng chuy\u1ec3n\u00a0\u0111\u1ed5i\u00a0\u0111\u1ea7u s\u1ed1 (F2:G2), d\u00f2 trong c\u1ed9t F. K\u1ebft qu\u1ea3 t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi\u00a0\u0111\u1ea7u s\u1ed1 s\u1ebd chuy\u1ec3n\u00a0\u0111\u1ed5i l\u00e0 c\u1ed9t G (c\u1ed9t th\u1ee9 2 t\u00ednh t\u1eeb c\u1ed9t F) =&gt; S\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html\">h\u00e0m VLOOKUP<\/a>, trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>lookup_value: l\u00e0 gi\u00e1 tr\u1ecb thu\u00a0\u0111\u01b0\u1ee3c b\u1edfi h\u00e0m LEFT, 4 ch\u1eef s\u1ed1<\/li>\n<li>table_array: v\u00f9ng F2:G2, c\u1ed1\u00a0\u0111\u1ecbnh b\u1ea3ng n\u00e0y.<\/li>\n<li>col_index_num: c\u1ed9t th\u1ee9 2<\/li>\n<li>range_lookup: t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c, ch\u1ecdn s\u1ed1 0<\/li>\n<\/ul>\n<p>Ta c\u00f3 =VLOOKUP(LEFT(A2,4),$F$2:$G$2,2,0)<\/p>\n<p>Do\u00a0\u0111\u00f3 c\u00f4ng th\u1ee9c\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 t\u1ea1i\u00a0\u00f4 C2 l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23094\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-chuyen-doi-dau-so.png\" width=\"896\" height=\"580\" title=\"ket-qua-chuyen-doi-dau-so\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh\u00a0\u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c chuy\u1ec3n\u00a0\u0111\u1ed5i\u00a0\u0111\u1ea7u s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i tr\u00ean\u00a0Excel r\u1ed3i. Ngo\u00e0i c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDEX, MATCH\u00a0\u0111\u1ec3 chuy\u1ec3n\u00a0\u0111\u1ed5i\u00a0\u0111\u1ea7u s\u1ed1.<\/p>\n<p>Tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-doi-dien-thoai-tu-11-sang-10-trong-excel.html\">C\u00e1ch \u0111\u1ed5i s\u1ed1 \u0111i\u1ec7n tho\u1ea1i t\u1eeb 11 s\u1ed1 sang 10 s\u1ed1 trong Excel (d\u00f9ng h\u00e0m INDEX+MATCH)<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/4-cach-de-nhap-so-dien-thoai-trong-excel-ma-khong-mat-so-0.html\">4 c\u00e1ch \u0111\u1ec3 nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel m\u00e0 kh\u00f4ng m\u1ea5t s\u1ed1 0<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-giu-va-xoa-0-dau-dong-trong-excel.html\">C\u00e1ch gi\u1eef v\u00e0 x\u00f3a s\u1ed1 0 \u0111\u1ea7u d\u00f2ng trong Excel<\/a><\/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-304.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3851,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3850","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\/3850","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=3850"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3850\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3851"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3850"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3850"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}