{"id":9319,"date":"2025-01-02T01:04:48","date_gmt":"2025-01-02T01:04:48","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-su-dung-ham-t-co-ban-trong-excel\/"},"modified":"2025-01-02T01:04:48","modified_gmt":"2025-01-02T01:04:48","slug":"huong-dan-su-dung-ham-t-co-ban-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-su-dung-ham-t-co-ban-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m T c\u01a1 b\u1ea3n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 <em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-n-trong-excel.html\">H\u00e0m N\u00a0<\/a><\/strong><\/em><strong><em><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-n-trong-excel.html\">tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1<\/a>.<\/em><\/strong><em>\u00a0<\/em>V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n m\u1ed9t h\u00e0m ng\u1eafn g\u1ecdn kh\u00f4ng k\u00e9m, \u0111\u00f3 l\u00e0\u00a0<strong>h\u00e0m T<\/strong>. \u0110\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m T c\u01a1 b\u1ea3n ra sao, h\u00e3y \u0111\u1ecdc ph\u1ea7n b\u00ean d\u01b0\u1edbi<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6775e62f8de2c\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-t-co-ban-trong-excel.html#Ham_T_cong_dung_va_cu_phap\" title=\"H\u00e0m T, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p\">H\u00e0m T, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-t-co-ban-trong-excel.html#Cong_dung\" title=\"C\u00f4ng d\u1ee5ng\">C\u00f4ng d\u1ee5ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-t-co-ban-trong-excel.html#Cong_thuc\" title=\"C\u00f4ng th\u1ee9c\">C\u00f4ng th\u1ee9c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-t-co-ban-trong-excel.html#Ung_dung_thuc_te\" title=\"\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf\">\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-t-co-ban-trong-excel.html#1_Chinh_sua_ngay_bi_sai\" title=\"1. Ch\u1ec9nh s\u1eeda ng\u00e0y b\u1ecb sai\">1. Ch\u1ec9nh s\u1eeda ng\u00e0y b\u1ecb sai<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-t-co-ban-trong-excel.html#2_Sua_loi_khi_ghep_chuoi\" title=\"2. S\u1eeda l\u1ed7i khi gh\u00e9p chu\u1ed7i\">2. S\u1eeda l\u1ed7i khi gh\u00e9p chu\u1ed7i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-t-co-ban-trong-excel.html#3_Thong_nhat_du_lieu_TextNumber\" title=\"3. Th\u1ed1ng nh\u1ea5t d\u1eef li\u1ec7u Text\/Number\">3. Th\u1ed1ng nh\u1ea5t d\u1eef li\u1ec7u Text\/Number<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_T_cong_dung_va_cu_phap\"><\/span>H\u00e0m T, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Cong_dung\"><\/span>C\u00f4ng d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>H\u00e0m T \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3\u00a0<em>tra\u0309 v\u00ea\u0300 v\u0103n ba\u0309n \u0111\u01b0\u01a1\u0323c tham chi\u00ea\u0301u theo gia\u0301 tri\u0323.<\/em><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc\"><\/span>C\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m T nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=T(value)<\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3\u00a0<strong>Value<\/strong>\u00a0l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i th\u00e0nh v\u0103n b\u1ea3n theo quy t\u1eafc:<\/p>\n<p>N\u00ea\u0301u gia\u0301 tri\u0323 la\u0300<strong> v\u0103n ba\u0309n (Text)<\/strong>\u00a0ho\u0103\u0323c<strong> tham chi\u00ea\u0301u \u0111\u00ea\u0301n v\u0103n ba\u0309n<\/strong>, ha\u0300m T tra\u0309 v\u00ea\u0300 <strong>gia\u0301 tri\u0323 v\u0103n b\u1ea3n \u0111\u00f3<\/strong>.<\/p>\n<p>N\u00ea\u0301u gia\u0301 tri\u0323 kh\u00f4ng ph\u1ea3i\u00a0<strong>Text<\/strong>, h\u00e0m T tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb\u00a0<strong>r\u1ed7ng \u201c\u201d.<\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Ung_dung_thuc_te\"><\/span>\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Nhi\u0300n chung ba\u0323n kh\u00f4ng c\u00e2\u0300n du\u0300ng ha\u0300m T trong c\u00f4ng th\u01b0\u0301c vi\u0300 Microsoft Excel t\u01b0\u0323 \u0111\u00f4\u0323ng chuy\u00ea\u0309n \u0111\u00f4\u0309i gia\u0301 tri\u0323 khi c\u00e2\u0300n. Tuy nhi\u00ean, ta v\u1eabn c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng h\u00e0m n\u00e0y hi\u1ec7u qu\u1ea3 khi tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u ph\u00e2n bi\u1ec7t \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>Text\u00a0<\/strong>v\u00e0\u00a0<strong>Number.<\/strong><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-37.gif\" title=\"ex101_92019-nho-37\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ta c\u00f3 v\u00ed d\u1ee5 sau:<\/p>\n<h5><span class=\"ez-toc-section\" id=\"1_Chinh_sua_ngay_bi_sai\"><\/span>1. Ch\u1ec9nh s\u1eeda ng\u00e0y b\u1ecb sai<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>Ng\u00e0y sai \u1edf \u0111\u00e2y bao g\u1ed3m nh\u1eefng ng\u00e0y sai \u0111\u1ecbnh d\u1ea1ng (th\u00e1ng\/ng\u00e0y\/n\u0103m) trong khi \u0111\u1ecbnh d\u1ea1ng m\u00e1y t\u00ednh l\u00e0 (ng\u00e0y\/th\u00e1ng\/n\u0103m), ho\u1eb7c ng\u00e0y l\u01b0u tr\u1eef \u1edf \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>Text<\/strong>.<\/p>\n<p>Ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 t\u00ecm ra nh\u1eefng gi\u00e1 tr\u1ecb sai, \u0111\u00f3 l\u00e0 nh\u1eefng gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n khi nh\u1eadp h\u00e0m T. Sau \u0111\u00f3, ta ch\u1ec9 c\u1ea7n x\u00f3a d\u1eef li\u1ec7u \u0111\u00f3 \u0111i.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24962\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-t-1.png\" width=\"305\" height=\"229\" title=\"ham-t-1\"><\/p>\n<h5><span class=\"ez-toc-section\" id=\"2_Sua_loi_khi_ghep_chuoi\"><\/span>2. S\u1eeda l\u1ed7i khi gh\u00e9p chu\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau: B\u1ea1n c\u00f3 c\u00e1c h\u00e0m tham chi\u1ebfu, l\u1ea5y gi\u00e1 tr\u1ecb, nh\u01b0ng c\u00f3 l\u1eabn v\u00e0i gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 b\u00ean trong, v\u00e0 khi gh\u00e9p l\u1ea1i s\u1ebd g\u1eb7p l\u1ed7i. V\u1eady khi v\u1eadn d\u1ee5ng, ta th\u00eam h\u00e0m T \u0111\u1ec3 s\u1eeda l\u1ed7i \u0111\u00f3.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/01\/trim-t-formula.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24983\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/trim-t-formula.jpg\" width=\"466\" height=\"289\" title=\"trim-t-formula\"><\/a><\/p>\n<h5><span class=\"ez-toc-section\" id=\"3_Thong_nhat_du_lieu_TextNumber\"><\/span>3. Th\u1ed1ng nh\u1ea5t d\u1eef li\u1ec7u Text\/Number<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>T\u01b0\u01a1ng t\u1ef1 b\u00e0i vi\u1ebft v\u1ec1\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-n-trong-excel.html\">h\u00e0m N<\/a>,\u00a0<\/strong>ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m T \u0111\u1ec3 t\u00ecm v\u00e0 th\u1ed1ng nh\u1ea5t \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong Excel. C\u1ee5 th\u1ec3 ra sao, c\u00e1c b\u1ea1n h\u00e3y \u0111\u1ecdc l\u1ea1i b\u00e0i vi\u1ebft tr\u00ean, k\u1ebft h\u1ee3p v\u00e0 th\u1eed s\u1ee9c nh\u00e9.<\/p>\n<p>Kh\u00f4ng h\u1ec1 kh\u00f3 ph\u1ea3i kh\u00f4ng n\u00e0o? Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u c\u00e1c h\u00e0m t\u01b0\u01a1ng t\u1ef1 trong nh\u1eefng b\u00e0i vi\u1ebft sau:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-phan-biet-loai-du-lieu-trong-excel-voi-nhom-ham-isnumber-isnontext-istext.html\">Ph\u00e2n bi\u1ec7t d\u1eef li\u1ec7u v\u1edbi ISTEXT, ISNUMBER, ISNONTEXT<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-cong-thuc-trong-excel-thanh-chuoi-ki-tu.html\"><strong>Chuy\u1ec3n c\u00f4ng th\u1ee9c th\u00e0nh chu\u1ed7i k\u00ed t\u1ef1<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-sua-dinh-dang-thoi-gian-bi-loi-ve-dang-chuan-ca-gio-phut-giay.html\"><strong>S\u1eeda \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel-co-bai-tap.html\">X\u00e1c \u0111\u1ecbnh ng\u00e0y th\u00e1ng b\u1eb1ng c\u00e1c h\u00e0m th\u1eddi gian<\/a><\/strong><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-37.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9320,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9319","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9319","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=9319"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9319\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9320"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9319"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}