{"id":8043,"date":"2024-12-21T19:33:23","date_gmt":"2024-12-21T19:33:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the\/"},"modified":"2024-12-21T19:33:23","modified_gmt":"2024-12-21T19:33:23","slug":"ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the\/","title":{"rendered":"H\u00e0m SUBSTITUTE trong Excel, h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng v\u00e0 c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>H\u00e0m SUBSTITUTE<\/strong> trong Excel gi\u00fap thay th\u1ebf chu\u1ed7i v\u0103n b\u1ea3n c\u0169 th\u00e0nh chu\u1ed7i v\u0103n b\u1ea3n m\u1edbi m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng. \u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 h\u00e0m n\u00e0y, b\u1ea1n h\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!<\/em><\/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-67671802c4780\" 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\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html#Cu_phap_ham_SUBSTITUTE\" title=\"C\u00fa ph\u00e1p h\u00e0m SUBSTITUTE\">C\u00fa ph\u00e1p h\u00e0m SUBSTITUTE<\/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\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html#Vi_du_su_dung_cua_ham_SUBSTITUTE\" title=\"V\u00ed d\u1ee5 s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m SUBSTITUTE\">V\u00ed d\u1ee5 s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m SUBSTITUTE<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html#Dung_ham_SUBSTITUTE_trong_truong_hop_nao\" title=\"D\u00f9ng h\u00e0m SUBSTITUTE trong tr\u01b0\u1eddng h\u1ee3p n\u00e0o\">D\u00f9ng h\u00e0m SUBSTITUTE trong tr\u01b0\u1eddng h\u1ee3p n\u00e0o<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cu_phap_ham_SUBSTITUTE\"><\/span><strong>C\u00fa ph\u00e1p h\u00e0m SUBSTITUTE<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>=<strong>SUBSTITUTE(text, old_text, new_text, [instance_num])<\/strong><\/p>\n<p><em>Trong \u0110\u00f3<\/em>:<\/p>\n<p><strong>\u2013 <em>text<\/em>: <\/strong>V\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n thay th\u1ebf c\u00e1c k\u00fd t\u1ef1 trong \u0111\u00f3.<br \/>\n<strong>\u2013 <em>old_text: <\/em><\/strong>V\u0103n b\u1ea3n c\u0169 b\u1ea1n mu\u1ed1n \u0111\u01b0\u1ee3c thay th\u1ebf<br \/>\n<strong>\u2013 <em>new_text:<\/em><\/strong> V\u0103n b\u1ea3n m\u1edbi m\u00e0 b\u1ea1n mu\u1ed1n thay\u00a0 th\u1ebf cho v\u0103n b\u1ea3n c\u0169.<br \/>\n<strong>\u2013 <em>instance_num:<\/em><\/strong> v\u1ecb tr\u00ed m\u00e0 v\u0103n b\u1ea3n c\u0169 xu\u1ea5t hi\u1ec7n m\u00e0 b\u1ea1n mu\u1ed1n thay b\u1eb1ng v\u0103n b\u1ea3n m\u1edbi<\/p>\n<blockquote>\n<p>Xem ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">c\u00e1c h\u00e0m th\u01b0\u1eddng d\u00f9ng trong excel<\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_su_dung_cua_ham_SUBSTITUTE\"><\/span><strong>V\u00ed d\u1ee5 s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m SUBSTITUTE<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>* Cho b\u1ea3ng d\u1eef li\u1ec7u, thay th\u1ebf v\u0103n b\u1ea3n c\u0169 th\u00e0nh v\u0103n b\u1ea3n m\u1edbi.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3488 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-37.png\" alt=\"ham-subtitute\" width=\"600\" height=\"419\" title=\"1-37\"><\/p>\n<ul>\n<li>Thay <strong>www.hocexcelonline.com<\/strong> th\u00e0nh\u00a0<strong>hocexcelonline.com,\u00a0<\/strong>d\u00f9ng c\u00f4ng th\u1ee9c:\u00a0<strong>=SUBSTITUTE(B4;\u201dwww.\u201d;\u201d\u201d)\u00a0<\/strong>v\u00e0 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3489 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-38.png\" width=\"600\" height=\"420\" title=\"1-38\"><\/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-726.gif\" title=\"ex101_92019-nho-726\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>Thay\u00a0<strong>H\u1ecdc Excel\u00a0<\/strong>th\u00e0nh <strong>Excel,\u00a0<\/strong>c\u00f4ng th\u1ee9c: <strong>=SUBSTITUTE(B5;\u201dH\u1ecdc\u201d;\u201d\u201d)<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3490 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-39.png\" width=\"600\" height=\"418\" title=\"1-39\"><\/p>\n<ul>\n<li>Thay<strong>\u00a0Excel\u00a0<\/strong>th\u00e0nh <b>Word,\u00a0<\/b>c\u00f4ng th\u1ee9c: <strong>=SUBSTITUTE(B6;\u201dExcel\u201d;\u201dWord\u201d)<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3491 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-40.png\" width=\"600\" height=\"424\" title=\"1-40\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Dung_ham_SUBSTITUTE_trong_truong_hop_nao\"><\/span>D\u00f9ng h\u00e0m SUBSTITUTE trong tr\u01b0\u1eddng h\u1ee3p n\u00e0o<span class=\"ez-toc-section-end\"><\/span><\/h2>\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.<\/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-1.png\" width=\"667\" height=\"246\" title=\"lam-the-nao-de-tach-chuoi-trong-excel-1\"><\/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-1.png\" width=\"705\" height=\"146\" title=\"tach-cum-chu-ra-khoi-chuoi-theo-dau-gach-1\"><\/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-1.jpg\" width=\"1061\" height=\"506\" title=\"subtitute-tach-dia-chi-tach-chuoi-1\">\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-1.jpg\" width=\"586\" height=\"190\" title=\"dem-so-luong-ga-bo-cho-1\"><\/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-726.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8044,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8043","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\/8043","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=8043"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8043\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8044"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8043"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8043"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8043"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}