{"id":12332,"date":"2025-01-15T08:08:23","date_gmt":"2025-01-15T08:08:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-len-ham-dem-so-ky-tu-trong-chuoi\/"},"modified":"2025-01-15T08:08:23","modified_gmt":"2025-01-15T08:08:23","slug":"ham-len-ham-dem-so-ky-tu-trong-chuoi","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-len-ham-dem-so-ky-tu-trong-chuoi\/","title":{"rendered":"H\u00e0m LEN, h\u00e0m \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>Mu\u1ed1n x\u00e1c \u0111\u1ecbnh \u0111\u1ed9 d\u00e0i c\u1ee7a m\u1ed9t chu\u1ed7i trong m\u1ed9t \u00f4 c\u1ee7a Excel, b\u1ea1n kh\u00f4ng th\u1ec3 ng\u1ed3i h\u00e0ng gi\u1edd \u0111\u1ebfm nh\u1ea9m t\u1eebng k\u00fd t\u1ef1. \u0110i\u1ec1u n\u00e0y kh\u00f4ng ch\u1ec9 l\u00e3ng ph\u00ed c\u00f4ng s\u1ee9c m\u00e0 c\u00f2n th\u1eddi gian n\u1eefa. Do \u0111\u00f3, b\u00e0i vi\u1ebft h\u00f4m nay m\u00ecnh s\u1ebd gi\u1edbi thi\u1ec7u cho c\u00e1c b\u1ea1n h\u00e0m LEN() gi\u00fap \u0111\u1ebfm k\u00ed t\u1ef1 nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t.<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">\u2013 H\u00e0m <strong>LEN() : <\/strong>Cho bi\u1ebft s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i.<\/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-67876cf49d030\" 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\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html#Cu_phap\" title=\"C\u00fa ph\u00e1p\">C\u00fa ph\u00e1p<\/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\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phap\"><\/span><strong>C\u00fa ph\u00e1p<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>=LEN(text)<\/strong><\/p>\n<p>Trong \u0111\u00f3: <em><strong>text<\/strong> <\/em>l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm \u0111\u1ed9 d\u00e0i hay \u0111\u1ebfm c\u1ea3 kho\u1ea3ng tr\u1ed1ng v\u00e0 l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c kh\u00e1c. Chu\u1ed7i bao g\u1ed3m c\u1ea3 ch\u1eef, s\u1ed1v\u00e0 c\u1ea3 k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span><strong>V\u00ed d\u1ee5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>\u0110\u1ebfm s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a chu\u1ed7i\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3330\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/03\/HAM-LEN.png\" alt=\"\" width=\"206\" height=\"26\">\u00a0\u1edf v\u1ecb tr\u00ed \u00f4 C5.<\/li>\n<li>D\u00f9ng h\u00e0m: <strong>=LEN(C5)<\/strong> r\u1ed3i Enter.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3331 size-full\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/03\/HAM-LEN-1.png\" alt=\"\" width=\"600\" height=\"404\">=&gt;K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3340 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-len.png\" width=\"600\" height=\"419\" title=\"ham-len\"><\/p>\n<ul>\n<li>\u0110\u1ebfm s\u1ed1 k\u00ed t\u1ef1 trong c\u00e1c chu\u1ed7i thu\u1ed9c c\u1ed9t H\u1ecd T\u00ean trong b\u1ea3ng v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y. T\u01b0\u01a1ng t\u1ef1, d\u00f9ng h\u00e0m LEN.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3344 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-len-3.png\" width=\"600\" height=\"418\" title=\"ham-len-3\"><\/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-384.gif\" title=\"ex101_92019-nho-384\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>=&gt; \u0110\u00e1p \u00e1n thu \u0111\u01b0\u1ee3c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3345 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-len-4.png\" width=\"600\" height=\"438\" title=\"ham-len-4\"><\/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-384.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12333,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12332","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\/12332","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=12332"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12332\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12333"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}