{"id":5395,"date":"2024-12-16T02:19:28","date_gmt":"2024-12-16T02:19:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-chen-them-ky-tu-vao-dau-hoac-cuoi-cua-chuoi-ky-tu-trong-excel\/"},"modified":"2024-12-16T02:19:28","modified_gmt":"2024-12-16T02:19:28","slug":"huong-dan-cach-chen-them-ky-tu-vao-dau-hoac-cuoi-cua-chuoi-ky-tu-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-chen-them-ky-tu-vao-dau-hoac-cuoi-cua-chuoi-ky-tu-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch ch\u00e8n th\u00eam k\u00fd t\u1ef1 v\u00e0o \u0111\u1ea7u ho\u1eb7c cu\u1ed1i c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n\u00a0mu\u1ed1n th\u00eam m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 v\u00e0o\u00a0\u0111\u1ea7u ho\u1eb7c cu\u1ed1i c\u1ee7a 1\u00a0\u00f4\u00a0\u0111\u00e3 c\u00f3 d\u1eef li\u1ec7u? Ho\u1eb7c ph\u1ee9c t\u1ea1p h\u01a1n l\u00e0 ch\u00e8n th\u00eam k\u00fd t\u1ef1 v\u00e0o 1 v\u1ecb tr\u00ed n\u1eb1m gi\u1eefa 1\u00a0\u0111o\u1ea1n k\u00fd t\u1ef1 kh\u00e1c? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m ngay n\u00e0o.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-675f8e2f2e544\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chen-ky-tu-vao-dau-hoac-cuoi-cua-chuoi-ky-tu-trong-excel.html#Chen_them_ky_tu_vao_dau_cua_chuoi_ky_tu\" title=\"Ch\u00e8n th\u00eam k\u00fd t\u1ef1 v\u00e0o \u0111\u1ea7u c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1\">Ch\u00e8n th\u00eam k\u00fd t\u1ef1 v\u00e0o \u0111\u1ea7u c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chen-ky-tu-vao-dau-hoac-cuoi-cua-chuoi-ky-tu-trong-excel.html#Cach_1_su_dung_dau_de_noi_ky_tu\" title=\"C\u00e1ch 1: s\u1eed d\u1ee5ng d\u1ea5u &amp;\u00a0\u0111\u1ec3 n\u1ed1i k\u00fd t\u1ef1\">C\u00e1ch 1: s\u1eed d\u1ee5ng d\u1ea5u &amp;\u00a0\u0111\u1ec3 n\u1ed1i k\u00fd t\u1ef1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chen-ky-tu-vao-dau-hoac-cuoi-cua-chuoi-ky-tu-trong-excel.html#Cach_2_Su_dung_ham_CONCATENATE\" title=\"C\u00e1ch 2: S\u1eed d\u1ee5ng h\u00e0m CONCATENATE\">C\u00e1ch 2: S\u1eed d\u1ee5ng h\u00e0m CONCATENATE<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chen-ky-tu-vao-dau-hoac-cuoi-cua-chuoi-ky-tu-trong-excel.html#Chen_them_ky_tu_vao_cuoi_cua_chuoi_ky_tu\" title=\"Ch\u00e8n th\u00eam k\u00fd t\u1ef1 v\u00e0o cu\u1ed1i c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1\">Ch\u00e8n th\u00eam k\u00fd t\u1ef1 v\u00e0o cu\u1ed1i c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chen-ky-tu-vao-dau-hoac-cuoi-cua-chuoi-ky-tu-trong-excel.html#Chen_them_ky_tu_vao_giua_cua_chuoi_ky_tu\" title=\"Ch\u00e8n th\u00eam k\u00fd t\u1ef1\u00a0v\u00e0o gi\u1eefa c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1\">Ch\u00e8n th\u00eam k\u00fd t\u1ef1\u00a0v\u00e0o gi\u1eefa c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chen-ky-tu-vao-dau-hoac-cuoi-cua-chuoi-ky-tu-trong-excel.html#Xac_dinh_vi_tri_bat_dau_chen_ky_tu_moi\" title=\"X\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed b\u1eaft\u00a0\u0111\u1ea7u ch\u00e8n k\u00fd t\u1ef1 m\u1edbi\">X\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed b\u1eaft\u00a0\u0111\u1ea7u ch\u00e8n k\u00fd t\u1ef1 m\u1edbi<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chen-ky-tu-vao-dau-hoac-cuoi-cua-chuoi-ky-tu-trong-excel.html#Ky_thuat_chen_va_noi_chuoi\" title=\"K\u1ef9 thu\u1eadt ch\u00e8n v\u00e0 n\u1ed1i chu\u1ed7i\">K\u1ef9 thu\u1eadt ch\u00e8n v\u00e0 n\u1ed1i chu\u1ed7i<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-chen-ky-tu-vao-dau-hoac-cuoi-cua-chuoi-ky-tu-trong-excel.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Chen_them_ky_tu_vao_dau_cua_chuoi_ky_tu\"><\/span>Ch\u00e8n th\u00eam k\u00fd t\u1ef1 v\u00e0o \u0111\u1ea7u c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24463\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/yeu-cau-them-ky-tu-o-dau.png\" width=\"440\" height=\"181\" title=\"yeu-cau-them-ky-tu-o-dau\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta mu\u1ed1n th\u00eam c\u00e1c k\u00fd t\u1ef1\u00a0\u201cT\u00f4i y\u00eau\u201d v\u00e0o tr\u01b0\u1edbc k\u00fd t\u01b0\u1ef1 g\u1ed1c l\u00e0 \u201cH\u1ecdc\u00a0Excel\u201d. C\u00e1c c\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_1_su_dung_dau_de_noi_ky_tu\"><\/span>C\u00e1ch 1: s\u1eed d\u1ee5ng d\u1ea5u &amp;\u00a0\u0111\u1ec3 n\u1ed1i k\u00fd t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u0103n c\u1ee9 v\u00e0o th\u1ee9 t\u1ef1 c\u00e1c k\u00fd t\u1ef1, ch\u00fang ta s\u1ebd \u0111\u1eb7t ph\u1ea7n k\u00fd t\u1ef1\u00a0n\u00e0o c\u1ea7n vi\u1ebft tr\u01b0\u1edbc, ti\u1ebfp theo l\u00e0\u00a0\u0111\u1ebfn ph\u1ea7n k\u00fd t\u1ef1 vi\u1ebft sau. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ta c\u00f3:<\/p>\n<p style=\"padding-left: 30px\">C5=B5&amp;A5<\/p>\n<p>K\u1ebft qu\u1ea3 l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24464\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/noi-ky-tu-voi-dau.png\" width=\"483\" height=\"222\" title=\"noi-ky-tu-voi-dau\"><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-466.gif\" title=\"ex101_92019-nho-466\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Nh\u01b0ng nh\u01b0 v\u1eady ch\u1eef Y\u00eau v\u00e0 ch\u1eef H\u1ecdc l\u1ea1i vi\u1ebft li\u1ec1n nhau. N\u1ebfu mu\u1ed1n c\u00f3 d\u1ea5u c\u00e1ch\u00a0\u0111\u1ec3 ng\u0103n c\u00e1ch 2 k\u00fd t\u1ef1 n\u00e0y, ch\u00fang ta s\u1ebd n\u1ed1i v\u1edbi d\u1ea5u c\u00e1ch\u00a0\u1edf v\u1ecb tr\u00ed gi\u1eefa c\u1ee7a 2\u00a0\u0111o\u1ea1n k\u00fd t\u1ef1 nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">C5=B5&amp;\u201d \u201c&amp;A5<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24465\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/noi-ky-tu-voi-dau-co-them-dau-cach.png\" width=\"508\" height=\"220\" title=\"noi-ky-tu-voi-dau-co-them-dau-cach\"><\/p>\n<p>D\u1ea5u c\u00e1ch c\u1ea7n\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p v\u00e0 coi\u00a0\u0111\u00f3 nh\u01b0 1 k\u00fd t\u1ef1\u00a0\u0111\u1ec3 n\u1ed1i, gi\u1ed1ng nh\u01b0 k\u00fd t\u1ef1 trong\u00a0\u00f4 A5 v\u00e0 B5<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_2_Su_dung_ham_CONCATENATE\"><\/span>C\u00e1ch 2: S\u1eed d\u1ee5ng h\u00e0m CONCATENATE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-concatenate-trong-excel-ung-dung-de-noi-cac-chuoi-o-mang-va-cot.html\">H\u00e0m Concatenate<\/a> (c\u00f3 th\u1ec3 vi\u1ebft g\u1ecdn l\u00e0 h\u00e0m Concat trong m\u1ed9t s\u1ed1\u00a0phi\u00ean b\u1ea3n m\u1edbi c\u1ee7a\u00a0Excel) l\u00e0 h\u00e0m gi\u00fap n\u1ed1i k\u00fd t\u1ef1 trong\u00a0Excel.\u00a0\u0110\u1eb7t c\u00e1c t\u1eeb kh\u00f3a c\u1ea7n n\u1ed1i theo th\u1ee9 t\u1ef1 v\u00e0o trong h\u00e0m:<\/p>\n<p style=\"padding-left: 30px\">C5=CONCATENATE(B5,\u201d \u201c,A5)<\/p>\n<p>K\u1ebft qu\u1ea3 l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24466\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/noi-ky-tu-voi-ham-concatenate.png\" width=\"646\" height=\"222\" title=\"noi-ky-tu-voi-ham-concatenate\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chen_them_ky_tu_vao_cuoi_cua_chuoi_ky_tu\"><\/span>Ch\u00e8n th\u00eam k\u00fd t\u1ef1 v\u00e0o cu\u1ed1i c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 vi\u1ec7c n\u1ed1i k\u00fd t\u1ef1\u00a0\u1edf\u00a0\u0111\u1ea7u, khi n\u1ed1i k\u00fd t\u1ef1 v\u00e0o cu\u1ed1i c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1 g\u1ed1c th\u00ec ch\u00fang ta l\u01b0u\u00a0\u00fd\u00a0\u0111\u1eb7t th\u1ee9 t\u1ef1 c\u00e1c k\u00fd t\u1ef1 cho\u00a0\u0111\u00fang.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24467\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/yeu-cau-them-ky-tu-o-cuoi.png\" width=\"441\" height=\"176\" title=\"yeu-cau-them-ky-tu-o-cuoi\"><\/p>\n<p>Th\u00eam t\u1eeb kh\u00f3a \u201c.online\u201d v\u00e0o cu\u1ed1i c\u1ee7a k\u00fd t\u1ef1 g\u1ed1c \u201cHocExcel\u201d<\/p>\n<p><strong>C\u00e1ch 1: S\u1eed d\u1ee5ng d\u1ea5u &amp;<\/strong> ta c\u00f3:<\/p>\n<p style=\"padding-left: 30px\">E3=A3&amp;D3<\/p>\n<p><strong>C\u00e1ch 2: S\u1eed d\u1ee5ng h\u00e0m Concatenate<\/strong> ta c\u00f3:<\/p>\n<p style=\"padding-left: 30px\">E3=Concatenate(A3,D3)<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chen_them_ky_tu_vao_giua_cua_chuoi_ky_tu\"><\/span>Ch\u00e8n th\u00eam k\u00fd t\u1ef1\u00a0v\u00e0o gi\u1eefa c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24468\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/yeu-cau-them-ky-tu-o-giua.png\" width=\"443\" height=\"177\" title=\"yeu-cau-them-ky-tu-o-giua\"><\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta mu\u1ed1n th\u00eam t\u1eeb \u201cHocExcel\u201d v\u00e0o gi\u1eefa k\u00fd t\u1ef1 \u201cBlog.online\u201d v\u00e0 c\u1ea7n th\u00eam d\u1ea5u ch\u1ea5m\u00a0\u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 Blog.HocExcel.online th\u00ec l\u00e0m th\u1ebf n\u00e0o?<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xac_dinh_vi_tri_bat_dau_chen_ky_tu_moi\"><\/span>X\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed b\u1eaft\u00a0\u0111\u1ea7u ch\u00e8n k\u00fd t\u1ef1 m\u1edbi<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta c\u1ea7n c\u00f3 1 c\u0103n c\u1ee9\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh k\u00fd t\u1ef1 m\u1edbi s\u1ebd\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1eb7t v\u00e0o\u00a0\u0111\u00e2u trong chu\u1ed7i k\u00fd t\u1ef1 g\u1ed1c. V\u00ed d\u1ee5 nh\u01b0 sau d\u1ea5u ch\u1ea5m, ho\u1eb7c sau k\u00fd t\u1ef1 th\u1ee9 5.<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta l\u1ea5y d\u1ea5u ch\u1ea5m l\u00e0m c\u0103n c\u1ee9. V\u00ec v\u1eady c\u1ea7n x\u00e1c\u00a0\u0111\u1ecbnh xem d\u1ea5u ch\u1ea5m n\u1eb1m\u00a0\u1edf v\u1ecb tr\u00ed th\u1ee9 m\u1ea5y trong\u00a0\u0111o\u1ea1n k\u00fd t\u1ef1 g\u1ed1c.\u00a0\u0110\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y ch\u00fang ta d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-find-va-search-voi-cac-cong-thuc-vi-du.html\">h\u00e0m Search<\/a> nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=SEARCH(\u201c.\u201d,A4)<\/p>\n<p>K\u1ebft qu\u1ea3 =5. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 d\u1ea5u ch\u1ea5m n\u1eb1m\u00a0\u1edf v\u1ecb tr\u00ed k\u00fd t\u1ef1 th\u1ee9 5 trong chu\u1ed7i k\u00fd t\u1ef1\u00a0\u1edf\u00a0\u00f4 A4<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 h\u00ecnh dung:\u00a0\u0110o\u1ea1n k\u00fd t\u1ef1 g\u1ed1c s\u1ebd b\u1ecb c\u1eaft l\u00e0m 2 ph\u1ea7n. V\u1ecb tr\u00ed c\u1eaft l\u00e0 v\u1ecb tr\u00ed k\u00fd t\u1ef1 th\u1ee9 5.\u00a0\u0110o\u1ea1n k\u00fd t\u1ef1 c\u1ea7n ch\u00e8n th\u00eam v\u00e0o s\u1ebd\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1eb7t v\u00e0o gi\u1eefa, sau\u00a0\u0111\u00f3 n\u1ed1i l\u1ea1i to\u00e0n b\u1ed9 c\u00e1c ph\u1ea7n\u00a0\u0111\u1ec3 ra chu\u1ed7i k\u00fd t\u1ef1 m\u1edbi.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ky_thuat_chen_va_noi_chuoi\"><\/span>K\u1ef9 thu\u1eadt ch\u00e8n v\u00e0 n\u1ed1i chu\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ph\u1ea7n b\u00ean tr\u00e1i c\u1ee7a k\u00fd t\u1ef1 g\u1ed1c\u00a0\u0111\u01b0\u1ee3c l\u1ea5y b\u1edfi h\u00e0m LEFT nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=LEFT(A4,SEARCH(\u201c.\u201d,A4))<\/p>\n<p style=\"padding-left: 30px\">\u00dd ngh\u0129a: l\u1ea5y ph\u1ea7n b\u00ean tr\u00e1i c\u1ee7a A4, theo s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y l\u00e0 \u0111\u1ebfn k\u00fd t\u1ef1 d\u1ea5u ch\u1ea5m trong\u00a0\u0111o\u1ea1n text \u1edf\u00a0\u00f4 A4<\/p>\n<p>Ph\u1ea7n c\u00f2n l\u1ea1i c\u1ee7a\u00a0\u0111o\u1ea1n k\u00fd t\u1ef1 g\u1ed1c\u00a0\u0111\u01b0\u1ee3c l\u1ea5y b\u1edfi h\u00e0m RIGHT nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=RIGHT(A4,LEN(A4)-SEARCH(\u201c.\u201d,A4))<\/p>\n<p style=\"padding-left: 30px\">\u00dd ngh\u0129a: L\u1ea5y ph\u1ea7n b\u00ean ph\u1ea3i c\u1ee7a A4, theo s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y l\u00e0 T\u1ed5ng to\u00e0n b\u1ed9 s\u1ed1 k\u00fd t\u1ef1 tr\u1eeb\u00a0\u0111i ph\u1ea7n k\u00fd t\u1ef1 b\u00ean tr\u00e1i\u00a0\u0111\u00e3 l\u1ea5y\u00a0\u1edf tr\u00ean.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24469\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-tach-ky-tu-ben-trai-ben-phai.png\" width=\"736\" height=\"64\" title=\"ket-qua-tach-ky-tu-ben-trai-ben-phai\"><\/p>\n<p>\u0110o\u1ea1n text c\u1ea7n th\u00eam v\u00e0o gi\u1eefa l\u00e0\u00a0\u00f4 F4 v\u00e0 d\u1ea5u ch\u1ea5m. V\u00ec v\u1eady ta c\u00f3 =F4&amp;\u201d.\u201d<\/p>\n<p>T\u1ed5ng h\u1ee3p to\u00e0n b\u1ed9 c\u00e1c n\u1ed9i dung tr\u00ean ta c\u00f3 c\u00f4ng th\u1ee9c sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24470\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-chen-ky-tu-vao-giua.png\" width=\"643\" height=\"237\" title=\"ket-qua-chen-ky-tu-vao-giua\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Vi\u1ec7c ch\u00e8n k\u00fd t\u1ef1 v\u00e0o 1 chu\u1ed7i k\u00fd t\u1ef1 g\u1ed1c\u00a0\u0111\u00f2i h\u1ecfi ch\u00fang ta ph\u1ea3i n\u1eafm\u00a0\u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 h\u00e0m li\u00ean quan\u00a0\u0111\u1ebfn d\u1eef li\u1ec7u d\u1ea1ng text nh\u01b0: H\u00e0m n\u1ed1i chu\u1ed7i, h\u00e0m Left, Mid, right, h\u00e0m d\u00f2 t\u00ecm k\u00fd t\u1ef1 nh\u01b0 Search\u2026\u00a0\u0110\u00e2y\u00a0\u0111\u1ec1u l\u00e0 nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n hay s\u1eed d\u1ee5ng trong\u00a0Excel.<\/p>\n<p>C\u1ea7n n\u1eafm v\u1eefng k\u1ef9 thu\u1eadt t\u00e1ch c\u00e1c ph\u1ea7n k\u00fd t\u1ef1 trong 1\u00a0\u0111o\u1ea1n text\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 ch\u00e8n\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1ee5ng\u00a0\u0111o\u1ea1n text m\u1edbi v\u00e0o v\u1ecb tr\u00ed mong mu\u1ed1n.<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-466.gif\" title=\"ex101_92019-nho-466\"><br \/>\n<\/a><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/lam-the-nao-de-tach-chuoi-van-ban-trong-excel-theo-dau-phay-khoang-trang-ky-tu-xac-dinh.html\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00e1ch chu\u1ed7i v\u0103n b\u1ea3n trong Excel theo d\u1ea5u ph\u1ea9y, kho\u1ea3ng tr\u1eafng, k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-loc-bo-ky-tu-o-dau-o-giua-o-cuoi-trong-doan-van-ban.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc b\u1ecf k\u00fd t\u1ef1 \u1edf \u0111\u1ea7u, \u1edf gi\u1eefa, \u1edf cu\u1ed1i trong \u0111o\u1ea1n v\u0103n b\u1ea3n<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-left-right-va-cach-su-dung-ham-left-right-trong-excel.html\">H\u00e0m LEFT, RIGHT v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT, RIGHT trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-ham-ghep-chuoi-chu-theo-o-vung-hoac-theo-nhieu-dieu-kien-voi-jointext-joinif-joinifs.html\">C\u00e1ch d\u00f9ng h\u00e0m gh\u00e9p chu\u1ed7i, n\u1ed1i ch\u1eef theo \u00f4, v\u00f9ng ho\u1eb7c theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-466.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5396,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5395","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5395","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=5395"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5395\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5396"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}