{"id":3506,"date":"2024-12-03T02:43:05","date_gmt":"2024-12-03T02:43:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-bo-dau-cham-trong-day-so-dien-thoai-tren-excel\/"},"modified":"2024-12-03T02:43:05","modified_gmt":"2024-12-03T02:43:05","slug":"huong-dan-cach-bo-dau-cham-trong-day-so-dien-thoai-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-bo-dau-cham-trong-day-so-dien-thoai-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Ch\u00fang ta th\u01b0\u1eddng c\u00f3 th\u00f3i quen s\u1eed d\u1ee5ng d\u1ea5u ch\u1ea5m\u00a0\u0111\u1ec3 ng\u0103n c\u00e1ch c\u00e1c th\u00e0nh ph\u1ea7n trong d\u00e3y s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i. Tuy nhi\u00ean vi\u1ec7c\u00a0\u0111\u00f3\u00a0\u1ea3nh h\u01b0\u1edfng t\u1edbi m\u1ed9t s\u1ed1 m\u1ee5c\u00a0\u0111\u00edch t\u00ednh to\u00e1n. V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 <strong>b\u1ecf d\u1ea5u ch\u1ea5m<\/strong> trong d\u00e3y s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i tr\u00ean\u00a0Excel? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.<\/em><\/p>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 c\u00e1c s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i nh\u01b0 sau:<\/p>\n<figure id=\"attachment_24003\" aria-describedby=\"caption-attachment-24003\" style=\"width: 319px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-24003 size-full\" title=\"1 - c\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i tr\u00ean Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/yeu-cau-bo-dau-cham-trong-day-so-dien-thoai.png\" alt=\"1 - c\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i tr\u00ean Excel\" width=\"319\" height=\"260\"><figcaption id=\"caption-attachment-24003\" class=\"wp-caption-text\">1 \u2013 c\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i tr\u00ean Excel<\/figcaption><\/figure>\n<p>\u0110\u1ec3 b\u1ecf d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1 n\u00e0y, ch\u00fang ta\u00a0c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c c\u00e1ch sau:<\/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-674e70381c20c\" 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\/huong-dan-cach-bo-dau-cham-trong-day-dien-thoai-tren-excel.html#Su_dung_cong_cu_Find_Replace_de_bo_dau_cham\" title=\"S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Find &amp; Replace\u00a0\u0111\u1ec3 b\u1ecf d\u1ea5u ch\u1ea5m\">S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Find &amp; Replace\u00a0\u0111\u1ec3 b\u1ecf d\u1ea5u ch\u1ea5m<\/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\/huong-dan-cach-bo-dau-cham-trong-day-dien-thoai-tren-excel.html#Su_dung_ham_SUBSTITUTE_de_loai_bo_dau_cham\" title=\"S\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE \u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1ea5u ch\u1ea5m\">S\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE \u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1ea5u ch\u1ea5m<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_cong_cu_Find_Replace_de_bo_dau_cham\"><\/span>S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Find &amp; Replace\u00a0\u0111\u1ec3 b\u1ecf d\u1ea5u ch\u1ea5m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n c\u00f3 th\u1ec3 m\u1edf c\u1eeda s\u1ed5 <strong>Find &amp; Replace<\/strong> trong\u00a0Excel v\u1edbi ph\u00edm t\u1eaft <strong>Ctrl + H<\/strong><\/p>\n<p>Trong c\u1eeda s\u1ed5 Find and Replace ch\u00fang ta th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>Find\u00a0what: nh\u1eadp d\u1ea5u ch\u1ea5m<\/li>\n<li>Replace\u00a0with: kh\u00f4ng nh\u1eadp n\u1ed9i dung g\u00ec<\/li>\n<\/ul>\n<figure id=\"attachment_24004\" aria-describedby=\"caption-attachment-24004\" style=\"width: 667px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-24004 size-full\" title=\"2- c\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i tr\u00ean Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/replace-loai-bo-dau-cham.png\" alt=\"2- c\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i tr\u00ean Excel\" width=\"667\" height=\"250\"><figcaption id=\"caption-attachment-24004\" class=\"wp-caption-text\">2- c\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i tr\u00ean Excel<\/figcaption><\/figure>\n<p>Sau\u00a0\u0111\u00f3 b\u1ea5m v\u00e0o Replace\u00a0\u0111\u1ec3 lo\u1ea1i b\u1ecf\u00a0d\u1ea5u ch\u1ea5m trong t\u1eebng\u00a0\u00f4; ho\u1eb7c Replace All\u00a0\u0111\u1ec3 b\u1ecf\u00a0\u0111i to\u00e0n b\u1ed9 d\u1ea5u ch\u1ea5m trong t\u1ea5t c\u1ea3 c\u00e1c\u00a0\u00f4 (ch\u00fa\u00a0\u00fd c\u00f3 th\u1ec3\u00a0x\u00f3a nh\u1ea7m d\u1ea5u ch\u1ea5m trong c\u00e1c\u00a0\u00f4 kh\u00e1c kh\u00f4ng ph\u1ea3i\u00a0\u00f4 ch\u1ee9a s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i)<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_SUBSTITUTE_de_loai_bo_dau_cham\"><\/span>S\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE \u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1ea5u ch\u1ea5m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>T\u1ea1i\u00a0\u00f4 B2 ch\u00fang ta nh\u1eadp c\u00f4ng th\u1ee9c sau:<\/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-270.gif\" title=\"ex101_92019-nho-270\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_24005\" aria-describedby=\"caption-attachment-24005\" style=\"width: 560px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-24005 size-full\" title=\"3- c\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i tr\u00ean Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-substitute-loai-bo-dau-cham.png\" alt=\"3- c\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i tr\u00ean Excel\" width=\"560\" height=\"142\"><figcaption id=\"caption-attachment-24005\" class=\"wp-caption-text\">3- c\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i tr\u00ean Excel<\/figcaption><\/figure>\n<p>=SUBSTITUTE(<span style=\"color: #ff00ff\"><strong>A2<\/strong><\/span>,<span style=\"color: #ff0000\"><strong>\u201c.\u201d<\/strong><\/span>,<span style=\"color: #0000ff\"><strong>\u201c\u201d<\/strong><\/span>)<\/p>\n<p>H\u00e0m n\u00e0y c\u00f3\u00a0\u00fd ngh\u0129a:<\/p>\n<p>Thay th\u1ebf k\u00fd t\u1ef1 d\u1ea5u ch\u1ea5m trong\u00a0\u00f4 A2 th\u00e0nh k\u00fd t\u1ef1 r\u1ed7ng, t\u01b0\u01a1ng\u00a0\u0111\u01b0\u01a1ng v\u1edbi vi\u1ec7c lo\u1ea1i b\u1ecf k\u00fd t\u1ef1 d\u1ea5u ch\u1ea5m kh\u1ecfi\u00a0\u00f4 A2<\/p>\n<p>C\u00e1c th\u00e0nh ph\u1ea7n trong h\u00e0m SUBSTITUTE g\u1ed3m:<\/p>\n<ul>\n<li><strong>Text<\/strong>:\u00a0\u0111o\u1ea1n text c\u1ea7n ki\u1ec3m tra (\u00f4 A2)<\/li>\n<li><strong>old_text<\/strong>: k\u00fd t\u1ef1 c\u1ea7n thay\u00a0\u0111\u1ed5i (d\u1ea5u ch\u1ea5m, d\u1ea5u n\u00e0y\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1eb7t trong c\u1eb7p d\u1ea5u nh\u00e1y k\u00e9p)<\/li>\n<li><strong>new_text<\/strong>: k\u00fd t\u1ef1 m\u1edbi s\u1ebd thay\u00a0\u0111\u1ed5i cho old_text (c\u1eb7p d\u1ea5u nh\u00e1y k\u00e9p li\u1ec1n nhau ngh\u0129a l\u00e0 r\u1ed7ng, kh\u00f4ng c\u00f3 k\u00fd t\u1ef1 g\u00ec)<\/li>\n<\/ul>\n<p>Th\u1eadt\u00a0\u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o? Kh\u00f4ng ch\u1ec9 c\u00f3 th\u1ec3 b\u1ecf d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i tr\u00ean Excel m\u00e0 b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng ki\u1ebfn th\u1ee9c n\u00e0y l\u00e0m c\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y tr\u00ean Excel. Ch\u00fac c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng t\u1ed1t ki\u1ebfn th\u1ee9c n\u00e0y v\u00e0o c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/p>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3\u00a0\u0111\u1ecdc th\u00eam m\u1ed9t s\u1ed1\u00a0b\u00e0i vi\u1ebft v\u1ec1 x\u1eed l\u00fd s\u1ed1\u00a0\u0111i\u1ec7n tho\u1ea1i trong\u00a0Excel nh\u01b0:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-doi-dien-thoai-tu-11-so-thanh-10-so-tren-excel-chi-tiet-nhat.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ed5i s\u1ed1 \u0111i\u1ec7n tho\u1ea1i t\u1eeb 11 s\u1ed1 th\u00e0nh 10 s\u1ed1 tr\u00ean Excel chi ti\u1ebft nh\u1ea5t<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tach-dien-thoai-ra-khoi-noi-dung-text.html\">T\u00e1ch s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ra kh\u1ecfi n\u1ed9i dung text<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/4-cach-de-nhap-so-dien-thoai-trong-excel-ma-khong-mat-so-0.html\">4 c\u00e1ch \u0111\u1ec3 nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel m\u00e0 kh\u00f4ng m\u1ea5t s\u1ed1 0<\/a><\/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\/2024\/12\/ex101_92019-nho-270.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3507,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3506","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\/3506","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=3506"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3506\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3507"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}