{"id":5838,"date":"2024-12-21T08:18:14","date_gmt":"2024-12-21T08:18:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-su-dung-ham-left-nang-cao-ket-hop-nhieu-ham-trong-excel\/"},"modified":"2024-12-21T08:18:14","modified_gmt":"2024-12-21T08:18:14","slug":"huong-dan-cach-su-dung-ham-left-nang-cao-ket-hop-nhieu-ham-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-su-dung-ham-left-nang-cao-ket-hop-nhieu-ham-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT n\u00e2ng cao k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00e0m LEFT l\u00e0 m\u1ed9t h\u00e0m kh\u00e1 c\u01a1 b\u1ea3n trong\u00a0Excel trong vi\u1ec7c x\u1eed l\u00fd k\u00fd t\u1ef1.\u00a0T\u00e1c d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y l\u00e0 l\u1ea5y ph\u1ea7n k\u00fd t\u1ef1 b\u00ean tr\u00e1i trong 1 chu\u1ed7i k\u00fd t\u1ef1. Nh\u01b0ng kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng x\u00e1c\u00a0\u0111\u1ecbnh ngay\u00a0\u0111\u01b0\u1ee3c c\u1ea7n l\u1ea5y bao nhi\u00eau k\u00fd t\u1ef1. Khi\u00a0\u0111\u00f3 ch\u00fang ta ph\u1ea3i k\u1ebft h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c m\u1edbi\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3. H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT<\/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-676679c5611b7\" 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\/huong-dan-cach-su-dung-ham-left-nang-cao-ket-hop-nhieu-ham-trong-excel.html#Cach_su_dung_ham_LEFT_ket_hop_ham_SEARCH\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT k\u1ebft h\u1ee3p h\u00e0m SEARCH\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT k\u1ebft h\u1ee3p h\u00e0m SEARCH<\/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\/huong-dan-cach-su-dung-ham-left-nang-cao-ket-hop-nhieu-ham-trong-excel.html#Cach_su_dung_ham_LEFT_ket_hop_ham_LEN\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT k\u1ebft h\u1ee3p h\u00e0m LEN\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT k\u1ebft h\u1ee3p h\u00e0m LEN<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_LEFT_ket_hop_ham_SEARCH\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT k\u1ebft h\u1ee3p h\u00e0m SEARCH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23425\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/de-bai-ham-left-nang-cao.png\" width=\"615\" height=\"152\" title=\"de-bai-ham-left-nang-cao\"><\/p>\n<p>Y\u00eau c\u1ea7u: T\u00e1ch ph\u1ea7n t\u00ean trong m\u1ed7i\u00a0\u0111o\u1ea1n email (ph\u1ea7n k\u00fd t\u1ef1 tr\u01b0\u1edbc d\u1ea5u @)<\/p>\n<p>Ph\u1ea7n k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y n\u1eb1m\u00a0\u1edf b\u00ean tr\u00e1i c\u1ee7a\u00a0\u0111o\u1ea1n text, do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEFT. Nh\u01b0ng s\u1ed1\u00a0k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y l\u1ea1i kh\u00e1c nhau. Do\u00a0\u0111\u00f3 kh\u00f4ng th\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh ngay\u00a0\u0111\u01b0\u1ee3c tham s\u1ed1 num_char trong h\u00e0m left.\u00a0\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y, ch\u00fang ta s\u1ebd c\u0103n c\u1ee9 v\u00e0o k\u00fd t\u1ef1 @.<\/p>\n<p>C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>D\u00f9ng h\u00e0m Search x\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed d\u1ea5u @ trong c\u00e1c\u00a0\u00f4\u00a0\u1edf c\u1ed9t A<\/li>\n<li>S\u1ed1 k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y c\u1ee7a h\u00e0m LEFT l\u00e0 ph\u1ea7n tr\u01b0\u1edbc k\u00fd t\u1ef1 @, n\u00ean num_char = k\u1ebft qu\u1ea3 h\u00e0m Search \u2013 1<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23427\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-ham-left-ket-hop-search.png\" width=\"668\" height=\"199\" title=\"su-dung-ham-left-ket-hop-search\"><\/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\/2024\/12\/ex101_92019-nho-514.gif\" title=\"ex101_92019-nho-514\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 D2 l\u00e0:<\/p>\n<p style=\"padding-left: 30px\">=LEFT(A2,SEARCH(\u201c@\u201d,A2)-1)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>A2:\u00a0\u0110o\u1ea1n text c\u1ea7n t\u00e1ch k\u00fd t\u1ef1 b\u1edfi h\u00e0m left<\/li>\n<li>SEARCH(\u201c@\u201d,A2): t\u00ecm v\u1ecb tr\u00ed k\u00fd t\u1ef1 @ trong\u00a0\u00f4 A2<\/li>\n<li>SEARCH(\u201c@\u201d,A2)-1: s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y c\u1ee7a h\u00e0m Left l\u00e0 ph\u1ea7n b\u00ean tr\u00e1i c\u1ee7a k\u00fd t\u1ef1 @<\/li>\n<\/ul>\n<p>=&gt; Khi mu\u1ed1n t\u00e1ch k\u00fd t\u1ef1 d\u1ef1a theo 1 k\u00fd t\u1ef1\u00a0\u0111\u1eb7c tr\u01b0ng c\u00f3 th\u1ec3 nh\u1eadn bi\u1ebft\u00a0\u0111\u01b0\u1ee3c, ch\u00fang ta d\u00f9ng h\u00e0m Search\u00a0\u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed k\u00fd t\u1ef1\u00a0\u0111\u00f3. Sau\u00a0\u0111\u00f3 d\u1ef1a theo ph\u1ea7n k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y n\u1eb1m\u00a0\u1edf v\u1ecb tr\u00ed n\u00e0o th\u00ec d\u00f9ng h\u00e0m t\u00e1ch k\u00fd t\u1ef1 t\u01b0\u01a1ng\u00a0\u1ee9ng.<\/p>\n<p>Tham kh\u1ea3o: <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-find-va-search-voi-cac-cong-thuc-vi-du.html\">H\u00e0m FIND<\/a> v\u00e0 SEARCH v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_LEFT_ket_hop_ham_LEN\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT k\u1ebft h\u1ee3p h\u00e0m LEN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi ch\u00fang ta mu\u1ed1n chuy\u1ec3n to\u00e0n b\u1ed9 gi\u00e1 tr\u1ecb trong 1\u00a0\u00f4 v\u1ec1 d\u1ea1ng text th\u00ec l\u00e0m th\u1ebf n\u00e0o? C\u00e2u tr\u1ea3 l\u1eddi r\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n: D\u00f9ng h\u00e0m LEFT\u00a0v\u1edbi s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y b\u1eb1ng\u00a0\u0111\u00fang t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1\u00a0\u0111o\u1ea1n text. K\u1ebft qu\u1ea3 h\u00e0m LEFT lu\u00f4n l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng Text.<\/p>\n<ul>\n<li>B\u01b0\u1edbc 1: S\u1eed d\u1ee5ng h\u00e0m LEN\u00a0\u0111\u1ec3\u00a0\u0111o\u00a0\u0111\u1ed9 d\u00e0i s\u1ed1 k\u00fd t\u1ef1 trong\u00a0\u00f4<\/li>\n<li>B\u01b0\u1edbc 2: D\u00f9ng h\u00e0m LEFT, trong\u00a0\u0111\u00f3 <em><strong>num_char<\/strong><\/em> ch\u00ednh l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m LEN<\/li>\n<\/ul>\n<p>Tham kh\u1ea3o:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html\">H\u00e0m LEN, h\u00e0m \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i<\/a><\/p>\n<p>Xem v\u00ed d\u1ee5 d\u01b0\u1edbi\u00a0\u0111\u00e2y<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23428\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-ham-left-ket-hop-len.png\" width=\"668\" height=\"171\" title=\"su-dung-ham-left-ket-hop-len\"><\/p>\n<p>T\u1ea1i c\u1ed9t A ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 c\u00e1c con s\u1ed1 (ki\u1ec3m tra b\u1eb1ng h\u00e0m\u00a0IsNumber ra k\u1ebft qu\u1ea3 TRUE t\u1ea1i c\u1ed9t B)<\/p>\n<p>T\u1ea1i c\u1ed9t C d\u00f9ng h\u00e0m LEFT k\u1ebft h\u1ee3p h\u00e0m LEN\u00a0\u0111\u1ec3 chuy\u1ec3n c\u00e1c con s\u1ed1\u00a0\u1edf c\u1ed9t A v\u1ec1 d\u1ea1ng TEXT (ki\u1ec3m tra b\u1eb1ng h\u00e0m\u00a0IsText ra k\u1ebft qu\u1ea3 TRUE t\u1ea1i c\u1ed9t D)<\/p>\n<p>\u0110\u1ecdc th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-phan-biet-loai-du-lieu-trong-excel-voi-nhom-ham-isnumber-isnontext-istext.html\">C\u00e1ch ph\u00e2n bi\u1ec7t d\u1ea1ng d\u1eef li\u1ec7u trong Excel v\u1edbi nh\u00f3m h\u00e0m IsNumber, IsNonText, IsText<\/a><\/p>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html\">h\u00e0m LEFT trong Excel<\/a><\/strong> khi k\u1ebft h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c trong Excel. B\u1ea1n c\u00f3 bi\u1ebft c\u00e1ch k\u1ebft h\u1ee3p n\u00e0o kh\u00e1c n\u1eefa kh\u00f4ng? H\u00e3y trao \u0111\u1ed5i v\u1edbi H\u1ecdc Excel Online nh\u00e9.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-514.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5839,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5838","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\/5838","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=5838"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5838\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5839"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5838"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5838"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5838"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}