{"id":12175,"date":"2022-11-18T22:59:29","date_gmt":"2022-11-18T15:59:29","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12175"},"modified":"2022-12-08T15:25:14","modified_gmt":"2022-12-08T08:25:14","slug":"ham-len-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/","title":{"rendered":"H\u00e0m Len trong Excel &#8211; H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;12175&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u00e0m Len trong Excel - H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ng\u00e0y nay c\u00f4ng ngh\u1ec7 th\u00f4ng tin ng\u00e0y c\u00e0ng ph\u00e1t tri\u1ec3n v\u00e0 ph\u1ed5 bi\u1ebfn, vi\u1ec7c s\u1eed d\u1ee5ng m\u00e1y t\u00ednh ch\u1eafc \u0111\u00e3 kh\u00f4ng c\u00f2n xa l\u1ea1 \u0111\u1ed1i v\u1edbi con ng\u01b0\u1eddi. \u0110em \u0111\u1ebfn nhi\u1ec1u c\u00f4ng d\u1ee5ng ph\u1ee5c v\u1ee5 cho nhu c\u1ea7u c\u1ee7a con ng\u01b0\u1eddi nh\u01b0 so\u1ea1n th\u1ea3o v\u0103n b\u1ea3n, l\u1eadp b\u1ea3ng t\u00ednh excel, powerpoint\u2026Trong \u0111\u00f3 excel l\u00e0 c\u00f4ng c\u1ee5 \u0111\u01b0\u1ee3c con ng\u01b0\u1eddi s\u1eed d\u1ee5ng nhi\u1ec1u trong vi\u1ec7c t\u00ednh to\u00e1n, l\u1eadp b\u1ea3ng\u2026 C\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u00e0 ph\u1ed5 bi\u1ebfn h\u01a1n c\u1ea3 l\u00e0 <\/span><b>h\u00e0m len trong excel<\/b><span style=\"font-weight: 400;\">. V\u1eady c\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n, c\u00fa ph\u00e1p v\u00e0 \u00fd ngh\u0129a c\u1ee7a h\u00e0m Len \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong Excel nh\u01b0 th\u1ebf n\u00e0o? c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 ph\u01b0\u01a1ng h\u01b0\u1edbng ra sao th\u00ec h\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y b\u1ea1n nh\u00e9.\u00a0\u00a0<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#Gioi_thieu_ve_ham_Len\" >Gi\u1edbi thi\u1ec7u v\u1ec1 h\u00e0m Len<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#Cach_dung_ham_Len_trong_Excel\" >C\u00e1ch d\u00f9ng h\u00e0m Len trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#Ham_Len_co_ban\" >H\u00e0m Len c\u01a1 b\u1ea3n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#Cong_thuc_su_dung_ham_Len_khi_ket_hop_voi_cac_ham_khac_trong_phan_mem_Excel\" >C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m Len khi k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong ph\u1ea7n m\u1ec1m Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#Dung_ket_hop_voi_ham_TRIM\" >D\u00f9ng k\u1ebft h\u1ee3p v\u1edbi h\u00e0m TRIM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#Dung_ham_Len_voi_SUBSTITUTE\" >D\u00f9ng h\u00e0m Len v\u1edbi SUBSTITUTE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#Cong_thuc_su_dung_ham_Len_ket_hop_voi_Search_va_Left_Right\" >C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m Len k\u1ebft h\u1ee3p v\u1edbi Search v\u00e0 Left \/ Right\u00a0\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#Cong_thuc_su_dung_ham_Len_ket_hop_voi_Mid_va_Search\" >C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m Len k\u1ebft h\u1ee3p v\u1edbi Mid v\u00e0 Search<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Gioi_thieu_ve_ham_Len\"><\/span><b>Gi\u1edbi thi\u1ec7u v\u1ec1 h\u00e0m Len<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00a0\u0110\u00e2y v\u1ed1n l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 trong m\u1ed9t \u00f4 bao g\u1ed3m c\u00e1c ch\u1eef c\u00e1i, ch\u1eef s\u1ed1, k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t n\u00ean r\u1ea5t d\u1ec5 \u0111\u1ec3 th\u1ef1c hi\u1ec7n.\u00a0\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0 h\u00e0m th\u00f4ng d\u1ee5ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Excel<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m b\u1eaft \u0111\u1ea7u b\u1eb1ng 3 k\u00fd t\u1ef1 c\u1ee7a t\u1eeb \u201c LENGTH\u201d- c\u00f3 ngh\u0129a l\u00e0 chi\u1ec1u d\u00e0i<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong ph\u1ea7n m\u1ec1m excel ng\u01b0\u1eddi ta s\u1ebd s\u1eed d\u1ee5ng c\u00fa ph\u00e1p = LEN ( ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1 hay \u00f4 c\u1ea7n \u0111\u1ebfm ) n\u00ean vi\u1ec7c nh\u1eadp \u0111\u00fang s\u1ebd \u0111\u01b0a ra gi\u00e1 tr\u1ecb v\u1ec1 \u0111\u1ed9 d\u00e0i\/ s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 thu\u1ed9c chu\u1ed7i k\u00fd t\u1ef1 k\u1ec3 c\u1ea3 nh\u1eefng k\u00fd t\u1ef1 thu\u1ed9c kho\u1ea3ng tr\u1ed1ng.\u00a0<\/span><b><\/b><\/p>\n<figure id=\"attachment_12189\" aria-describedby=\"caption-attachment-12189\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12189 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-1-e1648051052333.jpg\" alt=\"Gi\u1edbi thi\u1ec7u v\u1ec1 h\u00e0m Len\" width=\"600\" height=\"384\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-1-e1648051052333.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-1-e1648051052333-400x256.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12189\" class=\"wp-caption-text\">Gi\u1edbi thi\u1ec7u v\u1ec1 h\u00e0m Len<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_dung_ham_Len_trong_Excel\"><\/span><b>C\u00e1ch d\u00f9ng 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;\">\u0110\u1ec3 h\u00e0m Len c\u00f3 th\u1ec3 cung c\u1ea5p \u0111\u00fang k\u1ebft qu\u1ea3, s\u1ed1 li\u1ec7u <\/span><b>h\u00e0m l\u00e0m tr\u00f2n l\u00ean trong excel<\/b><span style=\"font-weight: 400;\"> m\u00e0 b\u1ea1n y\u00eau c\u1ea7u th\u00ec ch\u1eafc h\u1eb3n b\u1ea1n s\u1ebd ph\u1ea3i bi\u1ebft c\u00e1c c\u00fa ph\u00e1p c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m Len trong excel. V\u00e0 n\u1ebfu b\u1ea1n v\u1eabn c\u00f2n l\u00fang t\u00fang, l\u0103n t\u0103n, xin \u0111\u1eebng lo l\u1eafng, ch\u00fang t\u00f4i s\u1ebd \u1edf \u0111\u00e2y h\u1ed7 tr\u1ee3 v\u00e0 cung c\u1ea5p cho b\u1ea1n c\u00e1c th\u00f4ng tin c\u1ea7n thi\u1ebft v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng lo\u1ea1i h\u00e0m n\u00e0y<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00e1ch d\u00f9ng h\u00e0m LEN trong Excel - H\u00e0m \u0111\u1ebfm k\u00fd t\u1ef1 trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/NE4ss_lLGs8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_Len_co_ban\"><\/span><b>H\u00e0m Len c\u01a1 b\u1ea3n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng c\u00fa ph\u00e1p:<\/span><b> =LEN( TEXT)\u00a0<\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Text bao g\u1ed3m c\u00e1c chu\u1ed7i k\u00fd t\u1ef1 c\u1ea7n \u0111\u1ebfm ho\u1eb7c \u00f4 ch\u1ee9a chu\u1ed7i <a href=\"https:\/\/vi.wikipedia.org\/wiki\/K%C3%BD_t%E1%BB%B1\">k\u00fd t\u1ef1<\/a>, c\u00e1c kho\u1ea3ng tr\u1ed1ng c\u0169ng \u0111\u01b0\u1ee3c \u0111\u1ebfm trong chu\u1ed7i k\u00fd t\u1ef1<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sau khi \u0111\u00e3 ch\u1ecdn \u0111\u01b0\u1ee3c ph\u1ea7n Text d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm, h\u00e3y nh\u1ea5n Enter th\u00ec k\u1ebft qu\u1ea3 s\u1ebd b\u1eaft \u0111\u1ea7u hi\u1ec7n ra nh\u1eefng s\u1ed1 l\u01b0\u1ee3ng d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng.\u00a0\u00a0<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cong_thuc_su_dung_ham_Len_khi_ket_hop_voi_cac_ham_khac_trong_phan_mem_Excel\"><\/span><b>C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m Len khi k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong ph\u1ea7n m\u1ec1m Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m Len ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Sum hay d\u1ea5u \u2018 + \u2018 \u0111\u1ec3 \u0111\u1ebfm \u0111\u01b0\u1ee3c c\u00e1c k\u00fd t\u1ef1 trong nhi\u1ec1u \u00f4\u00a0<\/span><\/p>\n<figure id=\"attachment_12190\" aria-describedby=\"caption-attachment-12190\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12190 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-2-e1648051073309.jpg\" alt=\"Khi k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Sum\u00a0\" width=\"600\" height=\"381\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-2-e1648051073309.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-2-e1648051073309-400x254.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12190\" class=\"wp-caption-text\">Khi k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Sum<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><b><i>Khi k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Sum\u00a0<\/i><\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:\u00a0 <\/span><b>=Sum(Len(Text);Len(Text);Len(Text))<\/b><\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><i><span style=\"font-weight: 400;\">L\u01b0u \u00fd : Khi s\u1eed d\u1ee5ng lo\u1ea1i h\u00e0m n\u00e0y b\u1ea1n n\u00ean ki\u1ec3m tra k\u1ef9 c\u00e0ng d\u1ea5u ng\u0103n c\u00e1ch ( d\u1ea5u ph\u1ea9y, d\u1ea5u ch\u1ea5m ph\u1ea9y ) gi\u1eefa c\u00e1c h\u00e0m \u0111\u1ec3 gi\u1ea3m \u0111i s\u1ef1 \u1ea3nh h\u01b0\u1edfng c\u1ee7a c\u00e1c l\u1ed7i nh\u1ecf trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n.<\/span><\/i><\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sau khi nh\u1eadp v\u00e0 ki\u1ec3m tra h\u00e0m, nh\u1ea5n Enter \u0111\u1ec3 th\u1ef1c hi\u1ec7n v\u00e0 ho\u00e0n th\u00e0nh<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b><i>Khi k\u1ebft h\u1ee3p v\u1edbi d\u1ea5u \u2018 + \u2018<\/i><\/b><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn m\u1ed9t \u00f4 \u0111\u1ec3 t\u00ednh, sau \u0111\u00f3 nh\u1eadp c\u00f4ng th\u1ee9c\u00a0 <\/span><b>=Len(Text)+Len(Text)+Len(Text)<\/b><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u0169ng gi\u1ed1ng nh\u01b0 v\u1edbi h\u00e0m SUM, b\u1ea1n n\u00ean ch\u00fa \u00fd \u0111\u1ebfn c\u00e1c d\u1ea5u c\u1ee7a h\u00e0m, sau khi nh\u1eadp v\u00e0 ki\u1ec3m tra h\u00e0m, h\u00e3y nh\u1ea5n Enter v\u00e0 ho\u00e0n th\u00e0nh, l\u00fac n\u00e0y m\u00e1y t\u00ednh s\u1ebd thay b\u1ea1n l\u00e0m vi\u1ec7c v\u00e0 cung c\u1ea5p cho b\u1ea1n m\u1ed9t s\u1ed1 li\u1ec7u chi ti\u1ebft, c\u1ee5 th\u1ec3.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dung_ket_hop_voi_ham_TRIM\"><\/span><b>D\u00f9ng k\u1ebft h\u1ee3p v\u1edbi h\u00e0m TRIM<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_12192\" aria-describedby=\"caption-attachment-12192\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12192 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-4-e1648051095335.jpg\" alt=\"D\u00f9ng k\u1ebft h\u1ee3p v\u1edbi h\u00e0m TRIM\" width=\"600\" height=\"492\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-4-e1648051095335.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-4-e1648051095335-400x328.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12192\" class=\"wp-caption-text\">D\u00f9ng k\u1ebft h\u1ee3p v\u1edbi h\u00e0m TRIM<\/figcaption><\/figure>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u1edbi c\u00fa ph\u00e1p: <\/span><b>=Trim(Text) <\/b><span style=\"font-weight: 400;\">loai h\u00e0m n\u00e0y c\u00f3 t\u00e1c d\u1ee5ng d\u00f9ng \u0111\u1ec3 b\u1ecf qua kho\u1ea3ng tr\u1ed1ng v\u00e0 l\u00f9i v\u00e0o \u0111\u1ea7u d\u00f2ng ho\u1eb7c cu\u1ed1i d\u00f2ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 nh\u1eb1m t\u0103ng kh\u1ea3 n\u0103ng b\u1ea3o \u0111\u1ea3m ch\u00ednh x\u00e1c trong vi\u1ec7c \u0111\u1ebfm c\u00e1c k\u00fd t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m TRIM k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Len s\u1ebd \u0111em \u0111\u1ebfn m\u1ed9t hi\u1ec7u qu\u1ea3 \u0111\u00e1ng ng\u1edd cho b\u1ea1n<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1ea5n Enter sau khi \u0111\u00e3 ho\u00e0n th\u00e0nh vi\u1ec7c nh\u1eadp h\u00e0m.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dung_ham_Len_voi_SUBSTITUTE\"><\/span><b>D\u00f9ng h\u00e0m Len v\u1edbi SUBSTITUTE<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c k\u1ebft h\u1ee3p n\u00e0y c\u0169ng gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m \u1edf tr\u00ean nh\u01b0ng vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1ch n\u00e0y s\u1ebd kh\u00f4ng l\u00e0m thay \u0111\u1ed5i \u00f4 d\u1eef li\u1ec7u ban \u0111\u1ea7u.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><b>\u00a0=Len(Substitute(Text;Old_Text;New_Text;Instance_Num))<\/b><span style=\"font-weight: 400;\">&#8211; l\u00e0 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u1ee7a SUBSTITUTE. Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Text: ch\u1ee9a nh\u1eefng lo\u1ea1i \u00f4 d\u1eef li\u1ec7u m\u00e0 b\u1ea1n t\u00ecm ki\u1ebfm<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Old- text: bao g\u1ed3m c\u00e1c k\u00fd t\u1ef1 c\u0169 b\u1ea1n c\u1ea7n l\u1ef1a ch\u1ecdn \u0111\u1ec3 thay th\u1ebf<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">New- Text: ng\u01b0\u1ee3c l\u1ea1i v\u1edbi old-text, new- text d\u00f9ng \u0111\u1ec3 thay th\u1ebf c\u00e1c lo\u1ea1i k\u00fd t\u1ef1 c\u0169\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Instance_Num: \u0111\u00e2y l\u00e0 v\u1ecb tr\u00ed ch\u1ee9a nh\u1eefng v\u0103n b\u1ea3n c\u0169 xu\u1ea5t hi\u1ec7n<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau khi ho\u00e0n th\u00e0nh c\u00e1c b\u01b0\u1edbc, h\u00e3y nh\u1ea5n Enter v\u00e0 ch\u1edd k\u1ebft qu\u1ea3.<\/span><\/p>\n<figure id=\"attachment_12193\" aria-describedby=\"caption-attachment-12193\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12193 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-5-e1648051110488.jpg\" alt=\"D\u00f9ng h\u00e0m Len v\u1edbi SUBSTITUTE\" width=\"600\" height=\"478\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-5-e1648051110488.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-5-e1648051110488-400x319.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12193\" class=\"wp-caption-text\">D\u00f9ng h\u00e0m Len v\u1edbi SUBSTITUTE<\/figcaption><\/figure>\n<p>Xem th\u00eam:<\/p>\n<p><a href=\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/\">C\u00e1ch s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng?<\/a><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cong_thuc_su_dung_ham_Len_ket_hop_voi_Search_va_Left_Right\"><\/span><b>C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m Len k\u1ebft h\u1ee3p v\u1edbi Search v\u00e0 Left \/ Right\u00a0\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Excel k\u1ebft h\u1ee3p linh ho\u1ea1t c\u00e1c h\u00e0m v\u1edbi nhau gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u0111\u1ebfm ch\u00ednh x\u00e1c c\u00e1c k\u00fd t\u1ef1 m\u1eb7c \u0111\u1ecbnh \u1edf b\u00ean tr\u00e1i, ph\u1ea3i nh\u01b0: &#8220;-&#8220;, &#8220;_&#8221;, &#8220;\/&#8221;, \u2026<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m l\u00e0: <\/span><b>=Len(Left(Text;Search(Find_Text;Within_Text;Star_Num))<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">G\u1ed3m :\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u00a0Text: c\u0169ng gi\u1ed1ng nh\u01b0 SUBSTITUTE c\u0169ng l\u00e0 lo\u1ea1i \u00f4 d\u1eef li\u1ec7u m\u00e0 b\u1ea1n t\u00ecm ki\u1ebfm<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Find- text: gi\u00fap b\u1ea1n t\u00ecm ki\u1ebfm c\u00e1c k\u00fd t\u1ef1 trong \u00f4 d\u1eef li\u1ec7u<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Within- Text: bao g\u1ed3m to\u00e0n b\u1ed9 c\u00e1c d\u1eef li\u1ec7u b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Star- num: Kh\u00f4ng c\u1ea7n nh\u1eadp v\u00e0o v\u0103n b\u1ea3n, th\u00f4ng th\u01b0\u1eddng s\u1ebd b\u1eaft \u0111\u1ea7u b\u1eb1ng k\u00fd t\u1ef1 s\u1ed1 m\u1ea5y<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">CLick Enter v\u00e0 ho\u00e0n th\u00e0nh.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u00fa \u00fd: H\u00e0m Len k\u1ebft h\u1ee3p v\u1edbi h\u00e0m RIGHT c\u0169ng s\u1ebd t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0ng LEFT<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12191\" aria-describedby=\"caption-attachment-12191\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12191 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-3-e1648051143744.jpg\" alt=\"C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m Len k\u1ebft h\u1ee3p v\u1edbi Search v\u00e0 Left \/ Right\u00a0\u00a0\" width=\"600\" height=\"340\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-3-e1648051143744.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel-3-e1648051143744-400x227.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12191\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m Len k\u1ebft h\u1ee3p v\u1edbi Search v\u00e0 Left \/ Right<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cong_thuc_su_dung_ham_Len_ket_hop_voi_Mid_va_Search\"><\/span><b>C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m Len k\u1ebft h\u1ee3p v\u1edbi Mid v\u00e0 Search<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u00fang ta nh\u1eadp h\u00e0m : <\/span><b>=LEN(MID(H5;4;LEN(H5)-6))<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><b>=Len(H5)-6<\/b><span style=\"font-weight: 400;\">: v\u1edbi m\u1ee5c \u0111\u00edch l\u00e0 c\u1eaft 6 k\u00fd t\u1ef1 \u1edf gi\u1eefa hai b\u00ean d\u1eef li\u1ec7u\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>=Mid(H5;4;Len(H5)-6)<\/b><span style=\"font-weight: 400;\">: h\u00e0m Len k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m Mid \u1edf Num_chars s\u1ebd gi\u00fap c\u00f3 th\u1ec3 ch\u1ecdn l\u1ecdc v\u00e0 l\u1ea5y \u0111\u01b0\u1ee3c nh\u1eefng k\u00fd t\u1ef1 \u1edf gi\u1eefa\u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>=Len(Mid(H5;4;Len(H5)-6))<\/b><span style=\"font-weight: 400;\">: Nh\u01b0 \u0111\u00e3 cung c\u1ea5p c\u00f4ng th\u1ee9c \u1edf tr\u00ean, \u0111\u1ec3 h\u00e0m c\u00f3 th\u1ec3 \u0111\u1ebfm s\u1ed1 li\u1ec7u \u1edf gi\u1eefa hai d\u1ea5u g\u1ea1ch c\u1ee7a \u00f4 d\u1eef li\u1ec7u b\u1ea1n ph\u1ea3i th\u00eam h\u00e0m LEN v\u00e0o<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft th\u00fac qu\u00e1 tr\u00ecnh nh\u1eadp h\u00e0ng, nh\u1ea5n Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN c\u01a1 b\u1ea3n v\u00e0 <\/span><b>c\u00e1ch l\u00e0m tr\u00f2n h\u00e0m trong Excel <\/b><span style=\"font-weight: 400;\">nh\u1eb1m m\u1ee5c \u0111\u00edch gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh to\u00e1n m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng v\u00e0 thu\u1eadn ti\u1ec7n nh\u1ea5t. Ch\u00fang t\u00f4i lu\u00f4n s\u1eb5n s\u00e0ng cung c\u1ea5p \u0111\u1ed3ng th\u1eddi gi\u1ea3i \u0111\u00e1p nh\u1eefng th\u1eafc m\u1eafc c\u1ee7a b\u1ea1n trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng v\u00e0 l\u00e0m vi\u1ec7c.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y s\u1ebd \u0111em l\u1ea1i nh\u1eefng \u0111i\u1ec1u b\u1ed5 \u00edch cho b\u1ea1n.\u00a0\u00a0<\/span><\/p>\n<p><strong>Xem th\u00eam:<\/strong><\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/dinh-dang-text-trong-excel\/\" target=\"_blank\" rel=\"noopener\">\u0110\u1ecbnh d\u1ea1ng text trong excel c\u00f3 kh\u00f3 hay kh\u00f4ng?<\/a><\/li>\n<li><a href=\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-tron-trong-excel\/\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 tr\u00f2n trong excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\" target=\"_blank\" rel=\"noopener\">Nh\u1eefng \u0111i\u1ec1u b\u1ea1n c\u1ea7n bi\u1ebft v\u1ec1 h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Ng\u00e0y nay c\u00f4ng ngh\u1ec7 th\u00f4ng tin ng\u00e0y c\u00e0ng ph\u00e1t tri\u1ec3n v\u00e0 ph\u1ed5 bi\u1ebfn, vi\u1ec7c s\u1eed d\u1ee5ng m\u00e1y t\u00ednh ch\u1eafc \u0111\u00e3 kh\u00f4ng c\u00f2n xa l\u1ea1 \u0111\u1ed1i v\u1edbi con ng\u01b0\u1eddi. \u0110em \u0111\u1ebfn nhi\u1ec1u c\u00f4ng d\u1ee5ng ph\u1ee5c v\u1ee5 cho nhu c\u1ea7u c\u1ee7a con ng\u01b0\u1eddi nh\u01b0 so\u1ea1n th\u1ea3o v\u0103n b\u1ea3n, l\u1eadp b\u1ea3ng t\u00ednh excel, powerpoint\u2026Trong \u0111\u00f3 excel l\u00e0 c\u00f4ng &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12188,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12175","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m Len trong Excel - H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3<\/title>\n<meta name=\"description\" content=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Len trong Excel hi\u1ec7u qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng theo d\u00f5i b\u00e0i vi\u1ebft.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m Len trong Excel - H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3\" \/>\n<meta property=\"og:description\" content=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Len trong Excel hi\u1ec7u qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng theo d\u00f5i b\u00e0i vi\u1ebft.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-18T15:59:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-08T08:25:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"338\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m Len trong Excel &#8211; H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3\",\"datePublished\":\"2022-11-18T15:59:29+00:00\",\"dateModified\":\"2022-12-08T08:25:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/\"},\"wordCount\":1852,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/\",\"name\":\"H\u00e0m Len trong Excel - H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel.jpg\",\"datePublished\":\"2022-11-18T15:59:29+00:00\",\"dateModified\":\"2022-12-08T08:25:14+00:00\",\"description\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Len trong Excel hi\u1ec7u qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng theo d\u00f5i b\u00e0i vi\u1ebft.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel.jpg\",\"width\":600,\"height\":338,\"caption\":\"H\u00e0m Len trong Excel - H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m Len trong Excel &#8211; H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m Len trong Excel - H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3","description":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Len trong Excel hi\u1ec7u qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng theo d\u00f5i b\u00e0i vi\u1ebft.","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:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m Len trong Excel - H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3","og_description":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Len trong Excel hi\u1ec7u qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng theo d\u00f5i b\u00e0i vi\u1ebft.","og_url":"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-18T15:59:29+00:00","article_modified_time":"2022-12-08T08:25:14+00:00","og_image":[{"width":600,"height":338,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m Len trong Excel &#8211; H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3","datePublished":"2022-11-18T15:59:29+00:00","dateModified":"2022-12-08T08:25:14+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/"},"wordCount":1852,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/","name":"H\u00e0m Len trong Excel - H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel.jpg","datePublished":"2022-11-18T15:59:29+00:00","dateModified":"2022-12-08T08:25:14+00:00","description":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Len trong Excel hi\u1ec7u qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng theo d\u00f5i b\u00e0i vi\u1ebft.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-len-trong-excel.jpg","width":600,"height":338,"caption":"H\u00e0m Len trong Excel - H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m Len trong Excel &#8211; H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=12175"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12175\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12188"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}