{"id":12125,"date":"2022-11-24T13:34:40","date_gmt":"2022-11-24T06:34:40","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12125"},"modified":"2025-04-15T16:40:07","modified_gmt":"2025-04-15T09:40:07","slug":"ham-viet-hoa-chu-cai-dau-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh 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;12125&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;7&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.4&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;4.4\\\/5 - (7 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t&quot;,&quot;width&quot;:&quot;125.1&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: 125.1px;\">\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            4.4\/5 - (7 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><i><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng <\/span><\/i><b><i>h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/i><\/b><i><span style=\"font-weight: 400;\"> gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ch\u1eef hoa\/th\u01b0\u1eddng trong b\u1ea3ng t\u00ednh nhanh ch\u00f3ng, d\u1ec5 d\u00e0ng nh\u1ea5t.<\/span><\/i><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n \u0111ang thao t\u00e1c v\u0103n b\u1ea3n tr\u00ean Excel? B\u1ea1n c\u1ea7n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng k\u00fd t\u1ef1 ch\u1eef vi\u1ebft hoa trong b\u1ea3ng t\u00ednh? V\u1eady c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng <\/span><b>h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/b><span style=\"font-weight: 400;\"> n\u00e0o? \u0110\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 thay \u0111\u1ed5i ch\u00ednh x\u00e1c nh\u1ea5t? <a href=\"https:\/\/teky.edu.vn\/\">Teky<\/a> s\u1ebd gi\u00fap b\u1ea1n n\u1eafm r\u00f5 v\u1ea5n \u0111\u1ec1 n\u00e0y qua b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00e1ch d\u00f9ng h\u00e0m PROPER - H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/e_WYXoc40cg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<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-viet-hoa-chu-cai-dau-trong-excel\/#Ham_viet_hoa_chu_cai_dau_trong_Excel_duoc_ua_chuong\" >H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#Cong_thuc_cua_ham_viet_hoa_chu_cai_dau_trong_Excel\" >C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#Vi_du_cach_su_dung_ham_viet_hoa_chu_cai_dau_tien_trong_Excel\" >V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean 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-viet-hoa-chu-cai-dau-trong-excel\/#Vi_du_1\" >V\u00ed d\u1ee5 1:<\/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-viet-hoa-chu-cai-dau-trong-excel\/#Vi_du_2\" >V\u00ed d\u1ee5 2:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#Su_dung_ham_viet_hoa_chu_cai_dau_trong_Excel_cho_day_ky_tu_lien_tiep\" >S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel cho d\u00e3y k\u00fd t\u1ef1 li\u00ean ti\u1ebfp<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#Ham_Concatenate_viet_hoa_chu_cai_dau_tien\" >H\u00e0m Concatenate vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#Ket_hop_ham_Upper_ham_Right_va_ham_Len\" >K\u1ebft h\u1ee3p h\u00e0m Upper, h\u00e0m Right v\u00e0 h\u00e0m Len<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#Ket_luan\" >K\u1ebft lu\u1eadn<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_viet_hoa_chu_cai_dau_trong_Excel_duoc_ua_chuong\"><\/span><b>H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">PROPER l\u00e0 <\/span>h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean<span style=\"font-weight: 400;\">\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5t hi\u1ec7n nay. H\u00e0m n\u00e0y c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ti\u1ebfn h\u00e0nh vi\u1ebft hoa ch\u1eef \u0111\u1ea7u ti\u00ean trong chu\u1ed7i v\u0103n b\u1ea3n. Ngo\u00e0i ra, h\u00e0m PROPER c\u00f2n c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n vi\u1ebft hoa b\u1ea5t k\u1ef3 ch\u1eef n\u00e0o khi n\u00f3 n\u1eb1m ngay sau k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t kh\u00f4ng ph\u1ea3i l\u00e0 ch\u1eef. C\u00f9ng v\u1edbi \u0111\u00f3, <\/span><b><i>h\u00e0m vi\u1ebft hoa trong Excel<\/i><\/b><span style=\"font-weight: 400;\"> n\u00e0y c\u00f2n c\u00f3 th\u1ec3 chuy\u1ec3n c\u00e1c ch\u1eef c\u00f2n l\u1ea1i trong b\u1ea3ng t\u00ednh th\u00e0nh ch\u1eef th\u01b0\u1eddng. \u0110\u1ec3 \u0111\u1ea3m b\u1ea3o \u0111\u00fang ch\u00ednh t\u1ea3 khi tr\u00ecnh b\u00e0y.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12126\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-1.jpg\" alt=\"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-1-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cong_thuc_cua_ham_viet_hoa_chu_cai_dau_trong_Excel\"><\/span><b>C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 s\u1eed d\u1ee5ng <\/span><b>h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/b><span style=\"font-weight: 400;\"> \u2013 PROPER. B\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n theo c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=PROPER(text)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Theo \u0111\u00f3, Text ch\u00ednh l\u00e0 v\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ed5i ch\u1eef c\u00e1i \u0111\u1ea7u th\u00e0nh in hoa. N\u00f3 c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t chu\u1ed7i ho\u1eb7c c\u0169ng c\u00f3 th\u1ec3 l\u00e0m tham chi\u1ebfu \u0111\u1ebfn chu\u1ed7i n\u00e0o \u0111\u00f3 c\u1ea7n ph\u1ea3i ti\u1ebfn h\u00e0nh chuy\u1ec3n \u0111\u1ed5i k\u00fd t\u1ef1.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12127\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-2.jpg\" alt=\"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-2-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Vi_du_cach_su_dung_ham_viet_hoa_chu_cai_dau_tien_trong_Excel\"><\/span><b>V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng <\/span><b><i>h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong Excel.<\/i><\/b><span style=\"font-weight: 400;\">\u00a0Teky s\u1ebd \u0111\u01b0a ra m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 ngay d\u01b0\u1edbi \u0111\u00e2y. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o k\u1ef9 \u0111\u1ec3 \u00e1p d\u1ee5ng trong c\u00f4ng vi\u1ec7c, h\u1ecdc t\u1eadp m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Vi_du_1\"><\/span><b><i>V\u00ed d\u1ee5 1<\/i><\/b><span style=\"font-weight: 400;\">:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> Cho 1 b\u1ea3ng d\u1eef li\u1ec7u v\u1edbi c\u00e1c ch\u1eef hoa, th\u01b0\u1eddng h\u1ed7n lo\u1ea1n. B\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m PROPER \u0111\u1ec3 ch\u1ec9nh l\u1ea1i nh\u1eefng ch\u1eef c\u1ea7n vi\u1ebft hoa theo \u00fd mu\u1ed1n. \u0110\u1ec3 th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u n\u00e0y, t\u1ea1i \u00f4 c\u1ea7n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 (B3). B\u1ea1n s\u1ebd nh\u1eadp h\u00e0m v\u00e0o theo c\u00f4ng th\u1ee9c: =PROPER(A3). K\u1ebft th\u00fac b\u1eb1ng c\u00e1ch nh\u1ea5n n\u00fat Enter. Khi \u0111\u00f3, k\u1ebft qu\u1ea3 s\u1ebd chuy\u1ec3n \u0111\u1ed5i t\u1eeb ch\u1eef c\u00e1i th\u01b0\u1eddng l\u00e0 \u201cnguy\u1ec5n th\u1ecb th\u1ea3o\u201d sang ch\u1eef c\u00e1i in hoa k\u00fd t\u1ef1 \u0111\u1ea7u \u0111\u00fang ch\u00ednh t\u1ea3 l\u00e0 \u201cNguy\u1ec5n Th\u1ecb Th\u1ea3o\u201d.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12128\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-3.jpg\" alt=\"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong excel\" width=\"600\" height=\"223\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-3-400x149.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu trong b\u1ea3ng t\u00ednh c\u00f3 nhi\u1ec1u \u00f4 k\u00fd t\u1ef1 hoa\/th\u01b0\u1eddng b\u1ecb l\u1eabn l\u1ed9n th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng sao ch\u00e9p \u0111\u1ec3 chuy\u1ec3n c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c. \u0110i\u1ec1u n\u00e0y gi\u00fap qu\u00e1 tr\u00ecnh vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u \u0111\u01b0\u1ee3c tr\u1edf n\u00ean d\u1ec5 d\u00e0ng, nhanh ch\u00f3ng h\u01a1n.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12129\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-4.jpg\" alt=\"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong excel\" width=\"600\" height=\"147\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-4-400x98.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c, b\u1ea1n s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c b\u1ea3ng t\u00ednh v\u1edbi k\u00fd t\u1ef1 hoa \u0111\u1ea7u ti\u00ean chu\u1ea9n nh\u01b0 h\u00ecnh d\u01b0\u1edbi.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12130\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-5.jpg\" alt=\"\" width=\"600\" height=\"223\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-5-400x149.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Vi_du_2\"><\/span><b><i>V\u00ed d\u1ee5 2<\/i><\/b><i><span style=\"font-weight: 400;\">:<\/span><\/i><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <\/span><b><i>h\u00e0m vi\u1ebft ch\u1eef hoa \u0111\u1ea7u d\u00f2ng trong Excel<\/i><\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 \u00e1p d\u1ee5ng trong tr\u01b0\u1eddng h\u1ee3p c\u1ea7n chuy\u1ec3n \u0111\u1ed5i t\u1eeb ch\u1eef th\u01b0\u1eddng th\u00e0nh ch\u1eef hoa c\u1ee7a m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n. C\u1ee5 th\u1ec3 trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 b\u1ea1n c\u1ea7n chuy\u1ec3n \u0111\u1ed5i \u0111o\u1ea1n &#8220;T\u00f4i mu\u1ed1n h\u1ecdc gi\u1ecfi Excel&#8221;. B\u1ea1n c\u1ea7n ti\u1ebfn h\u00e0nh ch\u1ecdn \u00f4 trong b\u1ea3ng t\u00ednh v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c sau: =PROPER(&#8220;t\u00f4i mu\u1ed1n h\u1ecdc gi\u1ecfi Excel&#8221;).<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12131\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-6.jpg\" alt=\"\" width=\"600\" height=\"206\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-6-400x137.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau \u0111\u00f3, b\u1ea1n nh\u1ea5n n\u00fat Enter, b\u1ea3ng t\u00ednh s\u1ebd hi\u1ec7n l\u00ean k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12132\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-7.jpg\" alt=\"\" width=\"600\" height=\"191\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-7.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-7-400x127.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_viet_hoa_chu_cai_dau_trong_Excel_cho_day_ky_tu_lien_tiep\"><\/span><b>S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel cho d\u00e3y k\u00fd t\u1ef1 li\u00ean ti\u1ebfp<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng <\/span><b>h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong 1 d\u00e3y k\u00fd t\u1ef1 th\u00e0nh ch\u1eef hoa. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed nh\u01b0: trong d\u00e3y k\u00fd t\u1ef1: dienmayxanh.com b\u1ea1n s\u1ebd ph\u1ea3i chuy\u1ec3n ch\u1eef \u201cd\u201d th\u00e0nh ch\u1eef \u201cD\u201d. Hay d\u00e3y k\u00fd t\u1ef1 thegioididong.com b\u1ea1n s\u1ebd c\u1ea7n chuy\u1ec3n ch\u1eef \u2018t\u201d th\u01b0\u1eddng th\u00e0nh ch\u1eef \u201cT\u201d. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, n\u1ebfu ch\u1ec9 s\u1eed d\u1ee5ng h\u00e0m PROPER th\u00ec s\u1ebd kh\u00f4ng th\u1ec3 mang \u0111\u1ebfn k\u1ebft qu\u1ea3 chuy\u1ec3n \u0111\u1ed5i nh\u01b0 mong mu\u1ed1n. B\u1edfi khi \u0111\u00f3, h\u00e0m n\u00e0y s\u1ebd t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n \u0111\u1ed5i k\u00fd t\u1ef1 t\u1eeb th\u01b0\u1eddng sang hoa v\u1edbi c\u00e1c k\u00fd t\u1ef1 n\u00e0o \u0111\u1ee9ng sau 1 k\u00fd t\u1ef1 kh\u00f4ng ph\u1ea3i v\u0103n b\u1ea3n. C\u1ee5 th\u1ec3, k\u1ebft qu\u1ea3 khi \u1ee9ng d\u1ee5ng h\u00e0m PROPER \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i nh\u01b0 sau:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12133\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-8.jpg\" alt=\"\" width=\"600\" height=\"209\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-8-400x139.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_Concatenate_viet_hoa_chu_cai_dau_tien\"><\/span><em>H\u00e0m Concatenate vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean<\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng n\u00e0y, b\u1ea1n c\u1ea7n ph\u1ea3i d\u00f9ng \u0111\u1ebfn m\u1ed9t <\/span><b><i>h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong Excel<\/i><\/b><span style=\"font-weight: 400;\"> kh\u00e1c. \u0110\u00f3 ch\u00ednh l\u00e0 h\u00e0m CONCATENATE. C\u00f9ng v\u1edbi \u0111\u00f3, b\u1ea1n c\u0169ng ph\u1ea3i k\u1ebft h\u1ee3p th\u00eam c\u00e1c h\u00e0m h\u00e0m UPPER, LEN, LEFT v\u00e0 RIGHT kh\u00e1c \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 chuy\u1ec3n \u0111\u1ed5i nh\u01b0 mong mu\u1ed1n.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Theo \u0111\u00f3, c\u00f4ng d\u1ee5ng c\u1ee7a c\u00e1c h\u00e0m c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m CONCATENATE \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 n\u1ed1i t\u1eeb 2 chu\u1ed7i v\u0103n b\u1ea3n tr\u1edf l\u00ean th\u00e0nh 1 chu\u1ed7i. H\u00e0m n\u00e0y khi s\u1eed d\u1ee5ng c\u1ea7n \u00e1p d\u1ee5ng theo c\u00f4ng th\u1ee9c: =CONCATENATE(text1, text2,&#8230;). Theo \u0111\u00f3, text ch\u00ednh l\u00e0 c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n c\u1ea7n n\u1ed1i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m UPPER l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 chuy\u1ec3n ch\u1eef c\u00e1i th\u01b0\u1eddng th\u00e0nh ch\u1eef in hoa trong chu\u1ed7i v\u0103n b\u1ea3n. C\u00fa ph\u00e1p s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y l\u00e0: =UPPER(text).<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/lotrinhlaptrinh.teky.vn\/\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24875\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Sale-Promotion.png\" alt=\"\u01afu \u0111\u00e3i \u0111\u1ebfn 25%\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m LEN \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1ed1 k\u00fd t\u1ef1 \u1edf trong 1 \u00f4. H\u00e0m n\u00e0y s\u1ebd \u0111\u1ebfm v\u00e0 t\u00ednh s\u1ed1 l\u01b0\u1ee3ng \u0111\u1ed1i v\u1edbi c\u1ea3 k\u00fd t\u1ef1 tr\u1ed1ng. C\u00fa ph\u00e1p \u1ee9ng d\u1ee5ng h\u00e0m l\u00e0: =LEN(text).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m LEFT \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 n\u1eb1m ph\u00eda b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n. C\u00fa ph\u00e1p s\u1eed d\u1ee5ng h\u00e0m n\u00e0y s\u1ebd l\u00e0 =LEFT(text;num_chars). Theo \u0111\u00f3, text ch\u00ednh l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n c\u1ea7n c\u1eaft. num_chars ch\u00ednh l\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n c\u1eaft trong chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m RIGHT l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 c\u1eaft \u0111\u1ed1i v\u1edbi k\u00fd t\u1ef1 n\u1eb1m \u1edf ph\u00eda b\u00ean ph\u1ea3i chu\u1ed7i v\u0103n b\u1ea3n. T\u01b0\u01a1ng t\u1ef1 nh\u01b0 l\u00e0m LEFT th\u00ec c\u00fa ph\u00e1p c\u1ee7a h\u00e0m RIGHT s\u1ebd l\u00e0: =RIGHT(text,num_chars).<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ket_hop_ham_Upper_ham_Right_va_ham_Len\"><\/span><em>K\u1ebft h\u1ee3p h\u00e0m Upper, h\u00e0m Right v\u00e0 h\u00e0m Len<\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Quay tr\u1edf l\u1ea1i v\u00ed d\u1ee5 chuy\u1ec3n \u0111\u1ed5i chuy\u1ec3n ch\u1eef \u201cd\u201d th\u00e0nh ch\u1eef \u201cD\u201d trong chu\u1ed7i k\u00fd t\u1ef1 dienmayxanh.com n\u00f3i tr\u00ean, b\u1ea1n s\u1ebd c\u1ea7n d\u00f9ng h\u00e0m CONCATENATE \u0111\u1ec3 t\u00e1ch ch\u1eef \u201cd\u201d ra kh\u1ecfi chu\u1ed7i dienmayxanh.com \u0111\u1ec3 vi\u1ebft hoa n\u00f3 th\u00e0nh \u201cD\u201d. Sau \u0111\u00f3, b\u1ea1n s\u1ebd d\u00f9ng h\u00e0m LEFT \u0111\u1ec3 c\u1eaft c\u00e1c ph\u1ea7n c\u00f2n l\u1ea1i \u1edf ph\u00eda b\u00ean tr\u00e1i v\u00e0 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m UPPER \u0111\u1ec3 chuy\u1ec3n ch\u1eef \u201cd\u201d th\u00e0nh \u201cD\u201d theo c\u00fa ph\u00e1p: text1 = UPPER(LEFT(A2,1)). S\u1eed d\u1ee5ng ti\u1ebfp h\u00e0m RIGHT \u0111\u1ec3 c\u1eaft k\u00fd t\u1ef1 b\u00ean ph\u1ea3i v\u00e0 c\u00f9ng v\u1edbi h\u00e0m LEN \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u00f3 trong \u00f4 A2 theo c\u00fa ph\u00e1p: text2 = RIGHT(A2,LEN(A2)-1).<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12134\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-9.jpg\" alt=\"\" width=\"600\" height=\"182\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-9.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-9-400x121.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Cu\u1ed1i c\u00f9ng, b\u1ea1n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 chuy\u1ec3n \u0111\u1ed5i \u0111\u00fang nh\u01b0 \u00fd mu\u1ed1n: =CONCATENATE(UPPER(LEFT(A2,1)),RIGHT(A2,LEN(A2)-1)).<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c tr\u00ean cho c\u00e1c \u00f4 b\u00ean d\u01b0\u1edbi \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 chuy\u1ec3n \u0111\u1ed5i ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong chu\u1ed7i cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 nh\u01b0 h\u00ecnh sau.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12135\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-10.jpg\" alt=\"\" width=\"600\" height=\"154\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-10.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-10-400x103.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u00f9y theo t\u1eebng tr\u01b0\u1eddng h\u1ee3p m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng <\/span><b>h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/b><span style=\"font-weight: 400;\"> ph\u00f9 h\u1ee3p nh\u01b0 h\u01b0\u1edbng d\u1eabn c\u1ee7a Teky trong b\u00e0i vi\u1ebft tr\u00ean. \u0110i\u1ec1u n\u00e0y s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian, c\u00f4ng s\u1ee9c khi ti\u1ebfn h\u00e0nh chuy\u1ec3n \u0111\u1ed5i k\u00fd t\u1ef1 m\u00e0 v\u1eabn \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c, th\u1ea9m m\u1ef9 khi tr\u00ecnh b\u00e0y trong b\u1ea3ng t\u00ednh.<\/span><\/p>\n<p><a href=\"https:\/\/khuyenmai.teky.vn\/tangsachlaptrinh\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24876\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Free-Asset.png\" alt=\"T\u1eb7ng s\u00e1ch mi\u1ec5n ph\u00ed\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Xem th\u00eam:<\/p>\n<ul>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/\">T\u00e1ch ch\u1eef trong excel\u00a0<\/a><\/li>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\">H\u00e0m th\u1ed1ng k\u00ea trong excel<\/a><\/li>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\">H\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong excel<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o?<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-len-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m Len trong Excel &#8211; H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ch\u1eef hoa\/th\u01b0\u1eddng trong b\u1ea3ng t\u00ednh nhanh ch\u00f3ng, d\u1ec5 d\u00e0ng nh\u1ea5t. B\u1ea1n \u0111ang thao t\u00e1c v\u0103n b\u1ea3n tr\u00ean Excel? B\u1ea1n c\u1ea7n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng k\u00fd t\u1ef1 ch\u1eef vi\u1ebft hoa trong b\u1ea3ng t\u00ednh? V\u1eady c\u1ea7n ph\u1ea3i s\u1eed &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12126,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12125","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"acf":{"show_on_app":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ch\u1eef hoa\/th\u01b0\u1eddng trong b\u1ea3ng t\u00ednh nhanh ch\u00f3ng\" \/>\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-viet-hoa-chu-cai-dau-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ch\u1eef hoa\/th\u01b0\u1eddng trong b\u1ea3ng t\u00ednh nhanh ch\u00f3ng\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-24T06:34:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-15T09:40:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"338\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 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-viet-hoa-chu-cai-dau-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t\",\"datePublished\":\"2022-11-24T06:34:40+00:00\",\"dateModified\":\"2025-04-15T09:40:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/\"},\"wordCount\":1917,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-1.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-1.jpg\",\"datePublished\":\"2022-11-24T06:34:40+00:00\",\"dateModified\":\"2025-04-15T09:40:07+00:00\",\"description\":\"S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ch\u1eef hoa\/th\u01b0\u1eddng trong b\u1ea3ng t\u00ednh nhanh ch\u00f3ng\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-1.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-1.jpg\",\"width\":600,\"height\":338,\"caption\":\"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-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\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh 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":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t","description":"S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ch\u1eef hoa\/th\u01b0\u1eddng trong b\u1ea3ng t\u00ednh nhanh ch\u00f3ng","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-viet-hoa-chu-cai-dau-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t","og_description":"S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ch\u1eef hoa\/th\u01b0\u1eddng trong b\u1ea3ng t\u00ednh nhanh ch\u00f3ng","og_url":"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-24T06:34:40+00:00","article_modified_time":"2025-04-15T09:40:07+00:00","og_image":[{"width":600,"height":338,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-1.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"10 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t","datePublished":"2022-11-24T06:34:40+00:00","dateModified":"2025-04-15T09:40:07+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/"},"wordCount":1917,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-1.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-1.jpg","datePublished":"2022-11-24T06:34:40+00:00","dateModified":"2025-04-15T09:40:07+00:00","description":"S\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ch\u1eef hoa\/th\u01b0\u1eddng trong b\u1ea3ng t\u00ednh nhanh ch\u00f3ng","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-1.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-viet-hoa-chu-cai-dau-trong-excel-1.jpg","width":600,"height":338,"caption":"H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong excel"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-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":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh 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\/ham-viet-hoa-chu-cai-dau-trong-excel-1-400x225.jpg","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12125","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=12125"}],"version-history":[{"count":2,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12125\/revisions"}],"predecessor-version":[{"id":24953,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12125\/revisions\/24953"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12126"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}