{"id":3423,"date":"2024-12-03T02:25:43","date_gmt":"2024-12-03T02:25:43","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/substitute-va-40-ten-cuop\/"},"modified":"2024-12-03T02:25:43","modified_gmt":"2024-12-03T02:25:43","slug":"substitute-va-40-ten-cuop","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/substitute-va-40-ten-cuop\/","title":{"rendered":"SUBSTITUTE v\u00e0 40 t\u00ean c\u01b0\u1edbp."},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n h\u00e3y th\u1eadt ki\u00ean nh\u1eabn, \u0111\u1ecdc h\u1ebft c\u00e2u chuy\u1ec7n c\u1ed5 t\u00edch ng\u00e0y nay sau \u0111\u00e2y nh\u00e9:<\/p>\n<blockquote>\n<p>Thu\u1edf x\u01b0a, \u1edf v\u01b0\u01a1ng qu\u1ed1c Excel xa x\u00f4i, c\u00f3 hai anh em l\u00e0 <strong>T2Column<\/strong> v\u00e0 <strong>SUBSTITUTE<\/strong>. <strong>T2Column<\/strong>, ng\u01b0\u1eddi anh\u00a0chi\u1ebfm \u0111o\u1ea1t h\u1ebft c\u1ee7a c\u1ea3i t\u00e0i s\u1ea3n do cha m\u1eb9 \u0111\u1ec3 l\u1ea1i, \u0111\u1ed3ng th\u1eddi l\u1ea1i l\u1ea5y \u0111\u01b0\u1ee3c v\u1ee3 gi\u00e0u sang n\u00ean cu\u1ed9c s\u1ed1ng r\u1ea5t d\u01b0 d\u1ea3, r\u1ea5t sung t\u00fac.\u00a0Tr\u00e1i l\u1ea1i ng\u01b0\u1eddi em <strong>SUBSTITUTE\u00a0<\/strong>v\u00ec kh\u00f4ng mu\u1ed1n tranh gi\u00e0nh v\u1edbi ng\u01b0\u1eddi anh, n\u00ean \u0111\u1eddi s\u1ed1ng kh\u00e1 ch\u1eadt v\u1eadt. H\u00e0ng ng\u00e0y, <strong>SUBSTITUTE<\/strong> v\u1eabn ph\u1ea3i l\u00ean r\u1eebng \u0111\u1ed1n c\u1ee7i \u0111em v\u1ec1 \u0111\u1ec3 b\u00e1n. Th\u1ea5y em ngh\u00e8o t\u00fang, T2Column kh\u00f4ng nh\u1eefng kh\u00f4ng th\u01b0\u01a1ng x\u00f3t m\u00e0 c\u00f2n khinh ra m\u1eb7t.<\/p>\n<p>H\u00f4m \u1ea5y nh\u01b0 th\u01b0\u1eddng l\u1ec7,\u00a0<strong>SUBSTITUTE\u00a0<\/strong>l\u00ean r\u1eebng \u0111i l\u1ea5y c\u1ee7i. Xong vi\u1ec7c, ch\u00e0ng \u0111ang \u0111\u1ecbnh l\u00ean \u0111\u01b0\u1eddng v\u1ec1 l\u1ea1i nh\u00e0 b\u1ed7ng nh\u00ecn th\u1ea5y c\u00e1t b\u1ee5i m\u1ecbt m\u00f9 t\u1eeb \u0111\u00e0ng xa, r\u1ed3i k\u1ebf \u0111\u1ebfn l\u00e0 ti\u1ebfng v\u00f3 ng\u1ef1a d\u1ed3n d\u1eadp m\u1ed7i l\u00fac m\u1ed9t g\u1ea7n. <strong>SUBSTITUTE<\/strong> ho\u1ea3ng h\u1ed1t, d\u1eaft l\u1eeba v\u00e0o n\u00fap trong m\u1ed9t b\u1ee5i r\u1eadm, nh\u01b0ng v\u1eabn \u0111\u1ec3 \u00fd nghe ng\u00f3ng.<\/p>\n<p><strong>SUBSTITUTE<\/strong> \u0111\u1ebfm \u0111\u01b0\u1ee3c tr\u01b0\u1edbc sau <strong>40 ng\u01b0\u1eddi<\/strong> v\u00e0 <em>40 ng\u1ef1<\/em>a. Ng\u01b0\u1eddi n\u00e0o c\u0169ng th\u00e1o g\u1ee1 m\u1ed9t chi\u1ebfc t\u00fai l\u1edbn t\u1eeb tr\u00ean l\u01b0ng hay t\u1eeb hai b\u00ean h\u00f4ng ng\u1ef1a xu\u1ed1ng; c\u00f3 ng\u01b0\u1eddi th\u00ec hai t\u00fai, k\u1ebb ba t\u00fai\u2026 \u0110o\u00e0n ng\u01b0\u1eddi c\u00f9ng nhau ti\u1ebfn t\u1edbi s\u00e1t b\u00ean t\u1ea3ng \u0111\u00e1. Ng\u01b0\u1eddi \u0111i \u0111\u1ea7u, c\u00f3 l\u1ebd l\u00e0 th\u1ee7 l\u00e3nh c\u1ee7a \u0111\u00e1m ng\u01b0\u1eddi b\u1ed7ng ra d\u1ea5u cho t\u1ea5t c\u1ea3 d\u1eebng l\u1ea1i tr\u01b0\u1edbc r\u1ed3i gi\u01a1 hai tay l\u00ean tr\u1eddi n\u00f3i l\u1edbn: \u201c<strong>\u2013 V\u1eeaNG \u01a0I M\u1ede RA!<\/strong>\u201c<\/p>\n<p>L\u1ea1 l\u00f9ng thay, t\u1ea3ng \u0111\u00e1 l\u00e2u nay, SUBSTITUTE \u0111i ngang qua kh\u00f4ng bi\u1ebft bao nhi\u00eau l\u1ea7n m\u00e0 kh\u00f4ng bao gi\u1edd \u0111\u1ec3 \u00fd nh\u01b0 c\u00f3 m\u1ed9t c\u00e1nh c\u1eeda t\u1ef1 \u0111\u1ed9ng m\u1edf ra, v\u00e0 b\u00ean trong s\u00e2u hun h\u00fat t\u1ef1a nh\u01b0 l\u00e0 m\u1ed9t hang \u0111\u1ed9ng. \u0110o\u00e0n ng\u01b0\u1eddi \u00f4m h\u00e0nh trang c\u00f9ng v\u00e0o t\u1ea5t c\u1ea3 b\u00ean trong. Ng\u01b0\u1eddi th\u1ee7 l\u00e3nh l\u00e0 ng\u01b0\u1eddi \u0111i sau c\u00f9ng. Y l\u1ea1i gi\u01a1 hai tay l\u00ean tr\u1eddi n\u00f3i: \u201c<strong>\u2013 V\u1eebng \u01a1i, h\u00e3y \u0111\u00f3ng l\u1ea1i!<\/strong>\u201c.\u00a0L\u1eadp t\u1ee9c c\u00e1nh c\u1eeda \u0111\u00f3ng l\u1ea1i\u2026<\/p>\n<\/blockquote>\n<p><strong>SUBSTITUTE<\/strong> trong c\u00e2u chuy\u1ec7n tr\u00ean c\u00f3 gi\u1ed1ng Alibaba kh\u00f4ng? V\u1eady th\u00ec c\u00e2u chuy\u1ec7n c\u1ed5 t\u00edch n\u00e0y c\u00f3 d\u00f9ng \u0111\u01b0\u1ee3c g\u00ec trong Excel?<\/p>\n<ul>\n<li>\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-674e6c26763a5\" 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-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/substitute-va-40-ten-cuop.html#SUBSTITUTE_la_ai\" title=\"SUBSTITUTE l\u00e0 ai?\">SUBSTITUTE l\u00e0 ai?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/substitute-va-40-ten-cuop.html#SUBSTITUTE_thuong_di_don_cui_nen_se_biet_duoc_co_bao_nhieu_cui\" title=\"SUBSTITUTE th\u01b0\u1eddng \u0111i \u0111\u1ed1n c\u1ee7i, n\u00ean s\u1ebd bi\u1ebft \u0111\u01b0\u1ee3c c\u00f3 bao nhi\u00eau c\u1ee7i.\">SUBSTITUTE th\u01b0\u1eddng \u0111i \u0111\u1ed1n c\u1ee7i, n\u00ean s\u1ebd bi\u1ebft \u0111\u01b0\u1ee3c c\u00f3 bao nhi\u00eau c\u1ee7i.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/substitute-va-40-ten-cuop.html#SUBSTITUTE_dung_cau_than_chu_de_mo_ra_hang_dong_vao_do_lay_vang_bac_ra_sau_do_thi_dong_lai\" title=\"SUBSTITUTE d\u00f9ng c\u00e2u th\u1ea7n ch\u00fa \u0111\u1ec3 m\u1edf ra hang \u0111\u1ed9ng, v\u00e0o \u0111\u00f3 l\u1ea5y v\u00e0ng b\u1ea1c ra, sau \u0111\u00f3 th\u00ec \u0111\u00f3ng l\u1ea1i.\">SUBSTITUTE d\u00f9ng c\u00e2u th\u1ea7n ch\u00fa \u0111\u1ec3 m\u1edf ra hang \u0111\u1ed9ng, v\u00e0o \u0111\u00f3 l\u1ea5y v\u00e0ng b\u1ea1c ra, sau \u0111\u00f3 th\u00ec \u0111\u00f3ng l\u1ea1i.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/substitute-va-40-ten-cuop.html#Loi_ket\" title=\"L\u1eddi k\u1ebft\">L\u1eddi k\u1ebft<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"SUBSTITUTE_la_ai\"><\/span>SUBSTITUTE l\u00e0 ai?<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<\/ul>\n<p>[alert-success]SUBSTITUTE(text, old_text, new_text, [instance_num])[\/alert-success]<\/p>\n<p>C\u00fa ph\u00e1p h\u00e0m SUBSTITUTE c\u00f3 ca\u0301c \u0111\u1ed1i s\u1ed1 sau \u0111\u00e2y:<\/p>\n<p>Text: B\u1eaft bu\u1ed9c. V\u0103n ba\u0309n ho\u0103\u0323c tham chi\u00ea\u0301u \u0111\u00ea\u0301n \u00f4 ch\u01b0\u0301a v\u0103n ba\u0309n ma\u0300 ba\u0323n mu\u00f4\u0301n thay th\u00ea\u0301 ca\u0301c ky\u0301 t\u01b0\u0323 trong \u0111o\u0301.<\/p>\n<p>Old_text: B\u1eaft bu\u1ed9c. V\u0103n ba\u0309n ma\u0300 ba\u0323n mu\u00f4\u0301n \u0111\u01b0\u01a1\u0323c thay th\u00ea\u0301.<\/p>\n<p>New_text: B\u1eaft bu\u1ed9c. V\u0103n ba\u0309n ma\u0300 ba\u0323n mu\u00f4\u0301n thay th\u00ea\u0301 cho old_text.<\/p>\n<p>Instance_num: T\u00f9y ch\u1ecdn. Xa\u0301c \u0111i\u0323nh s\u00f4\u0301 l\u00e2\u0300n xu\u00e2\u0301t hi\u00ea\u0323n cu\u0309a old_text ma\u0300 ba\u0323n mu\u00f4\u0301n thay b\u0103\u0300ng new_text. N\u00ea\u0301u ba\u0323n xa\u0301c \u0111i\u0323nh instance_num, thi\u0300 s\u00f4\u0301 l\u00e2\u0300n xu\u00e2\u0301t hi\u00ea\u0323n \u0111o\u0301 cu\u0309a old_text \u0111\u01b0\u01a1\u0323c thay th\u00ea\u0301. N\u00ea\u0301u kh\u00f4ng, mo\u0323i l\u00e2\u0300n xu\u00e2\u0301t hi\u00ea\u0323n cu\u0309a old_text trong v\u0103n ba\u0309n \u0111\u01b0\u01a1\u0323c \u0111\u00f4\u0309i tha\u0300nh new_text.<\/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-263.gif\" title=\"ex101_92019-nho-263\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19182 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/substitute_instance_num.jpg\" width=\"740\" height=\"229\" title=\"substitute_instance_num\"><\/p>\n<ul>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"SUBSTITUTE_thuong_di_don_cui_nen_se_biet_duoc_co_bao_nhieu_cui\"><\/span>SUBSTITUTE th\u01b0\u1eddng \u0111i \u0111\u1ed1n c\u1ee7i, n\u00ean s\u1ebd bi\u1ebft \u0111\u01b0\u1ee3c c\u00f3 bao nhi\u00eau c\u1ee7i.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<\/ul>\n<p style=\"text-align: left\">V\u1edbi m\u1ed9t danh s\u00e1ch H\u1ecd t\u00ean c\u00f3 chi\u1ec1u d\u00e0i kh\u00e1c nhau, s\u1ed1 ch\u1eef trong t\u00ean c\u0169ng kh\u00e1c nhau.<br \/>\nL\u00e0m th\u1ebf n\u00e0o b\u1ea1n bi\u1ebft t\u00ean h\u1ecd c\u00f3 bao nhi\u00eau ch\u1eef?<br \/>\nD\u00f9ng \u0111\u1ebfm tay \u0111\u1ea1i ph\u00e1p ta c\u00f3 th\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c, \u201cNguy\u1ec5n A\u201d c\u00f3 2 ch\u1eef, \u201cTr\u1ea7n V\u0103n B\u201d, c\u00f3 3 ch\u1eef. V\u1eady Excel l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ebfm?<br \/>\nXin gi\u1edbi thi\u1ec7u c\u00e1c b\u1ea1n, anh SUBSTITUTE ngh\u00e8o kh\u00f3 v\u1eeba b\u1ecb tr\u1ee5c xu\u1ea5t kh\u1ecfi v\u01b0\u01a1ng qu\u1ed1c xa x\u00f4i v\u00ec qu\u00e1 t\u1ec9nh, v\u00e0 qu\u00e1 \u0111\u1eb9p trai.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-19171 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sokhoangtrang.jpg\" width=\"590\" height=\"249\" title=\"sokhoangtrang\"><\/p>\n<p>\u2013 SUBSTITUTE \u0111\u00e3 l\u00e0m g\u00ec trong h\u00e0m tr\u00ean? Ch\u00e0ng \u1ea5y l\u00e0m vi\u1ec7c \u0111i \u0111\u1ed1n c\u1ee7i, \u0111\u01a1n gi\u1ea3n l\u00e0 t\u00ecm kho\u1ea3ng tr\u1eafng v\u00e0 ch\u1eb7t \u0111i. SUBSTITUTE(\u201cNguy\u1ec5n A\u201d) s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0: \u201cNguy\u1ec5nA\u201d.<\/p>\n<p>\u2013 V\u1eady c\u00f2n H\u00e0m LEN l\u00e0 g\u00ec? C\u00f3 gi\u1ed1ng n\u00e0ng B\u00e2n d\u1ec7t \u00e1o len cho ch\u1ed3ng kh\u00f4ng? Kh\u00f4ng, ch\u1eafc ch\u1eafn r\u1ed3i, LEN c\u00f3 t\u00e1c d\u1ee5ng \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i. LEN(\u201cNguy\u1ec5n A\u201d) s\u1ebd tr\u1ea3 v\u1ec1 8 k\u00fd t\u1ef1, v\u1eady th\u00ec LEN(\u201cNguy\u1ec5nA\u201d) s\u1ebd l\u00e0 7. 8-7=1<\/p>\n<ul>\n<li><strong>SUBSTITUTE v\u00e0 40 t\u00ean c\u01b0\u1edbp s\u1ebd nh\u01b0 th\u1ebf n\u00e0o?<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19175 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/40tencuop-1024x229-1.jpg\" width=\"1024\" height=\"229\" title=\"40tencuop-1024x229-1\"><\/p>\n<p>H\u00e0m REPT l\u00e0 g\u00ec? REPT l\u00e0 th\u1ea7n ch\u00fa \u0111\u1ea1i ph\u00e1p, d\u00f9ng \u0111\u1ec3 l\u1eb7p l\u1ea1i s\u1ed1 t\u1eeb \u0111\u00e3 cho. Trong \u1ea3nh, l\u00e0 l\u1eb7p l\u1ea1i 40 l\u1ea7n kho\u1ea3ng tr\u1eafng.<\/p>\n<p>C\u1ee5 th\u1ec3 di\u1ec5n gi\u1ea3i th\u1ebf n\u00e0o? SUBSTITUTE t\u00ecm kho\u1ea3ng tr\u1eafng trong chu\u1ed7i, v\u00e0 thay th\u1ebf n\u00f3 b\u1eb1ng 40 k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng. Gi\u1ed1ng nh\u01b0 Alibaba, th\u1ea5y 40 t\u00ean c\u01b0\u1edbp \u0111i v\u00e0o h\u00e0ng \u0111\u1ed9ng v\u1eady th\u00f4i.<\/p>\n<ul>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"SUBSTITUTE_dung_cau_than_chu_de_mo_ra_hang_dong_vao_do_lay_vang_bac_ra_sau_do_thi_dong_lai\"><\/span>SUBSTITUTE d\u00f9ng c\u00e2u th\u1ea7n ch\u00fa \u0111\u1ec3 m\u1edf ra hang \u0111\u1ed9ng, v\u00e0o \u0111\u00f3 l\u1ea5y v\u00e0ng b\u1ea1c ra, sau \u0111\u00f3 th\u00ec \u0111\u00f3ng l\u1ea1i.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/substitute-text.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-19178 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/substitute-text-1024x398-1.jpg\" width=\"1024\" height=\"398\" title=\"substitute-text-1024x398-1\"><\/a><\/p>\n<\/li>\n<\/ul>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/xoa-khoang-trang-thua-bang-ham-trim-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">TRIM <\/a><\/strong>l\u00e0 v\u1ee3 c\u1ee7a SUBSTITUTE, ng\u01b0\u1eddi \u0111\u00e3 gi\u00fap h\u1ea1 \u0111i nh\u1eefng t\u00ean c\u01b0\u1edbp trong truy\u1ec7n c\u1ed5 t\u00edch. TRIM lo\u1ea1i b\u1ecf \u0111i 40 t\u00ean c\u01b0\u1edbp, ch\u1eeba l\u1ea1i 1 t\u00ean th\u1ee7 l\u0129nh. TRIM(\u201cch\u1eef[40 kho\u1ea3ng tr\u1eafng]s\u1ed1\u201d) =&gt; \u201cch\u1eef[1 kho\u1ea3ng tr\u1eafng]s\u1ed1\u201d. N\u1ebfu nh\u00f3m 40 t\u00ean c\u01b0\u1edbp \u0111\u1ee9ng \u0111\u1ea7u ho\u1eb7c cu\u1ed1i th\u00ec thanh l\u00fd s\u1ea1ch s\u1ebd: TRIM(\u201c[40 kho\u1ea3ng tr\u1eafng]k\u00fd t\u1ef1 b\u1ea5t k\u1ef3\u201d) =&gt; \u201ck\u00fd t\u1ef1 b\u1ea5t k\u1ef3\u201d.<\/p>\n<p>V\u1eady c\u00f2n h\u00e0m <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-mid-va-cach-su-dung-ham-mid-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">MID <\/a><\/strong>l\u00e0m g\u00ec? MID l\u00e0m nhi\u1ec7m v\u1ee5 chia gia t\u00e0i, khi chu\u1ed7i k\u00fd t\u1ef1, b\u1ea1n \u0111\u00e3 th\u00eam v\u00e0o l\u1ea7n l\u01b0\u1ee3t 40 k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng, v\u00ed d\u1ee5: \u201cNguy\u1ec5n[40 kho\u1ea3ng tr\u1eafng]A\u201d, khi \u0111\u00f3 s\u1ebd l\u00e0 47 k\u00fd t\u1ef1, v\u00e0 \u0111\u1ec3 l\u1ea5y h\u1ecd ra, ta d\u00f9ng h\u00e0m MID(\u201cNguy\u1ec5n[40 kho\u1ea3ng tr\u1eafng]A\u201d,1,40) =&gt; k\u1ebft qu\u1ea3 ta c\u00f3, \u201cNguy\u1ec5n[34 kho\u1ea3ng tr\u1eafng]\u201d. D\u00f9ng h\u00e0m TRIM, ch\u00fang ta b\u1ecf h\u1ebft kho\u1ea3ng tr\u1eafng, ra k\u1ebft qu\u1ea3 ch\u1ec9 l\u00e0 \u201cNguy\u1ec5n\u201d.<\/p>\n<p>Ngo\u00e0i ra, ta c\u00f3 c\u00e1ch v\u1eadn d\u1ee5ng h\u00e0m SUBSTITUTE k\u1ebft h\u1ee3p LEFT\/RIGHT \u0111\u1ec3 t\u00e1ch H\u1ecd v\u00e0 t\u00ean ra kh\u1ecfi chu\u1ed7i.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/cach-tach-ho-ten-excel-ham-substitute.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-31177\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-tach-ho-ten-excel-ham-substitute.jpg\" alt=\"c\u00e1ch t\u00e1ch h\u1ecd t\u00ean excel v\u1edbi h\u00e0m SUBSTITUTE\" width=\"821\" height=\"285\" title=\"cach-tach-ho-ten-excel-ham-substitute\"><\/a><\/p>\n<ul>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Loi_ket\"><\/span>L\u1eddi k\u1ebft<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<\/ul>\n<p>V\u00e0 l\u1eddi k\u1ebft, ch\u00fang ta d\u00f9ng SUBSTITUTE trong tr\u01b0\u1eddng h\u1ee3p n\u00e0o? R\u1ea5t nhi\u1ec1u \u00e1p d\u1ee5ng, t\u01b0\u01a1ng \u1ee9ng khi v\u1eadn d\u1ee5ng h\u00e0m. B\u1ea1n c\u00f2n nh\u1edb anh T2Column c\u1ee7a SUBSTITUTE ch\u1ee9? Anh ta ch\u00ednh l\u00e0 \u201c<strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-chia-o-thanh-cot-hoac-hang-bang-cach-xuong-dong.html\" target=\"_blank\" rel=\"noopener noreferrer\">Text to Columns<\/a><\/strong>\u201d trong Excel, v\u1edbi nhi\u1ec1u t\u00ednh n\u0103ng \u201cgi\u00e0u c\u00f3\u201d. V\u00e0 c\u00f2n ng\u01b0\u1eddi v\u1ee3 c\u1ee7a anh ta, b\u1ea1n bi\u1ebft <a href=\"http:\/\/blog.ezworkapp.com\/?s=flash+fill\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Flash Fill<\/strong><\/a> ch\u1ee9?<\/p>\n<p>Nh\u01b0ng, h\u00e3y xem SUBSTITUTE l\u00e0m \u0111\u01b0\u1ee3c g\u00ec nh\u00e9!<\/p>\n<ol>\n<li>T\u00e1ch ch\u1eef theo v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean v\u1edbi LEFT, cu\u1ed1i v\u1edbi RIGHT, b\u1ea5t k\u1ef3 v\u1ecb tr\u00ed n\u00e0o v\u1edbi MID:<br \/>\nV\u00ed d\u1ee5 b\u1ea1n c\u00f3 d\u00e3y s\u1ed1 \u201c55 77 99\u201d, mu\u1ed1n t\u00e1ch b\u00ean tr\u00e1i, v\u00e0 b\u00ean ph\u1ea3i ra th\u00ec ta v\u1eadn d\u1ee5ng h\u00e0m LEFT\/RIGHT. C\u00f2n d\u1ea5u tr\u1eeb tr\u1eeb (\u2013, hai d\u1ea5u tr\u1eeb) d\u00f9ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i ch\u1eef th\u00e0nh s\u1ed1, n\u1ebfu d\u1eef li\u1ec7u c\u1ea7n t\u00e1ch l\u00e0 ch\u1eef, th\u00ec b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i c\u00f3 2 d\u1ea5u tr\u1eeb tr\u1eeb n\u00e0y. V\u1edbi h\u00e0m MID, tr\u01b0\u1edbc ti\u00ean ta gh\u00e9p v\u00e0o ph\u00eda tr\u01b0\u1edbc m\u1ed9t kho\u1ea3ng tr\u1eafng, \u0111\u1ec3 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00e1ch ra v\u1ecb tr\u00ed mong mu\u1ed1n t\u1eeb tr\u00e1i sang (index).<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/lam-the-nao-de-tach-chuoi-trong-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-30199 alignnone\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lam-the-nao-de-tach-chuoi-trong-excel.png\" width=\"667\" height=\"246\" title=\"lam-the-nao-de-tach-chuoi-trong-excel\"><\/a><\/li>\n<li>T\u00e1ch c\u1ee5m ch\u1eef gi\u1eefa c\u00e1c k\u00fd t\u1ef1 ph\u00e2n c\u00e1ch:<br \/>\nV\u00ed d\u1ee5 ta mu\u1ed1n l\u1ea5y c\u1ee5m ch\u1eef \u201c123456789\u201d t\u1eeb c\u1ee5m sau:\u00a0190309-123456789-012345, th\u00ec l\u00e0m th\u1ebf n\u00e0o? \u0110\u1ea7u ti\u00ean, ta gh\u00e9p m\u1ed9t d\u1ea5u g\u1ea1ch n\u1ed1i v\u00e0o \u0111\u1ea7u chu\u1ed7i, v\u00e0 m\u1ecdi vi\u1ec7c s\u1ebd \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/tach-cum-chu-ra-khoi-chuoi-theo-dau-gach.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29672 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-cum-chu-ra-khoi-chuoi-theo-dau-gach.png\" width=\"705\" height=\"146\" title=\"tach-cum-chu-ra-khoi-chuoi-theo-dau-gach\"><\/a><\/li>\n<li>T\u00e1ch \u0111\u1ecba ch\u1ec9, ra t\u1eebng ph\u1ea7n X\u00e3\/Ph\u01b0\u1eddng, Huy\u1ec7n\/Qu\u1eadn, T\u1ec9nh\/Th\u00e0nh ph\u1ed1.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19186\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/subtitute-tach-dia-chi-tach-chuoi.jpg\" width=\"1061\" height=\"506\" title=\"subtitute-tach-dia-chi-tach-chuoi\">\u1ee6a, sao ch\u1ed7 n\u00e0y l\u1ea1i l\u00e0 80? B\u1ea1n \u0111\u00e3 qu\u00ean 40 con ng\u1ef1a r\u1ed3i.<\/li>\n<li>\u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng t\u1eeb xu\u1ea5t hi\u1ec7n trong \u00f4, v\u00ed d\u1ee5 nh\u01b0 \u0111\u1ebfm c\u00f3 bao nhi\u00eau B\u00f2, G\u00e0, Ch\u00f3 trong \u00f4.<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/06\/dem-so-luong-ga-bo-cho.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19196\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-so-luong-ga-bo-cho.jpg\" width=\"586\" height=\"190\" title=\"dem-so-luong-ga-bo-cho\"><\/a><\/li>\n<\/ol>\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-263.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3424,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3423","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\/3423","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=3423"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3423\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3424"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}