{"id":1110,"date":"2024-12-02T04:11:13","date_gmt":"2024-12-02T04:11:13","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dem-so-o-tinh-chua-van-ban-hoac-ky-tu-trong-excel-2010-2013-2016\/"},"modified":"2024-12-02T04:11:13","modified_gmt":"2024-12-02T04:11:13","slug":"cach-dem-so-o-tinh-chua-van-ban-hoac-ky-tu-trong-excel-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dem-so-o-tinh-chua-van-ban-hoac-ky-tu-trong-excel-2010-2013-2016\/","title":{"rendered":"C\u00e1ch \u0111\u1ebfm s\u1ed1 \u00f4 t\u00ednh ch\u1ee9a v\u0103n b\u1ea3n ho\u1eb7c k\u00fd t\u1ef1 trong Excel 2010 ,2013 ,2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">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 b\u1ea1n c\u00e1ch \u0111\u1ebfm s\u1ed1 \u00f4 t\u00ednh ch\u1ee9a n\u1ed9i dung d\u1ea1ng <strong>text\u00a0<\/strong>v\u00e0 k\u00fd t\u1ef1 trong Excel 2010-2013 b\u1eb1ng m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c \u0111\u1ebfm k\u00fd t\u1ef1 trong m\u1ed9t hay nhi\u1ec1u \u00f4 t\u00ednh, gi\u1edbi h\u1ea1n s\u1ed1 k\u00fd t\u1ef1 trong \u00f4 v\u00e0 c\u00e1ch t\u00ecm nh\u1eefng \u00f4 c\u00f3 ch\u1ee9a n\u1ed9i dung c\u1ee5 th\u1ec3.<\/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-674d3360653df\" 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-dem-so-o-tinh-chua-van-ban-hoac-ky-tu-trong-excel-201020132016.html#Dem_o_tinh_chua_noi_dung_la_dang_text\" title=\"\u0110\u1ebfm \u00f4 t\u00ednh ch\u1ee9a n\u1ed9i dung l\u00e0 d\u1ea1ng text\">\u0110\u1ebfm \u00f4 t\u00ednh ch\u1ee9a n\u1ed9i dung l\u00e0 d\u1ea1ng text<\/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-dem-so-o-tinh-chua-van-ban-hoac-ky-tu-trong-excel-201020132016.html#Dem_ky_tu_trong_nhieu_o_tinh\" title=\"\u0110\u1ebfm k\u00fd t\u1ef1 trong nhi\u1ec1u \u00f4 t\u00ednh\">\u0110\u1ebfm k\u00fd t\u1ef1 trong nhi\u1ec1u \u00f4 t\u00ednh<\/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\/cach-dem-so-o-tinh-chua-van-ban-hoac-ky-tu-trong-excel-201020132016.html#Dem_nhung_ky_tu_xac_dinh_trong_mot_o_tinh_bang_cong_thuc_Excel\" title=\"\u0110\u1ebfm nh\u1eefng k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh trong m\u1ed9t \u00f4 t\u00ednh b\u1eb1ng c\u00f4ng th\u1ee9c Excel\">\u0110\u1ebfm nh\u1eefng k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh trong m\u1ed9t \u00f4 t\u00ednh b\u1eb1ng c\u00f4ng th\u1ee9c Excel<\/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\/cach-dem-so-o-tinh-chua-van-ban-hoac-ky-tu-trong-excel-201020132016.html#Dem_so_lan_xuat_hien_mot_ky_tu_trong_day\" title=\"\u0110\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n m\u1ed9t k\u00fd t\u1ef1 trong d\u00e3y\">\u0110\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n m\u1ed9t k\u00fd t\u1ef1 trong d\u00e3y<\/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\/cach-dem-so-o-tinh-chua-van-ban-hoac-ky-tu-trong-excel-201020132016.html#Dem_so_lan_xuat_hien_cua_du_lieu_dang_text_trong_mot_day\" title=\"\u0110\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a d\u1eef li\u1ec7u d\u1ea1ng text trong m\u1ed9t d\u00e3y\">\u0110\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a d\u1eef li\u1ec7u d\u1ea1ng text trong m\u1ed9t d\u00e3y<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dem_o_tinh_chua_noi_dung_la_dang_text\"><\/span><strong>\u0110\u1ebfm \u00f4 t\u00ednh ch\u1ee9a n\u1ed9i dung l\u00e0 d\u1ea1ng text<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n\u00a0<strong>\u0111\u1ebfm s\u1ed1 \u00f4 t\u00ednh ch\u1ee9a n\u1ed9i dung l\u00e0 d\u1ea1ng text trong Excel<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-countif-trong-excel-huong-dan-cu-va-co-vi-du-minh-hoa.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m\u00a0<strong>COUNTIF<\/strong><\/a>:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTIF(A2:D10,\u201d*\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3,\u00a0<em>A2:D10\u00a0<\/em>l\u00e0 \u0111\u1ecba ch\u1ec9 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm v\u00e0\u00a0<em>\u201c*\u201d<\/em> l\u00e0 d\u1ea5u hoa th\u1ecb \u0111\u1ea1i di\u1ec7n cho b\u1ea5t k\u1ef3 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 n\u00e0o.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/countif-formula-example.png\" alt=\"Use the COUNTIF function - =COUNTIF(RANGE,'*'')\" title=\"countif-formula-example\"><\/p>\n<p style=\"text-align: justify\">Ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o b\u1ea5t k\u1ef3 \u00f4 t\u00ednh n\u00e0o b\u1ea1n mu\u1ed1n, k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb ngay t\u1ea1i \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>Gi\u00e1 tr\u1ecb Logic TRUE\/FALSE s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ebfm nh\u01b0 d\u1ea1ng\u00a0<strong>text<\/strong>. Th\u00eam v\u00e0o \u0111\u00f3, nh\u1eefng con s\u1ed1 c\u0169ng kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ebfm b\u1edfi \u201c*\u201d n\u1ebfu ch\u00fang kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>text<\/strong> b\u1eaft \u0111\u1ea7u v\u1edbi d\u1ea5u nh\u00e1y \u0111\u01a1n (\u2018). Nh\u1eefng \u00f4 r\u1ed7ng b\u1eaft \u0111\u1ea7u v\u1edbi d\u1ea5u nh\u00e1y \u0111\u01a1n (\u2018) s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ebfm.<\/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-24.gif\" title=\"vba101_92019-nho-24\"><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-78.gif\" title=\"ex101_92019-nho-78\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Xem th\u00eam: <strong>C\u00e1ch d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countif-va-countifs-voi-nhieu-dieu-kien.html\">h\u00e0m countifs<\/a> v\u00e0 h\u00e0m countif v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong><\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00f4ng th\u1ee9c n\u1eefa b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 t\u00ednh ch\u1ee9a n\u1ed9i dung \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>text\u00a0<\/strong>l\u00e0:<\/p>\n<p style=\"text-align: justify\"><strong>=COUNTA(range)-COUNT(range)<\/strong><\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/counta-formula-example.png\" alt=\"A formula you can use to count cells with text in Excel\" title=\"counta-formula-example\"><\/p>\n<p style=\"text-align: left\">C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd b\u1ecf qua ng\u00e0y th\u00e1ng v\u00e0 ch\u1eef s\u1ed1.<\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00f4ng th\u1ee9c kh\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u1eefa l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng (c\u1ea7n nh\u1ea5n\u00a0<strong>Ctrl + Shift + Enter <\/strong>\u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3). B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/47-%e2%97%8f-ham-sumproduct-va-su-khac-nhau-voi-sumifs-countifs-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m\u00a0<\/a><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/47-%e2%97%8f-ham-sumproduct-va-su-khac-nhau-voi-sumifs-countifs-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">SUMPRODUCT<\/a>\u00a0<\/strong><\/em>\u0111\u1ec3 \u0111\u1ebfm nh\u1eefng gi\u00e1 tr\u1ecb d\u1ea1ng\u00a0<strong>text <\/strong>c\u00f9ng v\u1edbi\u00a0h\u00e0m\u00a0<em><strong>ISTEXT\u00a0<\/strong><\/em>nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><em><strong>=<\/strong><\/em><strong>SUMPRODUCT(\u2013ISTEXT(range))<\/strong><\/p>\n<p style=\"text-align: justify\">Hai d\u1ea5u g\u1ea1ch n\u1ed1i r\u00e0ng bu\u1ed9c k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m\u00a0<em><strong>ISTEXT<\/strong><\/em> l\u00e0 gi\u00e1 tr\u1ecb logic TRUE ho\u1eb7c FALSE, l\u00e0 gi\u00e1 tr\u1ecb 1 ho\u1eb7c 0.\u00a0<em><strong>SUMPRODUCT<\/strong> <strong>\u00a0<\/strong><\/em>s\u1ebd c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb n\u00e0y l\u1ea1i v\u1edbi nhau v\u00e0 cho k\u1ebft qu\u1ea3.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00f4ng th\u1ee9c Excel \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4 t\u00ednh<\/strong><\/p>\n<p style=\"text-align: justify\">=<strong>LEN(A1)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c n\u00e0y, A1 l\u00e0 m\u1ed9t \u00f4 t\u00ednh ch\u1ee9a s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n t\u00ednh.<\/p>\n<p style=\"text-align: justify\">Tr\u1ecdng \u0111i\u1ec3m l\u00e0 Excel gi\u1edbi h\u1ea1n s\u1ed1 k\u00fd t\u1ef1. V\u00ed d\u1ee5, ti\u00eau \u0111\u1ec1 Excel kh\u00f4ng qua 254 k\u00ed t\u1ef1. N\u1ebfu b\u1ea1n v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n n\u00e0y, ti\u00eau \u0111\u1ec1 s\u1ebd b\u1ecb c\u1eaft. C\u00f4ng th\u1ee9c s\u1ebd r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n c\u00f3 m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 d\u00e0i trong \u00f4 t\u00ednh v\u00e0 c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng \u00f4 t\u00ednh c\u1ee7a b\u1ea1n kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 254 k\u00ed t\u1ef1 \u0111\u1ec3 tr\u00e1nh v\u1ea5n \u0111\u1ec1 nh\u1eadp ho\u1eb7c hi\u1ec3n th\u1ecb b\u1ea3ng t\u1eeb ngu\u1ed3n kh\u00e1c.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dem_ky_tu_trong_nhieu_o_tinh\"><\/span><strong>\u0110\u1ebfm k\u00fd t\u1ef1 trong nhi\u1ec1u \u00f4 t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Tr\u01b0\u1eddng h\u1ee3p n\u00e0y kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm nh\u01b0 <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-count-va-counta-de-dem-o-trong-excel.html\"><strong>h\u00e0m count<\/strong><\/a> th\u00f4ng th\u01b0\u1eddng \u0111\u01b0\u1ee3c m\u00e0 b\u1ea1n ph\u1ea3i nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\"><strong>=SUM(LEN(range))<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>C\u00f4ng th\u1ee9c ph\u00eda tr\u00ean c\u1ea7n nh\u1eadp d\u01b0\u1edbi d\u1ea1ng c\u00f4ng th\u1ee9c m\u1ea3ng. \u0110\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, b\u1ea1n c\u1ea7n nh\u1ea5n\u00a0<strong>Ctrl + Shift + Enter.<\/strong><\/p>\n<p style=\"text-align: center\"><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4704 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-characters-several-cells.png\" width=\"600\" height=\"251\" title=\"count-characters-several-cells\"><\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c n\u00e0y gi\u00fap b\u1ea1n phh\u00e1t hi\u1ec7n ra b\u1ea5t c\u1ee9 h\u00e0ng n\u00e0o v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n k\u00fd t\u1ef1 tr\u01b0\u1edbc khi s\u00e1t nh\u1eadp ho\u1eb7c nh\u1eadp d\u1eef li\u1ec7u b\u1ea3ng bi\u1ec3u. Ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o c\u1ed9t ph\u1ee5 v\u00e0 k\u00e9o sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng h\u1ebft c\u00e1c d\u00f2ng.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dem_nhung_ky_tu_xac_dinh_trong_mot_o_tinh_bang_cong_thuc_Excel\"><\/span><strong>\u0110\u1ebfm nh\u1eefng k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh trong m\u1ed9t \u00f4 t\u00ednh b\u1eb1ng c\u00f4ng th\u1ee9c Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n bi\u1ebft s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh trong \u00f4 t\u00ednh, ho\u1eb7c n\u1ebfu b\u1ea1n mu\u1ed1n ki\u1ec3m tra \u00f4 t\u00ednh c\u00f3 ch\u1ee9a k\u00fd t\u1ef1 kh\u00f4ng ph\u00f9 h\u1ee3p hay kh\u00f4ng, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>=LEN(A1)-LEN(SUBSTITUTE(A1,\u201da\u201d,\u201d\u201d))<\/strong><\/p>\n<p style=\"text-align: justify\">K\u00fd t\u1ef1 \u201ca\u201d l\u00e0 k\u00fd t\u1ef1 b\u1ea1n c\u1ea7n \u0111\u1ebfm trong Excel.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-character-occurances-cell.png\" alt=\"Count the number of occurrences of certain character in a cell\" title=\"count-character-occurances-cell\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dem_so_lan_xuat_hien_mot_ky_tu_trong_day\"><\/span><strong>\u0110\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n m\u1ed9t k\u00fd t\u1ef1 trong d\u00e3y<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n\u00a0<strong>\u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n m\u1ed9t k\u00fd t\u1ef1 trong d\u00e3y\u00a0<\/strong>trong nhi\u1ec1u \u00f4 t\u00ednh ho\u1eb7c m\u1ed9t c\u1ed9t, b\u1ea1n c\u1ea7n t\u1ea1o c\u1ed9t ph\u1ee5 v\u00e0 d\u00e1n v\u00e0o \u0111\u00f3 c\u00f4ng th\u1ee9c t\u00f4i v\u1eeba gi\u1edbi thi\u1ec7u \u1edf ph\u1ea7n tr\u01b0\u1edbc\u00a0<strong>=LEN(A1)-LEN(SUBSTITUTE(A1,\u201da\u201d,\u201d\u201d))<\/strong>. Sau \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c n\u00e0y sang c\u00e1c c\u1ed9t, c\u1ed9ng t\u1ed5ng c\u1ed9t n\u00e0y v\u00e0 b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n. D\u01b0\u1eddng nh\u01b0 kh\u00e1 m\u1ea5t th\u1eddi gian ph\u1ea3i kh\u00f4ng?<\/p>\n<p style=\"text-align: justify\">May m\u1eafn l\u00e0, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh trong m\u1ed9t d\u00e3y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng sau:<\/p>\n<p style=\"text-align: justify\"><strong>=SUM(LEN(range)-LEN(SUBSTITUTE(range,\u201da\u201d,\u201d\u201d)))<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>C\u00f4ng th\u1ee9c tr\u00ean l\u00e0 c\u00f4ng th\u1ee9c d\u1ea1ng m\u1ea3ng. H\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng b\u1ea1n nh\u1ea5n\u00a0<strong>Ctrl + Shift + Enter\u00a0<\/strong>\u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4705 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/count-character-occurances-text.png\" width=\"600\" height=\"359\" title=\"count-character-occurances-text\"><\/p>\n<h2 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Dem_so_lan_xuat_hien_cua_du_lieu_dang_text_trong_mot_day\"><\/span><strong>\u0110\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a d\u1eef li\u1ec7u d\u1ea1ng text trong m\u1ed9t d\u00e3y<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: left\">C\u00f4ng th\u1ee9c m\u1ea3ng sau s\u1ebd gi\u00fap b\u1ea1n \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a d\u1ef1 li\u1ec7u d\u1ea1ng\u00a0<strong>text\u00a0<\/strong>trong m\u1ed9t d\u00e3y:<\/p>\n<p style=\"text-align: left\"><strong>=SUM((LEN(C2:D66)-LEN(SUBSTITUE(C2:D66,\u201dExcel\u201d,\u201d\u201d)))\/LEN(\u201cExcel\u201d))<\/strong><\/p>\n<p style=\"text-align: left\">V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a \u201cExcel\u201d trong b\u1ea3ng. \u0110\u1eebng qu\u00ean d\u1ea5u c\u00e1ch ho\u1eb7c h\u00e0m c\u0169ng s\u1ebd \u0111\u1ebfm nh\u1eefng t\u1eeb b\u1eaft \u0111\u1ea7u v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng text \u0111\u00f3, kh\u00f4ng ph\u1ea3i nh\u1eefng t\u1eeb ri\u00eang l\u1ebb.<\/p>\n<p style=\"text-align: left\"><strong>Gi\u1edbi h\u1ea1n k\u00fd t\u1ef1 Excel cho \u00f4 t\u00ednh<\/strong><\/p>\n<p style=\"text-align: left\">Excel gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o m\u1ed9t \u00f4.<\/p>\n<p style=\"text-align: left\">T\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 m\u1ed9t \u00f4 t\u00ednh c\u00f3 th\u1ec3 ch\u1ee9a l\u00e0 32.767.<\/p>\n<p style=\"text-align: left\">M\u1ed9t \u00f4 t\u00ednh ch\u1ec9 c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb 1.024 k\u00fd t\u1ef1. B\u00ean c\u1ea1nh \u0111\u00f3, thanh c\u00f4ng th\u1ee9c ch\u1ec9 c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb 32.767 k\u00fd t\u1ef1.<\/p>\n<p style=\"text-align: left\">\u0110\u1ed9 d\u00e0i l\u1edbn nh\u1ea5t c\u1ee7a d\u00e3y c\u00f4ng th\u1ee9c l\u00e0 1.014 \u0111\u1ed1i v\u1edbi Excel 2003. Excel 2007-2013 c\u00f3 th\u1ec3 ch\u1ee9a 8.192 k\u00fd t\u1ef1.<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c tr\u00ean c\u0169ng nh\u01b0 nh\u1eefng ki\u1ebfn th\u1ee9c kh\u00e1c trong Excel c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a> c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc.<\/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-24.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1111,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1110","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\/1110","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=1110"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1110\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1111"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}