{"id":29057,"date":"2023-11-21T14:59:46","date_gmt":"2023-11-21T07:59:46","guid":{"rendered":"https:\/\/hocvienit.vn\/?p=29057"},"modified":"2024-07-01T19:31:48","modified_gmt":"2024-07-01T12:31:48","slug":"meo-dung-ham-dem-chu-trong-excel-don-gian-nhat","status":"publish","type":"post","link":"https:\/\/hocvienit.vn\/?p=29057","title":{"rendered":"M\u1eb9o d\u00f9ng h\u00e0m \u0111\u1ebfm ch\u1eef trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, b\u1ea1n c\u1ea7n ki\u1ec3m tra s\u1ed1 k\u00fd t\u1ef1 trong ti\u00eau \u0111\u1ec1 ho\u1eb7c \u00f4 t\u00ednh? V\u1eady h\u00e3y tham kh\u1ea3o ngay 4 h\u00e0m \u0111\u1ebfm ch\u1eef trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t nh\u00e9!<\/span><\/p>\n<figure id=\"attachment_29058\" aria-describedby=\"caption-attachment-29058\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29058 size-full\" title=\"M\u1eb9o d\u00f9ng h\u00e0m \u0111\u1ebfm ch\u1eef trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\" src=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat.jpg\" alt=\"M\u1eb9o d\u00f9ng h\u00e0m \u0111\u1ebfm ch\u1eef trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\" width=\"750\" height=\"400\" srcset=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat.jpg 750w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-300x160.jpg 300w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-510x272.jpg 510w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><figcaption id=\"caption-attachment-29058\" class=\"wp-caption-text\">M\u1eb9o d\u00f9ng h\u00e0m \u0111\u1ebfm ch\u1eef trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify; padding-left: 40px;\"><span style=\"font-weight: 400;\">Xem th\u00eam: <\/span><a href=\"https:\/\/hocvienit.vn\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">2 h\u00e0m \u0111\u1ebfm b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/span><\/a><\/p>\n<h2 style=\"text-align: justify;\"><b>1. H\u00e0m \u0111\u1ebfm ch\u1eef trong m\u1ed9t \u00f4 Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 \u0111\u01a1n gi\u1ea3n h\u00f3a qu\u00e1 tr\u00ecnh \u0111\u1ebfm s\u1ed1 ch\u1eef trong m\u1ed9t \u00f4 Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEN. C\u00f4ng th\u1ee9c s\u1ebd l\u00e0: <strong>=LEN(\u00f4)<\/strong>.<\/span><\/p>\n<figure id=\"attachment_29059\" aria-describedby=\"caption-attachment-29059\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29059 size-full\" title=\"H\u00e0m \u0111\u1ebfm ch\u1eef trong m\u1ed9t \u00f4 Excel\" src=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-1.jpg\" alt=\"H\u00e0m \u0111\u1ebfm ch\u1eef trong m\u1ed9t \u00f4 Excel\" width=\"750\" height=\"375\" srcset=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-1.jpg 750w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-1-300x150.jpg 300w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-1-510x255.jpg 510w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><figcaption id=\"caption-attachment-29059\" class=\"wp-caption-text\">H\u00e0m \u0111\u1ebfm ch\u1eef trong m\u1ed9t \u00f4 Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i ra, h\u00e0m LEN c\u00f2n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng \u0111\u1ec3:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110\u1ebfm k\u00fd t\u1ef1 b\u1ecf qua kho\u1ea3ng tr\u1eafng \u0111\u1ea7u d\u00f2ng v\u00e0 cu\u1ed1i d\u00f2ng: <strong>=LEN(TRIM(\u00f4))<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110\u1ebfm k\u00fd t\u1ef1 b\u1ecf qua c\u00e1c kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c t\u1eeb: <strong>=LEN(SUBSTITUTE(\u00f4,\u201d \u201c,\u201d\u201d))<\/strong>.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><b>2. H\u00e0m \u0111\u1ebfm t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a nhi\u1ec1u \u00f4 t\u00ednh<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i Excel c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ph\u00e1t hi\u1ec7n 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\u00e1p nh\u1eadp ho\u1eb7c nh\u1eadp li\u1ec7u b\u1ea3ng bi\u1ec3u.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m SUM v\u00e0 h\u00e0m LEN: <strong>=SUM(LEN(d\u1ea3i d\u1eef li\u1ec7u))<\/strong>. Sau \u0111\u00f3, b\u1ea1n nh\u1ea5n <strong>Ctrl + Shift + Enter<\/strong> \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3.<\/span><\/p>\n<figure id=\"attachment_29060\" aria-describedby=\"caption-attachment-29060\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29060 size-full\" title=\"H\u00e0m \u0111\u1ebfm ch\u1eef trong d\u1ea3i d\u1eef li\u1ec7u\" src=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-2.jpg\" alt=\"H\u00e0m \u0111\u1ebfm ch\u1eef trong d\u1ea3i d\u1eef li\u1ec7u\" width=\"750\" height=\"418\" srcset=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-2.jpg 750w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-2-300x167.jpg 300w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-2-510x284.jpg 510w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><figcaption id=\"caption-attachment-29060\" class=\"wp-caption-text\">H\u00e0m \u0111\u1ebfm ch\u1eef trong d\u1ea3i d\u1eef li\u1ec7u<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><b>3. H\u00e0m \u0111\u1ebfm s\u1ed1 t\u1eeb trong m\u1ed9t \u00f4 Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\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 ho\u1eb7c ki\u1ec3m tra xem \u00f4 t\u00ednh c\u00f3 ch\u1ee9a k\u00fd t\u1ef1 kh\u00f4ng mong mu\u1ed1n hay kh\u00f4ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEN k\u1ebft h\u1ee3p v\u1edbi h\u00e0m SUBSTITUTE nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>=LEN(\u00f4)-LEN(SUBSTITUTE(\u00f4, \u201ck\u00fd t\u1ef1\u201d,\u201d\u201d))<\/strong><\/p>\n<figure id=\"attachment_29061\" aria-describedby=\"caption-attachment-29061\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29061 size-full\" title=\"H\u00e0m \u0111\u1ebfm k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh trong m\u1ed9t \u00f4 t\u00ednh\" src=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-3.jpg\" alt=\"H\u00e0m \u0111\u1ebfm k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh trong m\u1ed9t \u00f4 t\u00ednh\" width=\"750\" height=\"381\" srcset=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-3.jpg 750w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-3-300x152.jpg 300w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-3-510x259.jpg 510w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><figcaption id=\"caption-attachment-29061\" class=\"wp-caption-text\">H\u00e0m \u0111\u1ebfm k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh trong m\u1ed9t \u00f4 t\u00ednh<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><b>4. H\u00e0m \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n m\u1ed9t k\u00fd t\u1ef1 trong \u00f4 Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 trong m\u1ed9t v\u00e0i \u00f4 t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>=SUMPRODUCT(LEN(chu\u1ed7i)-LEN(SUBSTITUTE(chu\u1ed7i,\u201dk\u00fd t\u1ef1\u201d,\u201d\u201d)))<\/strong><\/p>\n<figure id=\"attachment_29062\" aria-describedby=\"caption-attachment-29062\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29062 size-full\" title=\"H\u00e0m \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n m\u1ed9t k\u00fd t\u1ef1 trong d\u00e3y\" src=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-4.jpg\" alt=\"H\u00e0m \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n m\u1ed9t k\u00fd t\u1ef1 trong d\u00e3y\" width=\"750\" height=\"392\" srcset=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-4.jpg 750w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-4-300x157.jpg 300w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/meo-dung-ham-dem-chu-trong-excel-don-gian-nhat-4-510x267.jpg 510w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><figcaption id=\"caption-attachment-29062\" class=\"wp-caption-text\">H\u00e0m \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n m\u1ed9t k\u00fd t\u1ef1 trong d\u00e3y<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau \u0111\u00f3, b\u1ea1n nh\u1ea5n <\/span><b>Ctrl + Shift + Enter<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3.<\/span><\/p>\n<p style=\"text-align: justify; padding-left: 40px;\"><span style=\"font-weight: 400;\">Xem th\u00eam: <\/span><a href=\"https:\/\/hocvienit.vn\/sua-loi-product-activation-failed-office-2010\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eeda l\u1ed7i Product Activation Failed Office 2010 ch\u01b0a?<\/span><\/a><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 chia s\u1ebb c\u1ee7a H\u1ecdc vi\u1ec7n iT.vn v\u1ec1 c\u00e1c h\u00e0m \u0111\u1ebfm ch\u1eef trong Excel. Hy v\u1ecdng nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 gi\u00fap \u00edch cho b\u1ea1n trong qu\u00e1 tr\u00ecnh h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu c\u00f3 b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc n\u00e0o th\u00ec h\u00e3y \u0111\u1ec3 l\u1ea1i b\u00ecnh lu\u1eadn ngay b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u00e0y ho\u1eb7c inbox tr\u1ef1c ti\u1ebfp cho H\u1ecdc vi\u1ec7n iT.vn \u0111\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i \u0111\u00e1p t\u1ed1t nh\u1ea5t. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng!<\/span><\/p>\n<p style=\"text-align: left;\"><i>M\u1ecdi chi ti\u1ebft xin vui l\u00f2ng li\u00ean h\u1ec7:<br \/>\n<\/i><strong>C\u00d4NG TY C\u1ed4 PH\u1ea6N H\u1eccC VI\u1ec6N IT<br \/>\n<\/strong><strong>MST: 0108733789<br \/>\n<\/strong><strong>Hotline: 0981 223 001<br \/>\n<\/strong><strong>Facebook:<\/strong>\u00a0<a href=\"http:\/\/www.fb.com\/hocvienit\" target=\"_blank\" rel=\"noopener\">www.fb.com\/hocvienit<\/a><br \/>\n<strong>\u0110\u0103ng k\u00fd k\u00eanh Youtube \u0111\u1ec3 theo d\u00f5i c\u00e1c b\u00e0i h\u1ecdc c\u1ee7a Hu\u1ea5n luy\u1ec7n vi\u00ean t\u1ed1t nh\u1ea5t:<\/strong>\u00a0<a href=\"http:\/\/bit.ly\/Youtube_HOCVIENiT\" target=\"_blank\" rel=\"noopener nofollow\">http:\/\/bit.ly\/Youtube_HOCVIENiT<\/a><br \/>\n<b>H\u1ec7 th\u1ed1ng c\u01a1 s\u1edf \u0111\u00e0o t\u1ea1o:\u00a0<\/b><a href=\"https:\/\/hocvienit.vn\/lien-he\/\" target=\"_blank\" rel=\"noopener\">https:\/\/hocvienit.vn\/lien-he\/<\/a><br \/>\n<strong><i>H\u1ecdc vi\u1ec7n IT.vn \u2013 Truy\u1ec1n ngh\u1ec1 th\u1ef1c t\u1ebf c\u00f9ng b\u1ea1n \u0111\u1ebfn th\u00e0nh c\u00f4ng!\u00a0<\/i><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, b\u1ea1n c\u1ea7n ki\u1ec3m tra s\u1ed1 k\u00fd t\u1ef1 trong ti\u00eau \u0111\u1ec1 ho\u1eb7c \u00f4 t\u00ednh? V\u1eady h\u00e3y tham kh\u1ea3o ngay 4 h\u00e0m \u0111\u1ebfm ch\u1eef trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t nh\u00e9!<\/p>\n","protected":false},"author":95,"featured_media":29058,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[95,94],"tags":[],"_links":{"self":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts\/29057"}],"collection":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/users\/95"}],"replies":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=29057"}],"version-history":[{"count":0,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts\/29057\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/media\/29058"}],"wp:attachment":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=29057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=29057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=29057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}