{"id":11489,"date":"2022-11-14T17:04:47","date_gmt":"2022-11-14T10:04:47","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11489"},"modified":"2022-12-08T11:55:25","modified_gmt":"2022-12-08T04:55:25","slug":"tach-chu-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/","title":{"rendered":"T\u00e1ch ch\u1eef trong Excel &#8211; M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng"},"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;11489&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;T\u00e1ch ch\u1eef trong Excel - M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng&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;\"><em><span style=\"font-weight: 400;\">Excel c\u00f3 l\u1ebd l\u00e0 c\u00f4ng c\u1ee5 th\u00f4ng d\u1ee5ng, d\u00e2n v\u0103n ph\u00f2ng n\u00e0o c\u0169ng bi\u1ebft \u0111\u1ebfn. N\u00f3 gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch nhanh h\u01a1n thay v\u00ec nh\u1eefng c\u00e1ch t\u00ednh to\u00e1n hay ghi ch\u00e9p th\u00f4ng th\u01b0\u1eddng. Th\u1eadm ch\u00ed, c\u00f3 nh\u1eefng c\u00f4ng vi\u1ec7c b\u1ea1n ch\u1ec9 c\u1ea7n thao t\u00e1c m\u1ed9t l\u1ea7n v\u00e0 s\u1eed d\u1ee5ng m\u00e3i m\u00e3i. D\u01b0\u1edbi g\u00f3c nh\u00ecn c\u1ee7a ch\u1ee7 doanh nghi\u1ec7p, excel gi\u00fap ch\u1ee7 doanh nghi\u1ec7p n\u1eafm \u0111\u01b0\u1ee3c t\u00ecnh h\u00ecnh ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng ty m\u00ecnh, bi\u1ebft \u0111\u01b0\u1ee3c th\u1eddi \u0111i\u1ec3m h\u00f2a v\u1ed1n, kinh doanh l\u00e3i hay l\u1ed7. <\/span><span style=\"font-weight: 400;\">Trong r\u1ea5t nhi\u1ec1u h\u00e0m excel, kh\u00f4ng th\u1ec3 ph\u1ee7 nh\u1eadn vai tr\u00f2 c\u1ee7a h\u00e0m d\u00f9ng \u0111\u1ec3 <\/span><\/em><b><em>t\u00e1ch ch\u1eef trong excel.<\/em> <\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n mu\u1ed1n l\u1ea5y m\u1ed9t hay nhi\u1ec1u k\u00fd t\u1ef1 mong mu\u1ed1n n\u00e0o \u0111\u00f3, b\u1ea1n s\u1ebd d\u00f9ng c\u00e1c h\u00e0m trong excel \u0111\u1ec3 t\u00e1ch ra m\u1ed9t c\u1ed9t ri\u00eang. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao.<\/span><\/p>\n<figure id=\"attachment_11568\" aria-describedby=\"caption-attachment-11568\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11568 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel.jpg\" alt=\"T\u00e1ch ch\u1eef v\u00e0 s\u1ed1 trong Excel\" width=\"600\" height=\"450\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-400x300.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11568\" class=\"wp-caption-text\">T\u00e1ch ch\u1eef v\u00e0 s\u1ed1 trong Excel<span style=\"font-size: 16px;\">\u00a0<\/span><\/figcaption><\/figure>\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\/tach-chu-trong-excel\/#Mot_so_ham_excel_huu_dung_hay_duoc_nhan_vien_van_phong_dung\" >M\u1ed9t s\u1ed1 h\u00e0m excel h\u1eefu d\u1ee5ng hay \u0111\u01b0\u1ee3c nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng d\u00f9ng<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#Ham_REPLACE\" >H\u00e0m REPLACE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#Ham_FIND\" >H\u00e0m FIND<\/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\/tach-chu-trong-excel\/#Ham_SEARCH\" >H\u00e0m SEARCH<\/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\/tach-chu-trong-excel\/#Ham_LEFT\" >H\u00e0m LEFT<\/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\/tach-chu-trong-excel\/#Ham_LEN\" >H\u00e0m LEN<\/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\/tach-chu-trong-excel\/#Ham_RIGHT\" >H\u00e0m RIGHT<\/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\/tach-chu-trong-excel\/#Ham_MID\" >H\u00e0m MID<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#Ap_dung_cac_ham_co_ban_vao_thuc_te\" >\u00c1p d\u1ee5ng c\u00e1c h\u00e0m c\u01a1 b\u1ea3n v\u00e0o th\u1ef1c t\u1ebf<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#Ket_luan\" >K\u1ebft lu\u1eadn<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Mot_so_ham_excel_huu_dung_hay_duoc_nhan_vien_van_phong_dung\"><\/span><b>M\u1ed9t s\u1ed1 h\u00e0m excel h\u1eefu d\u1ee5ng hay \u0111\u01b0\u1ee3c nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng d\u00f9ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi excel cho m\u1ed9t c\u1ed9t m\u1ed7i \u00f4 g\u1ed3m m\u1ed9t chu\u1ed7i c\u00e1c k\u00fd t\u1ef1 v\u00e0 y\u00eau c\u1ea7u b\u1ea1n t\u00e1ch c\u00e1c k\u00fd t\u1ef1 \u0111\u00f3 ra. D\u00f9ng ph\u01b0\u01a1ng ph\u00e1p th\u1ee7 c\u00f4ng l\u00e0 \u0111i\u1ec1u qu\u00e1 kh\u00f3 v\u00e0 m\u1ea5t th\u1eddi gian. Hi\u1ec3u \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3, Microsoft \u0111\u00e3 vi\u1ebft ra m\u1ed9t s\u1ed1 <\/span><b>h\u00e0m<\/b> <b>t\u00e1ch ch\u1eef trong Excel <\/b><span style=\"font-weight: 400;\">\u0111\u1ec3 \u0111\u00e2y kh\u00f4ng c\u00f2n l\u00e0 n\u1ed7i s\u1ee3 c\u1ee7a ch\u1ecb em v\u0103n ph\u00f2ng.\u00a0<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00e1ch t\u00e1ch s\u1ed1 v\u00e0 ch\u1eef ra kh\u1ecfi chu\u1ed7i trong Excel (Kh\u00f4ng c\u1ea7n VBA)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/rDGHq-7tIGM?start=104&#038;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<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u00f9y thu\u1ed9c v\u00e0o c\u1ea5u t\u1ea1o c\u1ee7a chu\u1ed7i v\u00e0 y\u00eau c\u1ea7u \u0111\u1eb7t ra m\u00e0 b\u1ea1n \u00e1p d\u1ee5ng m\u1ed9t ho\u1eb7c nhi\u1ec1u nh\u1eefng h\u00e0m sau:<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_REPLACE\"><\/span><b>H\u00e0m REPLACE<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m n\u00e0y d\u00f9ng \u0111\u1ec3 thay th\u1ebf v\u0103n b\u1ea3n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=REPLACE(old_text, start_num, num_chars, new_text); Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\">old_text: v\u0103n b\u1ea3n c\u1ea7n thay th\u1ebf;<\/span><\/li>\n<li>start_num: v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u mu\u1ed1n thay th\u1ebf;<\/li>\n<li>num_chars: s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y;<\/li>\n<li>new_text: v\u0103n b\u1ea3n m\u1edbi thay th\u1ebf.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, \u00d4 A2 c\u00f3 v\u0103n b\u1ea3n \u201cM\u00e1y t\u00ednh \u0111\u1ec3 b\u00e0n 001\u201d d\u00f9ng h\u00e0m =replace(A2,16,3,\u201d \u201d) k\u1ebft qu\u1ea3 s\u1ebd thay th\u1ebf s\u1ed1 m\u00e3 m\u00e1y t\u00ednh \u201c001\u201d th\u00e0nh kho\u1ea3ng tr\u1eafng.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_FIND\"><\/span><b>H\u00e0m FIND<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_11571\" aria-describedby=\"caption-attachment-11571\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11571 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-3.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m Find trong t\u00e1ch s\u1ed1 ra kh\u1ecfi chu\u1ed7i\" width=\"600\" height=\"152\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-3-400x101.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11571\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m Find trong t\u00e1ch s\u1ed1 ra kh\u1ecfi chu\u1ed7i<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t v\u0103n b\u1ea3n b\u1ea1n mu\u1ed1n t\u00ecm.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=FIND(find_text, within_text, [start_num]); Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Find_text: c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t k\u00fd t\u1ef1 hay v\u0103n b\u1ea3n n\u00e0o \u0111\u00f3 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm;<\/span><\/li>\n<li style=\"text-align: justify;\">Within_text: V\u0103n b\u1ea3n ngu\u1ed3n \u0111\u1ec3 b\u1ea1n t\u00ecm ki\u1ebfm find_text;<\/li>\n<li>[start_num] khi b\u1ea1n kh\u00f4ng \u0111i\u1ec1n th\u00ec m\u1eb7c \u0111\u1ecbnh s\u1ebd l\u00e0 s\u1ed1 1 v\u00e0 t\u00ecm v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean trong chu\u1ed7i. Ho\u1eb7c b\u1ea1n s\u1ebd \u0111i\u1ec1n s\u1ed1 t\u01b0\u01a1ng \u1ee9ng v\u1edbi v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n t\u00ecm. N\u00f3 s\u1ebd b\u00e1o l\u1ed7i n\u1ebfu gi\u00e1 tr\u1ecb b\u1ea1n \u0111i\u1ec1n nh\u1ecf h\u01a1n 0 ho\u1eb7c l\u1edbn h\u01a1n t\u1ed5ng k\u00fd t\u1ef1 trong chu\u1ed7i.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: \u00d4 B2 c\u00f3 chu\u1ed7i l\u00e0 \u201cNguy\u1ec5n Thanh Tr\u00fac:, b\u1ea1n mu\u1ed1n t\u00ecm v\u1ecb tr\u00ed ch\u1eef \u201cn\u201d th\u1ee9 2, b\u1ea1n vi\u1ebft c\u00e2u l\u1ec7nh nh\u01b0 sau :=Find(\u201cn\u201d,B2,2) k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 6.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_SEARCH\"><\/span><b>H\u00e0m SEARCH<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u00f9ng \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed v\u0103n b\u1ea3n b\u1ea5t k\u1ef3 trong v\u0103n b\u1ea3n l\u1edbn h\u01a1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">SEARCH(find_text,within_text,[start_num]); Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\">find_text: V\u0103n b\u1ea3n c\u1ea7n t\u00ecm trong v\u0103n b\u1ea3n kh\u00e1c;<\/span><\/li>\n<li style=\"text-align: justify;\">within_text: V\u0103n b\u1ea3n m\u1eb9 \u0111\u1ec3 t\u00ecm;<\/li>\n<li style=\"text-align: justify;\">[start_num]: V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u mu\u1ed1n t\u00ecm.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u0169ng v\u00ed d\u1ee5 tr\u00ean, b\u1ea1n mu\u1ed1n t\u00ecm v\u1ecb tr\u00ed ch\u1eef t\u00ednh trong \u00f4 A2, =search(\u201c \u201c,A2) k\u1ebft qu\u1ea3 l\u00e0 4.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_LEFT\"><\/span><b>H\u00e0m LEFT<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_11570\" aria-describedby=\"caption-attachment-11570\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11570 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-2.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m Left trong t\u00e1ch s\u1ed1 ra kh\u1ecfi chu\u1ed7i\" width=\"600\" height=\"133\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-2-400x89.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11570\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m Left trong t\u00e1ch s\u1ed1 ra kh\u1ecfi chu\u1ed7i<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1ea5y ra m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t nhi\u1ec1u h\u01a1n trong m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=LEFT(text, [num_chars]); Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Text: chu\u1ed7i k\u00fd t\u1ef1 ho\u1eb7c v\u0103n b\u1ea3n ngu\u1ed3n \u0111\u1ec3 l\u1ea5y;<\/span><\/li>\n<li style=\"text-align: justify;\">[num_chars]: V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u <a href=\"https:\/\/vi.wikipedia.org\/wiki\/K%C3%BD_t%E1%BB%B1\">k\u00fd t\u1ef1<\/a> m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y t\u00ednh t\u1eeb b\u00ean tr\u00e1i hay s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: \u00d4 E1 c\u00f3 chu\u1ed7i l\u00e0: \u201cNguy\u1ec5n Trung Hi\u1ebfu\u201d, b\u1ea1n mu\u1ed1n t\u00e1ch l\u1ea5y ch\u1eef \u201cNguy\u1ec5n\u201d th\u00ec b\u1ea1n d\u00f9ng h\u00e0m nh\u01b0 sau =Left(E1,6).<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_LEN\"><\/span><b>H\u00e0m LEN<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ebfm s\u1ed1 k\u00fd t\u1ef1, k\u1ec3 c\u1ea3 kho\u1ea3ng tr\u1eafng trong chu\u1ed7i v\u0103n b\u1ea3n<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=LEN(text); Trong \u0111\u00f3:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Text l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n \u0111\u1ebfm.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: Chu\u1ed7i trong \u00f4 A2 l\u00e0 \u201cNguy\u1ec5n Trung Hi\u1ebfu\u201d b\u1ea1n d\u00f9ng l\u00e0m Len(A2) k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 17.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_RIGHT\"><\/span><b>H\u00e0m RIGHT<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_11572\" aria-describedby=\"caption-attachment-11572\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11572 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-4-e1647251706564.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m Right trong t\u00e1ch ch\u1eef ra kh\u1ecfi chu\u1ed7i\" width=\"600\" height=\"229\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-4-e1647251706564.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-4-e1647251706564-400x153.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11572\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m Right trong t\u00e1ch ch\u1eef ra kh\u1ecfi chu\u1ed7i<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1 h\u00e0m LEFT, h\u00e0m RIGHT l\u1ea5y ra k\u00fd t\u1ef1 t\u00ednh t\u1eeb b\u00ean ph\u1ea3i c\u1ee7a chu\u1ed7i<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u0169ng v\u00ed d\u1ee5 tr\u00ean, b\u1ea1n mu\u1ed1n l\u1ea5y ch\u1eef \u201cHi\u1ebfu\u201d th\u00ec d\u00f9ng =RIGHT(E1,4).<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_MID\"><\/span><b>H\u00e0m MID<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1ea5y 1 hay m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 \u1edf gi\u1eefa v\u0103n b\u1ea3n, thay v\u00ec ph\u00eda b\u00ean tr\u00e1i v\u0103n b\u1ea3n nh\u01b0 h\u00e0m Left v\u00e0 b\u00ean ph\u1ea3i v\u0103n b\u1ea3n nh\u01b0 h\u00e0m Right.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=MID(text, start_num, num_chars); Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Text: chu\u1ed7i k\u00fd t\u1ef1 ho\u1eb7c v\u0103n b\u1ea3n ngu\u1ed3n \u0111\u1ec3 l\u1ea5y;<\/span><\/li>\n<li style=\"text-align: justify;\">Start_num: V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u l\u1ea5y k\u00fd t\u1ef1 t\u00ednh t\u1eeb b\u00ean tr\u00e1i<\/li>\n<li style=\"text-align: justify;\">Num_chars: S\u1ed1 l\u01b0\u1ee3ng c\u1ea7n l\u1ea5y.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, \u00d4 B1 c\u00f3 chu\u1ed7i: \u201cABCD 1234 EFGH\u201d b\u1ea1n d\u00f9ng h\u00e0m =MID(B1,6,4) k\u1ebft qu\u1ea3 l\u00e0 \u201c1234\u201d.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u1ef1a v\u00e0o nh\u1eefng h\u00e0m tr\u00ean, b\u1ea1n s\u1ebd bi\u1ebft <\/span><b>c\u00e1ch t\u00e1ch ch\u1eef trong excel <\/b><span style=\"font-weight: 400;\">khi g\u1eb7p ph\u1ea3i nh\u1eefng b\u00e0i to\u00e1n \u0111\u01a1n gi\u1ea3n. Ch\u1ec9 c\u1ea7n \u00e1p d\u1ee5ng m\u1ed9t trong c\u00e1c h\u00e0m tr\u00ean s\u1ebd ra. L\u00e0m excel c\u0169ng gi\u1ed1ng nh\u01b0 khi b\u1ea1n h\u1ecdc m\u1ed9t m\u00f4n to\u00e1n v\u1eady, h\u1ecdc ph\u1ea3i \u0111i \u0111\u00f4i v\u1edbi h\u00e0nh. Th\u1ef1c h\u00e0nh nhi\u1ec1u s\u1ebd gi\u00fap b\u1ea1n nh\u1edb l\u00e2u v\u00e0 tr\u1edf n\u00ean nhanh nh\u1ea1y khi g\u1eb7p l\u1ea1i b\u00e0i to\u00e1n \u0111\u00f3 trong t\u01b0\u01a1ng lai.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng h\u00e0m m\u00e0 b\u1ea1n s\u1ebd ph\u1ea3i th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng \u0111\u1ec3 gi\u1ea3i quy\u1ebft b\u00e0i to\u00e1n <\/span><b>t\u00e1ch ch\u1eef trong excel<\/b><span style=\"font-weight: 400;\">. Ngo\u00e0i ra c\u00f2n m\u1ed9t s\u1ed1 h\u00e0m sau c\u0169ng quan tr\u1ecdng kh\u00f4ng k\u00e9m \u0111\u1ec3 b\u1ea1n gi\u1ea3i quy\u1ebft nh\u1eefng b\u00e0i to\u00e1n kh\u00f3 h\u01a1n.<\/span><\/p>\n<p style=\"text-align: justify;\">Xem th\u00eam b\u00e0i vi\u1ebft:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/cach-mo-khoa-file-excel\/\">C\u00e1ch m\u1edf kh\u00f3a file excel ch\u1ec9 trong \u201ct\u00edch t\u1eafc\u201d cho ng\u01b0\u1eddi m\u1edbi<\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/\">L\u1eadp tr\u00ecnh VBA trong Excel \u2013 C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z cho ng\u01b0\u1eddi m\u1edbi<\/a><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ap_dung_cac_ham_co_ban_vao_thuc_te\"><\/span><b>\u00c1p d\u1ee5ng c\u00e1c h\u00e0m c\u01a1 b\u1ea3n v\u00e0o th\u1ef1c t\u1ebf<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_11569\" aria-describedby=\"caption-attachment-11569\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11569 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-1.jpg\" alt=\"\u00c1p d\u1ee5ng c\u00e1c h\u00e0m c\u01a1 b\u1ea3n v\u00e0o th\u1ef1c t\u1ebf\" width=\"600\" height=\"161\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-1-400x107.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11569\" class=\"wp-caption-text\">\u00c1p d\u1ee5ng c\u00e1c h\u00e0m c\u01a1 b\u1ea3n v\u00e0o th\u1ef1c t\u1ebf<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tuy nhi\u00ean, th\u1ef1c t\u1ebf s\u1ebd c\u00f3 nh\u1eefng b\u00e0i to\u00e1n kh\u00f3 h\u01a1n y\u00eau c\u1ea7u<\/span><b> t\u00e1ch s\u1ed1 v\u00e0 ch\u1eef trong excel<\/b><span style=\"font-weight: 400;\">. Khi \u0111\u00f3 b\u1ea1n s\u1ebd ph\u1ea3i bi\u1ebft ph\u1ed1i h\u1ee3p linh ho\u1ea1t c\u00e1c h\u00e0m tr\u00ean.\u00a0 Ch\u1ec9 c\u1ea7n hi\u1ec3u v\u00e0 l\u00e0m thu\u1ea7n th\u1ee5c c\u00e1c h\u00e0m tr\u00ean<\/span> <span style=\"font-weight: 400;\">th\u00ec nh\u1eefng h\u00e0m ph\u1ee9c t\u1ea1p h\u01a1n b\u1ea1n s\u1ebd nh\u00ecn ra c\u00e1ch \u0111\u1ec3 \u00e1p d\u1ee5ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u00fang t\u00f4i \u0111\u01b0a ra m\u1ed9t v\u00ed d\u1ee5 sau \u0111\u00e2y. T\u1ea1i \u00f4 A1 \u0111\u1ebfn A3 c\u00f3 chu\u1ed7i nh\u01b0 b\u1ea3ng d\u01b0\u1edbi, b\u1ea1n c\u1ea7n t\u00e1ch s\u1ed1 c\u1ee7a c\u00e1c \u00f4 \u0111\u00f3.<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">Nguy\u1ec5n Trung Hi\u1ebfu 51292<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Nguy\u1ec5n Thanh Tr\u00fac 9818<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Ph\u1ea1m Th\u1ecb Toan\u00a0<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u00ecn v\u00ed d\u1ee5 tr\u00ean, b\u1ea1n c\u00f3 c\u00e1ch n\u00e0o \u0111\u1ec3 nh\u1eadn bi\u1ebft <\/span><b>h\u00e0m<\/b> <b>t\u00e1ch s\u1ed1 v\u00e0 ch\u1eef trong Excel <\/b><span style=\"font-weight: 400;\">l\u00e0 g\u00ec?\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc ti\u00ean b\u1ea1n d\u00f9ng h\u00e0m FIND \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed g\u00f5 v\u00e0o \u00f4 B1. =FIND({0;1;2;3;4;5;6;7;8;9};A1). Gi\u00fap b\u1ea1n t\u00ecm v\u1ecb tr\u00ed s\u1ed1 trong chu\u1ed7i \u00f4 A1, sau \u0111\u00f3 k\u00e9o xu\u1ed1ng c\u00e1c \u00f4 B2, B3 c\u00f2n l\u1ea1i. Tuy nhi\u00ean, v\u1edbi \u00f4 A3 kh\u00f4ng c\u00f3 s\u1ed1 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 #VALUE! n\u00ean b\u1ea1n c\u1ea7n vi\u1ebft th\u00eam c\u00e2u l\u1ec7nh v\u00e0o h\u00e0m FIND. =FIND({1;2;3;4;5;6;7;8;9},A1&amp;&#8221;0123456789&#8243;)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u00f9ng h\u00e0m MIN tr\u01b0\u1edbc h\u00e0m FIND \u0111\u1ec3 \u00f4 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 nh\u1ecf nh\u1ea5t (v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ti\u1ebfp theo m\u00ecnh th\u00eam h\u00e0m Min ph\u00eda ngo\u00e0i v\u00e0 enter l\u00fac n\u00e0y k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 v\u1ecb tr\u00ed n\u00f3 t\u00ecm th\u1ea5y v\u00e0 l\u00e0 v\u1ecb tr\u00ed nh\u1ecf nh\u1ea5t. T\u1ee9c l\u00e0 trong chu\u1ed7i C4 v\u00e0 t\u1eeb 0 \u0111\u1ebfn 9 \u0111\u1ec3 t\u00ecm \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean v\u00e0 tr\u1ea3 v\u1ec1.<\/span><\/p>\n<figure id=\"attachment_11573\" aria-describedby=\"caption-attachment-11573\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11573 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-5-e1647251762215.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m Left trong t\u00e1ch ch\u1eef\" width=\"600\" height=\"232\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-5-e1647251762215.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-5-e1647251762215-400x155.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11573\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m Left trong t\u00e1ch ch\u1eef<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u00e1ch<\/span> <span style=\"font-weight: 400;\">t\u00ean h\u1ecdc sinh, g\u00f5 v\u00e0o \u00f4 C1 =Left(A1,B1-1) k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 t\u00ean bao g\u1ed3m kho\u1ea3ng tr\u1eafng n\u00ean d\u00f9ng th\u00eam h\u00e0m Trim. =Trim(Left(A1,B1-1))<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau khi t\u1ed5ng h\u1ee3p l\u1ea1i c\u00e1c h\u00e0m tr\u00ean, ta vi\u1ebft lu\u00f4n h\u00e0m cu\u1ed1i c\u00f9ng v\u00e0o \u00f4 B1.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=Trim(Left(A1;Min(Find({0;1;2;3;4;5;6;7;8;9};A1&amp;&#8221;0123456789&#8243;))-1))<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u00e1ch s\u1ed1 \u1edf b\u1ea3ng v\u00ed d\u1ee5 tr\u00ean<\/span> <span style=\"font-weight: 400;\">ta d\u00f9ng h\u00e0m RIGHT.<\/span> <span style=\"font-weight: 400;\">=Right(A1;len(A1)+1-min(find({0;1;2;3;4;5;6;7;8;9};A1&amp;&#8221;0123456789&#8243;))).<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng ki\u1ebfn th\u1ee9c h\u1eefu \u00edch v\u1ec1 <\/span><b>t\u00e1ch ch\u1eef trong Excel<\/b><span style=\"font-weight: 400;\">. \u0110\u00f3 l\u00e0 nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n nh\u1ea5t \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng khi l\u00e0m vi\u1ec7c hay l\u00e0m b\u00e1o c\u00e1o cho c\u1ea5p tr\u00ean. Tuy nhi\u00ean, c\u00f2n r\u1ea5t nhi\u1ec1u nh\u1eefng h\u00e0m cao h\u01a1n, \u0111\u00f2i h\u1ecfi ph\u1ea3i s\u1eed d\u1ee5ng \u0111\u1ebfn VBA m\u1edbi c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c. Ch\u00fang t\u00f4i s\u1ebd chi ti\u1ebft h\u01a1n trong nh\u1eefng b\u00e0i ti\u1ebfp theo, m\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i nh\u00e9!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel c\u00f3 l\u1ebd l\u00e0 c\u00f4ng c\u1ee5 th\u00f4ng d\u1ee5ng, d\u00e2n v\u0103n ph\u00f2ng n\u00e0o c\u0169ng bi\u1ebft \u0111\u1ebfn. N\u00f3 gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch nhanh h\u01a1n thay v\u00ec nh\u1eefng c\u00e1ch t\u00ednh to\u00e1n hay ghi ch\u00e9p th\u00f4ng th\u01b0\u1eddng. Th\u1eadm ch\u00ed, c\u00f3 nh\u1eefng c\u00f4ng vi\u1ec7c b\u1ea1n ch\u1ec9 c\u1ea7n thao t\u00e1c m\u1ed9t l\u1ea7n v\u00e0 s\u1eed d\u1ee5ng m\u00e3i m\u00e3i. &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11574,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11489","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>T\u00e1ch ch\u1eef trong Excel - M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng<\/title>\n<meta name=\"description\" content=\"B\u1ea1n \u0111\u00e3 bi\u1ebft ph\u01b0\u01a1ng ph\u00e1p t\u00e1ch ch\u1eef trong excel ch\u01b0a? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng ki\u1ebfn th\u1ee9c m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n chia s\u1ebb \u0111\u1ebfn c\u00e1c b\u1ea1n v\u1ec1 k\u1ef9 thu\u1eadt trong excel\" \/>\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\/tach-chu-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u00e1ch ch\u1eef trong Excel - M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng\" \/>\n<meta property=\"og:description\" content=\"B\u1ea1n \u0111\u00e3 bi\u1ebft ph\u01b0\u01a1ng ph\u00e1p t\u00e1ch ch\u1eef trong excel ch\u01b0a? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng ki\u1ebfn th\u1ee9c m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n chia s\u1ebb \u0111\u1ebfn c\u00e1c b\u1ea1n v\u1ec1 k\u1ef9 thu\u1eadt trong excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/tach-chu-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-14T10:04:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-08T04:55:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-6-e1647251401529.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"322\" \/>\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=\"8 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\/tach-chu-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"T\u00e1ch ch\u1eef trong Excel &#8211; M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng\",\"datePublished\":\"2022-11-14T10:04:47+00:00\",\"dateModified\":\"2022-12-08T04:55:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/\"},\"wordCount\":2069,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-6-e1647251401529.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/\",\"name\":\"T\u00e1ch ch\u1eef trong Excel - M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-6-e1647251401529.jpg\",\"datePublished\":\"2022-11-14T10:04:47+00:00\",\"dateModified\":\"2022-12-08T04:55:25+00:00\",\"description\":\"B\u1ea1n \u0111\u00e3 bi\u1ebft ph\u01b0\u01a1ng ph\u00e1p t\u00e1ch ch\u1eef trong excel ch\u01b0a? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng ki\u1ebfn th\u1ee9c m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n chia s\u1ebb \u0111\u1ebfn c\u00e1c b\u1ea1n v\u1ec1 k\u1ef9 thu\u1eadt trong excel\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-6-e1647251401529.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-6-e1647251401529.jpg\",\"width\":600,\"height\":322,\"caption\":\"T\u00e1ch ch\u1eef trong Excel - M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/tach-chu-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\":\"T\u00e1ch ch\u1eef trong Excel &#8211; M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng\"}]},{\"@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":"T\u00e1ch ch\u1eef trong Excel - M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng","description":"B\u1ea1n \u0111\u00e3 bi\u1ebft ph\u01b0\u01a1ng ph\u00e1p t\u00e1ch ch\u1eef trong excel ch\u01b0a? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng ki\u1ebfn th\u1ee9c m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n chia s\u1ebb \u0111\u1ebfn c\u00e1c b\u1ea1n v\u1ec1 k\u1ef9 thu\u1eadt trong excel","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\/tach-chu-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"T\u00e1ch ch\u1eef trong Excel - M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng","og_description":"B\u1ea1n \u0111\u00e3 bi\u1ebft ph\u01b0\u01a1ng ph\u00e1p t\u00e1ch ch\u1eef trong excel ch\u01b0a? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng ki\u1ebfn th\u1ee9c m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n chia s\u1ebb \u0111\u1ebfn c\u00e1c b\u1ea1n v\u1ec1 k\u1ef9 thu\u1eadt trong excel","og_url":"https:\/\/teky.edu.vn\/blog\/tach-chu-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-14T10:04:47+00:00","article_modified_time":"2022-12-08T04:55:25+00:00","og_image":[{"width":600,"height":322,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-6-e1647251401529.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":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"T\u00e1ch ch\u1eef trong Excel &#8211; M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng","datePublished":"2022-11-14T10:04:47+00:00","dateModified":"2022-12-08T04:55:25+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/"},"wordCount":2069,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-6-e1647251401529.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/","name":"T\u00e1ch ch\u1eef trong Excel - M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-6-e1647251401529.jpg","datePublished":"2022-11-14T10:04:47+00:00","dateModified":"2022-12-08T04:55:25+00:00","description":"B\u1ea1n \u0111\u00e3 bi\u1ebft ph\u01b0\u01a1ng ph\u00e1p t\u00e1ch ch\u1eef trong excel ch\u01b0a? D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng ki\u1ebfn th\u1ee9c m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n chia s\u1ebb \u0111\u1ebfn c\u00e1c b\u1ea1n v\u1ec1 k\u1ef9 thu\u1eadt trong excel","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-6-e1647251401529.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/tach-chu-excel-6-e1647251401529.jpg","width":600,"height":322,"caption":"T\u00e1ch ch\u1eef trong Excel - M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/tach-chu-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":"T\u00e1ch ch\u1eef trong Excel &#8211; M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng"}]},{"@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\/11489","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=11489"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11489\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11574"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}