{"id":2221,"date":"2024-12-02T07:15:39","date_gmt":"2024-12-02T07:15:39","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-left-right-va-cach-su-dung-ham-left-right-trong-excel\/"},"modified":"2024-12-02T07:15:39","modified_gmt":"2024-12-02T07:15:39","slug":"ham-left-right-va-cach-su-dung-ham-left-right-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-left-right-va-cach-su-dung-ham-left-right-trong-excel\/","title":{"rendered":"H\u00e0m LEFT, RIGHT v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT, RIGHT trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><strong>Nhi\u1ec1u l\u00fac c\u00e1c b\u1ea1n mu\u1ed1n tr\u00edch d\u1eabn m\u1ed9t v\u00e0i k\u00fd t\u1ef1 trong chu\u1ed7i Text m\u00e0 kh\u00f4ng bi\u1ebft ph\u1ea3i l\u00e0m nh\u01b0 th\u1ebf n\u00e0o, d\u00f9ng h\u00e0m n\u00e0o th\u00ec h\u1ee3p l\u00fd. H\u00f4m nay m\u00ecnh s\u1ebd gi\u1edbi thi\u1ec7u \u00a0v\u1edbi c\u00e1c b\u1ea1n hai h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t nhi\u1ec1u trong Excel \u0111\u1ec3 tr\u00edch d\u1eabn k\u00fd t\u1ef1 trong chu\u1ed7i Text, \u0111\u00f3 l\u00e0 h\u00e0m Left v\u00e0 Right.\u00a0<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>1. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Left:<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p h\u00e0m Left: <strong>Left(text, num_chars)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul>\n<li style=\"text-align: justify\">Text: Bi\u1ec3u th\u1ee9c k\u00fd t\u1ef1<\/li>\n<li style=\"text-align: justify\">Num_chars: s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y ra t\u1eeb b\u00ean tr\u00e1i c\u1ee7a Text<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Ch\u1ee9c n\u0103ng: K\u1ebft qu\u1ea3 l\u00e0 bi\u1ec3u th\u1ee9c k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c l\u1ea5y ra t\u1eeb b\u00ean tr\u00e1i c\u1ee7a Text v\u1edbi s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 l\u1ea5y ra \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1eb1ng num_chars.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: Ph\u00e2n lo\u1ea1i ch\u1ee9c v\u1ee5 theo M\u00e3 nh\u00e2n vi\u00ean<\/p>\n<p style=\"text-align: justify\">T\u1ea1i \u00f4 D2 ta th\u1ef1c hi\u1ec7n: <strong>=Left(C2,2)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3467\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/03\/H%C3%A0m-left-e1490712888185.gif\" alt=\"\" width=\"600\" height=\"216\"><\/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-169.gif\" title=\"ex101_92019-nho-169\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong>2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Right:<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p h\u00e0m Right: <strong>Right(text, num_chars)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul>\n<li style=\"text-align: justify\">Text: Bi\u1ec3u th\u1ee9c k\u00fd t\u1ef1<\/li>\n<li style=\"text-align: justify\">Num_chars: s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y ra t\u1eeb b\u00ean ph\u1ea3i c\u1ee7a Text<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Ch\u1ee9c n\u0103ng: K\u1ebft qu\u1ea3 l\u00e0 bi\u1ec3u th\u1ee9c k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c l\u1ea5y ra t\u1eeb b\u00ean ph\u1ea3i c\u1ee7a Text v\u1edbi s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 l\u1ea5y ra \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1eb1ng num_chars.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: Ph\u00e2n lo\u1ea1i S\u1ed1 hi\u1ec7u nh\u00e2n vi\u00ean theo M\u00e3 nh\u00e2n vi\u00ean<\/p>\n<p style=\"text-align: justify\">T\u1ea1i \u00f4 D2 ta th\u1ef1c hi\u1ec7n: <strong>=Right(C2,3)<\/strong><\/p>\n<p>\u0110\u00ea\u0309 co\u0301 th\u00ea\u0309 trau d\u00f4\u0300i ki\u00ea\u0301n th\u01b0\u0301c t\u01b0\u0300 c\u01a1 ba\u0309n \u0111\u00ea\u0301n n\u00e2ng cao v\u00ea\u0300 Excel ca\u0301c ba\u0323n ha\u0303y \u0111\u0103ng ki\u0301 tham gia ngay\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">l\u1edbp h\u1ecdc Excel \u1edf H\u00e0 N\u1ed9i<\/a> v\u01a1\u0301i ca\u0301c chuy\u00ean gia co\u0301 nhi\u00ea\u0300u n\u0103m kinh nghi\u00ea\u0323m v\u00ea\u0300 Excel se\u0303 h\u01b0\u01a1\u0301ng d\u00e2\u0303n ca\u0301c ba\u0323n m\u00f4\u0323t ca\u0301ch t\u00e2\u0323n ti\u0300nh nh\u00e2\u0301t v\u01a1\u0301i gia\u0301 tha\u0300nh c\u01b0\u0323c h\u00e2\u0301p d\u00e2\u0303n.<\/p>\n<p>\u00a0<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3469\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/03\/h%C3%A0m-right.gif\" alt=\"\" width=\"600\" height=\"240\"><\/p>\n<p><strong>Xem th\u00eam: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m<a href=\"http:\/\/blog.ezworkapp.com\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html\"> left excel<\/a> cho ng\u01b0\u1eddi m\u1edbi\u00a0<\/strong><\/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-169.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2222,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2221","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\/2221","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=2221"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2221\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2222"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}