{"id":580,"date":"2024-12-02T02:31:31","date_gmt":"2024-12-02T02:31:31","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-dem-ky-tu-ky-tu-dac-biet-trong-mot-o-hoac-mot-dai-o-trong-excel\/"},"modified":"2024-12-02T02:31:31","modified_gmt":"2024-12-02T02:31:31","slug":"huong-dan-cach-dem-ky-tu-ky-tu-dac-biet-trong-mot-o-hoac-mot-dai-o-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-dem-ky-tu-ky-tu-dac-biet-trong-mot-o-hoac-mot-dai-o-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ebfm k\u00fd t\u1ef1, k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t d\u1ea3i \u00f4 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p style=\"text-align: justify\">B\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a>\u00a0s\u1ebd gi\u1ea3i th\u00edch c\u00e1ch \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong Excel. B\u1ea1n s\u1ebd bi\u1ebft \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c \u0111\u1ebfm t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 trong m\u1ed9t d\u1ea3i \u00f4, hay c\u00f4ng th\u1ee9c d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm ch\u1ec9 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong m\u1ed9t \u00f4 hay v\u00e0i \u00f4.<\/p>\n<p style=\"text-align: justify\">Trong b\u00e0i h\u01b0\u1edbng d\u1eabn tr\u01b0\u1edbc, ch\u00fang t\u00f4i \u0111\u00e3 gi\u1edbi thi\u1ec7u <a href=\"http:\/\/blog.ezworkapp.com\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m LEN<\/a> trong Excel, h\u00e0m n\u00e0y cho ph\u00e9p ch\u00fang ta \u0111\u1ebfm t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4.<\/p>\n<p style=\"text-align: justify\">Ch\u1ec9 d\u00f9ng h\u00e0m LEN th\u00f4i c\u0169ng r\u1ea5t hi\u1ec7u qu\u1ea3 r\u1ed3i, nh\u01b0ng khi k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 h\u00e0m SUM, SUMPRODUCT, v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html\" target=\"_blank\" rel=\"noopener noreferrer\">SUBSTITUTE<\/a> th\u00ec h\u00e0m LEN c\u00f3 th\u1ec3 gi\u1ea3i \u0111\u01b0\u1ee3c c\u00e1c b\u00e0i to\u00e1n ph\u1ee9c t\u1ea1p h\u01a1n r\u1ea5t nhi\u1ec1u. Ti\u1ebfp t\u1ee5c trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, ch\u00fang ta s\u1ebd xem x\u00e9t k\u1ef9 h\u01a1n c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n v\u00e0 n\u00e2ng cao \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong Excel.<\/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-674d1c028585d\" 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-dem-ky-tu-ky-tu-dac-biet-trong-mot-o-hoac-mot-dai-o-trong-excel.html#CACH_DEM_TAT_CA_KY_TU_TRONG_MOT_DAI_O\" title=\"C\u00c1CH \u0110\u1ebeM T\u1ea4T C\u1ea2 K\u00dd T\u1ef0 TRONG M\u1ed8T D\u1ea2I \u00d4\">C\u00c1CH \u0110\u1ebeM T\u1ea4T C\u1ea2 K\u00dd T\u1ef0 TRONG M\u1ed8T D\u1ea2I \u00d4<\/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-dem-ky-tu-ky-tu-dac-biet-trong-mot-o-hoac-mot-dai-o-trong-excel.html#LAM_THE_NAO_DE_DEM_CAC_KY_TU_DAC_BIET_TRONG_MOT_O\" title=\"L\u00c0M TH\u1ebe N\u00c0O \u0110\u1ec2 \u0110\u1ebeM C\u00c1C K\u00dd T\u1ef0 \u0110\u1eb6C BI\u1ec6T TRONG M\u1ed8T \u00d4\">L\u00c0M TH\u1ebe N\u00c0O \u0110\u1ec2 \u0110\u1ebeM C\u00c1C K\u00dd T\u1ef0 \u0110\u1eb6C BI\u1ec6T TRONG M\u1ed8T \u00d4<\/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\/huong-dan-cach-dem-ky-tu-ky-tu-dac-biet-trong-mot-o-hoac-mot-dai-o-trong-excel.html#DUNG_HAM_KHONG_PHAN_BIET_DANG_CHU_TRONG_EXCEL_DE_DEM_CAC_KY_TU_DAC_BIET_TRONG_MOT_O\" title=\"D\u00d9NG H\u00c0M KH\u00d4NG PH\u00c2N BI\u1ec6T D\u1ea0NG CH\u1eee TRONG EXCEL \u0110\u1ec2 \u0110\u1ebeM C\u00c1C K\u00dd T\u1ef0 \u0110\u1eb6C BI\u1ec6T TRONG M\u1ed8T \u00d4\">D\u00d9NG H\u00c0M KH\u00d4NG PH\u00c2N BI\u1ec6T D\u1ea0NG CH\u1eee TRONG EXCEL \u0110\u1ec2 \u0110\u1ebeM C\u00c1C K\u00dd T\u1ef0 \u0110\u1eb6C BI\u1ec6T TRONG M\u1ed8T \u00d4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dem-ky-tu-ky-tu-dac-biet-trong-mot-o-hoac-mot-dai-o-trong-excel.html#DEM_SU_XUAT_HIEN_CUA_MOT_KY_TU_NHAT_DINH_HAY_CHUOI_CON_TRONG_MOT_O\" title=\"\u0110\u1ebeM S\u1ef0 XU\u1ea4T HI\u1ec6N C\u1ee6A M\u1ed8T K\u00dd T\u1ef0 NH\u1ea4T \u0110\u1ecaNH HAY CHU\u1ed6I CON TRONG M\u1ed8T \u00d4\">\u0110\u1ebeM S\u1ef0 XU\u1ea4T HI\u1ec6N C\u1ee6A M\u1ed8T K\u00dd T\u1ef0 NH\u1ea4T \u0110\u1ecaNH HAY CHU\u1ed6I CON TRONG M\u1ed8T \u00d4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dem-ky-tu-ky-tu-dac-biet-trong-mot-o-hoac-mot-dai-o-trong-excel.html#LAM_THE_NAO_DE_DEM_CAC_KY_TU_DAC_BIET_TRONG_MOT_DAI_O\" title=\"L\u00c0M TH\u1ebe N\u00c0O \u0110\u1ec2 \u0110\u1ebeM C\u00c1C K\u00dd T\u1ef0 \u0110\u1eb6C BI\u1ec6T TRONG M\u1ed8T D\u1ea2I \u00d4\">L\u00c0M TH\u1ebe N\u00c0O \u0110\u1ec2 \u0110\u1ebeM C\u00c1C K\u00dd T\u1ef0 \u0110\u1eb6C BI\u1ec6T TRONG M\u1ed8T D\u1ea2I \u00d4<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_DEM_TAT_CA_KY_TU_TRONG_MOT_DAI_O\"><\/span>C\u00c1CH \u0110\u1ebeM T\u1ea4T C\u1ea2 K\u00dd T\u1ef0 TRONG M\u1ed8T D\u1ea2I \u00d4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi n\u00f3i \u0111\u1ebfn vi\u1ec7c \u0111\u1ebfm t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 trong m\u1ed9t v\u00e0i \u00f4 th\u00ec gi\u1ea3i ph\u00e1p m\u00e0 b\u1ea1n ngh\u0129 ngay \u0111\u1ebfn \u0111\u00f3 ch\u00ednh l\u00e0 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed7i \u00f4, r\u1ed3i c\u1ed9ng c\u00e1c con s\u1ed1 \u0111\u00f3 l\u1ea1i:<\/p>\n<p style=\"text-align: justify\"><strong><em>=LEN(A2)+(A3)+(A4)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Hay<\/p>\n<p style=\"text-align: justify\"><em><strong>=SUM(LEN(A2),LEN(A3),LEN(A4))<\/strong><\/em><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-6.gif\" title=\"vba101_92019-nho-6\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-29.gif\" title=\"ex101_92019-nho-29\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">C\u00e1c c\u00f4ng th\u1ee9c tr\u00ean c\u00f3 l\u1ebd s\u1ebd hi\u1ec7u qu\u1ea3 trong m\u1ed9t d\u1ea3i \u00f4 nh\u1ecf. \u0110\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 trong m\u1ed9t d\u1ea3i \u00f4 l\u1edbn h\u01a1n, ch\u00fang ta n\u00ean ngh\u0129 ra m\u1ed9t c\u00f4ng th\u1ee9c kh\u00e1c g\u1ecdn h\u01a1n, v\u00ed d\u1ee5: h\u00e0m SUMPRODUCT, h\u00e0m n\u00e0y s\u1ebd c\u1ed9ng c\u00e1c m\u1ea3ng l\u1ea1i v\u1edbi nhau r\u1ed3i tr\u1ea3 v\u1ec1 t\u1ed5ng c\u1ee7a c\u00e1c k\u1ebft qu\u1ea3 \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 c\u00f4ng th\u1ee9c chung trong Excel \u0111\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 trong m\u1ed9t d\u1ea3i \u00f4:<\/p>\n<p style=\"text-align: justify\"><strong><em>=SUMPRODUCT(LEN(d\u1ea3i \u00f4))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u00e0 khi \u00e1p d\u1ee5ng n\u00f3 s\u1ebd tr\u00f4ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong><em>=SUMPRODUCT(LEN(A1:A7))<\/em><\/strong><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5086 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-characters-excel-1.png\" width=\"600\" height=\"277\" title=\"count-characters-excel-1\"><\/p>\n<p style=\"text-align: justify\">C\u00e1ch kh\u00e1c \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t d\u1ea3i \u00f4 \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng h\u00e0m LEN k\u1ebft h\u1ee3p v\u1edbi h\u00e0m SUM:<\/p>\n<p style=\"text-align: justify\"><strong><em>=SUM(LEN(A1:A7))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Kh\u00f4ng gi\u1ed1ng h\u00e0m SUMPRODUCT, h\u00e0m SUM kh\u00f4ng t\u00ednh c\u00e1c m\u1ea3ng m\u1ed9t c\u00e1ch m\u1eb7c \u0111\u1ecbnh, v\u00e0 b\u1ea1n c\u1ea7n ph\u1ea3i nh\u1ea5n <strong><em>Ctrl+Shift+Enter<\/em><\/strong> \u0111\u1ec3 \u0111\u01b0a n\u00f3 v\u1ec1 c\u00f4ng th\u1ee9c m\u1ea3ng.<\/p>\n<p style=\"text-align: justify\">Khi \u0111\u01b0\u1ee3c di\u1ec5n gi\u1ea3i trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, h\u00e0m SUM tr\u1ea3 v\u1ec1 c\u00f9ng m\u1ed9t k\u1ebft qu\u1ea3 s\u1ed1 k\u00fd t\u1ef1:<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5087 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-characters-excel-1-1.png\" width=\"600\" height=\"277\" title=\"count-characters-excel-1-1\"><\/p>\n<p>C\u00d4NG TH\u1ee8C \u0110\u1ebeM S\u1ed0 K\u00dd T\u1ef0 TRONG M\u1ed8T D\u1ea2I \u00d4 HO\u1ea0T \u0110\u1ed8NG NH\u01af TH\u1ebe N\u00c0O<\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng th\u1ee9c d\u1ec5 nh\u1ea5t \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong Excel. H\u00e0m LEN t\u00ednh to\u00e1n chi\u1ec1u d\u00e0i chu\u1ed7i cho m\u1ed7i \u00f4 trong m\u1ed9t d\u1ea3i \u00f4 x\u00e1c \u0111\u1ecbnh r\u1ed3i tr\u1ea3 v\u1ec1 m\u1ed9t d\u00e3y s\u1ed1. Sau \u0111\u00f3, h\u00e0m SUMPRODUCT hay SUM c\u1ed9ng c\u00e1c con s\u1ed1 n\u00e0y v\u1edbi nhau v\u00e0 hi\u1ec7n k\u1ebft qu\u1ea3 l\u00e0 t\u1ed5ng s\u1ed1 c\u00e1c k\u00fd t\u1ef1.<\/p>\n<p style=\"text-align: justify\">Trong c\u00e1c v\u00ed d\u1ee5 tr\u00ean, m\u1ed9t d\u00e3y g\u1ed3m b\u1ea3y con s\u1ed1ch\u00ednh l\u00e0 chi\u1ec1u d\u00e0i chu\u1ed7i trong c\u00e1c \u00f4 t\u1eeb A1 \u0111\u1ebfn A7 khi \u0111\u01b0\u1ee3c c\u1ed9ng:<\/p>\n<p style=\"text-align: justify\"><strong><em>=SUMPRODUCT({28;29;27;23;27;29;30})<\/em><\/strong><\/p>\n<ul style=\"list-style-type: square\">\n<li style=\"text-align: justify\"><em><strong>L\u01b0u \u00fd.<\/strong> H\u00e3y ch\u00fa \u00fd r\u1eb1ng h\u00e0m LEN trong Excel c\u1ed9ng <strong>t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 trong m\u1ed7i \u00f4<\/strong> m\u1ed9t c\u00e1ch tuy\u1ec7t \u0111\u1ed1i, k\u1ec3 c\u1ea3 ch\u1eef c\u00e1i, ch\u1eef s\u1ed1, d\u1ea5u c\u00e2u, k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t, v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c kho\u1ea3ng tr\u1ed1ng (th\u1ee5t \u0111\u1ea7u d\u00f2ng, th\u1ee5t cu\u1ed1i d\u00f2ng v\u00e0 kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c t\u1eeb).<\/em><\/li>\n<\/ul>\n<blockquote>\n<p>Xem ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">l\u1edbp h\u1ecdc VBA \u1edf H\u00e0 N\u1ed9i<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"LAM_THE_NAO_DE_DEM_CAC_KY_TU_DAC_BIET_TRONG_MOT_O\"><\/span>L\u00c0M TH\u1ebe N\u00c0O \u0110\u1ec2 \u0110\u1ebeM C\u00c1C K\u00dd T\u1ef0 \u0110\u1eb6C BI\u1ec6T TRONG M\u1ed8T \u00d4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Th\u1ec9nh tho\u1ea3ng, thay v\u00ec ph\u1ea3i \u0111\u1ebfm t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 c\u1ea7n ph\u1ea3i \u0111\u1ebfm s\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t k\u00fd t\u1ef1, ch\u1eef s\u1ed1, hay bi\u1ec3u t\u01b0\u1ee3ng \u0111\u1eb7c bi\u1ec7t.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1ebfm t\u1ea7n su\u1ea5t xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh trong m\u1ed9t \u00f4, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m LEN k\u1ebft h\u1ee3p v\u1edbi h\u00e0m SUBSTITUTE:<\/p>\n<p style=\"text-align: justify\"><strong><em>=LEN(\u00f4)-LEN(SUBSTITUTE(\u00f4, k\u00fd t\u1ef1,\u201d\u201d))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec3u r\u00f5 v\u00ed d\u1ee5 h\u01a1n, h\u00e3y xem qua v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y nh\u00e9.<\/p>\n<p style=\"text-align: justify\">G\u1ec9\u1ea3 s\u1eed, b\u1ea1n l\u01b0u gi\u1eef m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a nh\u1eefng m\u00f3n h\u00e0ng \u0111\u01b0\u1ee3c giao, n\u01a1i m\u00e0 m\u1ed7i lo\u1ea1i h\u00e0ng c\u00f3 k\u00fd hi\u1ec7u nh\u1eadn d\u1ea1ng ri\u00eang bi\u1ec7t. V\u00e0 m\u1ed7i \u00f4 c\u00f3 m\u1ed9t v\u00e0i m\u00f3n h\u00e0ng c\u00e1ch nhau b\u1edfi d\u1ea5u ph\u1ea9y, kho\u1ea3ng tr\u1ed1ng, hay b\u1ea5t c\u1ee9 d\u1ea5u ph\u00e2n c\u00e1ch n\u00e0o. Nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 h\u00e3y \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a k\u00fd hi\u1ec7u nh\u1eadn d\u1ea1ng ri\u00eang bi\u1ec7t \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh trong m\u1ed7i \u00f4.<\/p>\n<p style=\"text-align: justify\">G\u1ec9\u1ea3 s\u1eed r\u1eb1ng danh s\u00e1ch c\u00e1c m\u00f3n h\u00e0ng n\u1eb1m \u1edf c\u1ed9t B (b\u1eaft \u0111\u1ea7u t\u1eeb B2) v\u00e0 ch\u00fang ta s\u1ebd \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a \u201cA\u201d, d\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><strong><em>=LEN(B2)-LEN(SUBSTITUTE(B2,\u201dA\u201d,\u201d\u201d))<\/em><\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5088 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-specific-char.png\" width=\"600\" height=\"343\" title=\"count-specific-char\"><\/p>\n<p style=\"text-align: justify\">C\u00d4NG TH\u1ee8C \u0110\u1ebeM K\u00dd T\u1ef0 N\u00c0Y TRONG EXCEL HO\u1ea0T \u0110\u1ed8NG NH\u01af TH\u1ebe N\u00c0O<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec3u quy lu\u1eadt c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y, h\u00e3y chia n\u00f3 ra th\u00e0nh t\u1eebng ph\u1ea7n nh\u1ecf:<\/p>\n<p style=\"text-align: justify\">\u0110\u1ea7u ti\u00ean, b\u1ea1n \u0111\u1ebfm t\u1ed5ng chi\u1ec1u d\u00e0i chu\u1ed7i c\u1ee7a \u00f4 B2:<\/p>\n<p style=\"text-align: justify\"><strong><em>LEN(B2)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, b\u1ea1n d\u00f9ng h\u00e0m SUBSTITUTE \u0111\u1ec3 lo\u1ea1i b\u1ecf s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a \u201cA\u201d trong B2 b\u1eb1ng c\u00e1ch thay th\u1ebf n\u00f3 b\u1eb1ng m\u1ed9t chu\u1ed7i r\u1ed7ng(\u201c\u201d):<\/p>\n<p style=\"text-align: justify\"><strong><em>SUBSTITUTE(B2,\u201dA\u201d,\u201d\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, b\u1ea1n \u0111\u1ebfm chi\u1ec1u d\u00e0i chu\u1ed7i m\u00e0 kh\u00f4ng c\u00f3 k\u00fd t\u1ef1 \u201cA\u201d:<\/p>\n<p style=\"text-align: justify\"><strong><em>LEN(SUBSTITUTE(B2,\u201dA\u201d,\u201d\u201d))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Cu\u1ed1i c\u00f9ng, b\u1ea1n l\u1ea5y t\u1ed5ng chi\u1ec1u d\u00e0i chu\u1ed7i tr\u1eeb cho chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i kh\u00f4ng c\u00f3 k\u00fd t\u1ef1 \u201cA\u201d.<\/p>\n<p style=\"text-align: justify\">Do \u0111\u00f3, b\u1ea1n t\u00ednh \u0111\u01b0\u1ee3c s\u1ed1 k\u00fd t\u1ef1 \u201c\u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf\u201d, k\u1ebft qu\u1ea3 n\u00e0y c\u0169ng l\u00e0 s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a k\u00fd t\u1ef1 \u0111\u00f3 trong m\u1ed9t \u00f4.<\/p>\n<p style=\"text-align: justify\">Thay v\u00ec x\u00e1c \u0111\u1ecbnh k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n \u0111\u1ebfm trong c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 g\u00f5 n\u00f3 v\u00e0o m\u1ed9t v\u00e0i \u00f4, r\u1ed3i tham chi\u1ebfu \u00f4 \u0111\u00f3 trong c\u00f4ng th\u1ee9c. B\u1eb1ng c\u00e1ch n\u00e0y, ng\u01b0\u1eddi d\u00f9ng c\u1ee7a b\u1ea1n s\u1ebd c\u00f3 kh\u1ea3 n\u0103ng \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a b\u1ea5t c\u1ee9 k\u00fd t\u1ef1 n\u00e0o h\u1ecd nh\u1eadp v\u00e0o \u00f4 \u0111\u00f3 m\u00e0 kh\u00f4ng ph\u00e1 c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5089 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/formula-count-specific-char.png\" width=\"600\" height=\"352\" title=\"formula-count-specific-char\"><\/p>\n<ul style=\"list-style-type: square\">\n<li style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> H\u00e0m SUBSTITUTE c\u1ee7a Excel l\u00e0 m\u1ed9t h\u00e0m ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef, v\u00e0 v\u00ec th\u1ebf c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean \u0111\u1ec1u ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef theo. V\u00ed d\u1ee5, trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean, \u00f4 B3 c\u00f3 3 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a \u201cA\u201d-hai l\u1ea7n vi\u1ebft hoa, v\u00e0 m\u1ed9t l\u1ea7n vi\u1ebft th\u01b0\u1eddng. C\u00f4ng th\u1ee9 c ch\u1ec9 \u0111\u1ebfm c\u00e1c k\u00fd t\u1ef1 vi\u1ebft hoa b\u1edfi v\u00ec ch\u00fang ta cung c\u1ea5p \u201cA\u201d cho h\u00e0m SUBSTITUTE.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"DUNG_HAM_KHONG_PHAN_BIET_DANG_CHU_TRONG_EXCEL_DE_DEM_CAC_KY_TU_DAC_BIET_TRONG_MOT_O\"><\/span>D\u00d9NG H\u00c0M KH\u00d4NG PH\u00c2N BI\u1ec6T D\u1ea0NG CH\u1eee TRONG EXCEL \u0110\u1ec2 \u0110\u1ebeM C\u00c1C K\u00dd T\u1ef0 \u0110\u1eb6C BI\u1ec6T TRONG M\u1ed8T \u00d4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n m\u1ed9t ph\u00e9p \u0111\u1ebfm kh\u00f4ng ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef, h\u00e3y l\u1ed3ng gh\u00e9p h\u00e0m UPPER v\u00e0o h\u00e0m SUBSTITUTE \u0111\u1ec3 \u0111\u1ed5i k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh sang d\u1ea1ng vi\u1ebft hoa tr\u01b0\u1edbc khi ch\u1ea1y ph\u00e9p th\u1ebf. V\u00e0, h\u00e3y ch\u1eafc r\u1eb1ng b\u1ea1n \u0111\u00e3 nh\u1eadp k\u00fd t\u1ef1 vi\u1ebft hoa v\u00e0o c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 \u0111\u1ebfm c\u00e1c k\u00fd t\u1ef1 \u201cA\u201d v\u00e0 \u201ca\u201d trong \u00f4 B2, h\u00e3y d\u00f9ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong><em>=LEN(B2)-LEN(SUBSTITUTE(UPPER(B2),\u201dA\u201d,\u201d\u201d))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u00e1ch kh\u00e1c \u0111\u00f3 l\u00e0 l\u1ed3ng gh\u00e9p h\u00e0m SUBSTITUTE v\u00e0o:<\/p>\n<p style=\"text-align: justify\"><em><strong>=LEN(B2)-LEN(SUBSTITUTE(SUBSTITUTE(B2,\u201dA\u201d,\u201d\u201d),\u201da\u201d,\u201d\u201d))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y qua \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi, c\u1ea3 hai c\u00f4ng th\u1ee9c \u0111\u1ec1u \u0111\u1ebfm s\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh d\u01b0\u1edbi d\u1ea1ng vi\u1ebft hoa v\u00e0 vi\u1ebft th\u01b0\u1eddng m\u1ed9t c\u00e1ch ho\u00e0n h\u1ea3o:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5090 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-character-case-insensitive.png\" width=\"600\" height=\"174\" title=\"count-character-case-insensitive\"><\/p>\n<p style=\"text-align: justify\">Trong v\u00e0i tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n ph\u1ea3i \u0111\u1ebfm nhi\u1ec1u k\u00fd t\u1ef1 kh\u00e1c nhau trong m\u1ed9t b\u1ea3ng, nh\u01b0ng b\u1ea1n l\u1ea1i kh\u00f4ng mu\u1ed1n ph\u1ea3i \u0111i\u1ec1u ch\u1ec9nh c\u00f4ng th\u1ee9c m\u1ed7i l\u1ea7n t\u00ednh to\u00e1n. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, h\u00e3y l\u1ed3ng gh\u00e9p h\u00e0m SUBSTITUE n\u00e0y v\u00e0o h\u00e0m SUBSTITUTE kh\u00e1c, r\u1ed3i g\u00f5 k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n \u0111\u1ebfm v\u00e0o m\u1ed9t \u00f4 n\u00e0o \u0111\u00f3 (tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 \u00f4 D1), v\u00e0 \u0111\u1ed5i gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 \u00a0n\u00e0y sang d\u1ea1ng vi\u1ebft hoa v\u00e0 vi\u1ebft th\u01b0\u1eddng b\u1eb3ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UPPER v\u00e0 LOWER:<\/p>\n<p style=\"text-align: justify\"><strong><em>=LEN(B2)-LEN(SUBSTITUTE(SUBSTITUTE(B2, UPPER($D$1),\u201d\u201d),LOWER($D$1),\u201d\u201d))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e3y lu\u00e2n phi\u00ean thay \u0111\u1ed5i \u00f4 ngu\u1ed3n v\u00e0 \u00f4 ch\u1ee9a ho\u1eb7c k\u00fd t\u1ef1 vi\u1ebft th\u01b0\u1eddng ho\u1eb7c k\u00fd t\u1ef1 vi\u1ebft hoa v\u1edbi nhau. V\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong><em>=LEN(B2)_LEN(SUBSTITUTE(UPPER(B2),UPPER($C$1),\u201d\u201d))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec3m c\u1ed9ng c\u1ee7a c\u00e1ch n\u00e0y \u0111\u00f3 l\u00e0 d\u00f9 ta nh\u1eadp k\u00fd t\u1ef1 vi\u1ebft th\u01b0\u1eddng hay vi\u1ebft hoa v\u00e0o \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu th\u00ec <strong>c\u00f4ng th\u1ee9c \u0111\u1ebfm k\u00fd t\u1ef1 kh\u00f4ng ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef <\/strong>c\u1ee7a b\u1ea1n \u0111\u1ec1u \u00a0s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u1ebfm ch\u00ednh x\u00e1c:<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5091 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-case-insensitive-char.png\" width=\"600\" height=\"250\" title=\"count-case-insensitive-char\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"DEM_SU_XUAT_HIEN_CUA_MOT_KY_TU_NHAT_DINH_HAY_CHUOI_CON_TRONG_MOT_O\"><\/span>\u0110\u1ebeM S\u1ef0 XU\u1ea4T HI\u1ec6N C\u1ee6A M\u1ed8T K\u00dd T\u1ef0 NH\u1ea4T \u0110\u1ecaNH HAY CHU\u1ed6I CON TRONG M\u1ed8T \u00d4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t <strong>s\u1ef1 k\u1ebft h\u1ee3p c\u1ee5 th\u1ec3 c\u00e1c k\u00fd t\u1ef1<\/strong> (v\u00ed d\u1ee5, m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh, hay chu\u1ed7i con) trong m\u1ed9t \u00f4 x\u00e1c \u0111\u1ecbnh, v\u00ed d\u1ee5, \u201cA2\u201d hay \u201cSS\u201d th\u00ec h\u00e3y chia s\u1ed1 k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi c\u00f4ng th\u1ee9c tr\u00ean cho chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i con.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c <strong>ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef:<\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>=(LEN(B2)-LEN(SUBSTITUTE(B2,$C$1,\u201d\u201d)))\/LEN($C$1)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c <strong>kh\u00f4ng ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef:<\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>=(LEN(B2)-LEN(SUBSTITUTE(LOWER(B2),LOWER($C$1),\u201d\u201d)))\/LEN($C$1)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">B2 l\u00e0 \u00f4 ch\u1ee9a c\u1ea3 m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1, v\u00e0 C1 l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 (chu\u1ed7i con) m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5092 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-text-cell.png\" width=\"600\" height=\"252\" title=\"count-text-cell\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"LAM_THE_NAO_DE_DEM_CAC_KY_TU_DAC_BIET_TRONG_MOT_DAI_O\"><\/span>L\u00c0M TH\u1ebe N\u00c0O \u0110\u1ec2 \u0110\u1ebeM C\u00c1C K\u00dd T\u1ef0 \u0110\u1eb6C BI\u1ec6T TRONG M\u1ed8T D\u1ea2I \u00d4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Gi\u1edd th\u00ec b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00f4ng th\u1ee9c trong Excel d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c k\u00fd t\u1ef1 trong m\u1ed9t \u00f4, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n c\u1ea3i thi\u1ec7n n\u00f3 th\u00eam \u0111\u1ec3 t\u00ecm ra s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t k\u00fd t\u1ef1\u00a0nh\u1ea5t \u0111\u1ecbnh trong m\u1ed9t d\u1ea3i \u00f4. V\u1ec1 vi\u1ec7c n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm m\u1ed9t k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong m\u1ed9t \u00f4, \u0111i\u1ec1u n\u00e0y \u0111\u00e3 \u0111\u01b0\u1ee3c n\u00f3i \u0111\u1ebfn trong v\u00ed d\u1ee5 tr\u00ean, r\u1ed3i \u0111\u1eb7t n\u00f3 v\u00e0o h\u00e0m SUMPRODUCT, h\u00e0m n\u00e0y c\u00f3 th\u1ec3 gi\u00fap ta x\u1eed l\u00fd c\u00e1c m\u1ea3ng:<\/p>\n<p style=\"text-align: justify\"><strong><em>SUMPRODUCT(LEN(chu\u1ed7i)-LEN(SUBSTITUTE(chu\u1ed7i, k\u00fd t\u1ef1,\u201d\u201d)))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, c\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5095 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-specific-chars-range.png\" width=\"600\" height=\"258\" title=\"count-specific-chars-range\"><\/p>\n<p style=\"text-align: justify\"><strong><em>=SUMPRODUCT(LEN(B2:B8)-LEN(SUBSTITUTE(B2:B8,\u201dA\u201d,\u201d\u201d)))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u00e0 \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c kh\u00e1c d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c k\u00fd t\u1ef1 trong d\u1ea3i \u00f4 Excel:<\/p>\n<p style=\"text-align: justify\"><strong><em>=SUM(LEN(B2:B8)-LEN(SUBSTITUTE(B2:B8,\u201dA\u201d,\u201d\u201d)))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">So v\u1edbi c\u00f4ng th\u1ee9c \u0111\u1ea7u ti\u00ean, \u0111i\u1ec3m kh\u00e1c bi\u1ec7t d\u1ec5 nh\u1eadn th\u1ea5y nh\u1ea5t \u0111\u00f3 ch\u00ednh l\u00e0 vi\u1ec7c d\u00f9ng h\u00e0m SUM thay v\u00ec h\u00e0m SUMPRODUCT. \u0110i\u1ec3m kh\u00e1c bi\u1ec7t kh\u00e1c \u0111\u00f3 ch\u00ednh l\u00e0 b\u1ea1n ph\u1ea3i nh\u1ea5n Ctrl+Shift+Enter b\u1edfi v\u00ec kh\u00f4ng gi\u1ed1ng nh\u01b0 <a href=\"http:\/\/blog.ezworkapp.com\/47-%E2%97%8F-ham-sumproduct-va-su-khac-nhau-voi-sumifs-countifs-trong-excel.html\">h\u00e0m SUMPRODUCT<\/a>, l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c t\u1ea1o ra \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c m\u1ea3ng, h\u00e0m SUM c\u00f3 th\u1ec3 x\u1eed l\u00fd c\u00e1c m\u1ea3ng ch\u1ec9 khi \u0111\u01b0\u1ee3c d\u00f9ng trong <strong>c\u00f4ng th\u1ee9c m\u1ea3ng.<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu kh\u00f4ng mu\u1ed1n ghi trong c\u00f4ng th\u1ee9c m\u1ed9t c\u00e1ch c\u1ed1 \u0111\u1ecbnh trong c\u00f4ng th\u1ee9c, th\u00ec t\u1ea5t nhi\u00ean b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp n\u00f3 v\u00e0o m\u1ed9t \u00f4 n\u00e0o \u0111\u00f3, v\u00ed d\u1ee5 l\u00e0 \u00f4 D1, r\u1ed3i tham chi\u1ebfu \u00f4 \u0111\u00f3 v\u00e0o c\u00f4ng th\u1ee9c \u0111\u1ebfm k\u00fd t\u1ef1 c\u1ee7a m\u00ecnh:<\/p>\n<p style=\"text-align: justify\"><strong><em>=SUMPRODUCT(LEN(B2:B8)-LEN(SUBSTITUTE(B2:B8,D1,\u201d\u201d)))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u00d4NG TH\u1ee8C \u0110\u1ebeM K\u00dd T\u1ef0 N\u00c0Y HO\u1ea0T \u0110\u1ed8NG NH\u01af TH\u1ebe N\u00c0O<\/p>\n<p style=\"text-align: justify\">Ch\u1eafc b\u1ea1n c\u00f2n nh\u1edb, h\u00e0m SUBSTITUTE \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 thay th\u1ebf t\u1ea5t c\u1ea3 s\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh (trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 k\u00fd t\u1ef1 \u201cA\u201d) b\u1eb1ng m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 r\u1ed7ng (\u201c\u201d).<\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, ch\u00fang ta cung c\u1ea5p chu\u1ed7i k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi h\u00e0m SUBSTITUTE cho h\u00e0m LEN trong Excel \u0111\u1ec3 n\u00f3 t\u00ednh chi\u1ec1u d\u00e0i chu\u1ed7i kh\u00f4ng c\u00f3 k\u00fd t\u1ef1 \u201cA\u201d. R\u1ed3i sau \u0111\u00f3, ch\u00fang ta l\u1ea5y t\u1ed5ng chi\u1ec1u d\u00e0i chu\u1ed7i k\u00fd t\u1ef1 tr\u1eeb cho chu\u1ed7i kh\u00f4ng c\u00f3 k\u00fd t\u1ef1 \u201cA\u201d \u0111\u00f3. K\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c ph\u00e9p t\u00ednh n\u00e0y ch\u00ednh l\u00e0 m\u1ed9t m\u1ea3ng c\u00e1c s\u1ed1 k\u00fd t\u1ef1, trong \u0111\u00f3 m\u1ed7i \u00f4 cho m\u1ed9t s\u1ed1 k\u00fd t\u1ef1.<\/p>\n<p style=\"text-align: justify\">Cu\u1ed1i c\u00f9ng, h\u00e0m SUMPRODUCT t\u00ednh t\u1ed5ng c\u00e1c con s\u1ed1 trong m\u1ea3ng r\u1ed3i tr\u1ea3 v\u1ec1 t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh trong m\u1ed9t d\u1ea3i \u00f4.<\/p>\n<p style=\"text-align: justify\">M\u1ed8T C\u00d4NG TH\u1ee8C KH\u00d4NG PH\u00c2N BI\u1ec6T D\u1ea0NG CH\u1eee \u0110\u1ec2 \u0110\u1ebeM C\u00c1C K\u00dd T\u1ef0 \u0110\u1eb6C BI\u1ec6T TRONG M\u1ed8T D\u1ea2I \u00d4<\/p>\n<p style=\"text-align: justify\">C\u00f3 l\u1ebd, b\u1ea1n \u0111\u00e3 bi\u1ebft h\u00e0m SUBSTITUTE l\u00e0 h\u00e0m ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef, h\u00e0m n\u00e0y c\u0169ng \u0111\u01b0\u1ee3c d\u00f9ng cho c\u00f4ng th\u1ee9c \u0111\u1ebfm k\u00fd t\u1ef1 c\u00f3 ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u00e0m cho c\u00f4ng th\u1ee9c kh\u00f4ng ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef n\u1eefa, h\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc \u0111\u00e3 \u0111\u01b0\u1ee3c di\u1ec5n gi\u1ea3i trong v\u00ed d\u1ee5 tr\u01b0\u1edbc: m\u1ee5c C\u00d4NG TH\u1ee8C KH\u00d4NG PH\u00c2N BI\u1ec6T D\u1ea0NG CH\u1eee D\u00d9NG \u0110\u1ec2 \u0110\u1ebeM C\u00c1C K\u00dd T\u1ef0 \u0110\u1eb6C BI\u1ec6T TRONG M\u1ed8T \u00d4.<\/p>\n<p style=\"text-align: justify\">C\u1ee5 th\u1ec3 l\u00e0, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t trong nh\u1eefng c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong m\u1ed9t d\u1ea3i \u00f4 m\u00e0 kh\u00f4ng ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef:<\/p>\n<ul style=\"list-style-type: circle\">\n<li style=\"text-align: justify\">S\u1eed d\u1ee5ng h\u00e0m UPPER v\u00e0 g\u00f5 k\u00fd t\u1ef1 in hoa:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><em>=SUMPRODUCT(LEN(B2:B8)-LEN(SUBSTITUTE(UPPER(B2:B8),\u201dA\u201d,\u201d\u201d)))<\/em><\/strong><\/p>\n<ul style=\"list-style-type: circle\">\n<li style=\"text-align: justify\">S\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE trong h\u00e0m SUBSTITUTE:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><em>=SUMPRODUCT(LEN(B2:B8)-LEN(SUBSTITUTE(SUBSTITUTE((B2:B8),\u201dA\u201d,\u201d\u201d),\u201da\u201d,\u201d\u201d)))<\/em><\/strong><\/p>\n<ul style=\"list-style-type: circle\">\n<li style=\"text-align: justify\">S\u1eed d\u1ee5ng h\u00e0m UPPER v\u00e0 h\u00e0m LOWER, h\u00e3y g\u00f5 ho\u1eb7c k\u00fd t\u1ef1 vi\u1ebft hoa ho\u1eb7c k\u00fd t\u1ef1 vi\u1ebft th\u01b0\u1eddng v\u00e0o m\u1ed9t \u00f4 n\u00e0o \u0111\u00f3, r\u1ed3i tham chi\u1ebfu \u00f4 \u0111\u00f3 trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><em>=SUMPRODUCT(LEN(B2:B8)-LEN(SUBSTITUTE(SUBSTITUTE((B2:B8),UPPER($E$1),\u201d\u201d), LOWER($E$1),\u201d\u201d)))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi di\u1ec5n gi\u1ea3i c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c cu\u1ed1i c\u00f9ng:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5093 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-chars-range-case-insensitive.png\" width=\"600\" height=\"236\" title=\"count-chars-range-case-insensitive\"><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-6.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":581,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-580","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\/580","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=580"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/580\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/581"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}