{"id":477694,"date":"2025-07-29T09:19:41","date_gmt":"2025-07-29T02:19:41","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=477694"},"modified":"2025-07-29T09:19:41","modified_gmt":"2025-07-29T02:19:41","slug":"dem-ky-tu","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m LEN l\u00e0 c\u00f4ng c\u1ee5 quen thu\u1ed9c trong Excel gi\u00fap b\u1ea1n \u0111\u1ebfm k\u00fd t\u1ef1 trong m\u1ed9t \u00f4 d\u1eef li\u1ec7u b\u1ea5t k\u1ef3, bao g\u1ed3m c\u1ea3 kho\u1ea3ng tr\u1eafng v\u00e0 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t. V\u1edbi c\u00fa ph\u00e1p \u0111\u01a1n gi\u1ea3n v\u00e0 kh\u1ea3 n\u0103ng k\u1ebft h\u1ee3p linh ho\u1ea1t v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 LEFT, RIGHT, TRIM hay SUBSTITUTE, h\u00e0m LEN l\u00e0 l\u1ef1a ch\u1ecdn l\u00fd t\u01b0\u1edfng \u0111\u1ec3 ki\u1ec3m so\u00e1t v\u00e0 x\u1eed l\u00fd chu\u1ed7i v\u0103n b\u1ea3n hi\u1ec7u qu\u1ea3. H\u00e3y c\u00f9ng b\u00e0i vi\u1ebft kh\u00e1m ph\u00e1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN n\u00e0o!<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m LEN trong Excel l\u00e0 g\u00ec?<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m LEN l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch trong Excel d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u00f3 trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, bao g\u1ed3m c\u1ea3 kho\u1ea3ng tr\u1eafng. C\u00fa ph\u00e1p s\u1eed d\u1ee5ng nh\u01b0 sau: =LEN(Text), trong \u0111\u00f3 Text c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t \u00f4 c\u1ee5 th\u1ec3 ho\u1eb7c m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n c\u1ea7n \u0111o \u0111\u1ed9 d\u00e0i.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m LEN ch\u1ec9 d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn d\u1eef li\u1ec7u ban \u0111\u1ea7u, do \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 y\u00ean t\u00e2m s\u1eed d\u1ee5ng m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i n\u1ed9i dung g\u1ed1c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m n\u00e0y c\u00f3 th\u1ec3 ph\u1ed1i h\u1ee3p hi\u1ec7u qu\u1ea3 v\u1edbi c\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i kh\u00e1c nh\u01b0 LEFT, RIGHT ho\u1eb7c MID \u0111\u1ec3 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u theo y\u00eau c\u1ea7u c\u1ee5 th\u1ec3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tuy nhi\u00ean, c\u1ea7n l\u01b0u \u00fd r\u1eb1ng LEN kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng v\u1edbi d\u1eef li\u1ec7u ki\u1ec3u ng\u00e0y th\u00e1ng. Khi \u00e1p d\u1ee5ng v\u1edbi ki\u1ec3u d\u1eef li\u1ec7u n\u00e0y, k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 kh\u00f4ng ph\u1ea3n \u00e1nh \u0111\u00fang mong \u0111\u1ee3i.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_477695\" aria-describedby=\"caption-attachment-477695\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-477695 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-1.jpg\" alt=\"dem-ky-tu-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-477695\" class=\"wp-caption-text\">H\u00e0m LEN trong Excel l\u00e0 g\u00ec?<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m LEN \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 trong Excel<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m LEN trong Excel c\u00f3 nhi\u1ec7m v\u1ee5 \u0111\u1ebfm t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 c\u00f3 trong m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, bao g\u1ed3m c\u1ea3 d\u1ea5u c\u00e1ch. C\u00fa ph\u00e1p s\u1eed d\u1ee5ng r\u1ea5t \u0111\u01a1n gi\u1ea3n: =LEN(Text). Trong \u0111\u00f3, Text l\u00e0 ph\u1ea7n n\u1ed9i dung b\u1ea1n mu\u1ed1n ki\u1ec3m tra, \u0111\u00f3 c\u00f3 th\u1ec3 l\u00e0 d\u1eef li\u1ec7u trong m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t chu\u1ed7i nh\u1eadp tr\u1ef1c ti\u1ebfp.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 k\u00fd t\u1ef1 c\u00f3 trong m\u1ed9t chu\u1ed7i b\u1ea5t k\u1ef3, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m LEN v\u1edbi c\u1ea5u tr\u00fac nh\u01b0 sau: =LEN(\u00f4_ch\u1ee9a_chu\u1ed7i). H\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 \u0111\u1ed9 d\u00e0i t\u00ednh theo t\u1eebng k\u00fd t\u1ef1, k\u1ec3 c\u1ea3 kho\u1ea3ng tr\u1eafng, d\u1ea5u c\u00e2u ho\u1eb7c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t. \u0110\u00e2y l\u00e0 h\u00e0m th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng trong vi\u1ec7c ki\u1ec3m tra \u0111\u1ed9 d\u00e0i d\u1eef li\u1ec7u v\u0103n b\u1ea3n.<\/span><\/p>\n<figure id=\"attachment_477696\" aria-describedby=\"caption-attachment-477696\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-477696 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-2.jpg\" alt=\"dem-ky-tu-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-477696\" class=\"wp-caption-text\">C\u00fa ph\u00e1p h\u00e0m LEN \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 trong Excel<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m LEN l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m x\u1eed l\u00fd v\u0103n b\u1ea3n c\u01a1 b\u1ea3n nh\u01b0ng c\u1ef1c k\u1ef3 h\u1eefu \u00edch trong Excel. T\u1eeb vi\u1ec7c \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 \u0111\u01a1n gi\u1ea3n cho \u0111\u1ebfn c\u00e1c \u1ee9ng d\u1ee5ng k\u1ebft h\u1ee3p n\u00e2ng cao, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch linh ho\u1ea1t. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft t\u1eeb m\u1ee9c \u0111\u1ed9 c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao khi s\u1eed d\u1ee5ng h\u00e0m LEN:<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m LEN c\u01a1 b\u1ea3n<\/span><\/h3>\n<p style=\"text-align: justify;\">Ch\u00fang ta c\u00f3 v\u00ed d\u1ee5 nh\u01b0 sau:<br \/>\n<picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-477697 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-3.jpg\" alt=\"dem-ky-tu-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Click v\u00e0o m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong Excel v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c: =LEN(Text) (Text l\u00e0 \u00f4 ch\u1ee9a n\u1ed9i dung b\u1ea1n mu\u1ed1n \u0111\u1ebfm k\u00fd t\u1ef1).<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477698 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-4.jpg\" alt=\"dem-ky-tu-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u2013 h\u00e0m s\u1ebd t\u00ednh c\u1ea3 ch\u1eef, s\u1ed1, d\u1ea5u c\u00e1ch v\u00e0 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong chu\u1ed7i.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477699 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-5.jpg\" alt=\"dem-ky-tu-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: \u0110\u1ec3 \u00e1p d\u1ee5ng cho nhi\u1ec1u \u00f4, h\u00e3y k\u00e9o th\u1ea3 t\u1eeb g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477700 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-6.jpg\" alt=\"dem-ky-tu-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u01b0u \u00fd: H\u00e0m kh\u00f4ng \u00e1p d\u1ee5ng cho \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng. Sau khi sao ch\u00e9p c\u00f4ng th\u1ee9c, n\u00ean ki\u1ec3m tra l\u1ea1i \u0111\u1ec3 ch\u1eafc ch\u1eafn tham chi\u1ebfu \u0111\u00fang \u00f4 c\u1ea7n t\u00ednh.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m LEN k\u1ebft h\u1ee3p h\u00e0m SUM<\/span><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i m\u1ed9t \u00f4 b\u1ea5t k\u1ef3, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c: =SUM(LEN(Text1);LEN(Text2);LEN(Text3) \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a ba \u00f4 kh\u00e1c nhau. L\u01b0u \u00fd: D\u1ea5u ng\u0103n c\u00e1ch gi\u1eefa c\u00e1c h\u00e0m c\u00f3 th\u1ec3 l\u00e0 d\u1ea5u ph\u1ea9y (,) ho\u1eb7c ch\u1ea5m ph\u1ea9y (;) t\u00f9y theo c\u00e0i \u0111\u1eb7t v\u00f9ng c\u1ee7a Excel, trong v\u00ed d\u1ee5 n\u00e0y s\u1eed d\u1ee5ng d\u1ea5u ;.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477701 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-7.jpg\" alt=\"dem-ky-tu-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n Enter \u0111\u1ec3 h\u1ec7 th\u1ed1ng hi\u1ec3n th\u1ecb t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 t\u1eeb ba \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477702 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-8.jpg\" alt=\"dem-ky-tu-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng LEN \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i c\u1ee7a m\u1ed9t k\u00fd t\u1ef1<\/span><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng t\u00ednh, nh\u1eadp c\u00f4ng th\u1ee9c: =LEN(LEFT(Text;SEARCH(K\u00fd_t\u1ef1_t\u00ecm;Text)-1)) \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 k\u00fd t\u1ef1 \u0111\u1ee9ng tr\u01b0\u1edbc m\u1ed9t k\u00fd t\u1ef1 c\u1ee5 th\u1ec3 nh\u01b0 &#8220;-&#8220;, &#8220;_&#8221;, &#8220;\/&#8221;. Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Text l\u00e0 \u00f4 ch\u1ee9a chu\u1ed7i c\u1ea7n x\u1eed l\u00fd<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u00fd_t\u1ef1_t\u00ecm l\u00e0 k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm v\u1ecb tr\u00ed trong chu\u1ed7i<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c SEARCH x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed k\u00fd t\u1ef1, LEFT tr\u00edch xu\u1ea5t ph\u1ea7n b\u00ean tr\u00e1i, v\u00e0 LEN \u0111\u1ebfm \u0111\u1ed9 d\u00e0i k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">-1 \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 lo\u1ea1i b\u1ecf ch\u00ednh k\u00fd t\u1ef1 t\u00ecm ki\u1ebfm kh\u1ecfi k\u1ebft qu\u1ea3 \u0111\u1ebfm<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477703 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-9.jpg\" alt=\"dem-ky-tu-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: V\u00ed d\u1ee5 c\u1ee5 th\u1ec3: v\u1edbi chu\u1ed7i trong \u00f4 G5 l\u00e0 &#8220;ABC-XYZ&#8221;, c\u00f4ng th\u1ee9c =LEN(LEFT(G5;SEARCH(&#8220;-&#8220;;G5)-1)) s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 3 (\u0111\u1ebfm &#8220;ABC&#8221;).<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477704 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-10.jpg\" alt=\"dem-ky-tu-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Nh\u1ea5n Enter \u0111\u1ec3 xem k\u1ebft qu\u1ea3 s\u1ed1 k\u00fd t\u1ef1 tr\u01b0\u1edbc k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t \u0111\u00e3 ch\u1ecdn.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477705 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-11.jpg\" alt=\"dem-ky-tu-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng LEN \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 t\u1eeb b\u00ean ph\u1ea3i c\u1ee7a m\u1ed9t k\u00fd t\u1ef1<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch k\u1ebft h\u1ee3p LEN v\u1edbi LEFT v\u00e0 SEARCH. Nh\u01b0ng thay v\u00ec l\u1ea5y ph\u1ea7n k\u00fd t\u1ef1 n\u1eb1m b\u00ean tr\u00e1i k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t, b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng h\u00e0m RIGHT \u0111\u1ec3 \u0111\u1ebfm ph\u1ea7n n\u1eb1m ph\u00eda sau.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c:<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\"> =LEN(RIGHT(Text; LEN(Text) &#8211; SEARCH(K\u00fd_t\u1ef1; Text)))<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3i th\u00edch:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">SEARCH t\u00ecm v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong chu\u1ed7i<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">LEN(Text) t\u00ednh t\u1ed5ng chi\u1ec1u d\u00e0i to\u00e0n b\u1ed9 chu\u1ed7i<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ph\u00e9p tr\u1eeb x\u00e1c \u0111\u1ecbnh ph\u1ea7n k\u00fd t\u1ef1 c\u00f2n l\u1ea1i ph\u00eda sau<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">RIGHT tr\u00edch ph\u1ea7n b\u00ean ph\u1ea3i, v\u00e0 LEN \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a ph\u1ea7n \u0111\u00f3.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477706 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-12.jpg\" alt=\"dem-ky-tu-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m LEN \u0111\u1ec3 \u0111\u1ebfm chu\u1ed7i k\u00fd t\u1ef1<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi c\u1ea7n lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng d\u01b0 th\u1eeba \u1edf \u0111\u1ea7u, cu\u1ed1i ho\u1eb7c gi\u1eefa chu\u1ed7i tr\u01b0\u1edbc khi \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m \u0111\u1ebfm k\u00fd t\u1ef1 LEN v\u1edbi TRIM. C\u00fa ph\u00e1p:\u00a0 =LEN(TRIM(Text)). Trong \u0111\u00f3 Text l\u00e0 \u00f4 d\u1eef li\u1ec7u ch\u1ee9a chu\u1ed7i v\u0103n b\u1ea3n b\u1ea1n mu\u1ed1n x\u1eed l\u00fd.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i m\u1ed9t \u00f4 trong b\u1ea3ng t\u00ednh, nh\u1eadp c\u00f4ng th\u1ee9c =LEN(TRIM(A1)) \u0111\u1ec3 \u0111\u1ebfm ch\u00ednh x\u00e1c s\u1ed1 k\u00fd t\u1ef1 sau khi lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1eafng th\u1eeba. Vi\u1ec7c k\u1ebft h\u1ee3p n\u00e0y gi\u00fap \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 \u0111\u1ebfm kh\u00f4ng b\u1ecb sai l\u1ec7ch b\u1edfi c\u00e1c k\u00fd t\u1ef1 tr\u1eafng kh\u00f4ng mong mu\u1ed1n. C\u00fa ph\u00e1p n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi x\u1eed l\u00fd d\u1eef li\u1ec7u nh\u1eadp t\u1eeb ngu\u1ed3n ngo\u00e0i.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477708 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-14.jpg\" alt=\"dem-ky-tu-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n Enter v\u00e0 xem k\u1ebft qu\u1ea3, s\u1ed1 k\u00fd t\u1ef1 th\u1ef1c t\u1ebf sau khi \u0111\u00e3 l\u00e0m s\u1ea1ch chu\u1ed7i s\u1ebd xu\u1ea5t hi\u1ec7n.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477709 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-15.jpg\" alt=\"dem-ky-tu-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m LEN \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 kh\u00f4ng t\u00ednh kho\u1ea3ng tr\u1eafng<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi mu\u1ed1n \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 th\u1ef1c s\u1ef1 c\u00f3 trong m\u1ed9t chu\u1ed7i m\u00e0 kh\u00f4ng t\u00ednh kho\u1ea3ng tr\u1eafng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p gi\u1eefa LEN v\u00e0 SUBSTITUTE.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i m\u1ed9t \u00f4 b\u1ea5t k\u1ef3, nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400;\">=LEN(SUBSTITUTE(Text; Old_Text; New_Text)). Trong \u0111\u00f3:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Text: l\u00e0 \u00f4 ch\u1ee9a chu\u1ed7i c\u1ea7n x\u1eed l\u00fd<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Old_Text: l\u00e0 k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf (v\u00ed d\u1ee5 &#8221; &#8220;)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">New_Text: l\u00e0 gi\u00e1 tr\u1ecb thay th\u1ebf (n\u1ebfu x\u00f3a k\u00fd t\u1ef1 th\u00ec \u0111\u1ec3 tr\u1ed1ng &#8220;&#8221;)<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477710 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-16.jpg\" alt=\"dem-ky-tu-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: V\u00ed d\u1ee5: n\u1ebfu \u00f4 I5 ch\u1ee9a &#8220;Nguy\u1ec5n V\u0103n A&#8221; v\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 b\u1ecf qua kho\u1ea3ng tr\u1eafng, d\u00f9ng c\u00f4ng th\u1ee9c: =LEN(SUBSTITUTE(I5; &#8221; &#8220;; &#8220;&#8221;)). K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 11 thay v\u00ec 13, v\u00ec hai d\u1ea5u c\u00e1ch \u0111\u00e3 b\u1ecb lo\u1ea1i b\u1ecf tr\u01b0\u1edbc khi \u0111\u1ebfm.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477711 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-17.jpg\" alt=\"dem-ky-tu-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. N\u1ebfu mu\u1ed1n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho nhi\u1ec1u \u00f4, b\u1ea1n ch\u1ec9 c\u1ea7n k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c d\u00f2ng kh\u00e1c trong c\u00f9ng c\u1ed9t nh\u01b0 b\u00ecnh th\u01b0\u1eddng.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477712 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-18.jpg\" alt=\"dem-ky-tu-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m LEN \u0111\u1ebfm k\u00fd t\u1ef1<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi \u00e1p d\u1ee5ng h\u00e0m LEN \u0111\u1ec3 \u0111\u1ebfm c\u00e1c k\u00fd t\u1ef1 trong Excel, b\u1ea1n c\u1ea7n quan t\u00e2m \u0111\u1ebfn m\u1ed9t s\u1ed1 \u0111\u1eb7c \u0111i\u1ec3m \u0111\u1eb7c th\u00f9 c\u1ee7a h\u00e0m n\u00e0y. Vi\u1ec7c hi\u1ec3u r\u00f5 c\u00e1ch h\u00e0m ho\u1ea1t \u0111\u1ed9ng s\u1ebd gi\u00fap b\u1ea1n tr\u00e1nh \u0111\u01b0\u1ee3c nh\u1eefng l\u1ed7i ph\u1ed5 bi\u1ebfn v\u00e0 \u00e1p d\u1ee5ng linh ho\u1ea1t h\u01a1n trong th\u1ef1c t\u1ebf:<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m LEN \u0111\u1ebfm c\u1ea3 kho\u1ea3ng tr\u1eafng trong chu\u1ed7i<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u00f9 l\u00e0 kho\u1ea3ng tr\u1eafng \u1edf \u0111\u1ea7u, gi\u1eefa hay cu\u1ed1i chu\u1ed7i, h\u00e0m LEN v\u1eabn t\u00ednh t\u1ea5t c\u1ea3 l\u00e0 k\u00fd t\u1ef1. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 g\u00e2y ra sai l\u1ec7ch n\u1ebfu d\u1eef li\u1ec7u b\u1ea1n \u0111ang ki\u1ec3m tra ch\u01b0a \u0111\u01b0\u1ee3c x\u1eed l\u00fd s\u1ea1ch. Do \u0111\u00f3, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng chu\u1ed7i v\u0103n b\u1ea3n kh\u00f4ng ch\u1ee9a d\u1ea5u c\u00e1ch th\u1eeba n\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n \u0111\u1ebfm ph\u1ea7n n\u1ed9i dung ch\u00ednh.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477713 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-19.jpg\" alt=\"dem-ky-tu-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kh\u00f4ng \u00e1p d\u1ee5ng tr\u1ef1c ti\u1ebfp cho d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m LEN v\u1edbi c\u00e1c \u00f4 ch\u1ee9a ng\u00e0y th\u00e1ng, Excel s\u1ebd \u0111\u1ebfm k\u00fd t\u1ef1 d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb s\u1ed1 n\u1ed9i b\u1ed9 c\u1ee7a ng\u00e0y \u0111\u00f3 (th\u01b0\u1eddng l\u00e0 s\u1ed1 seri), ch\u1ee9 kh\u00f4ng ph\u1ea3i \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 th\u1ec3 khi\u1ebfn b\u1ea1n hi\u1ec3u sai n\u1ebfu kh\u00f4ng \u0111\u1ec3 \u00fd \u0111\u1ebfn ki\u1ec3u d\u1eef li\u1ec7u ban \u0111\u1ea7u.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 ph\u1ee5 thu\u1ed9c v\u00e0o n\u1ed9i dung th\u1ef1c t\u1ebf trong \u00f4<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u00f4i khi chu\u1ed7i v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c t\u1ea1o ra t\u1eeb c\u00f4ng th\u1ee9c ho\u1eb7c ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 \u1ea9n m\u00e0 b\u1ea1n kh\u00f4ng nh\u00ecn th\u1ea5y b\u1eb1ng m\u1eaft th\u01b0\u1eddng. Trong tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3, LEN v\u1eabn \u0111\u1ebfm to\u00e0n b\u1ed9 k\u00fd t\u1ef1 th\u1eadt s\u1ef1 c\u00f3 trong \u00f4, kh\u00f4ng ph\u1ea3i ch\u1ec9 nh\u1eefng g\u00ec hi\u1ec3n th\u1ecb. \u0110i\u1ec1u n\u00e0y r\u1ea5t quan tr\u1ecdng khi x\u1eed l\u00fd d\u1eef li\u1ec7u t\u1ef1 \u0111\u1ed9ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-20-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477714 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-20.jpg\" alt=\"dem-ky-tu-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-20-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u00ean k\u1ebft h\u1ee3p v\u1edbi TRIM ho\u1eb7c SUBSTITUTE \u0111\u1ec3 lo\u1ea1i b\u1ecf k\u00fd t\u1ef1 th\u1eeba<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm ch\u00ednh x\u00e1c ph\u1ea7n n\u1ed9i dung c\u1ed1t l\u00f5i m\u00e0 kh\u00f4ng b\u1ecb \u1ea3nh h\u01b0\u1edfng b\u1edfi kho\u1ea3ng tr\u1eafng d\u01b0, h\u00e3y d\u00f9ng h\u00e0m TRIM \u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1ea5u c\u00e1ch \u1edf \u0111\u1ea7u\/cu\u1ed1i chu\u1ed7i. Trong khi \u0111\u00f3, SUBSTITUTE r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh (nh\u01b0 d\u1ea5u c\u00e1ch, d\u1ea5u ch\u1ea5m,&#8230;).<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m LEN ph\u00f9 h\u1ee3p nh\u1ea5t v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng v\u0103n b\u1ea3n<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m \u0111\u1ebfm k\u00fd t\u1ef1 LEN ho\u1ea1t \u0111\u1ed9ng hi\u1ec7u qu\u1ea3 khi \u00e1p d\u1ee5ng cho c\u00e1c chu\u1ed7i k\u00fd t\u1ef1 ch\u1ee9a ch\u1eef, s\u1ed1 ho\u1eb7c k\u00fd hi\u1ec7u \u0111\u1eb7c bi\u1ec7t. Tuy nhi\u00ean, khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng logic (TRUE\/FALSE), c\u00f4ng th\u1ee9c ho\u1eb7c c\u00e1c \u0111\u1ecbnh d\u1ea1ng \u0111\u1eb7c bi\u1ec7t, b\u1ea1n n\u00ean ki\u1ec3m tra l\u1ea1i k\u1ebft qu\u1ea3 \u0111\u1ec3 tr\u00e1nh hi\u1ec3u nh\u1ea7m.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m LEN<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau \u0111\u00e2y l\u00e0 v\u00e0i c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m LEN:<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m LEN c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kh\u00f4ng. LEN ch\u1ec9 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1, kh\u00f4ng ph\u00e2n bi\u1ec7t \u0111\u00f3 l\u00e0 ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m LEN c\u00f3 th\u1ec3 d\u00f9ng v\u1edbi nhi\u1ec1u \u00f4 c\u00f9ng l\u00fac kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kh\u00f4ng tr\u1ef1c ti\u1ebfp. LEN ch\u1ec9 \u00e1p d\u1ee5ng cho t\u1eebng \u00f4 \u0111\u01a1n. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi SUM ho\u1eb7c ARRAYFORMULA (trong Google Sheets) \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a nhi\u1ec1u \u00f4.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-21.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-21-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/dem-ky-tu-21-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-477715 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-21.jpg\" alt=\"dem-ky-tu-21\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-21.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-21-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu-21-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 d\u00f9ng LEN \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 trong k\u1ebft qu\u1ea3 c\u1ee7a m\u1ed9t c\u00f4ng th\u1ee9c kh\u00e1c kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3. B\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 l\u1ed3ng h\u00e0m LEN v\u1edbi m\u1ed9t h\u00e0m kh\u00e1c, v\u00ed d\u1ee5: =LEN(TEXT(A1, &#8220;dd-mm-yyyy&#8221;)) \u0111\u1ec3 \u0111\u1ebfm c\u00e1c k\u00fd t\u1ef1 trong chu\u1ed7i ng\u00e0y \u0111\u00e3 \u0111\u1ecbnh d\u1ea1ng l\u1ea1i.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">LEN c\u00f3 ho\u1ea1t \u0111\u1ed9ng v\u1edbi \u00f4 tr\u1ed1ng kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3. N\u1ebfu \u00f4 ho\u00e0n to\u00e0n tr\u1ed1ng, h\u00e0m LEN s\u1ebd tr\u1ea3 v\u1ec1 0. N\u1ebfu \u00f4 c\u00f3 kho\u1ea3ng tr\u1eafng m\u00e0 b\u1ea1n kh\u00f4ng nh\u00ecn th\u1ea5y, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 1 ho\u1eb7c nhi\u1ec1u h\u01a1n, t\u00f9y s\u1ed1 l\u01b0\u1ee3ng d\u1ea5u c\u00e1ch.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m LEN c\u00f3 \u0111\u1ebfm \u0111\u01b0\u1ee3c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t ho\u1eb7c k\u00fd t\u1ef1 Unicode kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3. LEN s\u1ebd \u0111\u1ebfm c\u1ea3 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t, d\u1ea5u ti\u1ebfng Vi\u1ec7t v\u00e0 k\u00fd t\u1ef1 Unicode nh\u01b0 emoji. M\u1ed7i k\u00fd t\u1ef1 nh\u01b0 v\u1eady th\u01b0\u1eddng \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 1 k\u00fd t\u1ef1, nh\u01b0ng v\u1edbi m\u1ed9t s\u1ed1 emoji t\u1ed5 h\u1ee3p c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u00ednh nhi\u1ec1u h\u01a1n t\u00f9y h\u1ec7 th\u1ed1ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c n\u1eafm v\u1eefng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng \u0111\u1ebfm k\u00fd t\u1ef1 trong Excel v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u v\u0103n b\u1ea3n m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c h\u01a1n. D\u00f9 l\u00e0 lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng, tr\u00edch xu\u1ea5t chu\u1ed7i con hay t\u00ednh to\u00e1n \u0111\u1ed9 d\u00e0i v\u0103n b\u1ea3n, h\u00e0m LEN lu\u00f4n \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng trong thao t\u00e1c h\u00e0ng ng\u00e0y v\u1edbi b\u1ea3ng t\u00ednh. Hy v\u1ecdng b\u00e0i vi\u1ebft \u0111\u00e3 cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c h\u1eefu \u00edch \u0111\u1ec3 \u00e1p d\u1ee5ng linh ho\u1ea1t trong c\u00f4ng vi\u1ec7c.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tham kh\u1ea3o b\u00e0i vi\u1ebft li\u00ean quan:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/\"><span style=\"font-weight: 400;\">C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/sum\/\"><span style=\"font-weight: 400;\">H\u00e0m SUM trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft<\/span><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m LEN l\u00e0 c\u00f4ng c\u1ee5 quen thu\u1ed9c trong Excel gi\u00fap b\u1ea1n \u0111\u1ebfm k\u00fd t\u1ef1 trong m\u1ed9t \u00f4 d\u1eef li\u1ec7u b\u1ea5t k\u1ef3, bao g\u1ed3m c\u1ea3 kho\u1ea3ng tr\u1eafng v\u00e0 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t. V\u1edbi c\u00fa ph\u00e1p \u0111\u01a1n gi\u1ea3n v\u00e0 kh\u1ea3 n\u0103ng k\u1ebft h\u1ee3p linh ho\u1ea1t v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 LEFT, RIGHT, TRIM hay SUBSTITUTE, h\u00e0m LEN [&hellip;]<\/p>\n","protected":false},"author":102,"featured_media":477716,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,412],"tags":[],"class_list":["post-477694","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1, k\u00e8m v\u00ed d\u1ee5<\/title>\n<meta name=\"description\" content=\"B\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 ch\u00ednh x\u00e1c t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao. H\u00e3y kh\u00e1m ph\u00e1 n\u00e0o!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft\" \/>\n<meta property=\"og:description\" content=\"B\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 ch\u00ednh x\u00e1c t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao. H\u00e3y kh\u00e1m ph\u00e1 n\u00e0o!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-29T02:19:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft\",\"datePublished\":\"2025-07-29T02:19:41+00:00\",\"dateModified\":\"2025-07-29T02:19:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/\"},\"wordCount\":2957,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1, k\u00e8m v\u00ed d\u1ee5\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu.jpg\",\"datePublished\":\"2025-07-29T02:19:41+00:00\",\"dateModified\":\"2025-07-29T02:19:41+00:00\",\"description\":\"B\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 ch\u00ednh x\u00e1c t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao. H\u00e3y kh\u00e1m ph\u00e1 n\u00e0o!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu.jpg\",\"width\":1200,\"height\":628,\"caption\":\"dem-ky-tu\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4\",\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\"},\"description\":\"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1, k\u00e8m v\u00ed d\u1ee5","description":"B\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 ch\u00ednh x\u00e1c t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao. H\u00e3y kh\u00e1m ph\u00e1 n\u00e0o!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft","og_description":"B\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 ch\u00ednh x\u00e1c t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao. H\u00e3y kh\u00e1m ph\u00e1 n\u00e0o!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-07-29T02:19:41+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"16 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/"},"author":{"name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft","datePublished":"2025-07-29T02:19:41+00:00","dateModified":"2025-07-29T02:19:41+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/"},"wordCount":2957,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1, k\u00e8m v\u00ed d\u1ee5","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu.jpg","datePublished":"2025-07-29T02:19:41+00:00","dateModified":"2025-07-29T02:19:41+00:00","description":"B\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1 ch\u00ednh x\u00e1c t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao. H\u00e3y kh\u00e1m ph\u00e1 n\u00e0o!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/dem-ky-tu.jpg","width":1200,"height":628,"caption":"dem-ky-tu"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/dem-ky-tu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm k\u00fd t\u1ef1, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4","name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean"},"description":"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/477694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/102"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=477694"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/477694\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/477716"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=477694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=477694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=477694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}