{"id":11862,"date":"2025-01-15T05:44:06","date_gmt":"2025-01-15T05:44:06","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-dem-ki-tu-trong-o-bang-ham-len\/"},"modified":"2025-01-15T05:44:06","modified_gmt":"2025-01-15T05:44:06","slug":"cach-dem-ki-tu-trong-o-bang-ham-len","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-dem-ki-tu-trong-o-bang-ham-len\/","title":{"rendered":"C\u00e1ch \u0111\u1ebfm k\u00ed t\u1ef1 trong \u00f4 b\u1ea3ng h\u00e0m LEN"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t h\u00e0m Excel c\u00f3 th\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00ed t\u1ef1 trong m\u1ed9t \u00f4 th\u00ec \u0111\u00e2y ch\u00ednh l\u00e0 b\u00e0i vi\u1ebft b\u1ea1n c\u1ea7n t\u00ecm. B\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y s\u1ebd gi\u00fap b\u1ea1n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-len-trong-excel-de-dem-so-ky-tu-trong-mot-o.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m LEN<\/a> \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00ed t\u1ef1 trong Excel.<\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Trong t\u1ea5t c\u1ea3 c\u00e1c h\u00e0m Excel, LEN l\u00e0 h\u00e0m d\u1ec5 d\u00e0ng s\u1eed d\u1ee5ng nh\u1ea5t. Th\u1eadm ch\u00ed t\u00ean c\u1ee7a n\u00f3 v\u00f4 c\u00f9ng d\u1ec5 nh\u1edb v\u00ec l\u00e0 3 ch\u1eef c\u00e1i \u0111\u1ea7u c\u1ee7a ch\u1eef \u201clength\u201d (\u0111\u1ed9 d\u00e0i). V\u00e0 h\u00e0m LEN tr\u1ea3 l\u1ea1i ch\u00ednh x\u00e1c \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i k\u00ed t\u1ef1 ho\u1eb7c \u0111\u1ed9 d\u00e0i c\u1ee7a \u00f4.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">N\u00f3i c\u00e1ch kh\u00e1c, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel \u0111\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 s\u1ed1 k\u00ed t\u1ef1 trong m\u1ed9t \u00f4 bao g\u1ed3m ch\u1eef,s\u1ed1, k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t, v\u00e0 c\u1ea3 k\u00ed t\u1ef1 tr\u1ed1ng. <\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n s\u1eed d\u1ee5ng c\u00fa ph\u00e1p h\u00e0m LEN th\u00f4ng qua c\u00e1c v\u00ed d\u1ee5 c\u1ee5 th\u1ec3.<\/span><\/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-67874b23c4eca\" 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-ki-tu-trong-o-bang-ham-len.html#Ham_LEN\" title=\"H\u00e0m LEN\">H\u00e0m LEN<\/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-ki-tu-trong-o-bang-ham-len.html#Vi_du_cach_su_dung_ham_LEN_trong_Excel\" title=\"V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel\">V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_LEN\"><\/span><b>H\u00e0m LEN<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">H\u00e0m LEN trong Excel \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c k\u00ed t\u1ef1 trong m\u1ed9t \u00f4, v\u00e0 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 l\u00e0 \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i k\u00ed t\u1ef1. C\u00f4ng th\u1ee9c n\u00e0y c\u00f3 m\u1ed9t tham s\u1ed1 v\u00e0 l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=LEN (text)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">v\u1edbi \u201c<\/span><b>text<\/b><span style=\"font-weight: 400\">\u201d l\u00e0 chu\u1ed7i k\u00ed t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm.<\/span><\/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-331.gif\" title=\"ex101_92019-nho-331\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t b\u00e0i c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3m gi\u00fap b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m LEN<\/span><\/p>\n<p style=\"text-align: justify\"><b>=LEN (123) <\/b><span style=\"font-weight: 400\">\u2013 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 l\u00e0 3 b\u1edfi 3 s\u1ed1 \u0111\u01b0\u1ee3c cung c\u1ea5p cho tham s\u1ed1 <\/span><b>text<\/b><\/p>\n<p style=\"text-align: justify\"><b>=LEN (\u201ct\u1ed1t\u201d) <\/b><span style=\"font-weight: 400\">\u2013 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 l\u00e0 3 b\u1edfi t\u1eeb <\/span><i><span style=\"font-weight: 400\">t\u1ed1t <\/span><\/i><span style=\"font-weight: 400\">ch\u1ee9a 3 ch\u1eef c\u00e1i. Gi\u1ed1ng nh\u01b0 c\u00e1c c\u00f4ng th\u1ee9c Excel kh\u00e1c, h\u00e0m LEM y\u00eau c\u1ea7u chu\u1ed7i k\u00ed t\u1ef1 ph\u1ea3i n\u1eb1m trong d\u1ea5u ngo\u1eb7c k\u00e9p.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Tr\u00ean th\u1ef1c t\u1ebf, b\u1ea1n c\u00f3 xu h\u01b0\u1edbng cung c\u1ea5p \u00f4 tham chi\u1ebfu h\u01a1n l\u00e0 chu\u1ed7i s\u1ed1 ho\u1eb7c v\u0103n b\u1ea3n \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00ed t\u1ef1 trong m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t d\u00e3y c\u00e1c \u00f4.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u00ed d\u1ee5, \u0111\u1ec3 t\u00ednh \u0111\u1ed9 d\u00e0i c\u1ee7a v\u0103n b\u1ea3n trong \u00f4 A1, b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/span><\/p>\n<p style=\"text-align: justify\"><b>=LEN (A1)<\/b><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_cach_su_dung_ham_LEN_trong_Excel\"><\/span><b>V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00e1ch \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c k\u00ed t\u1ef1 trong m\u1ed9t \u00f4 (bao g\u1ed3m c\u1ea3 k\u00ed t\u1ef1 tr\u1ed1ng)<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u01b0 \u0111\u00e3 n\u00f3i \u1edf tr\u00ean, h\u00e0m LEN \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c k\u00ed t\u1ef1 trong m\u1ed9t \u00f4 bao g\u1ed3m t\u1ea5t c\u1ea3 k\u00ed t\u1ef1 tr\u1ed1ng. <\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u00ed d\u1ee5 \u0111\u1ec3 t\u00ednh \u0111\u1ed9 d\u00e0i \u00f4 A2, b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=LEN (A2)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c LEN \u0111\u1ebfm \u0111\u01b0\u1ee3c 25 k\u00ed t\u1ef1 bao g\u1ed3m 20 ch\u1eef c\u00e1i, m\u1ed9t ch\u1eef s\u1ed1 v\u00e0 5 k\u00ed t\u1ef1 tr\u1ed1ng<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6540\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-06-04-at-23-28-53.png\" width=\"600\" height=\"282\" title=\"screen-shot-2017-06-04-at-23-28-53\"><\/p>\n<ul style=\"text-align: justify\">\n<li><span style=\"font-weight: 400\">C\u00e1ch \u0111\u1ebfm s\u1ed1 k\u00ed t\u1ef1 trong nhi\u1ec1u \u00f4 <\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00ed t\u1ef1 trong nhi\u1ec1u \u00f4, ch\u1ecdn \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c Len v\u00e0 copy n\u00f3 v\u1ec1 c\u00e1c \u00f4 kh\u00e1c, c\u00f3 th\u1ec3 b\u1eb1ng c\u00e1ch k\u00e9o n\u00fat fill handle (d\u1ea5u ch\u1eef th\u1eadp m\u00e0u \u0111en g\u00f3c ph\u1ea3i d\u01b0\u1edbi \u00f4). Sau khi c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u01b0\u1ee3c copy, h\u00e0m LEN s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 k\u00ed t\u1ef1 \u0111\u1ebfm \u0111\u01b0\u1ee3c c\u1ee7a m\u1ed7i \u00f4. <\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y h\u00e0m LEN c\u00f3 th\u1ec3 \u0111\u1ebfm m\u1ecdi k\u00ed t\u1ef1 bao g\u1ed3m ch\u1eef c\u00e1i, ch\u1eef s\u1ed1, k\u00ed t\u1ef1 tr\u1ed1ng, d\u1ea5u ph\u1ea9y, d\u1ea5u nh\u00e1y, v.v<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6541 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-06-05-at-00-06-31.png\" width=\"576\" height=\"302\" title=\"screen-shot-2017-06-05-at-00-06-31\"><\/p>\n<p style=\"text-align: justify\"><b>L\u01b0u \u00fd: <\/b><span style=\"font-weight: 400\">Khi copy c\u00f4ng th\u1ee9c theo c\u1ed9t, h\u00e3y ch\u1eafc ch\u1eafn s\u1eed d\u1ee5ng \u00f4 tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u01b0\u01a1ng nh\u01b0 <\/span><b>LEN (A1)<\/b><span style=\"font-weight: 400\">, ho\u1eb7c tham chi\u1ebfu d\u1ea1ng h\u1ed7n h\u1ee3p nh\u01b0 <\/span><b>LEN ($A1)<\/b><span style=\"font-weight: 400\"> \u0111\u1ec3 c\u00f4ng th\u1ee9c LEN c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh ph\u00f9 h\u1ee3p cho nh\u1eefng v\u1ecb tr\u00ed m\u1edbi.<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li><span style=\"font-weight: 400\">\u0110\u1ebfm t\u1ed5ng s\u1ed1 k\u00ed t\u1ef1 \u1edf m\u1ed9t v\u00e0i \u00f4<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 \u0111\u1ebfm t\u1ed5ng s\u1ed1 k\u00ed t\u1ef1 \u1edf nhi\u1ec1u \u00f4 l\u00e0 t\u00ednh c\u1ed9ng c\u00e1c h\u00e0m LEN v\u1edbi nhau, v\u00ed d\u1ee5:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=LEN (A2) + LEN (A3) + LEN (A4)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 k\u00ed t\u1ef1 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi c\u00f4ng th\u1ee9c LEN<\/span><\/p>\n<p style=\"text-align: justify\"><b>=SUM (LEN (A2), LEN (A3), LEN (A4))<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Trong c\u1ea3 hai tr\u01b0\u1eddng h\u1ee3p tr\u00ean, c\u00f4ng th\u1ee9c \u0111\u1ebfm s\u1ed1 k\u00ed t\u1ef1 trong m\u1ed7i \u00f4 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh v\u00e0 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 l\u00e0 t\u1ed5ng \u0111\u1ed9 d\u00e0i chu\u1ed7i.<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6542 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-06-05-at-00-06-31-1.png\" width=\"576\" height=\"302\" title=\"screen-shot-2017-06-05-at-00-06-31-1\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00e1ch l\u00e0m n\u00e0y r\u1ea5t d\u1ec5 hi\u1ec3u v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng, nh\u01b0ng l\u1ea1i kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00ed t\u1ef1 trong m\u1ed9t d\u00e3y g\u1ed3m 100 ho\u1eb7c 1000 \u00f4. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m SUM v\u00e0 LEN trong c\u00f4ng th\u1ee9c m\u1ea3ng.<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li><span style=\"font-weight: 400\">C\u00e1ch \u0111\u1ebfm s\u1ed1 k\u00ed t\u1ef1 kh\u00f4ng bao g\u1ed3m k\u00ed t\u1ef1 tr\u1ed1ng<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c trang t\u00ednh l\u1edbn, m\u1ed9t v\u1ea5n \u0111\u1ec1 ph\u1ed5 bi\u1ebfn l\u00e0 k\u00ed t\u1ef1 tr\u1ed1ng cu\u1ed1i ho\u1eb7c \u0111\u1ea7u v\u0103n b\u1ea3n, v\u00ed d\u1ee5 nh\u01b0 kho\u1ea3ng tr\u1ed1ng th\u1eeba \u1edf \u0111\u1ea7u ho\u1eb7c cu\u1ed1i v\u0103n b\u1ea3n. B\u1ea1n c\u00f3 th\u1ec3 \u00edt khi nh\u1eadn ra ch\u00fang tr\u00ean trang t\u00ednh nh\u01b0ng sau m\u1ed9t v\u00e0i l\u1ea7n b\u1ea1n b\u1eaft \u0111\u1ea7u \u0111\u1ec3 m\u1eaft t\u1edbi ch\u00fang. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEN khi nghi ng\u1edd c\u00f3 k\u00ed t\u1ef1 tr\u1ed1ng. Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, h\u00e0m LEN \u0111\u1ebfm t\u1ea5t c\u1ea3 k\u00ed t\u1ef1 tr\u1ed1ng trong l\u00fac \u0111\u1ebfm<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6543\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-06-05-at-00-29-30.png\" width=\"600\" height=\"226\" title=\"screen-shot-2017-06-05-at-00-29-30\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c \u0111\u1ed9 d\u00e0i chu\u1ed7i v\u0103n b\u1ea3n tr\u1eeb k\u00ed t\u1ef1 tr\u1ed1ng, b\u1ea1n ch\u1ec9 c\u1ea7n g\u1eafn h\u00e0m TRIM v\u00e0o c\u00f4ng th\u1ee9c LEN <\/span><\/p>\n<p style=\"text-align: justify\"><b>=LEN (TRIM (A2))<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6544\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-06-05-at-00-35-46.png\" width=\"600\" height=\"218\" title=\"screen-shot-2017-06-05-at-00-35-46\"><\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ebfm s\u1ed1 k\u00ed t\u1ef1 trong m\u1ed9t \u00f4 kh\u00f4ng t\u00ednh t\u1ea5t c\u1ea3 c\u00e1c k\u00ed t\u1ef1 tr\u1ed1ng<\/li>\n<\/ul>\n<p style=\"text-align: justify\">N\u1ebfu m\u1ee5c \u0111\u00edch c\u1ee7a b\u1ea1n l\u00e0 \u0111\u1ebfm s\u1ed1 k\u00ed t\u1ef1 kh\u00f4ng t\u00ednh k\u00ed t\u1ef1 tr\u1ed1ng \u1edf \u0111\u1ea7u, cu\u1ed1i ho\u1eb7c gi\u1eefa v\u0103n b\u1ea3n, b\u1ea1n s\u1ebd c\u1ea7n m\u1ed9t c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p h\u01a1n<\/p>\n<p style=\"text-align: justify\"><strong>=LEN (SUBSTITUTE (A2, \u201d \u201c, \u201c\u201d))<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6545\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-06-05-at-00-42-04.png\" width=\"600\" height=\"215\" title=\"screen-shot-2017-06-05-at-00-42-04\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, <a href=\"http:\/\/blog.ezworkapp.com\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m SUBSTITUTE<\/a> gi\u00fap thay th\u1ebf m\u1ed9t k\u00ed t\u1ef1 n\u00e0y b\u1eb1ng m\u1ed9t k\u00ed t\u1ef1 kh\u00e1c. Trong c\u00f4ng th\u1ee9c tr\u00ean, b\u1ea1n \u0111\u00e3 thay k\u00ed t\u1ef1 tr\u1ed1ng (\u201c \u201d) v\u1edbi kh\u00f4ng k\u00ed t\u1ef1 n\u00e0o v\u00ed d\u1ee5 nh\u01b0 v\u1edbi m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n tr\u1ed1ng (\u201c\u201d). Do h\u00e0m SUBSTITUTE \u0111\u01b0\u1ee3c g\u1eafn v\u00e0o h\u00e0m LEN, c\u00f4ng th\u1ee9c n\u00e0y kh\u00f4ng th\u1ef1c s\u1ef1 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 thay th\u1ebf m\u00e0 ch\u1ec9 gi\u00fap h\u00e0m LEN t\u00ednh \u0111\u1ed9 d\u00e0i chu\u1ed7i v\u0103n b\u1ea3n kh\u00f4ng bao g\u1ed3m k\u00ed t\u1ef1 tr\u1ed1ng.<\/span><\/p>\n<ul style=\"text-align: justify\">\n<li><span style=\"font-weight: 400\">C\u00e1ch \u0111\u1ebfn s\u1ed1 k\u00ed t\u1ef1 tr\u01b0\u1edbc ho\u1eb7c sau m\u1ed9t k\u00ed t\u1ef1 \u0111\u01b0\u1ee3c cho<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u0110\u00f4i khi b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n bi\u1ebft \u0111\u1ed9 d\u00e0i m\u1ed9t \u0111o\u1ea1n n\u1eb1m trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch m\u00e3 SKU nh\u01b0 sau<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6546 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-06-05-at-00-45-10.png\" width=\"372\" height=\"298\" title=\"screen-shot-2017-06-05-at-00-45-10\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u00e0 t\u1ea5t c\u1ea3 c\u00e1c m\u00e3 h\u1ee3p l\u1ec7 \u0111\u1ec1u c\u00f3 5 k\u00ed t\u1ef1 trong nh\u00f3m \u0111\u1ea7u ti\u00ean. Nh\u01b0 v\u1eady \u0111\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c m\u00e3 \u0111\u00f3 h\u1ee3p l\u1ec7 hay kh\u00f4ng, b\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u1ebfm s\u1ed1 k\u00ed t\u1ef1 tr\u01b0\u1edbc d\u1ea5u g\u1ea1ch ngang. C\u00f4ng th\u1ee9c nh\u01b0 sau<\/span><\/p>\n<p style=\"text-align: justify\"><b>=LEN (LEFT ($A2, SEARCH(\u201c-\u201d, $A2)-1))<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6547\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-06-05-at-00-47-21.png\" width=\"600\" height=\"234\" title=\"screen-shot-2017-06-05-at-00-47-21\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c tr\u00ean \u0111\u01b0\u1ee3c hi\u1ec3u nh\u01b0 sau:<\/span><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ea1n s\u1eed d\u1ee5ng h\u00e0m SEARCH \u0111\u1ec3 cho k\u1ebft qu\u1ea3 l\u00e0 v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u g\u1ea1ch ngang \u0111\u1ea7u ti\u00ean (\u201c-\u201d) trong \u00f4 A2: <\/span><b>SEARCH (\u201c-\u201d, $A2)<\/b><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Sau \u0111\u00f3 d\u00f9ng h\u00e0m LEFT \u0111\u1ec3 h\u01b0\u1edbng h\u00e0m LEN \u0111\u1ebfm s\u1ed1 k\u00ed t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb b\u00ean tr\u00e1i chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 tr\u1eeb \u0111i 1 t\u1eeb k\u1ebft qu\u1ea3 do d\u1ea5u g\u1ea1ch ngang \u0111\u00e3 \u0111\u01b0\u1ee3c t\u00ednh v\u00e0o.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Cu\u1ed1i c\u00f9ng h\u00e0m LEN tr\u1ea3 v\u1ec1 \u0111\u1ed9 d\u00e0i chu\u1ed7i v\u0103n b\u1ea3n c\u1ea7n t\u00ednh.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Ngay khi c\u00f3 \u0111\u01b0\u1ee3c s\u1ed1 k\u00ed t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n th\u00eam m\u1ed9t b\u01b0\u1edbc n\u1eefa \u0111\u1ec3 highlight c\u00e1c m\u00e3 SKU kh\u00f4ng h\u1ee3p l\u1ec7 b\u1eb1ng c\u00e1ch l\u1eadp \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec7u ki\u1ec7n v\u1edbi c\u00f4ng th\u1ee9c v\u00ed d\u1ee5 nh\u01b0 <\/span><b>=$B2&lt;&gt;5<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6548\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-06-05-at-00-57-46-1024x799-1.png\" width=\"600\" height=\"468\" title=\"screen-shot-2017-06-05-at-00-57-46-1024x799-1\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 x\u00e1c nh\u1eadn m\u00e3 SKU kh\u00f4ng h\u1ee3p l\u1ec7 b\u1eb1ng c\u00e1ch g\u1eafn th\u00eam h\u00e0m IF tr\u01b0\u1edbc c\u00f4ng th\u1ee9c LEN <\/span><\/p>\n<p style=\"text-align: justify\"><b>=IF (LEN (LEFT ($A2, SEARCH (\u201c-\u201d, $A2)-1))&lt;&gt;5, \u201cKh\u00f4ng h\u1ee3p l\u1ec7\u201d, \u201c\u201d)<\/b><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c nh\u1eadn d\u1ea1ng ch\u00ednh x\u00e1c m\u00e3 SKU kh\u00f4ng h\u1ee3p l\u1ec7 d\u1ef1a tr\u00ean \u0111\u1ed9 d\u00e0i chu\u1ed7i v\u0103n b\u1ea3n, v\u00e0 b\u1ea1n kh\u00f4ng c\u1ea7n m\u1ed9t c\u1ed9t ri\u00eang \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00ed t\u1ef1.<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6549\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-06-05-at-01-01-45-1024x308-1.png\" width=\"600\" height=\"181\" title=\"screen-shot-2017-06-05-at-01-01-45-1024x308-1\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEN \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00ed t\u1ef1 sau m\u1ed9t k\u00ed t\u1ef1 nh\u1ea5t \u0111\u1ecbnh.<\/span><\/p>\n<blockquote>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">C\u00e1c h\u00e0m c\u01a1 b\u1ea3n trong Excel <\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">V\u00ed d\u1ee5, trong m\u1ed9t danh s\u00e1ch c\u00e1c t\u00ean, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n bi\u1ebft c\u00f3 bao nhi\u00eau k\u00ed t\u1ef1 n\u1eb1m trong T\u00ean. H\u00e0m LEN d\u01b0\u1edbi \u0111\u00e2y c\u00f3 th\u1ec3 l\u00e0m \u0111i\u1ec1u \u0111\u00f3 nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify\"><b>=LEN (RIGHT (A2, LEN (A2)-SEARCH (\u201c \u201c, A2)))<\/b><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6550\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2017-06-05-at-01-11-58.png\" width=\"600\" height=\"206\" title=\"screen-shot-2017-06-05-at-01-11-58\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng nh\u01b0 sau:<\/span><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li><span style=\"font-weight: 400\">\u0110\u1ea7u ti\u00ean b\u1ea1n x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed k\u00ed t\u1ef1 tr\u1ed1ng (\u201c \u201c) trong chu\u1ed7i v\u0103n b\u1ea3n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SEARCH <\/span><b>SEARCH (\u201c \u201d, A2)<\/b><\/li>\n<li><span style=\"font-weight: 400\">Sau \u0111\u00f3 t\u00ednh c\u00f3 bao nhi\u00eau k\u00ed t\u1ef1 \u0111\u1eb1ng sau d\u1ea5u c\u00e1ch. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n tr\u1eeb \u0111i v\u1ecb tr\u00ed d\u1ea5u c\u00e1ch t\u1eeb \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n <\/span><b>LEN (A2)-SEARCH(\u201c \u201d, A2)<\/b><\/li>\n<li><span style=\"font-weight: 400\">Sau \u0111\u00f3 h\u00e0m RIGHT \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 tr\u1ea3 l\u1ea1i c\u00e1c k\u00ed t\u1ef1 n\u1eb1m sau k\u00ed t\u1ef1 tr\u1ed1ng<\/span><\/li>\n<li><span style=\"font-weight: 400\">Cu\u1ed1i c\u00f9ng h\u00e0m LEN s\u1ebd t\u00ednh \u0111\u1ed9 d\u00e0i chu\u1ed7i \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i b\u1edfi h\u00e0m RIGHT<\/span><\/li>\n<li><span style=\"font-weight: 400\">L\u01b0u \u00fd r\u1eb1ng \u0111\u1ec3 c\u00f4ng th\u1ee9c tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 \u0111\u00fang, m\u1ed7i \u00f4 ch\u1ec9 n\u00ean ch\u1ee9a m\u1ed9t k\u00ed t\u1ef1 tr\u1ed1ng. Nh\u01b0 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u1ec9 c\u00f3 t\u00ean v\u00e0 t\u00ean h\u1ecd m\u00e0 kh\u00f4ng c\u00f3 t\u00ean \u0111\u1ec7m.<\/span><\/li>\n<\/ul>\n<blockquote>\n<p>\u0110\u0103ng k\u00fd ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\">L\u1edbp h\u1ecdc Excel \u1edf H\u00e0 N\u1ed9i<\/a><\/p>\n<\/blockquote>\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-331.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11863,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11862","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\/11862","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=11862"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11862\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11863"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}