{"id":12385,"date":"2025-01-15T08:28:02","date_gmt":"2025-01-15T08:28:02","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-su-dung-ham-replace-trong-excel-2007-2010-2013-2016\/"},"modified":"2025-01-15T08:28:02","modified_gmt":"2025-01-15T08:28:02","slug":"cach-su-dung-ham-replace-trong-excel-2007-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-su-dung-ham-replace-trong-excel-2007-2010-2013-2016\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m REPLACE trong Excel 2007, 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong Excel, ng\u01b0\u1eddi ta th\u01b0\u1eddng d\u00f9ng <strong>h\u00e0m <\/strong><\/em><strong>REPLACE<\/strong><em> \u0111\u1ec3 thay th\u1ebf m\u1ed9t ph\u1ea7n c\u1ee7a chu\u1ed7i b\u1eb1ng m\u1ed9t chu\u1ed7i kh\u00e1c, d\u1ef1a v\u00e0o s\u1ed1 k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd chia s\u1ebb v\u1edbi b\u1ea1n t\u1eeb A t\u1edbi Z v\u1ec1 <strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m REPLACE<\/strong> trong Excel 2007, 2010, 2013, 2016 \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/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-67877190bfa72\" 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\/cach-su-dung-ham-replace-trong-excel.html#Cu_phap_cua_ham_Replace\" title=\"C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Replace\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Replace<\/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\/cach-su-dung-ham-replace-trong-excel.html#Vi_du_ve_cach_su_dung_ham_Replace_trong_Excel\" title=\"V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Replace trong Excel\">V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Replace trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_Replace\"><\/span><strong>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Replace<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><b>= REPLACE(old_text,start_num,num_chars,new_text)<\/b><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul style=\"text-align: justify\">\n<li><em><strong>old_text<\/strong><\/em>: chu\u1ed7i v\u0103n b\u1ea3n c\u1ea7n \u0111\u01b0\u1ee3c x\u1eed l\u00fd<\/li>\n<li><em><strong>start_num<\/strong><\/em>: v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u t\u00ecm c\u00e1i s\u1ebd thay th\u1ebf, t\u00ednh t\u1eeb b\u00ean tr\u00e1i sang<\/li>\n<li><strong><em>num_chars<\/em><\/strong>: l\u00e0 s\u1ed1 k\u00fd t\u1ef1 trong old_text m\u00e0 ta mu\u1ed1n h\u00e0m <strong>REPLACE<\/strong> thay b\u1eb1ng new_tex t<\/li>\n<li><strong><em>new_text<\/em><\/strong>: l\u00e0 chu\u1ed7i m\u00e0 ta mu\u1ed1n thay cho c\u00e1c k\u00fd t\u1ef1 trong old_text.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, c\u00e1i c\u1ea7n l\u01b0u \u00fd nh\u1ea5t khi s\u1eed d\u1ee5ng h\u00e0m <strong>REPLACE<\/strong> l\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u00ea rx\u00e1c \u0111\u1ecbnh <em><strong>start_num<\/strong><\/em> v\u00e0 <em><strong>num_chars.<\/strong> <\/em><\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u00fang ta d\u00f9ng h\u00e0m <b>FIND<\/b>() ho\u1eb7c <b>SEARCH<\/b>() \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u (<strong><em>start_num<\/em><\/strong>)<\/li>\n<li>D\u00f9ng h\u00e0m <b>LEN<\/b>() \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a chu\u1ed7i s\u1ebd \u0111\u01b0\u1ee3c thay th\u1ebf (<em><strong>num_chars<\/strong><\/em>)<\/li>\n<\/ul>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_ve_cach_su_dung_ham_Replace_trong_Excel\"><\/span><strong>V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Replace trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Xem th\u00eam: <strong>K\u1ebft h\u1ee3p h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-replace-va-substitute-trong-excel-cong-thuc-vi-du.html\">Replace v\u00e0 h\u00e0m Substitute<\/a> trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu mu\u1ed1n\u00a0thay th\u1ebf 2007 th\u00e0nh 2010 trong d\u00f2ng \u201cH\u1eccC EXCEL 2007\u201d ta l\u00e0m nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3264 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-replace.png\" width=\"600\" height=\"406\" title=\"ham-replace\"><\/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-391.gif\" title=\"ex101_92019-nho-391\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">D\u00f9ng c\u00f4ng th\u1ee9c: =<strong>REPLACE(<\/strong>C4; FIND(\u201c2007\u201d; C4); LEN(\u201c2007\u201d); \u201c2010\u201d<strong>)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3265 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-replace-1.png\" width=\"600\" height=\"306\" title=\"ham-replace-1\"><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3266 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-replace-2.png\" width=\"600\" height=\"448\" title=\"ham-replace-2\"><\/p>\n<p style=\"text-align: justify\"><em>V\u1eady l\u00e0 h\u01b0\u1edbng d\u1eabn \u0111\u01a1n gi\u1ea3n c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong> \u0111\u00e3 k\u1ebft th\u00fac r\u1ed3i. Th\u1eadt l\u00e0 qu\u00e1 d\u1ec5 d\u00e0ng \u0111\u1ec3 <strong>s\u1eed d\u1ee5ng h\u00e0m Replace<\/strong> \u0111\u00fang kh\u00f4ng n\u00e0o. N\u1ebfu c\u00f2n b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc n\u00e0o \u0111\u1eebng ng\u1ea1i ng\u1ea7n cmt b\u00ean d\u01b0\u1edbi \u0111\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i \u0111\u00e1p t\u1eadn t\u00ecnh c\u00e1c b\u1ea1n nh\u00e9<\/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\/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-391.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12386,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12385","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\/12385","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=12385"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12385\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12386"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}