{"id":11605,"date":"2023-11-23T10:06:09","date_gmt":"2023-11-23T03:06:09","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11605"},"modified":"2023-11-23T16:05:45","modified_gmt":"2023-11-23T09:05:45","slug":"ham-noi-ky-tu-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t"},"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;11605&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;3&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 - (3 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t&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 - (3 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p>H\u00e0m n\u1ed1i k\u00fd t\u1ef1 hay c\u00f2n c\u00f3 t\u00ean kh\u00e1c l\u00e0 h\u00e0m Concatenate l\u00e0 m\u1ed9t trong c\u00e1c h\u00e0m ph\u1ed5 bi\u1ebfn. H\u00e0m n\u00e0y s\u1ebd gi\u00fap n\u1ed1i c\u00e1c chu\u1ed7i k\u00fd t\u1ef1 \u1edf nhi\u1ec1u \u00f4 v\u00e0o c\u00f9ng v\u1edbi nhau. Qua \u0111\u00f3 gi\u00fap t\u1ed5ng h\u1ee3p v\u00e0 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c r\u00f5 r\u00e0ng h\u01a1n. Nh\u01b0ng c\u00f3 l\u1ebd nhi\u1ec1u ng\u01b0\u1eddi v\u1eabn ch\u01b0a bi\u1ebft c\u00e1ch \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel. V\u1eady th\u00ec h\u00e3y c\u00f9ng Teky.edu.vn theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 bi\u1ebft c\u00e1ch nh\u00e9.<\/p>\n<p><!--more--><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#Khai_niem_ham_noi_chuoi_ky_tu_trong_Excel\" >Kh\u00e1i ni\u1ec7m h\u00e0m n\u1ed1i chu\u1ed7i k\u00fd t\u1ef1 trong Excel<\/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\/ham-noi-ky-tu-trong-excel\/#Mot_luu_y_khi_su_dung_cu_phap_nay\" >M\u1ed9t l\u01b0u \u00fd khi s\u1eed d\u1ee5ng c\u00fa ph\u00e1p n\u00e0y<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#Cac_vi_du_cu_the_cua_ham_noi_ky_tu_trong_Excel\" >C\u00e1c v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 c\u1ee7a h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#Noi_tu_hoac_them_ky_tu\" >N\u1ed1i t\u1eeb ho\u1eb7c th\u00eam k\u00fd t\u1ef1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#Noi_du_lieu_cua_hai_hay_nhieu_cot_lai_voi_nhau\" >N\u1ed1i d\u1eef li\u1ec7u c\u1ee7a hai hay nhi\u1ec1u c\u1ed9t l\u1ea1i v\u1edbi nhau<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#Noi_du_lieu_trong_cung_mot_mang\" >N\u1ed1i d\u1eef li\u1ec7u trong c\u00f9ng m\u1ed9t m\u1ea3ng<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#Cach_dau_tien\" >C\u00e1ch \u0111\u1ea7u ti\u00ean<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#Cach_thu_2\" >C\u00e1ch th\u1ee9 2<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#De_su_dung_thi_can_thuc_hien_cac_thao_tac_nhu_sau\" >\u0110\u1ec3 s\u1eed d\u1ee5ng th\u00ec c\u1ea7n th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c nh\u01b0 sau<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Khai_niem_ham_noi_chuoi_ky_tu_trong_Excel\"><\/span><b>Kh\u00e1i ni\u1ec7m h\u00e0m n\u1ed1i chu\u1ed7i k\u00fd t\u1ef1 trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong <a href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/excel\" rel=\"nofollow noreferrer\">Excel<\/a> hay c\u00f2n g\u1ecdi l\u00e0 h\u00e0m Concatenate l\u00e0 m\u1ed9t h\u00e0m gi\u00fap n\u1ed1i c\u00e1c chu\u1ed7i k\u00fd\u00a0<\/span><\/p>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">t\u1ef1 l\u1ea1i v\u1edbi nhanh. \u0110\u00e2y c\u0169ng l\u00e0 m\u1ed9t h\u00e0m trong v\u0103n b\u1ea3n c\u00f3 ch\u1ee9c n\u0103ng n\u1ed1i c\u00e1c \u0111o\u1ea1n v\u0103n kh\u00e1c nhau l\u1ea1i c\u00f9ng m\u1ed9t \u00f4.\u00a0<\/span><\/p>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m n\u00e0y s\u1ebd c\u00f3 c\u00fa ph\u00e1p c\u1ee5 th\u1ec3 nh\u01b0 sau: <strong>= CONCATENATE(text1, text2,\u2026)<\/strong><\/span><\/p>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3 c\u1ee5 th\u1ec3 c\u1ee7a c\u00fa ph\u00e1p n\u00e0y l\u00e0 text 1 v\u00e0 text 2 l\u00e0 chu\u1ed7i c\u00e1c v\u0103n b\u1ea3n, c\u00e1c \u00f4 tham chi\u1ebfu ho\u1eb7c c\u00e1c c\u00f4ng th\u1ee9c.<\/span><\/p>\n<h3 style=\"font-weight: 400;\"><span class=\"ez-toc-section\" id=\"Mot_luu_y_khi_su_dung_cu_phap_nay\"><\/span><span style=\"font-weight: 400;\">M\u1ed9t l\u01b0u \u00fd khi s\u1eed d\u1ee5ng c\u00fa ph\u00e1p n\u00e0y<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><span style=\"font-weight: 400;\">B\u1ea1n ph\u1ea3i d\u00f9ng d\u1ea5u ph\u1ea9y \u0111\u1ec3 ng\u0103n c\u00e1ch gi\u1eefa c\u00e1c text1 v\u00e0 text2, \u2026<\/span><\/li>\n<li><span style=\"font-weight: 400;\">V\u1edbi c\u00e1c \u0111\u1ed1i s\u1ed1 text th\u00ec c\u1ea7n th\u00eam d\u1ea5u ngo\u1eb7c ho\u1eb7c k\u00e9p v\u00e0o \u0111\u1ea7u ho\u1eb7c cu\u1ed1i c\u00e1c chu\u1ed7i k\u00fd t\u1ef1. N\u1ebfu b\u1ea1n kh\u00f4ng th\u00eam c\u00e1c d\u1ea5u th\u00ec m\u00e1y s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #NAME?.<\/span><\/li>\n<li>V\u1edbi h\u00e0m n\u00e0y th\u00ec m\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u1ec3 gh\u00e9p n\u1ed1i t\u1ed1i \u0111a l\u00e0 255 chu\u1ed7i. Chu\u1ed7i n\u00e0y s\u1ebd t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi 8192 k\u00fd t\u1ef1.<\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m n\u00e0y s\u1ebd lu\u00f4n tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel s\u1ebd kh\u00f4ng nh\u1eadn bi\u1ebft c\u00e1c m\u1ea3ng. Ch\u00ednh v\u00ec th\u1ebf m\u00e0 b\u1ea1n c\u1ea7n li\u1ec7t k\u00ea c\u00e1c \u0111\u1ed1i s\u1ed1 ri\u00eang. \u0110\u1ed3ng th\u1eddi ph\u1ea3i ph\u00e2n c\u00e1ch b\u1eb1ng d\u1ea5u ph\u1ea9y.<\/span><\/li>\n<\/ul>\n<p>&gt;&gt;&gt; Xem th\u00eam : <a href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-lam-tron-trong-excel-chi-tiet\/\"><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot; H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u00e0m tr\u00f2n trong Excel chi ti\u1ebft&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:12706,&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:12829895}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;10&quot;:2,&quot;11&quot;:4,&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:11}\"> H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u00e0m tr\u00f2n trong Excel chi ti\u1ebft<\/span><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cac_vi_du_cu_the_cua_ham_noi_ky_tu_trong_Excel\"><\/span><b>C\u00e1c v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 c\u1ee7a h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u h\u01a1n v\u1ec1 h\u00e0m n\u00e0y c\u0169ng nh\u01b0 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng. Sau \u0111\u00e2y ch\u00fang t\u00f4i xin chia s\u1ebb m\u1ed9t s\u1ed1 v\u00ed d\u1ee5.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Noi_tu_hoac_them_ky_tu\"><\/span><b>N\u1ed1i t\u1eeb ho\u1eb7c th\u00eam k\u00fd t\u1ef1<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00e1c v\u00ed d\u1ee5 v\u1ec1 n\u1ed1i t\u1eeb n\u00e0y nh\u01b0:<\/span><\/p>\n<ul style=\"font-weight: 400;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u00e8n th\u00eam k\u00fd t\u1ef1 ho\u1eb7c t\u1eeb<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00f9ng k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m text \u0111\u1ec3 ch\u00e8n ng\u00e0y th\u00e1ng v\u00e0o chu\u1ed7i.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Th\u00eam kho\u1ea3ng tr\u1eafng gi\u1eefa h\u1ecd v\u00e0 t\u00ean<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ed1i c\u00e1c s\u1ed1 v\u00e0o chu\u1ed7i k\u00fd t\u1ef1 c\u00f3 s\u1eb5n<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_11606\" aria-describedby=\"caption-attachment-11606\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11606 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-1.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11606\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<p>&gt;&gt;&gt; Xem th\u00eam : <a href=\"https:\/\/teky.edu.vn\/blog\/ham-vlookup-trong-excel\/\"><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot; H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:12706,&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16185335},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:12829895}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;10&quot;:2,&quot;11&quot;:4,&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:11}\"> H\u00e0m Vlookup trong Excel l\u00e0 g\u00ec? 4 th\u00e0nh ph\u1ea7n h\u00e0m ch\u00ednh<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Noi_du_lieu_cua_hai_hay_nhieu_cot_lai_voi_nhau\"><\/span><b>N\u1ed1i d\u1eef li\u1ec7u c\u1ee7a hai hay nhi\u1ec1u c\u1ed9t l\u1ea1i v\u1edbi nhau<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u00e2y c\u0169ng l\u00e0m m\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn c\u1ee7a h\u00e0m n\u1ed1i c\u00e1c chu\u1ed7i k\u00fd t\u1ef1 trong Excel. \u0110\u1ec3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7u n\u1ed1i d\u1eef li\u1ec7u c\u1ee7a nhi\u1ec1u c\u1ed9t l\u1ea1i v\u1edbi nhau. M\u1ecdi ng\u01b0\u1eddi h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c t\u1eeb \u00f4 \u0111\u1ea7u ti\u00ean m\u00e0 b\u1ea1n mu\u1ed1n gi\u1eef l\u1ea1i d\u1eef li\u1ec7u. V\u00ed d\u1ee5 b\u1ea1n mu\u1ed1n n\u1ed1i d\u1eef li\u1ec7u gi\u1eefa c\u1ed9t H\u1ecd v\u00e0 c\u1ed9t T\u00ean l\u1ea1i \u0111\u1ec3 \u0111\u01b0\u1ee3c c\u1ed9t H\u1ecd v\u00e0 t\u00ean, gi\u1eefa h\u1ecd v\u00e0 t\u00ean c\u1ea7n m\u1ed9t kho\u1ea3ng tr\u1eafng \u0111\u1ec3 ph\u00e2n c\u00e1ch t\u1eeb.\u00a0<\/span><\/p>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n s\u1ebd ti\u1ebfn h\u00e0nh l\u00e0m nh\u01b0 sau. \u1ede \u00f4 C2 th\u00ec b\u1ea1n s\u1ebd nh\u1eadp =CONCATENATE(A2,&#8221; &#8220;,B2). Ho\u1eb7c b\u1ea1n s\u1ebd ti\u1ebfn h\u00e0nh nh\u1eadp =A2&amp;&#8221; &#8220;&amp;B2.<\/span><\/p>\n<figure id=\"attachment_11607\" aria-describedby=\"caption-attachment-11607\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11607 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-1.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11607\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<figure id=\"attachment_11608\" aria-describedby=\"caption-attachment-11608\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11608 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-3-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11608\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sau khi \u0111\u00e3 nh\u1eadp nh\u01b0 v\u00ed d\u1ee5 tr\u00ean b\u1ea1n s\u1ebd nh\u1ea5n Enter. Ti\u1ebfp \u0111\u1ebfn b\u1ea1n s\u1ebd th\u1ef1c hi\u1ec7n thao t\u00e1c l\u00e0 sao ch\u00e9p c\u00e1c c\u00f4ng th\u1ee9c. B\u1ea1n s\u1ebd th\u1ef1c hi\u1ec7n \u0111\u1eb7t tr\u1ecf chu\u1ed9t v\u00e0o g\u00f3c d\u01b0\u1edbi \u1edf ph\u00eda b\u00ean ph\u1ea3i \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c ch\u1ecdn v\u00e0 k\u00e9o th\u1ea3 chu\u1ed9t xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i trong c\u1ed9t.<\/span><\/p>\n<p>&gt;&gt;&gt; Xem th\u00eam <a href=\"https:\/\/teky.edu.vn\/blog\/excel-co-ban-van-phong\/\">: <span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot; Excel c\u01a1 b\u1ea3n v\u0103n ph\u00f2ng l\u00e0 g\u00ec \u2013 5 th\u1ee7 thu\u1eadt b\u1ea1n c\u1ea7n bi\u1ebft&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:12706,&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:12829895}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;10&quot;:2,&quot;11&quot;:4,&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:11}\"> Excel c\u01a1 b\u1ea3n v\u0103n ph\u00f2ng l\u00e0 g\u00ec \u2013 5 th\u1ee7 thu\u1eadt b\u1ea1n c\u1ea7n bi\u1ebft<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Noi_du_lieu_trong_cung_mot_mang\"><\/span><b>N\u1ed1i d\u1eef li\u1ec7u trong c\u00f9ng m\u1ed9t m\u1ea3ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 n\u1ed1i d\u1eef li\u1ec7u trong c\u00f9ng m\u1ed9t m\u1ea3ng th\u00ec b\u1ea1n s\u1ebd l\u00e0m v\u1edbi c\u00e1c c\u00e1ch nh\u01b0 sau:<\/span><\/p>\n<h4 style=\"font-weight: 400;\"><span class=\"ez-toc-section\" id=\"Cach_dau_tien\"><\/span><b>C\u00e1ch \u0111\u1ea7u ti\u00ean<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Li\u1ec7t k\u00ea ho\u1eb7c ch\u1ecdn t\u1eebng \u0111\u1ed1i s\u1ed1 text<\/span><\/p>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u1edbi c\u00e1ch n\u00e0y th\u00ec \u0111\u1ea7u ti\u00ean b\u1ea1n s\u1ebd nh\u1eadp c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m n\u1ed1i k\u00fd t\u1ef1. Ti\u1ebfp \u0111\u1ebfn \u1edf m\u1ee5c li\u1ec7t k\u00ea th\u00ec b\u1ea1n b\u1ea1n c\u1ea7n nh\u1ea5n v\u00e0 gi\u1eef k\u00e8m ph\u00edm Ctrl. Sau \u0111\u00f3 c\u1ea7n nh\u1ea5p v\u00e0o t\u1eebng \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n gh\u00e9p l\u1ea1i. Khi \u0111\u00e3 ch\u1ecdn h\u1ebft th\u00ec b\u1ea1n th\u1ea3 ph\u00edm Ctrl v\u00e0 \u0111\u00f3ng ngo\u1eb7c c\u1ee7a c\u00f4ng th\u1ee9c.<\/span><\/p>\n<figure id=\"attachment_11609\" aria-describedby=\"caption-attachment-11609\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11609 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-2.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-2.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-2-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-2-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11609\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<h4 style=\"font-weight: 400;\"><span class=\"ez-toc-section\" id=\"Cach_thu_2\"><\/span><b>C\u00e1ch th\u1ee9 2<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"> S\u1eed d\u1ee5ng h\u00e0m TRANSPOSE k\u1ebft h\u1ee3p c\u00f9ng ph\u00edm F9 \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i. Sau \u0111\u00f3 s\u1ebd l\u1ea5y k\u1ebft qu\u1ea3 v\u00e0 \u0111\u01b0a v\u00e0o h\u00e0m CONCATENATE.<\/span><\/p>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u01b0u \u00fd cho ph\u1ea7n n\u00e0y l\u00e0 c\u00e1ch h\u01b0\u1edbng d\u1eabn nh\u01b0 tr\u00ean ch\u1ec9 \u00e1p d\u1ee5ng cho m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p c\u00e1c \u00f4 ch\u1ee9a chu\u1ed7i. v\u00e0 b\u1ea1n c\u1ea7n ph\u1ea3i n\u1ed1i \u0111\u1ec3 x\u1ebfp th\u00e0nh m\u1ed9t c\u1ed9t d\u1ecdc theo nh\u01b0 th\u1ee9 t\u1ef1.<\/span><\/p>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi h\u00e0m <strong>TRANSPOSE<\/strong> th\u00ec s\u1ebd c\u00f3 t\u00e1c d\u1ee5ng l\u00e0 chuy\u1ec3n \u0111\u1ed5i h\u00e0ng th\u00e0nh c\u1ed9t ho\u1eb7c c\u00f3 th\u1ec3 ng\u01b0\u1ee3c l\u1ea1i. \u0110\u1ec3 s\u1eed d\u1ee5ng th\u00ec b\u1ea1n c\u1ea7n ph\u1ea3i d\u00f9ng h\u00e0m n\u00e0y \u0111\u1ec3 l\u1ea5y c\u00f4ng th\u1ee9c m\u1ea3ng. Ti\u1ebfp \u0111\u1ebfn b\u1ea1n h\u00e3y d\u00f9ng ph\u00edm F9 sau \u0111\u00f3 d\u00f9ng th\u00eam ph\u00edm F9 \u0111\u1ec3 thay th\u1ebf c\u00f4ng th\u1ee9c v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n v\u00e0 cu\u1ed1i c\u00f9ng d\u00f9ng CONCATENATE x\u00e2u chu\u1ed7i l\u1ea1i. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m TRANSPOSE: <strong>=TRANSPOSE(array)<\/strong> v\u1edbi array l\u00e0 m\u1ea3ng ch\u1ee9a chu\u1ed7i c\u1ea7n n\u1ed1i.<\/span><\/p>\n<h4 style=\"font-weight: 400;\"><span class=\"ez-toc-section\" id=\"De_su_dung_thi_can_thuc_hien_cac_thao_tac_nhu_sau\"><\/span><span style=\"font-weight: 400;\">\u0110\u1ec3 s\u1eed d\u1ee5ng th\u00ec c\u1ea7n th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c nh\u01b0 sau<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"font-weight: 400;\"><b>B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean:<\/b><span style=\"font-weight: 400;\"> B\u1ea1n c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c l\u00e0 =TRANSPOSE(B1:B3). Sau khi nh\u1eadp xong th\u00ec nh\u1ea5n F9. Nh\u1ea5n nh\u01b0 th\u1ebf n\u00e0y \u0111\u1ec3 c\u00f3 c\u00f4ng th\u1ee9c v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n.<\/span><\/p>\n<figure id=\"attachment_11610\" aria-describedby=\"caption-attachment-11610\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11610 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-3.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m transpose\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-3.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-3-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-3-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11610\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m transpose<\/figcaption><\/figure>\n<p style=\"font-weight: 400;\"><b>B\u01b0\u1edbc ti\u1ebfp theo: <\/b><span style=\"font-weight: 400;\">B\u1ea1n s\u1ebd nh\u1eadn F9 v\u00e0 s\u1ebd th\u1ea5y h\u00e0m TRANSPOSE s\u1ebd kh\u00f4ng c\u00f2n. Thay v\u00e0o \u0111\u00f3 l\u00e0 chu\u1ed7i c\u00e1c k\u00fd t\u1ef1 hi\u1ec3n th\u1ecb t\u1ea1i c\u00e1c \u00f4 trong m\u1ea3ng \u0111\u01b0\u1ee3c ch\u1ecdn, ph\u00e2n c\u00e1ch nhau b\u1edfi d\u1ea5u ph\u1ea9y v\u00e0 \u0111\u01b0\u1ee3c b\u1ecdc b\u1edfi d\u1ea5u ngo\u1eb7c nh\u1ecdn. Ti\u1ebfp \u0111\u1ebfn m\u1ecdi ng\u01b0\u1eddi c\u1ea7n ti\u1ebfn h\u00e0nh lo\u1ea1i b\u1ecf d\u1ea5u ngo\u1eb7c nh\u1ecdn \u0111\u1ec3 c\u00f3 th\u1ec3 th\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb ch\u1ee9a trong c\u00e1c \u00f4 mu\u1ed1n n\u1ed1i th\u00e0nh chu\u1ed7i.<\/span><\/p>\n<figure id=\"attachment_11611\" aria-describedby=\"caption-attachment-11611\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11611 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-2.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-2.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-2-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-2-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11611\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"font-weight: 400;\"><b>B\u01b0\u1edbc cu\u1ed1i c\u00f9ng: <\/b><span style=\"font-weight: 400;\">C\u00e1c gi\u00e1 tr\u1ecb thu \u0111\u01b0\u1ee3c sau khi th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c tr\u00ean s\u1ebd tr\u1edf th\u00e0nh c\u00e1c \u0111\u1ed1i s\u1ed1 text c\u1ee7a CONCATENATE.\u00a0<\/span><\/p>\n<figure id=\"attachment_11612\" aria-describedby=\"caption-attachment-11612\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11612 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-1.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11612\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u00fac n\u00e0y, b\u1ea1n \u0111\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o \u0111\u1ea7u c\u00f4ng th\u1ee9c, tr\u01b0\u1edbc c\u00e1c gi\u00e1 tr\u1ecb v\u00e0 ti\u1ebfn h\u00e0nh nh\u1eadp t\u00ean h\u00e0m CONCATENATE \u0111\u1ec3 \u00e1p d\u1ee5ng h\u00e0m n\u00e0y n\u1ed1i chu\u1ed7i nh\u01b0 b\u00ecnh th\u01b0\u1eddng. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c \u0111\u1ec3 th\u00eam, b\u1edbt c\u00e1c k\u00fd t\u1ef1 nh\u1eb1m \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ee5c \u0111\u00edch hi\u1ec3n th\u1ecb nh\u01b0 mong mu\u1ed1n.<\/span><\/p>\n<p style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u1eeba r\u1ed3i l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel. V\u1edbi nh\u1eefng chia s\u1ebb tr\u00ean, Teky.edu.vn hy v\u1ecdng \u0111\u00e3 gi\u00fap m\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u1ec3 hi\u1ec3u h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y. v\u00e0 \u0111\u1ec3 bi\u1ebft th\u00eam c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a c\u00e1c h\u00e0m kh\u00e1c trong Excel. M\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft t\u1ea1i website. Ho\u1eb7c c\u00f3 b\u1ea5t k\u1ef3 th\u1eafc m\u1eafc n\u00e0o, m\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u1ec3 \u0111\u1ec3 l\u1ea1i b\u00ecnh lu\u1eadn \u0111\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i \u0111\u00e1p.<\/span><\/p>\n<p>Tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c.<\/p>\n<ul>\n<li>\n<p class=\"c-detail-head__title\"><a href=\"https:\/\/teky.edu.vn\/blog\/cach-hien-sheet-trong-excel-thuc-hien-nhu-the-nao-xem-ngay\/\">C\u00e1ch hi\u1ec7n sheet trong excel th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o- [Xem ngay]<\/a><\/p>\n<\/li>\n<li>\n<p class=\"c-detail-head__title\"><a href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-cac-phim-tat-chuyen-sheet-trong-excel-don-gian-nhat\/\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng c\u00e1c ph\u00edm t\u1eaft chuy\u1ec3n sheet trong excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/p>\n<\/li>\n<li><a href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-month-trong-excel-don-gian-va-de-hieu-nhat\/\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m month trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m n\u1ed1i k\u00fd t\u1ef1 hay c\u00f2n c\u00f3 t\u00ean kh\u00e1c l\u00e0 h\u00e0m Concatenate l\u00e0 m\u1ed9t trong c\u00e1c h\u00e0m ph\u1ed5 bi\u1ebfn. H\u00e0m n\u00e0y s\u1ebd gi\u00fap n\u1ed1i c\u00e1c chu\u1ed7i k\u00fd t\u1ef1 \u1edf nhi\u1ec1u \u00f4 v\u00e0o c\u00f9ng v\u1edbi nhau. Qua \u0111\u00f3 gi\u00fap t\u1ed5ng h\u1ee3p v\u00e0 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c r\u00f5 r\u00e0ng h\u01a1n. Nh\u01b0ng c\u00f3 l\u1ebd nhi\u1ec1u ng\u01b0\u1eddi v\u1eabn &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11614,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[2,173],"tags":[],"class_list":["post-11605","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-cong-nghe","category-excel"],"acf":{"show_on_app":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"B\u1ea1n \u0111\u00e3 bi\u1ebft h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong excel ch\u01b0a? N\u1ebfu ch\u01b0a h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n nhanh nh\u1ea5t nh\u00e9.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"B\u1ea1n \u0111\u00e3 bi\u1ebft h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong excel ch\u01b0a? N\u1ebfu ch\u01b0a h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n nhanh nh\u1ea5t nh\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-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=\"2023-11-23T03:06:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-23T09:05:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-su-dung-ham-noi-ky-tu-trong-Excel-chi-tiet-nhat.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"9 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t\",\"datePublished\":\"2023-11-23T03:06:09+00:00\",\"dateModified\":\"2023-11-23T09:05:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\"},\"wordCount\":2004,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-su-dung-ham-noi-ky-tu-trong-Excel-chi-tiet-nhat.png\",\"articleSection\":[\"C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt\",\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-su-dung-ham-noi-ky-tu-trong-Excel-chi-tiet-nhat.png\",\"datePublished\":\"2023-11-23T03:06:09+00:00\",\"dateModified\":\"2023-11-23T09:05:45+00:00\",\"description\":\"B\u1ea1n \u0111\u00e3 bi\u1ebft h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong excel ch\u01b0a? N\u1ebfu ch\u01b0a h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n nhanh nh\u1ea5t nh\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-su-dung-ham-noi-ky-tu-trong-Excel-chi-tiet-nhat.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-su-dung-ham-noi-ky-tu-trong-Excel-chi-tiet-nhat.png\",\"width\":600,\"height\":400,\"caption\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-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\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t\"}]},{\"@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":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t","description":"B\u1ea1n \u0111\u00e3 bi\u1ebft h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong excel ch\u01b0a? N\u1ebfu ch\u01b0a h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n nhanh nh\u1ea5t nh\u00e9.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t","og_description":"B\u1ea1n \u0111\u00e3 bi\u1ebft h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong excel ch\u01b0a? N\u1ebfu ch\u01b0a h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n nhanh nh\u1ea5t nh\u00e9.","og_url":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-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":"2023-11-23T03:06:09+00:00","article_modified_time":"2023-11-23T09:05:45+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-su-dung-ham-noi-ky-tu-trong-Excel-chi-tiet-nhat.png","type":"image\/png"}],"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":"9 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t","datePublished":"2023-11-23T03:06:09+00:00","dateModified":"2023-11-23T09:05:45+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/"},"wordCount":2004,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-su-dung-ham-noi-ky-tu-trong-Excel-chi-tiet-nhat.png","articleSection":["C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt","T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/","name":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-su-dung-ham-noi-ky-tu-trong-Excel-chi-tiet-nhat.png","datePublished":"2023-11-23T03:06:09+00:00","dateModified":"2023-11-23T09:05:45+00:00","description":"B\u1ea1n \u0111\u00e3 bi\u1ebft h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong excel ch\u01b0a? N\u1ebfu ch\u01b0a h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n nhanh nh\u1ea5t nh\u00e9.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-su-dung-ham-noi-ky-tu-trong-Excel-chi-tiet-nhat.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-su-dung-ham-noi-ky-tu-trong-Excel-chi-tiet-nhat.png","width":600,"height":400,"caption":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-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":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t"}]},{"@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\/"}]}},"thumbnail":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Huong-dan-su-dung-ham-noi-ky-tu-trong-Excel-chi-tiet-nhat-400x267.png","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11605","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=11605"}],"version-history":[{"count":2,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11605\/revisions"}],"predecessor-version":[{"id":23656,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11605\/revisions\/23656"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11614"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}