{"id":1470,"date":"2020-10-09T01:18:51","date_gmt":"2020-10-08T18:18:51","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1470"},"modified":"2020-10-09T01:18:52","modified_gmt":"2020-10-08T18:18:52","slug":"ham-lay-ky-tu-bat-ky-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-lay-ky-tu-bat-ky-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng D\u1eabn S\u1eed D\u1ee5ng 3 H\u00e0m L\u1ea5y K\u00fd T\u1ef1 B\u1ea5t K\u1ef3 Trong Excel Hi\u1ec7u Qu\u1ea3 Nh\u1ea5t: H\u00e0m LEFT\/ RIGHT\/ MID"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1470\" class=\"elementor elementor-1470\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-31219d8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"31219d8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-be2e4e8\" data-id=\"be2e4e8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-108af33 elementor-widget elementor-widget-text-editor\" data-id=\"108af33\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Khi x\u1eed l\u00fd v\u0103n b\u1ea3n\/ \u0111\u1ecbnh d\u1ea1ng text trong Excel, ch\u00fang ta th\u01b0\u1eddng ph\u1ea3i x\u1eed l\u00fd ph\u00e2n chia, c\u1eaft chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch t\u00e1ch c\u00e1c \u00f4 b\u1eb1ng h\u00e0m c\u1eaft chu\u1ed7i trong Excel: h\u00e0m MID, h\u00e0m LEFT, h\u00e0m RIGHT. <\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">B\u1ea1n s\u1ebd h\u1ecdc c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m l\u1ea5y k\u00fd t\u1ef1 b\u1ea5t k\u1ef3 trong Excel \u0111\u1ec3 t\u00e1ch v\u0103n b\u1ea3n, lo\u1ea1i b\u1ecf \u0111\u1ed3ng th\u1eddi gh\u00e9p c\u00e1c chu\u1ed7i k\u00fd t\u1ef1 \u0111\u1ec3 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n c\u00f4ng vi\u1ec7c y\u00eau c\u1ea7u.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-508f0bd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"508f0bd\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3d3f06d\" data-id=\"3d3f06d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c8c1bd4 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"c8c1bd4\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;&quot;,&quot;library&quot;:&quot;&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-loading eicon-animation-spin\" aria-hidden=\"true\"><\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3e0f546 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3e0f546\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c52702c\" data-id=\"c52702c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-deefee4 elementor-widget elementor-widget-heading\" data-id=\"deefee4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-0d93676c-7fff-0925-299c-079774728afb\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1, H\u00e0m MID - H\u00e0m L\u1ea5y K\u00fd T\u1ef1 B\u1ea5t K\u1ef3 Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f19e65d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f19e65d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e94c978\" data-id=\"e94c978\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-93a3611 elementor-widget elementor-widget-text-editor\" data-id=\"93a3611\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m MID l\u00e0 h\u00e0m l\u1ea5y k\u00fd t\u1ef1 gi\u1eefa trong Excel (Middle):<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=MID(text, start_num, num_chars)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong \u0111\u00f3:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Text: chu\u1ed7i v\u0103n b\u1ea3n c\u1ea7n tr\u00edch xu\u1ea5t.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Start_num: V\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ea7n t\u00e1ch trong text.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Num_chars: S\u1ed1 k\u00fd t\u1ef1 c\u1ea7n c\u1eaft ra t\u1eeb chu\u1ed7i k\u00fd t\u1ef1.<\/span><\/p><\/li><\/ul><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap; text-align: justify;\">\u00a0<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap; text-align: justify;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID \u0111\u1ec3 t\u00e1ch chu\u1ed7i trong Excel v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n, v\u00ed d\u1ee5 MID(\u201cstudent\u201d,2,4) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 \u201ctude\u201d.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u1ee8ng d\u1ee5ng h\u00e0m MID \u0111\u1ec3 t\u00ecm l\u1edbp c\u1ee7a c\u00e1c sinh vi\u00ean trong danh s\u00e1ch sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a39aa3f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a39aa3f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1743d19\" data-id=\"1743d19\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2d72133 elementor-widget elementor-widget-image\" data-id=\"2d72133\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/10\/vi-du-ham-lay-ky-tu-bat-ky-trong-Excel.png\" title=\"vi-du-ham-lay-ky-tu-bat-ky-trong-Excel\" alt=\"V\u00ed D\u1ee5 C\u1ea7n S\u1eed D\u1ee5ng H\u00e0m L\u1ea5y K\u00fd T\u1ef1 B\u1ea5t K\u1ef3 Trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-eb77a19 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"eb77a19\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1b8e286\" data-id=\"1b8e286\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c5234a6 elementor-widget elementor-widget-text-editor\" data-id=\"c5234a6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m MID tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh l\u00e0 t\u00ean l\u1edbp (t\u1eeb gi\u1eefa chu\u1ed7i v\u0103n b\u1ea3n):<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">MID(C8,3,4) <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">tr\u1ea3 v\u1ec1 4 k\u00fd t\u1ef1 \u1edf gi\u1eefa t\u1eeb v\u1ecb tr\u00ed th\u1ee9 3 c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n n\u1eb1m trong \u00f4 C8, nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, \u00f4 C8 ch\u1ee9a chu\u1ed7i text \u201cCQK17A001@st.edu.vn\u201d n\u00ean k<\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m MID(C8,3,4) tr\u1ea3 v\u1ec1 \u201cK17A\u201d.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3daa12a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3daa12a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bb768d1\" data-id=\"bb768d1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1ccfd53 elementor-widget elementor-widget-image\" data-id=\"1ccfd53\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/10\/vi-du-ham-lay-ky-tu-bat-ky-trong-Excel-ham-mid.png\" title=\"vi-du-ham-lay-ky-tu-bat-ky-trong-Excel-ham-mid\" alt=\"v\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MID h\u00e0m l\u1ea5y k\u00fd t\u1ef1 b\u1ea5t k\u1ef3 trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4bb506c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4bb506c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7a7954d\" data-id=\"7a7954d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-11537c4 elementor-widget elementor-widget-heading\" data-id=\"11537c4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-8e3dc714-7fff-9384-a768-8bd673ec8b60\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2. H\u00e0m LEFT L\u1ea5y K\u00fd T\u1ef1 B\u00ean Tr\u00e1i Chu\u1ed7i Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-624455c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"624455c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f23a70c\" data-id=\"f23a70c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-17caeb0 elementor-widget elementor-widget-text-editor\" data-id=\"17caeb0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m LEFT \u0111\u1ec3 l\u1ea5y k\u00fd t\u1ef1 trong chu\u1ed7i t\u1eeb ph\u00eda b\u00ean tr\u00e1i, hay c\u00f2n g\u1ecdi l\u00e0 h\u00e0m x\u00f3a k\u00fd t\u1ef1 b\u00ean ph\u1ea3i trong Excel:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=LEFT(text, [num_chars])<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong \u0111\u00f3:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Text: chu\u1ed7i v\u0103n b\u1ea3n c\u1ea7n tr\u00edch xu\u1ea5t c\u00e1c k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i, c\u00f3 th\u1ec3 l\u00e0 v\u0103n b\u1ea3n\/ tham chi\u1ebfu \u00f4.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">[num_chars]: s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n c\u1eaft chu\u1ed7i, n\u1ebfu kh\u00f4ng \u0111\u01b0\u1ee3c nh\u1eadp s\u1ebd m\u1eb7c \u0111\u1ecbnh b\u1eb1ng 1.<\/span><\/p><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d76b250 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d76b250\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a6365f4\" data-id=\"a6365f4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-03ec9ee elementor-widget elementor-widget-text-editor\" data-id=\"03ec9ee\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y c\u1eaft chu\u1ed7i t\u1eeb \u0111\u1ecba ch\u1ec9 email c\u1ee7a sinh vi\u00ean \u0111\u1ec3 ra k\u1ebft qu\u1ea3 l\u00e0 m\u00e3 sinh vi\u00ean t\u01b0\u01a1ng \u1ee9ng khi bi\u1ebft m\u00e3 n\u00e0y l\u00e0 9 k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u c\u1ee7a email:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"><b>LEFT(C7,9)<\/b> <\/span><span style=\"font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">tr\u1ea3 v\u1ec1 9 k\u00fd t\u1ef1 b\u00ean tr\u00e1i chu\u1ed7i n\u1eb1m trong \u00f4 C7<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-647d1d8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"647d1d8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6b9a2c1\" data-id=\"6b9a2c1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-869ffd1 elementor-widget elementor-widget-image\" data-id=\"869ffd1\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/10\/vi-du-ham-lay-ky-tu-bat-ky-trong-Excel-ham-left.png\" title=\"vi-du-ham-lay-ky-tu-bat-ky-trong-Excel-ham-left\" alt=\"v\u00ed d\u1ee5 h\u00e0m l\u1ea5y k\u00fd t\u1ef1 b\u1ea5t k\u1ef3 trong Excel H\u00e0m LEFT L\u1ea5y K\u00fd T\u1ef1 B\u00ean Tr\u00e1i Chu\u1ed7i Trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-04fbb3d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"04fbb3d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-44e7152\" data-id=\"44e7152\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-81acf18 elementor-widget elementor-widget-heading\" data-id=\"81acf18\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-f19ed909-7fff-9329-e284-82677b6f7c68\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3, H\u00e0m RIGHT T\u00e1ch K\u00fd T\u1ef1 Ph\u00eda B\u00ean Ph\u1ea3i Chu\u1ed7i Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4afc851 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4afc851\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f030fc7\" data-id=\"f030fc7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-21e9593 elementor-widget elementor-widget-text-editor\" data-id=\"21e9593\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m RIGHT \u0111\u1ec3 l\u1ea5y chu\u1ed7i k\u00fd t\u1ef1 trong Excel t\u1eeb ph\u00eda b\u00ean ph\u1ea3i, hay c\u00f2n g\u1ecdi l\u00e0 h\u00e0m b\u1ecf k\u00fd t\u1ef1 b\u00ean tr\u00e1i c\u00f3 c\u00fa ph\u00e1p:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=RIGHT(text, [num_chars])<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y y h\u1ec7t h\u00e0m LEFT \u0111\u00e3 tr\u00ecnh b\u00e0y \u1edf tr\u00ean.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y tr\u00edch xu\u1ea5t s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a sinh vi\u00ean trong danh s\u00e1ch l\u1edbp d\u1ef1a v\u00e0o m\u00e3 sinh vi\u00ean \u0111\u00e3 l\u1ea5y \u0111\u01b0\u1ee3c \u1edf m\u1ee5c 2, v\u00ed d\u1ee5 sinh vi\u00ean c\u00f3 m\u00e3 K17ACQ001 s\u1ebd c\u00f3 s\u1ed1 th\u1ee9 t\u1ef1 l\u00e0 001 trong danh s\u00e1ch l\u1edbp K17A, \u0111\u1ec3 l\u1ea5y s\u1ed1 th\u1ee9 t\u1ef1 n\u00e0y, c\u00f4ng th\u1ee9c h\u00e0m RIGHT nh\u01b0 sau:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\"><b>RIGHT(\u2018K17ACQ001\u2019,3)<\/b> ho\u1eb7c <b>RIGHT(C7,3)<\/b><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f8d503a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f8d503a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c609c18\" data-id=\"c609c18\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7d90a68 elementor-widget elementor-widget-image\" data-id=\"7d90a68\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/10\/vi-du-ham-lay-ky-tu-bat-ky-trong-Excel-ham-right.png\" title=\"vi-du-ham-lay-ky-tu-bat-ky-trong-Excel-ham-right\" alt=\"S\u1eed D\u1ee5ng H\u00e0m L\u1ea5y K\u00fd T\u1ef1 B\u1ea5t K\u1ef3 Trong Excel H\u00e0m RIGHT t\u00e1ch k\u00fd t\u1ef1 b\u00ean ph\u1ea3i chu\u1ed7i\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-837f123 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"837f123\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0f634c7\" data-id=\"0f634c7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5edb13a elementor-widget elementor-widget-heading\" data-id=\"5edb13a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-a29884b0-7fff-f57c-e10b-63da88ed7b0d\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">4, K\u1ebft H\u1ee3p C\u00e1c H\u00e0m L\u1ecdc K\u00fd T\u1ef1 Trong Excel \u0110\u1ec3 T\u00e1ch\/ Th\u00eam K\u00fd T\u1ef1 V\u00e0o Chu\u1ed7i<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1347d08 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1347d08\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d736093\" data-id=\"d736093\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9e8e5eb elementor-widget elementor-widget-text-editor\" data-id=\"9e8e5eb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 th\u00eam k\u00fd t\u1ef1 v\u00e0o \u0111\u1ea7u chu\u1ed7i trong Excel, ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng d\u1ea5u n\u1ed1i \u0111\u01a1n gi\u1ea3n, v\u00ed d\u1ee5 gh\u00e9p \u201cT\u00e1o\u201d v\u00e0 \u201cApple\u201d s\u1eed d\u1ee5ng = \u201cT\u00e1o\u201d &amp; \u201cApple\u201d s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 chu\u1ed7i \u201cT\u00e1oApple\u201d.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u1ea1n c\u00f3 th\u1ec3 th\u00eam v\u00e0o chu\u1ed7i k\u00fd t\u1ef1 d\u1ea5u c\u00e1ch (space) \u201c \u201c \u0111\u1ec3 t\u1ea1o kho\u1ea3ng c\u00e1ch gi\u1eefa c\u00e1c t\u1eeb.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y t\u00e1ch ph\u1ea7n k\u00fd t\u1ef1 c\u00f3 ch\u1eef c\u00e1i v\u00e0 ph\u1ea7n ch\u1ec9 c\u00f3 s\u1ed1 \u1edf c\u1ee5m bi\u1ec3n s\u1ed1 trong Excel: \u201c30D112345\u201d \u0111\u01b0\u1ee3c t\u00e1ch v\u1ec1 chu\u1ed7i \u201c30D1 &#8211; 12345\u201d b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m LEFT v\u00e0 h\u00e0m RIGHT \u0111\u1ec3 t\u00e1ch 2 ph\u1ea7n c\u1ee7a chu\u1ed7i:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-413b77d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"413b77d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b1f9c48\" data-id=\"b1f9c48\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ee48643 elementor-widget elementor-widget-image\" data-id=\"ee48643\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/10\/vi-du-ham-lay-ky-tu-bat-ky-trong-Excel-ket-hop-cac-ham-left-right-dau-noi.png\" title=\"vi-du-ham-lay-ky-tu-bat-ky-trong-Excel-ket-hop-cac-ham-left-right-dau-noi\" alt=\"K\u1ebft H\u1ee3p C\u00e1c H\u00e0m L\u1ecdc K\u00fd T\u1ef1 Trong Excel \u0110\u1ec3 T\u00e1ch\/ Th\u00eam K\u00fd T\u1ef1 V\u00e0o Chu\u1ed7i \u0110\u01a1n Gi\u1ea3n V\u1edbi D\u1ea5u N\u1ed1i\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7dc729e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7dc729e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f65fbad\" data-id=\"f65fbad\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a141ee5 elementor-widget elementor-widget-text-editor\" data-id=\"a141ee5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Tuy nhi\u00ean c\u00e1ch n\u00e0y ch\u1ec9 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c khi b\u1ed9 s\u1ed1 li\u1ec7u l\u00e0 c\u00e1c chu\u1ed7i c\u00f3 c\u00f9ng \u0111\u1ed9 d\u00e0i, ch\u1ec9 c\u1ea7n m\u1ed9t chu\u1ed7i kh\u00f4ng \u0111\u01b0\u1ee3c nh\u1eadp theo m\u1eabu th\u00ec quy t\u1eafc l\u1ea5y s\u1ed1 k\u00fd t\u1ef1 c\u1ed1 \u0111\u1ecbnh s\u1ebd kh\u00f4ng ch\u00ednh x\u00e1c:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">V\u00ed d\u1ee5 chu\u1ed7i \u201c30D123456\u201d \u1edf \u00f4 A6 \u0111\u01b0\u1ee3c t\u00e1ch v\u1ec1 chu\u1ed7i \u201c30D1 &#8211; 23456\u201d b\u1eb1ng c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p LEFT(A6,4)&amp;&#8221; &#8211; &#8220;&amp;RIGHT(A6,5) ch\u1ec9 \u0111\u00fang khi bi\u1ec3n s\u1ed1 xe c\u00f3 5 ch\u1eef s\u1ed1.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Khi xu\u1ea5t hi\u1ec7n chu\u1ed7i \u201c29B1233.63\u201d c\u00f3 th\u00eam d\u1ea5u ng\u1eaft \u1edf gi\u1eefa th\u00ec k\u1ebft qu\u1ea3 c\u00f4ng th\u1ee9c \u201c29B1 &#8211; 33.63\u201d thi\u1ebfu m\u1ea5t 1 ch\u1eef s\u1ed1 c\u1ee7a bi\u1ec3n s\u1ed1, ho\u1eb7c bi\u1ec3n c\u00f3 4 ch\u1eef s\u1ed1 th\u00ec c\u00f4ng th\u1ee9c s\u1ebd l\u1ea5y th\u1eeba 1 ch\u1eef s\u1ed1 v\u00ec h\u00e0m RIGHT(tham chi\u1ebfu \u00f4, 5) l\u1ea5y \u0111\u00fang 5 k\u00fd t\u1ef1 t\u1eeb ph\u1ea3i sang:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-85923ba elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"85923ba\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-75b2560\" data-id=\"75b2560\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7e67c9b elementor-widget elementor-widget-image\" data-id=\"7e67c9b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/10\/vi-du-ket-hop-cac-ham-left-right-dau-noi-thieu-chinh-xac-vi-chua-dem-so-ky-tu.png\" title=\"vi-du-ket-hop-cac-ham-left-right-dau-noi-thieu-chinh-xac-vi-chua-dem-so-ky-tu\" alt=\"v\u00ed d\u1ee5 k\u1ebft h\u1ee3p c\u00e1c h\u00e0m l\u1ea5y k\u00fd t\u1ef1 trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9826672 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9826672\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e008974\" data-id=\"e008974\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8f4c89e elementor-widget elementor-widget-text-editor\" data-id=\"8f4c89e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 x\u1eed l\u00fd 1 t\u1ec7p d\u1eef li\u1ec7u g\u1ed3m nhi\u1ec1u chu\u1ed7i v\u0103n b\u1ea3n kh\u00f4ng c\u00f9ng \u0111\u1ed9 d\u00e0i, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m LEN (tr\u1ea3 v\u1ec1 \u0111\u1ed9 d\u00e0i chu\u1ed7i) c\u00f9ng c\u00e1c h\u00e0m l\u1ea5y k\u00fd t\u1ef1 b\u1ea5t k\u1ef3 trong Excel (h\u00e0m MID\/ RIGHT\/ LEFT):<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">V\u00ed d\u1ee5 chu\u1ed7i \u201c30D123456\u201d v\u00e0 \u201c18F12888\u201d c\u00f3 \u0111\u1ed9 d\u00e0i kh\u00e1c nhau nh\u01b0ng \u0111\u1ec1u c\u00f3 th\u1ec3 t\u00e1ch v\u1ec1 d\u1ea1ng \u201c30D1 &#8211; 23456\u201d v\u00e0 \u201c18F1 &#8211; 2888\u201d b\u1eb1ng c\u00f4ng th\u1ee9c:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">LEFT(text,4)&amp;&#8221; &#8211; &#8220;&amp;RIGHT(text,LEN(text)-4)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Ph\u1ea7n \u0111u\u00f4i c\u1ee7a bi\u1ec3n s\u1ed1 l\u00fac n\u00e0y \u0111\u01b0\u1ee3c t\u00e1ch ra kh\u1ecfi chu\u1ed7i t\u1eeb ph\u00eda b\u00ean ph\u1ea3i, b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m LEN v\u00e0 RIGHT: \u0111\u1ed1i s\u1ed1 <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">LEN(text)-4 <\/span><span style=\"background-color: transparent; font-size: 12pt; font-family: Arial; color: #000000; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">l\u00e0 s\u1ed1 k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c c\u1eaft kh\u1ecfi chu\u1ed7i \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng c\u00e1ch l\u1ea5y \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i tr\u1eeb \u0111i 4 k\u00fd t\u1ef1 \u0111\u1ea7u:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u201c30D123456\u201d tr\u1eeb \u0111i 4 k\u00fd t\u1ef1 \u0111\u1ea7u \u201c30D1\u201d ra ph\u1ea7n \u0111u\u00f4i c\u1ee7a bi\u1ec3n s\u1ed1 \u201c23456\u201d;<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u201c18F12888\u201d tr\u1eeb \u0111i 4 k\u00fd t\u1ef1 \u0111\u1ea7u \u201c18F1\u201d ra ph\u1ea7n \u0111u\u00f4i c\u1ee7a bi\u1ec3n s\u1ed1 \u201c2888\u201d;<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u2026<\/span><\/p><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Nh\u1edd h\u00e0m LEN, b\u1ea1n kh\u00f4ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ea7n t\u00e1ch kh\u1ecfi chu\u1ed7i l\u00e0 4 hay 5 ch\u1eef s\u1ed1 (nh\u01b0 v\u00ed d\u1ee5 bi\u1ec3n s\u1ed1 \u1edf tr\u00ean).<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><div><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">K\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c khi k\u1ebft h\u1ee3p c\u00e1c h\u00e0m l\u1ea5y k\u00fd t\u1ef1 v\u00e0 h\u00e0m LEN nh\u01b0 sau:<\/span><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5ef77e2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5ef77e2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d6e6614\" data-id=\"d6e6614\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cb664a8 elementor-widget elementor-widget-image\" data-id=\"cb664a8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/10\/vi-du-ham-lay-ky-tu-bat-ky-trong-Excel-ket-hop-cac-ham-left-right-ham-len.png\" title=\"vi-du-ham-lay-ky-tu-bat-ky-trong-Excel-ket-hop-cac-ham-left-right-ham-len\" alt=\"V\u00ed d\u1ee5 K\u1ebft H\u1ee3p C\u00e1c H\u00e0m L\u1ecdc K\u00fd T\u1ef1 Trong Excel K\u1ebft h\u1ee3p h\u00e0m len v\u00e0 right\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-490cc5c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"490cc5c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-06b669c\" data-id=\"06b669c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f5c9737 elementor-widget elementor-widget-text-editor\" data-id=\"f5c9737\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c c\u00e1ch \u00e1p d\u1ee5ng h\u00e0m l\u1ea5y k\u00fd t\u1ef1 b\u1ea5t k\u1ef3 trong Excel. Hi v\u1ecdng b\u00e0i vi\u1ebft c\u1ee7a hoctin.vn \u0111\u00e3 mang l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1c th\u00f4ng tin h\u1eefu \u00edch.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ngo\u00e0i ra, \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u v\u0103n b\u1ea3n, v\u00ed d\u1ee5 l\u1ecdc\/ s\u1eafp x\u1ebfp, copy, g\u1ed9p \u00f4 m\u00e0 kh\u00f4ng m\u1ea5t v\u0103n b\u1ea3n, c\u00e1c c\u00e1ch chuy\u1ec3n ch\u1eef th\u01b0\u1eddng th\u00e0nh ch\u1eef hoa trong Excel v\u00e0 ng\u01b0\u1ee3c l\u1ea1i, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a style=\"background-color: #ffffff;\" href=\"https:\/\/hoctin.vn\/cach-loc-du-lieu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch L\u1ecdc V\u00e0 S\u1eafp X\u1ebfp D\u1eef Li\u1ec7u Trong Excel<\/a><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/gop-o-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng D\u1eabn C\u00e1ch G\u1ed9p \u00d4 Trong Excel<\/a><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a style=\"background-color: #ffffff;\" href=\"https:\/\/hoctin.vn\/cach-copy-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1c C\u00e1ch Copy Trong Excel<\/a><\/p><div>\u00a0<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Khi x\u1eed l\u00fd v\u0103n b\u1ea3n\/ \u0111\u1ecbnh d\u1ea1ng text trong Excel, ch\u00fang ta th\u01b0\u1eddng ph\u1ea3i x\u1eed l\u00fd ph\u00e2n chia, c\u1eaft chu\u1ed7i v\u0103n b\u1ea3n. Trong b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch t\u00e1ch c\u00e1c \u00f4 b\u1eb1ng h\u00e0m c\u1eaft chu\u1ed7i trong Excel: h\u00e0m MID, h\u00e0m LEFT, h\u00e0m RIGHT. B\u1ea1n s\u1ebd h\u1ecdc c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c &#8230; <a title=\"H\u01b0\u1edbng D\u1eabn S\u1eed D\u1ee5ng 3 H\u00e0m L\u1ea5y K\u00fd T\u1ef1 B\u1ea5t K\u1ef3 Trong Excel Hi\u1ec7u Qu\u1ea3 Nh\u1ea5t: H\u00e0m LEFT\/ RIGHT\/ MID\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-lay-ky-tu-bat-ky-trong-excel\/\">Read more <span class=\"screen-reader-text\">H\u01b0\u1edbng D\u1eabn S\u1eed D\u1ee5ng 3 H\u00e0m L\u1ea5y K\u00fd T\u1ef1 B\u1ea5t K\u1ef3 Trong Excel Hi\u1ec7u Qu\u1ea3 Nh\u1ea5t: H\u00e0m LEFT\/ RIGHT\/ MID<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":1501,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[58,53,57,59],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1470"}],"collection":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/comments?post=1470"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1470\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/1501"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=1470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=1470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=1470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}