{"id":4094,"date":"2024-12-04T08:43:47","date_gmt":"2024-12-04T08:43:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel\/"},"modified":"2024-12-04T08:43:47","modified_gmt":"2024-12-04T08:43:47","slug":"ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel\/","title":{"rendered":"H\u00e0m Text v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng tuy\u1ec7t v\u1eddi c\u1ee7a h\u00e0m Text trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1ea3i th\u00edch c\u00e1c \u0111\u1eb7c tr\u01b0ng c\u1ee7a h\u00e0m Text trong Excel v\u00e0 ch\u1ec9 ra nh\u1eefng c\u00e1ch t\u1ed1i \u01b0u \u0111\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m Text trong Excel<em>.<\/em><\/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-6750164235d42\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel.html#HAM_TEXT_TRONG_EXCEL_%E2%80%93_CONG_THUC_VA_CACH_SU_DUNG_CO_BAN\" title=\"H\u00c0M TEXT TRONG EXCEL \u2013 C\u00d4NG TH\u1ee8C V\u00c0 C\u00c1CH S\u1eec D\u1ee4NG C\u01a0 B\u1ea2N\">H\u00c0M TEXT TRONG EXCEL \u2013 C\u00d4NG TH\u1ee8C V\u00c0 C\u00c1CH S\u1eec D\u1ee4NG C\u01a0 B\u1ea2N<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel.html#MA_DINH_DANG_HAM_TEXT_TRONG_EXCEL\" title=\"M\u00c3 \u0110\u1ecaNH D\u1ea0NG H\u00c0M TEXT TRONG EXCEL\">M\u00c3 \u0110\u1ecaNH D\u1ea0NG H\u00c0M TEXT TRONG EXCEL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel.html#CACH_SU_DUNG_HAM_TEXT_TRONG_EXCEL_%E2%80%93_CONG_THUC_MAU\" title=\"C\u00c1CH S\u1eec D\u1ee4NG H\u00c0M TEXT TRONG EXCEL \u2013 C\u00d4NG TH\u1ee8C M\u1eaaU\">C\u00c1CH S\u1eec D\u1ee4NG H\u00c0M TEXT TRONG EXCEL \u2013 C\u00d4NG TH\u1ee8C M\u1eaaU<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel.html#KET_NOI_VAN_BAN_VA_SO_HOAC_NGAY_THEO_DINH_DANG_TUY_CHINH\" title=\"K\u1ebeT N\u1ed0I V\u0102N B\u1ea2N V\u00c0 S\u1ed0 (HO\u1eb6C NG\u00c0Y) THEO \u0110\u1ecaNH D\u1ea0NG T\u00d9Y CH\u1ec8NH\">K\u1ebeT N\u1ed0I V\u0102N B\u1ea2N V\u00c0 S\u1ed0 (HO\u1eb6C NG\u00c0Y) THEO \u0110\u1ecaNH D\u1ea0NG T\u00d9Y CH\u1ec8NH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel.html#THEM_SO_0_DUNG_DAU_MOI_SO_VOI_DO_DAI_NGAN_KHAC_NHAU\" title=\"TH\u00caM S\u1ed0 0 \u0110\u1ee8NG \u0110\u1ea6U M\u1ed6I S\u1ed0 V\u1edaI \u0110\u1ed8 D\u00c0I NG\u1eaeN KH\u00c1C NHAU\">TH\u00caM S\u1ed0 0 \u0110\u1ee8NG \u0110\u1ea6U M\u1ed6I S\u1ed0 V\u1edaI \u0110\u1ed8 D\u00c0I NG\u1eaeN KH\u00c1C NHAU<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel.html#CHUYEN_GIA_TRI_THANH_SO_DIEN_THOAI_THEO_MOT_DINH_DANG_NHAT_DINH\" title=\"CHUY\u1ec2N GI\u00c1 TR\u1eca TH\u00c0NH S\u1ed0 \u0110I\u1ec6N THO\u1ea0I THEO M\u1ed8T \u0110\u1ecaNH D\u1ea0NG NH\u1ea4T \u0110\u1ecaNH\">CHUY\u1ec2N GI\u00c1 TR\u1eca TH\u00c0NH S\u1ed0 \u0110I\u1ec6N THO\u1ea0I THEO M\u1ed8T \u0110\u1ecaNH D\u1ea0NG NH\u1ea4T \u0110\u1ecaNH<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel.html#HAM_TEXT_TRONG_EXCEL_KHONG_THUC_HIEN_DUOC_%E2%80%93_NGUYEN_NHAN_VA_CACH_KHAC_PHUC\" title=\"H\u00c0M TEXT TRONG EXCEL KH\u00d4NG TH\u1ef0C HI\u1ec6N \u0110\u01af\u1ee2C \u2013 NGUY\u00caN NH\u00c2N V\u00c0 C\u00c1CH KH\u1eaeC PH\u1ee4C\">H\u00c0M TEXT TRONG EXCEL KH\u00d4NG TH\u1ef0C HI\u1ec6N \u0110\u01af\u1ee2C \u2013 NGUY\u00caN NH\u00c2N V\u00c0 C\u00c1CH KH\u1eaeC PH\u1ee4C<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_TEXT_TRONG_EXCEL_%E2%80%93_CONG_THUC_VA_CACH_SU_DUNG_CO_BAN\"><\/span>H\u00c0M TEXT TRONG EXCEL \u2013 C\u00d4NG TH\u1ee8C V\u00c0 C\u00c1CH S\u1eec D\u1ee4NG C\u01a0 B\u1ea2N<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e0m Text \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u00e1 tr\u1ecb s\u1ed1 sang chu\u1ed7i v\u0103n b\u1ea3n \u1edf m\u1ed9t \u0111\u1ecbnh d\u1ea1ng c\u1ee5 th\u1ec3.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c: <em><strong>TEXT(gi\u00e1 tr\u1ecb, \u0111\u1ecbnh d\u1ea1ng_v\u0103n b\u1ea3n)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">C\u1ee5 th\u1ec3:<\/p>\n<ul style=\"text-align: justify\">\n<li style=\"text-align: justify\">Gi\u00e1 tr\u1ecb: gi\u00e1 tr\u1ecb s\u1ed1 c\u1ea7n chuy\u1ec3n sang v\u0103n b\u1ea3n. C\u00f3 th\u1ec3 l\u00e0 s\u1ed1, ng\u00e0y th\u00e1ng, l\u00e0 tham chi\u1ebfu c\u1ee7a m\u1ed9t \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 hay m\u1ed9t h\u00e0m kh\u00e1c tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 hay ng\u00e0y.<\/li>\n<li style=\"text-align: justify\">\u0110\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n: \u0111\u1ecbnh d\u1ea1ng c\u1ea7n s\u1eed d\u1ee5ng, cung c\u1ea5p th\u1ec3 th\u1ee9c c\u1ee7a m\u00e3 \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p, nh\u01b0 \u201cmm\/dd\/yy\u201d.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">H\u00e0m Text th\u00edch h\u1ee3p v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel 2016, Excel 2013, 2010, 2007, 2003 v\u00e0 th\u1ea5p h\u01a1n.<\/p>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng, h\u00e0m Text trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p sau \u0111\u00e2y:<\/p>\n<ul style=\"text-align: justify\">\n<li>Hi\u1ec3n th\u1ecb s\u1ed1 theo c\u00e1ch d\u1ec5 \u0111\u1ecdc h\u01a1n ho\u1eb7c theo m\u1ed9t \u0111\u1ecbnh d\u1ea1ng d\u1ec5 d\u00e0ng h\u01a1n cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng.<\/li>\n<li>Hi\u1ec3n th\u1ecb ng\u00e0y th\u00e1ng theo m\u1ed9t \u0111\u1ecbnh d\u1ea1ng nh\u1ea5t \u0111\u1ecbnh<\/li>\n<li>K\u1ebft h\u1ee3p c\u00e1c s\u1ed1 ho\u1eb7c ng\u00e0y th\u00e1ng v\u1edbi v\u0103n b\u1ea3n ho\u1eb7c c\u00e1c k\u00ed t\u1ef1 nh\u1ea5t \u0111\u1ecbnh.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 k\u00e9o ng\u00e0y t\u1eeb \u00f4 A2 sang \u00f4 kh\u00e1c theo \u0111\u1ecbnh d\u1ea1ng truy\u1ec1n th\u1ed1ng nh\u01b0 \u201cJan 1, 2016\u201d, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-137.gif\" title=\"vba101_92019-nho-137\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-326.gif\" title=\"ex101_92019-nho-326\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">=<strong><em>TEXT(A2, \u201cmmmm d, yyyy\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4807 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-10.png\" width=\"246\" height=\"102\" title=\"2-10\"><\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd quan tr\u1ecdng: h\u00e0m Text trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 chuy\u1ec3n gi\u00e1 tr\u1ecb s\u1ed1 sang chu\u1ed7i v\u0103n b\u1ea3n. V\u00ec v\u1eady, k\u1ebft qu\u1ea3 h\u00e0m Text \u0111\u01b0a ra kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng trong c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c. N\u1ebfu mu\u1ed1n, c\u00f3 th\u1ec3 gi\u1eef nguy\u00ean gi\u00e1 tr\u1ecb g\u1ed1c v\u00e0 d\u00f9ng c\u00f4ng th\u1ee9c kh\u00e1c.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"MA_DINH_DANG_HAM_TEXT_TRONG_EXCEL\"><\/span>M\u00c3 \u0110\u1ecaNH D\u1ea0NG H\u00c0M TEXT TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 th\u1ea5y, c\u00f4ng th\u1ee9c h\u00e0m Text r\u1ea5t \u0111\u01a1n gi\u1ea3n. M\u1ed7i ph\u1ea7n \u0111\u01b0\u1ee3c c\u1ea5p m\u1ed9t m\u00e3 \u0111\u1ecbnh d\u1ea1ng ph\u00f9 h\u1ee3p v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ed1 theo c\u00e1ch mong mu\u1ed1n. V\u1ec1 c\u01a1 b\u1ea3n, h\u00e0m Text ch\u1ea5p nh\u1eadn h\u1ea7u h\u1ebft c\u00e1c \u0111\u1ecbnh d\u1ea1ng m\u00e3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong \u0111\u1ecbnh d\u1ea1ng Excel. B\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y li\u1ec7t k\u00ea nh\u1eefng m\u00e3 \u0111\u1ecbnh d\u1ea1ng c\u01a1 b\u1ea3n nh\u1ea5t.<\/p>\n<table style=\"width: 839px\">\n<tbody>\n<tr>\n<td style=\"width: 71px\">M\u00e3<\/td>\n<td style=\"width: 289.2px\">M\u00f4 t\u1ea3<\/td>\n<td style=\"width: 462.8px\">\u0110\u1ecbnh d\u1ea1ng m\u00e3 m\u1eabu<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 71px\">0<\/td>\n<td style=\"width: 289.2px\">Ch\u1eef s\u1ed1 th\u1ec3 hi\u1ec7n nh\u1eefng s\u1ed1 0 v\u00f4 ngh\u0129a<\/td>\n<td style=\"width: 462.8px\">#.00 t\u00ednh \u0111\u1ebfn s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 2.<\/p>\n<p>N\u1ebfu nh\u1eadp 2.5. trong \u00f4 tham chi\u1ebfu, s\u1ed1 hi\u1ec3n th\u1ecb l\u00e0 2.50<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 71px\">#<\/td>\n<td style=\"width: 289.2px\">D\u1ea5u ng\u0103n kh\u00f4ng bi\u1ec3u di\u1ec5n th\u00eam s\u1ed1 0<\/td>\n<td style=\"width: 462.8px\">#.## \u2013 t\u00ednh \u0111\u1ebfn s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 2<\/p>\n<p>N\u1ebfu nh\u1eadp 2.5, s\u1ed1 hi\u1ec3n th\u1ecb l\u00e0 2.5<\/p>\n<p>N\u1ebfu nh\u1eadp 2.5555, s\u1ed1 hi\u1ec3n th\u1ecb l\u00e0 2.56<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 71px\">?<\/td>\n<td style=\"width: 289.2px\">D\u1ea5u \u0111\u1ec3 kho\u1ea3ng tr\u1ed1ng cho s\u1ed1 0 v\u00f4 ngh\u0129a nh\u01b0ng kh\u00f4ng bi\u1ec3u di\u1ec5n ch\u00fang. Th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 s\u1eafp x\u1ebfp c\u00e1c s\u1ed1 trong c\u1ed9t t\u1ea1i m\u1ed9t \u0111i\u1ec3m th\u1eadp ph\u00e2n<\/td>\n<td style=\"width: 462.8px\">#.?? Bi\u1ec3u di\u1ec5n t\u1ed1i \u0111a 2 ph\u1ea7n th\u1eadp ph\u00e2n v\u00e0 c\u0103n nh\u1eadp cho c\u00e1c \u0111i\u1ec3m th\u1eadp ph\u00e2n trong m\u1ed9t c\u1ed9t<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 71px\">.<\/td>\n<td style=\"width: 289.2px\">\u0110i\u1ec3m th\u1eadp ph\u00e2n<\/td>\n<td style=\"width: 462.8px\"><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 71px\">,<\/td>\n<td style=\"width: 289.2px\">Ng\u0103n c\u00e1ch h\u00e0ng ngh\u00ecn<\/td>\n<td style=\"width: 462.8px\">###,###.## bi\u1ec3u hi\u1ec7n d\u1ea5u ph\u00e2n t\u00e1ch h\u00e0ng ngh\u00ecn v\u00e0 2 s\u1ed1 th\u1eadp ph\u00e2n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">C\u00f9ng \u0111\u00f3, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f9ng v\u1edbi b\u1ea5t c\u1ee9 k\u00ed t\u1ef1 n\u00e0o d\u01b0\u1edbi \u0111\u00e2y trong m\u00e3 \u0111\u1ecbnh d\u1ea1ng, k\u1ebft qu\u1ea3 th\u1ec3 hi\u1ec7n \u0111\u01b0\u1ee3c v\u1eabn gi\u1eef nguy\u00ean k\u00ed t\u1ef1<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"151\">+ v\u00e0 \u2013<\/td>\n<td width=\"204\">D\u1ea5u c\u1ed9ng v\u00e0 tr\u1eeb<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">()<\/td>\n<td width=\"204\">D\u1ea5u ngo\u1eb7c \u0111\u01a1n<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">:<\/td>\n<td width=\"204\">D\u1ea5u :<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">\u2018<\/td>\n<td width=\"204\">D\u1ea5u nh\u00e1y<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">{}<\/td>\n<td width=\"204\">D\u1ea5u ngo\u1eb7c nh\u1ecdn<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">&lt; &gt;<\/td>\n<td width=\"204\">Nh\u1ecf h\u01a1n ho\u1eb7c l\u1edbn h\u01a1n<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">=<\/td>\n<td width=\"204\">D\u1ea5u b\u1eb1ng<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">\/<\/td>\n<td width=\"204\">D\u1ea5u g\u1ea1ch ch\u00e9o<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">B\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y ch\u1ec9 c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m Text trong Excel \u0111\u1ec3 \u1ee9ng d\u1ee5ng c\u00e1c \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau ra gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u01b0\u01a1ng.<\/p>\n<table width=\"667\">\n<tbody>\n<tr>\n<td width=\"55\"><\/td>\n<td width=\"119\">A<\/td>\n<td width=\"141\">B<\/td>\n<td width=\"352\">C<\/td>\n<\/tr>\n<tr>\n<td width=\"55\">1<\/td>\n<td width=\"119\">Gi\u00e1 tr\u1ecb g\u1ed1c<\/td>\n<td width=\"141\">Gi\u00e1 tr\u1ecb \u0111\u1ecbnh d\u1ea1ng<\/td>\n<td width=\"352\">C\u00f4ng th\u1ee9c<\/td>\n<\/tr>\n<tr>\n<td width=\"55\">2<\/td>\n<td width=\"119\">5.5<\/td>\n<td width=\"141\">5.50<\/td>\n<td width=\"352\">=TEXT(A2, \u201c0.00\u201d)<\/td>\n<\/tr>\n<tr>\n<td width=\"55\">3<\/td>\n<td width=\"119\"><\/td>\n<td width=\"141\">550%<\/td>\n<td width=\"352\">=TEXT(A2,\u201d#%\u201d)<\/td>\n<\/tr>\n<tr>\n<td width=\"55\">4<\/td>\n<td width=\"119\"><\/td>\n<td width=\"141\">$5.50<\/td>\n<td width=\"352\">=TEXT(A2, \u201c$#,##0.00\u201d<\/td>\n<\/tr>\n<tr>\n<td width=\"55\">5<\/td>\n<td width=\"119\"><\/td>\n<td width=\"141\">+$5.50<\/td>\n<td width=\"352\">=TEXT(A2,\u201d+$#,##0.00;-$#,##0.00;$0.00\u2033)<\/td>\n<\/tr>\n<tr>\n<td width=\"55\">6<\/td>\n<td width=\"119\"><\/td>\n<td width=\"141\">-$5.50<\/td>\n<td width=\"352\">=TEXT(A2, \u201c- $#,##0.00;- $#,##0.00;$0.00\u201d)<\/td>\n<\/tr>\n<tr>\n<td width=\"55\">7<\/td>\n<td width=\"119\"><\/td>\n<td width=\"141\">5 \u00bd<\/td>\n<td width=\"352\">=TEXT(A2,\u201d# ?\/?\u201d)<\/td>\n<\/tr>\n<tr>\n<td width=\"55\">8<\/td>\n<td width=\"119\"><\/td>\n<td width=\"141\">5.50E+00<\/td>\n<td width=\"352\">=TEXT(A2,\u201d0.00E+00\u2033)<\/td>\n<\/tr>\n<tr>\n<td width=\"55\">9<\/td>\n<td width=\"119\"><\/td>\n<td width=\"141\">~6!<\/td>\n<td width=\"352\">=TEXT(A2,\u201d~# !\u201d)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">Khi s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel v\u1edbi ng\u00e0y v\u00e0 gi\u1edd, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u00e3 \u0111\u1ecbnh d\u1ea1ng sau:<\/p>\n<table style=\"width: 783.6px\">\n<tbody>\n<tr>\n<td style=\"width: 114px\">M\u00e3 \u0111\u1ecbnh d\u1ea1ng<\/td>\n<td style=\"width: 234px\">M\u00f4 t\u1ea3<\/td>\n<td style=\"width: 424.6px\">V\u00ed d\u1ee5<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 114px\">d (day)<\/td>\n<td style=\"width: 234px\">Ng\u00e0y c\u1ee7a th\u00e1ng ho\u1eb7c ng\u00e0y c\u1ee7a n\u0103m<\/td>\n<td style=\"width: 424.6px\">d \u2013 m\u1ed9t ho\u1eb7c 2 s\u1ed1 kh\u00f4ng ch\u1ee9a s\u1ed1 0 \u1edf \u0111\u1ea7u (t\u1eeb 1 \u0111\u1ebfn 31)<\/p>\n<p>dd \u2013 2 s\u1ed1 ch\u1ee9a s\u1ed1 0 \u1edf \u0111\u1ea7u (01 \u0111\u1ebfn 31)<\/p>\n<p>ddd \u2013 3 k\u00ed t\u1ef1 vi\u1ebft t\u1eaft (Mon \u2013 Sun (th\u1ee9 2 \u0111\u1ebfn ch\u1ee7 nh\u1eadt)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 114px\">m (month)<\/td>\n<td style=\"width: 234px\">Th\u00e1ng (\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 m\u1ed9t ph\u1ea7n c\u1ee7a ng\u00e0y)<\/td>\n<td style=\"width: 424.6px\">m \u2013 m\u1ed9t ho\u1eb7c 2 s\u1ed1 kh\u00f4ng ch\u1ee9a s\u1ed1 0 \u1edf \u0111\u1ea7u (1 \u0111\u1ebfn 12)<\/p>\n<p>mm \u2013 2 s\u1ed1 ch\u1ee9a s\u1ed1 0 \u1edf \u0111\u1ea7u (01 \u2013 12)<\/p>\n<p>mmm \u2013 vi\u1ebft t\u1eaft c\u1ee7a th\u00e1ng (Jan \u2013 Dec)<\/p>\n<p>mmmm \u2013 ch\u1eef \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a th\u00e1ng<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 114px\">y (year)<\/td>\n<td style=\"width: 234px\">N\u0103m<\/td>\n<td style=\"width: 424.6px\">yy- m\u1ed9t ho\u1eb7c 2 s\u1ed1 (v\u00ed d\u1ee5 06 l\u00e0 2006, hay 16 l\u00e0 2016)<\/p>\n<p>yyyy \u2013 4 ch\u1eef s\u1ed1 (2006,2016)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 114px\">h (hour)<\/td>\n<td style=\"width: 234px\">Gi\u1edd<\/td>\n<td style=\"width: 424.6px\">h \u2013 m\u1ed9t ho\u1eb7c hai ch\u1eef s\u1ed1 kh\u00f4ng ch\u1ee9a s\u1ed1 0 \u1edf \u0111\u1ea7u (1-60)<\/p>\n<p>hh -2 ch\u1eef s\u1ed1 ch\u1ee9a s\u1ed1 0 \u1edf \u0111\u1ea7u (01-60)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 114px\">m (minute)<\/td>\n<td style=\"width: 234px\">Ph\u00fat<\/td>\n<td style=\"width: 424.6px\">m \u2013 m\u1ed9t ho\u1eb7c hai ch\u1eef s\u1ed1 kh\u00f4ng ch\u1ee9a s\u1ed1 0 \u1edf \u0111\u1ea7u (1-60)<\/p>\n<p>mm -2 ch\u1eef s\u1ed1 ch\u1ee9a s\u1ed1 0 \u1edf \u0111\u1ea7u (01-60)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 114px\">S (second)<\/td>\n<td style=\"width: 234px\">gi\u00e2y<\/td>\n<td style=\"width: 424.6px\">s \u2013 m\u1ed9t ho\u1eb7c hai ch\u1eef s\u1ed1 kh\u00f4ng ch\u1ee9a s\u1ed1 0 \u1edf \u0111\u1ea7u (1-60)<\/p>\n<p>ss -2 ch\u1eef s\u1ed1 ch\u1ee9a s\u1ed1 0 \u1edf \u0111\u1ea7u (01-60)<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">Trang t\u00ednh d\u01b0\u1edbi th\u1ec3 hi\u1ec7n m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c h\u00e0m Text cho ng\u00e0y:<\/p>\n<table width=\"697\">\n<tbody>\n<tr>\n<td width=\"79\"><\/td>\n<td width=\"96\">A<\/td>\n<td width=\"216\">B<\/td>\n<td width=\"306\">C<\/td>\n<\/tr>\n<tr>\n<td width=\"79\">1<\/td>\n<td width=\"96\">Ng\u00e0y g\u1ed1c<\/td>\n<td width=\"216\">Ng\u00e0y \u0111\u01b0\u1ee3c \u0111\u1ecbnh \u0111\u1ea1ng<\/td>\n<td width=\"306\">C\u00f4ng th\u1ee9c<\/td>\n<\/tr>\n<tr>\n<td width=\"79\">2<\/td>\n<td width=\"96\">12\/9\/2016<\/td>\n<td width=\"216\">Dec 09 2016<\/td>\n<td width=\"306\">=TEXT(A2, \u201cmmm dd yyyy\u201d)<\/td>\n<\/tr>\n<tr>\n<td width=\"79\">3<\/td>\n<td width=\"96\"><\/td>\n<td width=\"216\">Friday 09 December, 2016<\/td>\n<td width=\"306\">=TEXT(A2, \u201cdddd dd mmmm, yyyy\u201d)<\/td>\n<\/tr>\n<tr>\n<td width=\"79\">4<\/td>\n<td width=\"96\"><\/td>\n<td width=\"216\">9-Dec-16<\/td>\n<td width=\"306\">=TEXT(A2, \u201cd-mmm-yy\u201d)<\/td>\n<\/tr>\n<tr>\n<td width=\"79\">5<\/td>\n<td width=\"96\"><\/td>\n<td width=\"216\">Friday<\/td>\n<td width=\"306\">=TEXT(A2,\u201ddddd\u201d)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_SU_DUNG_HAM_TEXT_TRONG_EXCEL_%E2%80%93_CONG_THUC_MAU\"><\/span>C\u00c1CH S\u1eec D\u1ee4NG H\u00c0M TEXT TRONG EXCEL \u2013 C\u00d4NG TH\u1ee8C M\u1eaaU<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00f3 th\u1ec3 th\u1ea5y, \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m Text trong Excel c\u00f2n kh\u00e1 h\u1ea1n ch\u1ebf (b\u1edfi gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng thay \u0111\u1ed5i b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u1ed9p \u0110\u1ecbnh d\u1ea1ng \u00f4 c\u00f3 s\u1eb5n th\u00f4ng qua ch\u01b0\u01a1ng tr\u00ecnh l\u1eadp tr\u00ecnh \u00f4 ho\u1eb7c ph\u00edm t\u1eaft Ctrl+1.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"KET_NOI_VAN_BAN_VA_SO_HOAC_NGAY_THEO_DINH_DANG_TUY_CHINH\"><\/span>K\u1ebeT N\u1ed0I V\u0102N B\u1ea2N V\u00c0 S\u1ed0 (HO\u1eb6C NG\u00c0Y) THEO \u0110\u1ecaNH D\u1ea0NG T\u00d9Y CH\u1ec8NH<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi t\u1ea1o t\u00f3m t\u1eaft ho\u1eb7c b\u00e1o c\u00e1o, ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng kh\u00f4ng ch\u1ec9 mu\u1ed1n <a href=\"http:\/\/blog.ezworkapp.com\/cac-cach-tinh-tong-nhanh-trong-excel-nhieu-cach-hay-va-la.html\"><strong>t\u00ednh t\u1ed5ng trong Excel<\/strong><\/a>, ph\u1ea7n tr\u0103m v\u00e0 nh\u1eefng ph\u1ea7n t\u01b0\u01a1ng t\u1ef1, m\u00e0 c\u00f2n gi\u1ea3i th\u00edch cho ng\u01b0\u1eddi d\u00f9ng \u00fd ngh\u0129a c\u1ee7a ch\u00fang. \u0110\u1ec3 th\u1ef1c hi\u1ec7n, s\u1eed d\u1ee5ng h\u00e0m Concatenate \u0111\u1ec3 nh\u1eadp v\u0103n b\u1ea3n v\u00e0 s\u1ed1, v\u00e0 s\u1eed d\u1ee5ng h\u00e0m Text \u0111\u1ec3 th\u1ec3 hi\u1ec7n s\u1ed1 (hay ng\u00e0y) theo \u00fd mu\u1ed1n c\u1ee7a ng\u01b0\u1eddi d\u00f9ng.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 1. \u0110\u1ecbnh d\u1ea1ng s\u1ed1 b\u00ean trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed, c\u1ea7n t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng d\u1ef1a tr\u00ean gi\u00e1 c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng trong \u00f4 A2, s\u1ed1 l\u01b0\u1ee3ng \u0111\u1ed1i t\u01b0\u1ee3ng trong \u00f4 B2, v\u00e0 gi\u1ea3m t\u1ec9 l\u1ec7 trong \u00f4 C2 s\u1eed d\u1ee5ng ph\u00e9p t\u00ednh: =A2*B2*(1-C2). \u0110\u1ed1i v\u1edbi ng\u01b0\u1eddi s\u1eed d\u1ee5ng bi\u1ebft ch\u00ednh x\u00e1c \u00fd ngh\u0129a c\u1ee7a k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1, ng\u01b0\u1eddi s\u1eed d\u1ee5ng mu\u1ed1n ch\u00e8n th\u00eam c\u00e2u gi\u1ea3i th\u00edch nh\u01b0: \u201cYour price is\u201d \u2013 \u201cgi\u00e1 c\u1ee7a b\u1ea1n l\u00e0\u201d. C\u00f9ng \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n hi\u1ec3n th\u1ecb bi\u1ec3u t\u01b0\u1ee3ng ti\u1ec1n t\u1ec7, d\u1ea5u ph\u00e2n c\u00e1ch h\u00e0ng ngh\u00ecn v\u00e0 hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 ho\u00e0n th\u00e0nh, b\u1ed5 sung c\u00f4ng th\u1ee9c t\u00ednh v\u00e0o \u0111\u1ed1i s\u1ed1 th\u1ee9 nh\u1ea5t c\u1ee7a h\u00e0m Text, bao g\u1ed3m m\u00e3 \u0111\u1ecbnh d\u1ea1ng t\u01b0\u01a1ng \u1ee9ng trong \u0111\u1ed1i s\u1ed1 th\u1ee9 2, v\u00e0 n\u1ed1i h\u00e0m Text v\u1edbi chu\u1ed7i b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u1ec7 th\u1ed1ng k\u00ed hi\u1ec7u ho\u1eb7c <a href=\"http:\/\/blog.ezworkapp.com\/meo-noi-noi-dung-giua-cac-o-tinh-voi-nhau.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m Concatenate<\/a>:<\/p>\n<p style=\"text-align: justify\">=<strong><em>\u201cYour price is \u201c&amp;TEXT(A2*B2*(1-C2), \u201c$###,###.00\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c<\/p>\n<p style=\"text-align: justify\">= <em><strong>CONCATENATE(\u201cYour price is \u201c,TEXT(A2*B2*(1-C2), \u201c$###,###.00\u201d))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u01b0\u01a1ng t\u1ef1 b\u1ea3ng sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-4808 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-1-300x78-1.png\" width=\"300\" height=\"78\" title=\"2-1-300x78-1\"><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 2: K\u1ebft h\u1ee3p v\u0103n b\u1ea3n v\u00e0 ng\u00e0y th\u00e1ng theo \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n<\/p>\n<p style=\"text-align: justify\">Khi quay l\u1ea1i ng\u00e0y hi\u1ec7n t\u1ea1i b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Today() hay Now, c\u00f3 th\u1ec3 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n bi\u1ec3u di\u1ec5n ng\u00e0y b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi m\u1ed9t v\u00e0i c\u00e2u, hay \u0111o\u1ea1n \u0111\u1ec3 tr\u00e1nh g\u00e2y nghi ng\u1edd hay nh\u1ea7m l\u1eabn.<\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, n\u1ebfu ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n n\u1ed1i v\u0103n b\u1ea3n v\u1edbi ng\u00e0y th\u00e1ng theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng:<\/p>\n<p style=\"text-align: justify\"><strong><em>=CONCATENATE(\u201cToday is \u201c, TODAY())<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 r\u1ea5t l\u1ea1, nh\u01b0 \u201cToday is 42198\u201d.<\/p>\n<p style=\"text-align: justify\">\u0110\u00f3 l\u00e0 do h\u1ec7 th\u00f4ng l\u1eadp tr\u00ecnh c\u1ee7a Excel, ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c l\u01b0u b\u1eb1ng c\u00e1c con s\u1ed1. B\u1edfi v\u1eady, c\u00e1c con s\u1ed1 n\u00e0y xu\u1ea5t hi\u1ec7n trong chu\u1ed7i v\u0103n b\u1ea3n n\u1ed1i. \u0110\u1ec3 kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng nay, s\u1eed d\u1ee5ng h\u00e0m Text \u0111\u1ec3 bi\u1ec3u di\u1ec5n ng\u00e0y th\u00e1ng theo \u00fd mu\u1ed1n c\u1ee7a ng\u01b0\u1eddi d\u00f9ng.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, g\u1eafn h\u00e0m Today trong c\u00f4ng th\u1ee9c h\u00e0mText c\u00f3 m\u00e3 \u0111\u1ecbnh d\u1ea1ng \u201cdddd d mmm,yyyy\u201d, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0: \u201cToday is Monday 12 Dec, 2016\u201d<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>=CONCATENATE(\u201cToday is \u201c, TEXT(TODAY(), \u201cdddd d mmm, yyyy\u201d))<\/em><\/strong><br \/>\nor<br \/>\n<em><strong>=\u201dToday is \u201d &amp; TEXT(TODAY(), \u201cdddd d mmm, yyyy\u201d)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-4809 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-2-300x57-1.png\" width=\"300\" height=\"57\" title=\"2-2-300x57-1\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"THEM_SO_0_DUNG_DAU_MOI_SO_VOI_DO_DAI_NGAN_KHAC_NHAU\"><\/span>TH\u00caM S\u1ed0 0 \u0110\u1ee8NG \u0110\u1ea6U M\u1ed6I S\u1ed0 V\u1edaI \u0110\u1ed8 D\u00c0I NG\u1eaeN KH\u00c1C NHAU<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Microsoft Excel t\u1ef1 \u0111\u1ed9ng x\u00f3a nh\u1eefng s\u1ed1 0 \u0111\u1ee9ng \u0111\u1ea7u m\u1ed7i con s\u1ed1 trong m\u1ed9t \u00f4, \u0111i\u1ec1u n\u00e0y kh\u00f4ng c\u00f3 \u1ea3nh h\u01b0\u1edfng g\u00ec trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p. Tuy nhi\u00ean, n\u1ebfu ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n gi\u1eef nguy\u00ean nh\u1eefng s\u1ed1 0 \u0111\u1ee9ng tr\u01b0\u1edbc n\u00e0y th\u00ec sao?<\/p>\n<p style=\"text-align: justify\">H\u00e0m Text trong Excel c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng th\u00eam nh\u1eefng s\u1ed1 0 \u0111\u1ee9ng tr\u01b0\u1edbc nh\u1eefng con s\u1ed1 trong m\u1ed9t c\u1ed9t, ngay c\u1ea3 khi nh\u1eefng con s\u1ed1 \u0111\u00f3 kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u01b0\u01a1ng. \u0110\u01a1n gi\u1ea3n b\u1eb1ng c\u00e1ch d\u00f9ng m\u00e3 \u0111\u1ecbnh d\u1ea1ng ch\u01b0a nh\u1eefng s\u1ed1 0 v\u00e0o \u0111\u1ea7u nh\u01b0 \u201c0000000\u201d, trong \u0111\u00f3, nh\u1eefng s\u1ed1 0 ph\u1ea3i t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u0111\u01a1n v\u1ecb s\u1ed1 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 bi\u1ec3u di\u1ec5n s\u1ed1 c\u00f3 7 ch\u1eef s\u1ed1 v\u1edbi s\u1ed1 0 \u0111\u1ee9ng \u0111\u1ea7u, d\u00f9ng c\u00f4ng th\u1ee9c sau: (A2 l\u00e0 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb g\u1ed1c)<\/p>\n<p style=\"text-align: justify\"><strong><em>=TEXT(A2,\u201d0000000\u2033)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c h\u00e0m Text th\u00eam \u0111\u00e3 th\u00eam s\u1ed1 0 \u0111\u1ee9ng \u0111\u1ea7u theo y\u00eau c\u1ea7u \u0111\u1ec3 t\u1ea1o chu\u1ed7i 7 k\u00ed t\u1ef1. (L\u01b0u \u00fd: k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m Text trong Excel\u00a0 lu\u00f4n l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n, ngay c\u1ea3 khi k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u01b0\u1edfng ch\u1eebng l\u00e0 s\u1ed1).<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4810 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-3-2.png\" width=\"269\" height=\"226\" title=\"2-3-2\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CHUYEN_GIA_TRI_THANH_SO_DIEN_THOAI_THEO_MOT_DINH_DANG_NHAT_DINH\"><\/span>CHUY\u1ec2N GI\u00c1 TR\u1eca TH\u00c0NH S\u1ed0 \u0110I\u1ec6N THO\u1ea0I THEO M\u1ed8T \u0110\u1ecaNH D\u1ea0NG NH\u1ea4T \u0110\u1ecaNH<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Chuy\u1ec3n gi\u00e1 tr\u1ecb s\u1ed1 trong \u00f4 th\u00e0nh nh\u1eefng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u00f3 v\u1ebb l\u00e0 m\u1ed9t nhi\u1ec7m v\u1ee5 kh\u00f3 nh\u1eb1n, tuy nhi\u00ean, h\u00e3y nh\u1edb r\u1eb1ng h\u00e0m Text trong Excel cho ph\u00e9p s\u1eed d\u1ee5ng d\u1ea5u g\u1ea1ch ngang (-) v\u00e0 d\u1ea5u ngo\u1eb7c \u0111\u01a1n () trong m\u00e3 \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<p style=\"text-align: justify\">B\u1edfi v\u1eady, \u0111\u1ec3 bi\u1ec3u di\u1ec5n s\u1ed1 trong \u00f4 A2 theo s\u1ed1 \u0111i\u1ec7n tho\u1ea1i 7 ch\u1eef s\u1ed1 truy\u1ec1n th\u1ed1ng\u00a0 theo \u0111\u1ecbnh d\u1ea1ng 123-456, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify\">=TEXT(A2, \u201c###-####\u201d)<\/p>\n<p style=\"text-align: justify\">N\u1ebfu m\u1ed9t v\u00e0i gi\u00e1 tr\u1ecb g\u1ed1c ch\u1ee9a m\u00e3 khi v\u1ef1c (VD: c\u00f3 th\u1ec3 l\u00e0 7 ch\u1eef s\u1ed1, hay 10 ch\u1eef s\u1ed1), bao g\u1ed3m m\u00e3 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n sau \u0111\u00e2y \u0111\u1ec3 hi\u1ec3n th\u1ecb s\u1ed1 c\u00f3 10 ch\u1eef s\u1ed1 theo \u0111\u1ecbnh d\u1ea1ng (123) 246-789:<\/p>\n<p style=\"text-align: justify\">=TEXT(A2,\u201d[&lt;=9999999]###-####;(###) ###-####\u201d)<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-4811 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-4-300x111-1.png\" width=\"300\" height=\"111\" title=\"2-4-300x111-1\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_TEXT_TRONG_EXCEL_KHONG_THUC_HIEN_DUOC_%E2%80%93_NGUYEN_NHAN_VA_CACH_KHAC_PHUC\"><\/span>H\u00c0M TEXT TRONG EXCEL KH\u00d4NG TH\u1ef0C HI\u1ec6N \u0110\u01af\u1ee2C \u2013 NGUY\u00caN NH\u00c2N V\u00c0 C\u00c1CH KH\u1eaeC PH\u1ee4C<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">So v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong Excel, h\u00e0m Text \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1, t\u01b0\u1edfng nh\u01b0 kh\u00f4ng c\u00f3 ch\u00fat kh\u00f3 kh\u0103n n\u00e0o c\u1ea3n tr\u1edf. N\u1ebfu trong tr\u01b0\u1eddng h\u1ee3p h\u00e0m Text kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c, l\u00ed do c\u1ee7a h\u1ea7u h\u1ebft tr\u01b0\u1eddng h\u1ee3p l\u00e0 do sai m\u00e3 \u0111\u1ecbnh d\u1ea1ng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 2 tr\u01b0\u1eddng h\u1ee3p \u0111i\u1ec3n h\u00ecnh:<\/p>\n<ol style=\"text-align: justify\">\n<li>H\u00e0m Text tr\u1ea3 v\u1ec1 l\u1ed7i #NAME? n\u1ebfu ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng d\u00f9ng d\u1ea5u ngo\u1eb7c k\u00e9p \u201c\u201d ngo\u00e0i m\u00e3 \u0111\u1ecbnh d\u1ea1ng<\/li>\n<\/ol>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 c\u00f4ng th\u1ee9c\u00a0=TEXT(A2, mm\/dd\/yy) b\u1ecb l\u1ed7i, n\u00ean s\u1eeda th\u00e0nh: =TEXT(A2, \u201cmm\/dd\/yy\u201d)<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li style=\"text-align: justify\">H\u00e0m Text trong Excel c\u00f3 ng\u00f4n ng\u1eef \u0111\u1eb7c tr\u01b0ng, y\u00eau c\u1ea7u c\u00f3 m\u00e3 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y v\u00e0 gi\u1edd c\u1ee5 th\u1ec3.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c =TEXT(A2, \u201cmm\/dd\/yy\u201d) ho\u1ea1t \u0111\u1ed9ng t\u1ed1t v\u1edbi ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng ti\u1ebfng Anh, nh\u01b0ng nh\u1eefng v\u00f9ng kh\u00e1c th\u00ec kh\u00f4ng. \u0110i\u1ec3n h\u00ecnh, \u1edf \u0110\u1ee9c, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng sau: \u201ct\u201d thay cho \u201cd\u201d v\u00e0 \u201cj\u201d thay cho \u201cy\u201d. B\u1edfi v\u1eady, trong ph\u1ea7n m\u1ec1m Excel c\u1ee7a \u0110\u1ee9c, c\u00f4ng th\u1ee9c b\u00ean tr\u00ean s\u1ebd thay b\u1eb1ng \u00a0=TEXT(A2; \u201cmm\/tt\/jj\u201d).<\/p>\n<p style=\"text-align: justify\">Tr\u00ean \u0111\u00e2y l\u00e0 b\u00e0i gi\u1ea3ng v\u1ec1 h\u00e0m Text trong Excel, ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel:<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2wc29iW\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-137.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4095,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4094","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\/4094","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=4094"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4094\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4095"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}