{"id":10557,"date":"2025-01-14T15:40:11","date_gmt":"2025-01-14T15:40:11","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-cach-su-dung-cong-cu-replace-de-sua-cong-thuc-excel\/"},"modified":"2025-01-14T15:40:11","modified_gmt":"2025-01-14T15:40:11","slug":"huong-dan-cach-su-dung-cong-cu-replace-de-sua-cong-thuc-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-cach-su-dung-cong-cu-replace-de-sua-cong-thuc-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Replace \u0111\u1ec3 s\u1eeda c\u00f4ng th\u1ee9c Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Replace l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu\u00a0\u00edch\u00a0\u0111\u1ec3 s\u1eeda ch\u1eefa, thay th\u1ebf n\u1ed9i dung trong\u00a0Excel.\u00a0\u0110\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a Replace l\u00e0 n\u00f3 cho ph\u00e9p ch\u00fang ta s\u1eeda c\u00e1c\u00a0n\u1ed9i dung\u00a0trong c\u00f4ng th\u1ee9c m\u1ed9t c\u00e1ch tr\u1ef1c ti\u1ebfp. Trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc\u00a0Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Replace\u00a0\u0111\u1ec3 s\u1eeda c\u00f4ng th\u1ee9c trong\u00a0Excel:<\/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-6786855ac6acd\" 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\/huong-dan-cach-su-dung-cong-cu-replace-de-sua-cong-thuc-excel.html#1_Yeu_cau\" title=\"1. Y\u00eau c\u1ea7u\">1. Y\u00eau c\u1ea7u<\/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\/huong-dan-cach-su-dung-cong-cu-replace-de-sua-cong-thuc-excel.html#2_Cach_mo_cong_cu_Replace_trong_Excel\" title=\"2. C\u00e1ch\u00a0m\u1edf c\u00f4ng c\u1ee5 Replace trong\u00a0Excel\">2. C\u00e1ch\u00a0m\u1edf c\u00f4ng c\u1ee5 Replace trong\u00a0Excel<\/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-su-dung-cong-cu-replace-de-sua-cong-thuc-excel.html#3_Cach_sua_cong_thuc_bang_cong_cu_Replace\" title=\"3. C\u00e1ch s\u1eeda c\u00f4ng th\u1ee9c b\u1eb1ng c\u00f4ng c\u1ee5 Replace\">3. C\u00e1ch s\u1eeda c\u00f4ng th\u1ee9c b\u1eb1ng c\u00f4ng c\u1ee5 Replace<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Yeu_cau\"><\/span>1. Y\u00eau c\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong b\u1ea3ng d\u1eef li\u1ec7u d\u01b0\u1edbi\u00a0\u0111\u00e2y c\u00f4ng th\u1ee9c t\u1ea1i c\u1ed9t D\u00a0\u0111ang ra k\u1ebft qu\u1ea3 l\u00e0 0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17909\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/heo-sua-loi-cong-thuc-01.png\" width=\"527\" height=\"167\" title=\"heo-sua-loi-cong-thuc-01\"><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta c\u1ea7n thay\u00a0\u0111\u1ed5i c\u00f4ng th\u1ee9c\u00a0\u1edf c\u1ed9t D\u00a0\u0111\u1ec3 thay\u00a0\u0111\u1ed5i tham chi\u1ebfu c\u1ed9t B sang c\u1ed9t A<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Cach_mo_cong_cu_Replace_trong_Excel\"><\/span>2. C\u00e1ch\u00a0m\u1edf c\u00f4ng c\u1ee5 Replace trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Thay v\u00ec s\u1eeda tr\u1ef1c ti\u1ebfp b\u1eb1ng tay th\u00ec ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Replace\u00a0\u0111\u1ec3 s\u1eeda.<\/p>\n<p>\u0110\u1ec3 m\u1edf c\u00f4ng c\u1ee5 n\u00e0y, c\u00e1c b\u1ea1n b\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft <strong>Ctrl + H<\/strong> ho\u1eb7c trong <strong>th\u1ebb Home<\/strong> ch\u1ecdn m\u1ee5c <strong>Find &amp; Select<\/strong> v\u00e0 ch\u1ecdn <strong>Replace<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17914\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/heo-replace-excel.png\" width=\"280\" height=\"437\" title=\"heo-replace-excel\"><\/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-189.gif\" title=\"ex101_92019-nho-189\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"3_Cach_sua_cong_thuc_bang_cong_cu_Replace\"><\/span>3. C\u00e1ch s\u1eeda c\u00f4ng th\u1ee9c b\u1eb1ng c\u00f4ng c\u1ee5 Replace<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>B\u01b0\u1edbc 1: X\u00e1c\u00a0\u0111\u1ecbnh n\u1ed9i dung c\u1ea7n s\u1eeda<\/strong><\/p>\n<p>Trong c\u00f4ng th\u1ee9c\u00a0\u1edf c\u1ed9t D c\u1ea7n s\u1eeda tham chi\u1ebfu c\u1ed9t B th\u00e0nh c\u1ed9t A:<\/p>\n<ul>\n<li>T\u1ea1i D2: s\u1eeda B2 th\u00e0nh A2<\/li>\n<li>T\u1ea1i D3 s\u1eeda B3 th\u00e0nh A3<\/li>\n<li>Ti\u1ebfp t\u1ee5c nh\u01b0 v\u1eady cho t\u1edbi h\u1ebft D6<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2: Th\u1ef1c hi\u1ec7n theo tr\u00ecnh t\u1ef1 sau<\/strong><\/p>\n<ul>\n<li>1-L\u1ef1a ch\u1ecdn\u00a0\u00f4 D2 (\u0111\u1eb7t v\u1ecb tr\u00ed ch\u1ecdn t\u1ea1i\u00a0\u00f4 D2)<\/li>\n<li>2-Trong Replace\u00a0\u0111\u1eb7t Find\u00a0what = B, Replace\u00a0with = A (thay k\u00fd t\u1ef1 B th\u00e0nh k\u00fd t\u1ef1 A)<\/li>\n<li>3-Th\u1ee9 t\u1ef1 search ch\u1ecdn By Columns (do s\u1eeda trong c\u00f9ng 1 c\u1ed9t n\u00ean s\u1ebd search theo c\u1ed9t)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17916\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/heo-cac-buoc-sua-trong-replace.png\" width=\"1198\" height=\"340\" title=\"heo-cac-buoc-sua-trong-replace\"><\/p>\n<p><strong>B\u01b0\u1edbc 3: L\u1ea7n l\u01b0\u1ee3t b\u1ea5m Replace v\u00e0 ki\u1ec3m tra k\u1ebft qu\u1ea3\u00a0\u1edf c\u1ed9t D t\u1eeb D2 t\u1edbi D6<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17917\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/heo-cac-buoc-sua-trong-replace-hoan-thanh.png\" width=\"1198\" height=\"337\" title=\"heo-cac-buoc-sua-trong-replace-hoan-thanh\"><\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eeda c\u00f4ng th\u1ee9c b\u1eb1ng c\u00f4ng c\u1ee5 Replace trong\u00a0Excel r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n \u201c<strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong>\u201c.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0\u0111\u00e1p\u00a0\u1ee9ng y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel. Chi ti\u1ebft kh\u00f3a h\u1ecdc xem t\u1ea1i:<\/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-189.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10558,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10557","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\/10557","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=10557"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10557\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10558"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10557"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10557"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}