{"id":9807,"date":"2025-01-03T05:18:42","date_gmt":"2025-01-03T05:18:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/cach-su-dung-ham-substitute-bo-dau-cach-trong-danh-sach-so-dien-thoai-hieu-qua\/"},"modified":"2025-01-03T05:18:42","modified_gmt":"2025-01-03T05:18:42","slug":"cach-su-dung-ham-substitute-bo-dau-cach-trong-danh-sach-so-dien-thoai-hieu-qua","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/cach-su-dung-ham-substitute-bo-dau-cach-trong-danh-sach-so-dien-thoai-hieu-qua\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE b\u1ecf d\u1ea5u c\u00e1ch trong danh s\u00e1ch s\u1ed1 \u0111i\u1ec7n tho\u1ea1i hi\u1ec7u qu\u1ea3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00e0m SUBSTITUTE r\u1ea5t h\u1eefu d\u1ee5ng \u0111\u1ec3 thay th\u1ebf chu\u1ed7i k\u00ed t\u1ef1 n\u00e0y b\u1eb1ng chu\u1ed7i k\u00ed t\u1ef1 kh\u00e1c, ph\u1ee5c v\u1ee5 cho nhi\u1ec1u c\u00f4ng t\u00e1c v\u1edbi d\u1eef li\u1ec7u. Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE b\u1ecf d\u1ea5u c\u00e1ch trong danh s\u00e1ch s\u1ed1 \u0111i\u1ec7n tho\u1ea1i \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o.<\/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-6777733186231\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-substitute-bo-dau-cach-trong-danh-sach-so-dien-thoai.html#Ham_SUBSTITUTE\" title=\"H\u00e0m SUBSTITUTE\">H\u00e0m SUBSTITUTE<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-substitute-bo-dau-cach-trong-danh-sach-so-dien-thoai.html#Su_dung_ham_SUBSTITUTE_bo_dau_cach_trong_danh_sach_so_dien_thoai_hieu_qua\" title=\"S\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE b\u1ecf d\u1ea5u c\u00e1ch trong danh s\u00e1ch s\u1ed1 \u0111i\u1ec7n tho\u1ea1i hi\u1ec7u qu\u1ea3\">S\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE b\u1ecf d\u1ea5u c\u00e1ch trong danh s\u00e1ch s\u1ed1 \u0111i\u1ec7n tho\u1ea1i hi\u1ec7u qu\u1ea3<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_SUBSTITUTE\"><\/span>H\u00e0m SUBSTITUTE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html\"><strong>H\u00e0m SUBSTITUTE<\/strong><\/a> c\u00f3 c\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=SUBSTITUTE(text, old_text, new_text, [instance_num])<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>text<\/strong>\u00a0l\u00e0 chu\u1ed7i k\u00ed t\u1ef1 tham chi\u1ebfu \u0111\u1ebfn<\/p>\n<p><strong>old_text\u00a0<\/strong>l\u00e0 \u0111o\u1ea1n k\u00ed t\u1ef1 n\u1eb1m trong chu\u1ed7i\u00a0<strong>text<\/strong>\u00a0mu\u1ed1n thay th\u1ebf<\/p>\n<p><strong>new_text<\/strong>\u00a0l\u00e0 \u0111o\u1ea1n k\u00ed t\u1ef1 m\u1edbi thay th\u1ebf cho\u00a0<strong>old_text<\/strong><\/p>\n<p><strong>instance_num<\/strong>\u00a0(kh\u00f4ng b\u1eaft bu\u1ed9c) l\u00e0\u00a0v\u1ecb tr\u00ed thay th\u1ebf. V\u00ed d\u1ee5 n\u1ebfu c\u00f3 3 \u0111o\u1ea1n\u00a0<strong>old_text<\/strong>, khi \u0111\u1ec3\u00a0<strong>instance_num<\/strong>\u00a0b\u1eb1ng 2, \u0111o\u1ea1n\u00a0<strong>old_text 1\u00a0<\/strong>v\u00e0\u00a0<strong>3<\/strong>\u00a0s\u1ebd kh\u00f4ng b\u1ecb \u1ea3nh h\u01b0\u1edfng. N\u1ebfu kh\u00f4ng nh\u1eadp, h\u00e0m\u00a0<strong>SUBSTITUTE<\/strong>\u00a0m\u1eb7c \u0111\u1ecbnh s\u1ebd thay th\u1ebf h\u1ebft c\u1ea3 3 \u0111o\u1ea1n.<\/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\/2025\/01\/ex101_92019-nho-95.gif\" title=\"ex101_92019-nho-95\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_SUBSTITUTE_bo_dau_cach_trong_danh_sach_so_dien_thoai_hieu_qua\"><\/span>S\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE b\u1ecf d\u1ea5u c\u00e1ch trong danh s\u00e1ch s\u1ed1 \u0111i\u1ec7n tho\u1ea1i hi\u1ec7u qu\u1ea3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>SUBSTITUTE<\/strong>\u00a0\u0111\u1ec3 l\u00e0m li\u1ec1n kho\u1ea3ng c\u00e1ch c\u1ee7a c\u00e1c s\u1ed1 trong m\u1ed9t s\u1ed1 \u0111i\u1ec7n tho\u1ea1i nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-23415\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/substitute-xoa-dau-cach-sdt-1-1-1024x246-1.png\" width=\"1024\" height=\"246\" title=\"substitute-xoa-dau-cach-sdt-1-1-1024x246-1\"><\/p>\n<p>\u00a0<\/p>\n<p><em>=SUBSTITUTE(A2,\u201d \u201c,\u201d\u201d)<\/em><\/p>\n<p>H\u00e0m SUBSTITUTE s\u1ebd ti\u1ebfn h\u00e0nh tham chi\u1ebfu t\u1edbi \u00f4\u00a0<strong>A2<\/strong>, sau \u0111\u00f3 thay th\u1ebf nh\u1eefng k\u00ed t\u1ef1 kho\u1ea3ng tr\u1eafng\u00a0<strong>\u201d \u201c<\/strong> b\u1eb1ng c\u00e1ch kh\u00f4ng nh\u1eadp g\u00ec c\u1ea3\u00a0<strong>\u201c\u201d<\/strong>.\u00a0\u0110\u1ed1i s\u1ed1\u00a0<strong>Instant_num<\/strong> \u1edf \u0111\u00e2y ta kh\u00f4ng nh\u1eadp \u0111\u1ec3 SUBSTITUTE thay th\u1ebf to\u00e0n b\u1ed9 d\u1ea5u c\u00e1ch trong chu\u1ed7i.<\/p>\n<p>Sau khi x\u1eed l\u00fd, \u0111\u1ec3 chuy\u1ec3n s\u1ed1 v\u1ec1 \u0111\u1ecbnh d\u1ea1ng number, ta nh\u1eadp:<\/p>\n<p><em>=\u2013SUBSTITUTE(A2,\u201d \u201c,\u201d\u201d) ho\u1eb7c\u00a0=VALUE(SUBSTITUTE(A2,\u201d \u201c,\u201d\u201d))<\/em><\/p>\n<blockquote>\n<p><strong>Xem th\u00eam:<\/strong><a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-bo-khoang-trong-thua-trong-excel.html\">C\u00f4ng th\u1ee9c b\u1ecf kho\u1ea3ng tr\u1ed1ng th\u1eeba trong Excel hi\u1ec7u qu\u1ea3<\/a><\/p>\n<\/blockquote>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o? Tr\u00ean \u0111\u00e2y ch\u1ec9 l\u00e0 v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n nh\u1ea5t v\u1ec1 c\u00e1ch \u1ee9ng d\u1ee5ng h\u00e0m SUBSTITUTE m\u00e0 th\u00f4i. H\u00e3y t\u00ecm hi\u1ec3u th\u00eam v\u00e0 t\u00edch c\u1ef1c luy\u1ec7n t\u1eadp \u0111\u1ec3 ng\u00e0y c\u00e0ng thu\u1ea7n th\u1ee5c h\u01a1n khi x\u1eed l\u00fd d\u1eef li\u1ec7u trong Excel nh\u00e9.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t.<\/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\/2025\/01\/ex101_92019-nho-95.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9808,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9807","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\/9807","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=9807"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9807\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9808"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}