{"id":12334,"date":"2022-03-24T17:18:21","date_gmt":"2022-03-24T10:18:21","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12334"},"modified":"2022-03-24T17:19:26","modified_gmt":"2022-03-24T10:19:26","slug":"ham-right-trong-excel-ban-da-biet-duoc-nhung-gi","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/","title":{"rendered":"H\u00e0m RIGHT trong Excel \u2013 b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec?"},"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;12334&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 RIGHT trong Excel \u2013 b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec?&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><span style=\"font-weight: 400\">Trong ph\u1ea7n m\u1ec1m Excel, c\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m d\u00f9ng \u0111\u1ec3 x\u1eed l\u00fd chu\u1ed7i. M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u00f3 th\u1ec3 k\u1ec3 \u0111\u1ebfn nh\u01b0: h\u00e0m LEN, h\u00e0m MID, h\u00e0m LEFT,\u2026 <\/span><a href=\"https:\/\/teky.edu.vn\/blog\/\"><b>H\u00e0m RIGHT trong Excel<\/b><\/a><span style=\"font-weight: 400\"> c\u0169ng l\u00e0 m\u1ed9t h\u00e0m nh\u01b0 v\u1eady. H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft \u0111\u1ec3 xem b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c bao nhi\u00eau ph\u1ea7n tr\u0103m v\u1ec1 h\u00e0m n\u00e0y nh\u00e9!<\/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-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#Dinh_nghia_cu_phap_cua_ham_RIGHT\" >\u0110\u1ecbnh ngh\u0129a, c\u00fa ph\u00e1p c\u1ee7a h\u00e0m RIGHT<\/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-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#Cach_dung_ham_RIGHT_trong_Excel_khong_dieu_kien\" >C\u00e1ch d\u00f9ng h\u00e0m RIGHT trong Excel kh\u00f4ng \u0111i\u1ec1u ki\u1ec7n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#Cach_dung_ham_Right_trong_Excel_nhieu_dieu_kien\" >C\u00e1ch d\u00f9ng h\u00e0m Right trong Excel nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#Su_dung_ham_RIGHT_va_ham_LEN\" >S\u1eed d\u1ee5ng h\u00e0m RIGHT v\u00e0 h\u00e0m LEN<\/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-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#Su_dung_ham_RIGHT_va_ham_VALUE\" >S\u1eed d\u1ee5ng h\u00e0m RIGHT v\u00e0 h\u00e0m VALUE<\/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-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#Su_dung_ham_RIGHT_LEN_SEARCH\" >S\u1eed d\u1ee5ng h\u00e0m RIGHT, LEN, SEARCH<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#Nhung_loi_thuong_xuyen_gap_phai_khi_su_dung_Excel\" >Nh\u1eefng l\u1ed7i th\u01b0\u1eddng xuy\u00ean g\u1eb7p ph\u1ea3i khi s\u1eed d\u1ee5ng Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#Loi_khoang_trong\" >L\u1ed7i kho\u1ea3ng tr\u1ed1ng\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#Loi_khi_thuc_hien_ham_RIGHT_trong_Excel_voi_ngay_thang_nam\" >L\u1ed7i khi th\u1ef1c hi\u1ec7n h\u00e0m RIGHT trong Excel v\u1edbi ng\u00e0y th\u00e1ng n\u0103m<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#Loi_gia_tri_cua_doi_so_num_chars_la_so_am\" >L\u1ed7i gi\u00e1 tr\u1ecb c\u1ee7a \u0111\u1ed1i s\u1ed1 (num_chars) l\u00e0 s\u1ed1 \u00e2m<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dinh_nghia_cu_phap_cua_ham_RIGHT\"><\/span><span style=\"font-weight: 400\">\u0110\u1ecbnh ngh\u0129a, c\u00fa ph\u00e1p c\u1ee7a h\u00e0m RIGHT<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi h\u00e0m LEFT l\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 m\u1ed9t ho\u1eb7c nhi\u1ec1u k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong m\u1ed9t chu\u1ed7i (t\u1ee9c l\u00e0 c\u00e1c k\u00fd t\u1ef1 t\u00ednh t\u1eeb b\u00ean tr\u00e1i sang) d\u1ef1a v\u00e0o s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh th\u00ec <\/span>h\u00e0m RIGHT<span style=\"font-weight: 400\"> l\u1ea1i ng\u01b0\u1ee3c l\u1ea1i.<\/span><\/p>\n<p><b>H\u00e0m RIGHT trong Excel<\/b><span style=\"font-weight: 400\"> s\u1ebd tr\u1ea3 v\u1ec1 cho b\u1ea1n m\u1ed9t ho\u1eb7c nhi\u1ec1u k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng trong m\u1ed9t chu\u1ed7i (t\u1ee9c l\u00e0 c\u00e1c k\u00fd t\u1ef1 t\u00ednh t\u1eeb b\u00ean ph\u1ea3i sang) c\u0169ng d\u1ef1a v\u00e0o s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh.<\/span><\/p>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd: H\u00e0m RIGHT s\u1eed d\u1ee5ng \u0111\u1ec3 d\u00f9ng trong c\u00e1c ng\u00f4n n\u1eef c\u00f3 b\u1ed9 k\u00fd t\u1ef1 byte \u0111\u01a1n (SBCS: Single-Byte Character Set). V\u00ec v\u1eady, b\u1ea5t k\u1ec3 b\u1ea1n thi\u1ebft \u0111\u1eb7t ng\u00f4n ng\u1eef m\u1eb7c \u0111\u1ecbnh l\u00e0 g\u00ec th\u00ec h\u00e0m RIGHT v\u1eabn lu\u00f4n \u0111\u1ebfm m\u1ed7i k\u00fd t\u1ef1 l\u00e0 1, d\u00f9 l\u00e0 byte \u0111\u01a1n hay byte k\u00e9p.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u00e0m RIGHT trong Excel c\u00f3 c\u00fa ph\u00e1p \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: center\"><b>RIGHT(text,[num_chars])<\/b><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3 bao g\u1ed3m c\u00e1c \u0111\u1ed1i s\u1ed1:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Text (b\u1eaft bu\u1ed9c) l\u00e0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n c\u00f3 ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Num_chars (t\u00f9y ch\u1ecdn) l\u00e0 s\u1ed1 l\u01b0\u1ee3ng c\u00e1c k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t t\u1eeb v\u0103n b\u1ea3n. C\u00e1c s\u1ed1 k\u00fd t\u1ef1 n\u00e0y ph\u1ea3i l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 0. N\u1ebfu nh\u01b0 b\u1ea1n b\u1ecf qua s\u1ed1 k\u00fd t\u1ef1 th\u00ec n\u00f3 \u0111\u01b0\u1ee3c gi\u1ea3 \u0111\u1ecbnh l\u00e0 1. N\u1ebfu nh\u01b0 s\u1ed1 l\u01b0\u1ee3ng b\u1ea1n \u0111i\u1ec1n l\u1edbn h\u01a1n \u0111\u1ed9 d\u1ea1i c\u1ee7a v\u0103n b\u1ea3n th\u00ec k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 to\u00e0n b\u1ed9 v\u0103n b\u1ea3n.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12351 size-full aligncenter\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-8.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-8-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-8-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <a href=\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\"><span style=\"color: #0000ff\"><em><strong>H\u00e0m th\u1ed1ng k\u00ea trong Excel<\/strong><\/em><\/span><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_dung_ham_RIGHT_trong_Excel_khong_dieu_kien\"><\/span><span style=\"font-weight: 400\">C\u00e1ch d\u00f9ng h\u00e0m RIGHT trong Excel kh\u00f4ng \u0111i\u1ec1u ki\u1ec7n<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 c\u00e1ch d\u00f9ng <\/span><b>h\u00e0m RIGHT trong Excel<\/b><span style=\"font-weight: 400\"> \u0111\u1ec3 l\u1ea5y nh\u1eefng k\u00fd t\u1ef1 s\u1ed1 ho\u1eb7c ch\u1eef \u1edf cu\u1ed1i m\u1ed7i chu\u1ed7i k\u00fd t\u1ef1 sang m\u1ed9t \u00f4 kh\u00e1c v\u00e0 kh\u00f4ng l\u00e0m \u1ea3nh h\u01b0\u1edfng g\u00ec \u0111\u1ebfn nh\u1eefng k\u00fd t\u1ef1 ban \u0111\u1ea7u.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: \u0110\u1ec3 l\u1ea5y ra 3 k\u00fd t\u1ef1 trong c\u1ed9t \u201cH\u1ecd v\u00e0 t\u00ean\u201d c\u1ee7a h\u00ecnh b\u00ean d\u01b0\u1edbi, ta l\u00e0m nh\u01b0 sau:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12338 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-25.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-25.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-25-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ea7u ti\u00ean l\u00e0 ch\u1ecdn m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 \u0111\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c, gi\u1ea3 s\u1eed nh\u01b0 \u00f4 G2. Sau \u0111\u00f3 \u0111i\u1ec1n c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p style=\"text-align: center\"><b>=RIGHT(E2,3)<\/b><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c l\u00e0:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12340 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-19.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-19.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-19-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Ti\u1ebfp theo, t\u1eeb \u00f4 G2 b\u1ea1n ch\u1ec9 c\u1ea7n k\u00e9o t\u1eeb g\u00f3c ph\u1ea3i b\u00ean d\u01b0\u1edbi c\u1ee7a \u00f4 G2 xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i l\u00e0 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12339 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-22.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-22.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-22-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">T\u01b0\u01a1ng t\u1ef1, n\u1ebfu mu\u1ed1n l\u1ea5y ra 3 k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng trong c\u1ed9t \u201cM\u00e3 s\u1ed1 SV\u201d, ta s\u1ebd nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 H2:<\/span><\/li>\n<\/ul>\n<p style=\"text-align: center\"><b>=RIGHT(F2,3)<\/b><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c nh\u01b0 h\u00ecnh.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12337 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-24.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-24.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-24-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Cu\u1ed1i c\u00f9ng, b\u1ea1n c\u0169ng ch\u1ec9 c\u1ea7n k\u00e9o t\u1eeb g\u00f3c ph\u1ea3i b\u00ean d\u01b0\u1edbi c\u1ee7a \u00f4 H2 xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12336 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-25.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-25.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-25-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00f3 l\u00e0 c\u00e1ch b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_dung_ham_Right_trong_Excel_nhieu_dieu_kien\"><\/span><span style=\"font-weight: 400\">C\u00e1ch d\u00f9ng h\u00e0m Right trong Excel nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_RIGHT_va_ham_LEN\"><\/span><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng h\u00e0m RIGHT v\u00e0 h\u00e0m LEN<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">H\u00e0m LEN trong Excel l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm \u0111\u1ed9 d\u00e0i chu\u1ed7i k\u00fd t\u1ef1.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Khi k\u1ebft h\u1ee3p hai h\u00e0m n\u00e0y v\u1edbi nhau ta s\u1ebd c\u00f3 th\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c nh\u1eefng k\u00fd t\u1ef1 \u1edf b\u00ean ph\u1ea3i v\u00e0 c\u1eaft b\u1ecf \u0111i nh\u1eefng nh\u1eefng k\u00fd t\u1ef1 m\u00e0 b\u1ea1n kh\u00f4ng mu\u1ed1n l\u1ea5y qua vi\u1ec7c tr\u1eeb n\u00f3 \u0111i b\u1eb1ng d\u1ea5u \u201c-\u201d. C\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c vi\u1ebft l\u00e0:<\/span><\/p>\n<p><b>=RIGHT(text,LEN(text)-s\u1ed1 k\u00fd t\u1ef1 mu\u1ed1n c\u1eaft)<\/b><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed, trong c\u1ed9t \u201cM\u00e3 s\u1ed1 SV\u201d, b\u1ea1n mu\u1ed1n b\u1ecf \u0111i 2 k\u00fd t\u1ef1 ch\u1eef v\u00e0 ch\u1ec9 gi\u1eef l\u1ea1i 2 k\u00fd t\u1ef1 s\u1ed1. Nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: center\"><b>=RIGHT(F2,LEN(F2)-2)<\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12343 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-15.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-15.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-15-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">D\u1eef li\u1ec7u \u1edf nh\u1eefng \u00f4 kh\u00e1c, b\u1ea1n ch\u1ec9 vi\u1ec7c k\u00e9o xu\u1ed1ng.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12345 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-8.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-8-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi c\u1ed9t \u201cH\u1ecd v\u00e0 t\u00ean\u201d c\u00f3 d\u1ea5u c\u00e1ch, n\u00f3 c\u0169ng \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 m\u1ed9t k\u00fd t\u1ef1. B\u1edfi v\u1eady khi b\u1ea1n mu\u1ed1n c\u1eaft \u0111i 5 k\u00fd t\u1ef1 th\u00ec k\u1ebft qu\u1ea3 s\u1ebd ra nh\u01b0 sau:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12341 size-full aligncenter\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-20.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-20.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-20-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_RIGHT_va_ham_VALUE\"><\/span><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng h\u00e0m RIGHT v\u00e0 h\u00e0m VALUE<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">C\u00e1ch n\u00e0y d\u00f9ng \u0111\u1ec3 chuy\u1ec3n c\u00e1c d\u1eef li\u1ec7u sang d\u1ea1ng s\u1ed1. V\u00ec khi s\u1eed d\u1ee5ng nguy\u00ean h\u00e0m RIGHT c\u00e1c d\u1eef li\u1ec7u v\u1eabn c\u00f2n l\u00e0 v\u0103n b\u1ea3n ch\u1ee9 kh\u00f4ng t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1 \u0111\u01b0\u1ee3c. Do \u0111\u00f3, c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: center\"><b>=VALUE(RIGHT(text,num_chars))<\/b><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed, b\u1ea1n mu\u1ed1n l\u1ea5y nguy\u00ean s\u1ed1 k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng trong c\u1ed9t \u201cM\u00e3 s\u1ed1 SV\u201d, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p style=\"text-align: center\"><b>=VALUE(RIGHT(F2,2))<\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12342 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-19.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-19.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-19-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c s\u1ebd l\u00e0:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12344 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-11.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-11.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-11-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_RIGHT_LEN_SEARCH\"><\/span><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng h\u00e0m RIGHT, LEN, SEARCH<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">H\u00e0m SEARCH h\u00e0m h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u \u1edf sau nh\u1eefng k\u00fd t\u1ef1. Khi s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p ba h\u00e0m n\u00e0y v\u1edbi nhau s\u1ebd c\u00f3 c\u00f4ng d\u1ee5ng l\u1ea5y nh\u1eefng d\u1eef li\u1ec7u b\u00ean ph\u1ea3i c\u00e1c k\u00fd t\u1ef1 nh\u01b0: d\u1ea5u c\u00e1ch, d\u1ea5u ph\u1ea9y, d\u1ea5u ch\u1ea5m ph\u1ea9y, d\u1ea5u hai ch\u1ea5m,\u2026 v\u00e0 c\u1eaft nh\u1eefng d\u1eef li\u1ec7u c\u00f2n l\u1ea1i. C\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c vi\u1ebft l\u00e0:\u00a0<\/span><\/p>\n<p style=\"text-align: center\"><b>=RIGHT(text, LEN(text)-SEARCH(\u201c \u201d,text))<\/b><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3:<\/span><\/p>\n<p><span style=\"font-weight: 400\">text l\u00e0 \u00f4 d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n c\u1eaft.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u201c \u201d l\u00e0 k\u00fd t\u1ef1 m\u00e0 b\u1ea1n l\u1ea5y nh\u1eefng d\u1eef li\u1ec7u b\u00ean ph\u1ea3i n\u00f3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5, b\u1ea1n mu\u1ed1n l\u1ea5y ph\u1ea7n t\u00ean \u0111\u1ec7m v\u00e0 t\u00ean trong c\u1ed9t \u201cH\u1ecd v\u00e0 t\u00ean\u201d, b\u1ea1n h\u00e3y nh\u1eadp:<\/span><\/p>\n<p style=\"text-align: center\"><b>=RIGHT(E2,LEN(E2)-SEARCH(\u201c \u201d,E2)<\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12346 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-7.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-7.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-7-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">T\u01b0\u01a1ng t\u1ef1 v\u1edbi nh\u1eefng d\u00f2ng c\u00f2n l\u1ea1i, k\u1ebft qu\u1ea3 b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c s\u1ebd gi\u1ed1ng nh\u01b0 h\u00ecnh.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12348 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-4.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-4-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n ti\u1ebfp t\u1ee5c t\u00e1ch ra nguy\u00ean ph\u1ea7n t\u00ean th\u00ec b\u1ea1n s\u1ebd l\u1ea5y d\u1eef li\u1ec7u \u1edf c\u1ed9t H \u0111\u1ec3 thay v\u00e0o c\u00f4ng th\u1ee9c, gi\u1ed1ng nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12347 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12-4.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12-4-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhung_loi_thuong_xuyen_gap_phai_khi_su_dung_Excel\"><\/span><span style=\"font-weight: 400\">Nh\u1eefng l\u1ed7i th\u01b0\u1eddng xuy\u00ean g\u1eb7p ph\u1ea3i khi s\u1eed d\u1ee5ng Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Loi_khoang_trong\"><\/span><span style=\"font-weight: 400\">L\u1ed7i kho\u1ea3ng tr\u1ed1ng<\/span><span style=\"font-weight: 400\">\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Ban \u0111\u1ea7u khi m\u1edbi s\u1eed d\u1ee5ng h\u00e0m RIGHT trong Excel, b\u1ea1n s\u1ebd d\u1ec5 g\u1eb7p ph\u1ea3i l\u1ed7i ng\u00e0y nh\u1ea5t. V\u00ed d\u1ee5 nh\u01b0 khi b\u1ea1n \u0111i\u1ec1n v\u00e0o c\u1ed9t \u201cM\u00e3 s\u1ed1 SV\u201d v\u00e0 khi nh\u1eadp xong m\u00e3 s\u1ed1 v\u00e0 d\u00f9ng h\u00e0m RIGHT l\u1ea5y 2 k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng v\u00e0 k\u1ebft qu\u1ea3 l\u1ea1i cho ra nh\u01b0 th\u1ebf n\u00e0y:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12350 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-2.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-2-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n s\u1ebd c\u1ea3m th\u1ea5y kh\u00e1 hoang mang v\u00ec kh\u00f4ng hi\u1ec3u t\u1ea1i sao l\u1ea1i c\u00f3 2 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 kh\u00f4ng \u0111\u00fang v\u1edbi nh\u1eefng g\u00ec b\u1ea1n mong mu\u1ed1n. \u0110\u00f3 l\u00e0 do b\u1ea1n l\u1ee1 d\u00f9ng d\u1ea5u c\u00e1ch ngay sau 2 m\u00e3 s\u1ed1 n\u00e0y. D\u1ea5u c\u00e1ch \u0111\u01b0\u01a1ng nhi\u00ean \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 1 k\u00fd t\u1ef1 b\u1edfi v\u1eady 2 k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c Excel \u0111\u01b0a ra s\u1ebd l\u00e0 s\u1ed1 3, 4 v\u00e0 d\u1ea5u c\u00e1ch. Nh\u01b0 v\u1eady, b\u1ea1n ch\u1ec9 c\u1ea7n x\u00f3a d\u1ea5u c\u00e1ch \u1edf hai d\u00f2ng n\u00e0y \u0111i ho\u1eb7c d\u00f9ng h\u00e0m TRIM \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i kho\u1ea3ng tr\u1ed1ng.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12349 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14-3.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14-3-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loi_khi_thuc_hien_ham_RIGHT_trong_Excel_voi_ngay_thang_nam\"><\/span><span style=\"font-weight: 400\">L\u1ed7i khi th\u1ef1c hi\u1ec7n h\u00e0m RIGHT trong Excel v\u1edbi ng\u00e0y th\u00e1ng n\u0103m<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>H\u00e0m RIGHT trong Excel<\/b><span style=\"font-weight: 400\"> ch\u1ec9 l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n, c\u00f2n ng\u00e0y th\u00e1ng n\u0103m th\u00ec to\u00e0n b\u1ed9 l\u00e0 c\u00e1c con s\u1ed1. B\u1edfi v\u1eady n\u1ebfu b\u1ea1n mu\u1ed1n l\u1ea5y ra \u0111\u01b0\u1ee3c t\u1eebng ph\u1ea7n th\u00ec <\/span><b>h\u00e0m RIGHT<\/b><span style=\"font-weight: 400\"> s\u1ebd kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y. Thay v\u00e0o \u0111\u00f3, b\u1ea1n h\u00e3y d\u00f9ng c\u00e1c h\u00e0m kh\u00e1c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu mu\u1ed1n l\u1ea5y ra ng\u00e0y th\u00ec s\u1eed d\u1ee5ng h\u00e0m DAY, vi\u1ebft l\u00e0: =DAY(text).<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu mu\u1ed1n l\u1ea5y ra th\u00e1ng th\u00ec s\u1eed d\u1ee5ng h\u00e0m MONTH, vi\u1ebft l\u00e0: =MONTH(text).<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu mu\u1ed1n l\u1ea5y ra n\u0103m th\u00ec s\u1eed d\u1ee5ng h\u00e0m YEAR, vi\u1ebft l\u00e0: =YEAR(text)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3, text ch\u00ednh l\u00e0 d\u1eef li\u1ec7u ngu\u1ed3n m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t c\u00e1c k\u00fd t\u1ef1 trong \u0111\u00f3 ra.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loi_gia_tri_cua_doi_so_num_chars_la_so_am\"><\/span><span style=\"font-weight: 400\">L\u1ed7i gi\u00e1 tr\u1ecb c\u1ee7a \u0111\u1ed1i s\u1ed1 (num_chars) l\u00e0 s\u1ed1 \u00e2m<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Khi tr\u00edch xu\u1ea5t c\u00e1c k\u00fd t\u1ef1 trong d\u1eef li\u1ec7u, ch\u1eafc ch\u1eafn b\u1ea1n s\u1ebd kh\u00f4ng d\u00f9ng \u0111\u1ebfn s\u1ed1 \u00e2m. Tuy nhi\u00ean, n\u1ebfu b\u1ea1n d\u00f9ng c\u00e1c h\u00e0m kh\u00e1c ho\u1eb7c l\u1ed3ng gh\u00e9p c\u00e1c h\u00e0m l\u1ea1i v\u1edbi nhau m\u00e0 gi\u00e1 tr\u1ecb c\u1ee7a num_chars l\u1ea1i nh\u1ecf h\u01a1n 0 th\u00ec l\u00fac \u0111\u00f3 h\u00e0m RIGHT s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Mong r\u1eb1ng nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n \u1edf ph\u00eda tr\u00ean \u0111\u00e3 gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 <\/span><b>h\u00e0m RIGHT trong Excel<\/b><span style=\"font-weight: 400\">. Ch\u00fac c\u00e1c b\u1ea1n s\u1edbm chinh ph\u1ee5c \u0111\u01b0\u1ee3c ph\u1ea7n m\u1ec1m n\u00e0y \u0111\u1ec3 ph\u1ee5c v\u1ee5 \u0111\u01b0\u1ee3c nhi\u1ec1u m\u1ee5c \u0111\u00edch kh\u00e1c nhau trong cu\u1ed9c s\u1ed1ng c\u1ee7a b\u1ea1n!<\/span><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <span style=\"color: #0000ff\"><a style=\"color: #0000ff\" href=\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/\"><em><strong>T\u00e1ch ch\u1eef trong Excel<\/strong><\/em><\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trong ph\u1ea7n m\u1ec1m Excel, c\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m d\u00f9ng \u0111\u1ec3 x\u1eed l\u00fd chu\u1ed7i. M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u00f3 th\u1ec3 k\u1ec3 \u0111\u1ebfn nh\u01b0: h\u00e0m LEN, h\u00e0m MID, h\u00e0m LEFT,\u2026 H\u00e0m RIGHT trong Excel c\u0169ng l\u00e0 m\u1ed9t h\u00e0m nh\u01b0 v\u1eady. H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft \u0111\u1ec3 xem b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c bao nhi\u00eau ph\u1ea7n tr\u0103m v\u1ec1 h\u00e0m n\u00e0y nh\u00e9! &hellip;<\/p>\n","protected":false},"author":26,"featured_media":12352,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12334","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"acf":{"show_on_app":false},"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 RIGHT trong Excel \u2013 b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec?<\/title>\n<meta name=\"description\" content=\"H\u00e0m RIGHT trong Excel c\u0169ng l\u00e0 m\u1ed9t h\u00e0m nh\u01b0 v\u1eady. H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft \u0111\u1ec3 xem b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c bao nhi\u00eau ph\u1ea7n tr\u0103m v\u1ec1 h\u00e0m n\u00e0y nh\u00e9!\" \/>\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-right-trong-excel-ban-da-biet-duoc-nhung-gi\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m RIGHT trong Excel \u2013 b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec?\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m RIGHT trong Excel c\u0169ng l\u00e0 m\u1ed9t h\u00e0m nh\u01b0 v\u1eady. H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft \u0111\u1ec3 xem b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c bao nhi\u00eau ph\u1ea7n tr\u0103m v\u1ec1 h\u00e0m n\u00e0y nh\u00e9!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/\" \/>\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-03-24T10:18:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-24T10:19:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-7.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1eb1ng L\u00ea\" \/>\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=\"H\u1eb1ng L\u00ea\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 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-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/\"},\"author\":{\"name\":\"H\u1eb1ng L\u00ea\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\"},\"headline\":\"H\u00e0m RIGHT trong Excel \u2013 b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec?\",\"datePublished\":\"2022-03-24T10:18:21+00:00\",\"dateModified\":\"2022-03-24T10:19:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/\"},\"wordCount\":1934,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-7.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/\",\"name\":\"H\u00e0m RIGHT trong Excel \u2013 b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec?\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-7.jpg\",\"datePublished\":\"2022-03-24T10:18:21+00:00\",\"dateModified\":\"2022-03-24T10:19:26+00:00\",\"description\":\"H\u00e0m RIGHT trong Excel c\u0169ng l\u00e0 m\u1ed9t h\u00e0m nh\u01b0 v\u1eady. H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft \u0111\u1ec3 xem b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c bao nhi\u00eau ph\u1ea7n tr\u0103m v\u1ec1 h\u00e0m n\u00e0y nh\u00e9!\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-7.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-7.jpg\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#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 RIGHT trong Excel \u2013 b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec?\"}]},{\"@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\/aba2a2e5a9eb4e0b390280d28d910d8b\",\"name\":\"H\u1eb1ng L\u00ea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"caption\":\"H\u1eb1ng L\u00ea\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/lehang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m RIGHT trong Excel \u2013 b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec?","description":"H\u00e0m RIGHT trong Excel c\u0169ng l\u00e0 m\u1ed9t h\u00e0m nh\u01b0 v\u1eady. H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft \u0111\u1ec3 xem b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c bao nhi\u00eau ph\u1ea7n tr\u0103m v\u1ec1 h\u00e0m n\u00e0y nh\u00e9!","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-right-trong-excel-ban-da-biet-duoc-nhung-gi\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m RIGHT trong Excel \u2013 b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec?","og_description":"H\u00e0m RIGHT trong Excel c\u0169ng l\u00e0 m\u1ed9t h\u00e0m nh\u01b0 v\u1eady. H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft \u0111\u1ec3 xem b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c bao nhi\u00eau ph\u1ea7n tr\u0103m v\u1ec1 h\u00e0m n\u00e0y nh\u00e9!","og_url":"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/","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-03-24T10:18:21+00:00","article_modified_time":"2022-03-24T10:19:26+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-7.jpg","type":"image\/jpeg"}],"author":"H\u1eb1ng L\u00ea","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1eb1ng L\u00ea","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"9 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/"},"author":{"name":"H\u1eb1ng L\u00ea","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b"},"headline":"H\u00e0m RIGHT trong Excel \u2013 b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec?","datePublished":"2022-03-24T10:18:21+00:00","dateModified":"2022-03-24T10:19:26+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/"},"wordCount":1934,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-7.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/","url":"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/","name":"H\u00e0m RIGHT trong Excel \u2013 b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec?","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-7.jpg","datePublished":"2022-03-24T10:18:21+00:00","dateModified":"2022-03-24T10:19:26+00:00","description":"H\u00e0m RIGHT trong Excel c\u0169ng l\u00e0 m\u1ed9t h\u00e0m nh\u01b0 v\u1eady. H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft \u0111\u1ec3 xem b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c bao nhi\u00eau ph\u1ea7n tr\u0103m v\u1ec1 h\u00e0m n\u00e0y nh\u00e9!","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-7.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-7.jpg","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-right-trong-excel-ban-da-biet-duoc-nhung-gi\/#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 RIGHT trong Excel \u2013 b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec?"}]},{"@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\/aba2a2e5a9eb4e0b390280d28d910d8b","name":"H\u1eb1ng L\u00ea","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","caption":"H\u1eb1ng L\u00ea"},"url":"https:\/\/teky.edu.vn\/blog\/author\/lehang\/"}]}},"thumbnail":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-7-400x267.jpg","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12334","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\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=12334"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12334\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12352"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}