{"id":286181,"date":"2023-11-19T11:04:45","date_gmt":"2023-11-19T04:04:45","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=286181"},"modified":"2023-11-19T11:04:45","modified_gmt":"2023-11-19T04:04:45","slug":"ham-text-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel chi ti\u1ebft"},"content":{"rendered":"<p><b>H\u00e0m TEXT trong Excel<\/b><span style=\"font-weight: 400;\"> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c t\u1ed1i \u01b0u. Tuy nhi\u00ean, \u0111\u1ed1i v\u1edbi nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng Excel c\u00f2n ch\u01b0a n\u1eafm \u0111\u01b0\u1ee3c c\u00fa ph\u00e1p c\u0169ng nh\u01b0 c\u00e1ch d\u00f9ng c\u1ee7a h\u00e0m TEXT. Do \u0111\u00f3, b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT cho c\u00e1c b\u1ea1n tham kh\u1ea3o nh\u00e9!\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">H\u00e0m TEXT l\u00e0 g\u00ec v\u00e0 c\u00f4ng th\u1ee9c?\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Trong Excel, h\u00e0m TEXT \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u00e1 tr\u1ecb t\u1eeb s\u1ed1 sang d\u1ea1ng v\u0103n b\u1ea3n. M\u1ee5c \u0111\u00edch c\u1ee7a thao t\u00e1c chuy\u1ec3n \u0111\u1ed5i l\u00e0 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u \u1edf \u0111\u1ecbnh d\u1ea1ng d\u1ec5 s\u1eed d\u1ee5ng v\u00e0 theo d\u00f5i h\u01a1n. Ngo\u00e0i ra, trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, h\u00e0m TEXT c\u00f2n \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 k\u1ebft h\u1ee3p c\u00e1c s\u1ed1, ng\u00e0y th\u00e1ng n\u0103m v\u1edbi v\u0103n b\u1ea3n hay k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-2-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-2-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-286501 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-2.jpg\" alt=\"ham-text-trong-excel-2\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-2-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-2-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>H\u00e0m TEXT trong Excel<\/b><span style=\"font-weight: 400;\"> c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=TEXT(value, format_text)\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">value: Ch\u00ednh l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 c\u1ea7n chuy\u1ec3n \u0111\u1ed5i c\u00f3 th\u1ec3 l\u00e0 ng\u00e0y, th\u00e1ng, \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb tham chi\u1ebfu,&#8230;<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">format_text: L\u00e0 \u0111\u1ecbnh d\u1ea1ng m\u00e0 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n \u00e1p d\u1ee5ng, m\u00e3 \u0111\u1ecbnh d\u1ea1ng s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p ch\u1eb3ng h\u1ea1n nh\u01b0: \u201cmm\/dd\/yy\u201d,&#8221;# ?\/?\u201d.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng c\u00fa ph\u00e1p h\u00e0m TEXT, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n l\u01b0u \u00fd k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n. B\u00ean c\u1ea1nh \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n th\u1ed1ng nh\u1ea5t d\u00f9ng d\u1ea5u ch\u1ea5m \u0111\u1ec3 ph\u00e2n c\u00e1ch s\u1ed1 th\u1eadp ph\u00e2n v\u00e0 d\u00f9ng d\u1ea5u ph\u1ea9y \u0111\u1ec3 ph\u00e2n c\u00e1ch h\u00e0ng ngh\u00ecn.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">H\u00e0m TEXT trong Excel c\u00f3 m\u00e3 \u0111\u1ecbnh d\u1ea1ng nh\u01b0 th\u1ebf n\u00e0o?\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Sau khi n\u1eafm \u0111\u01b0\u1ee3c c\u00fa ph\u00e1p c\u1ee7a h\u00e0m TEXT, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n bi\u1ebft m\u00e3 \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t c\u00e1ch th\u00e0nh th\u1ea1o. Sau \u0111\u00e2y l\u00e0 danh s\u00e1ch m\u00e3 \u0111\u1ecbnh d\u1ea1ng c\u01a1 b\u1ea3n nh\u1ea5t c\u1ee7a h\u00e0m TEXT m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea7n nh\u1edb:\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">M\u00e3 c\u01a1 b\u1ea3n d\u00f9ng trong h\u00e0m TEXT\u00a0<\/span><\/h3>\n<ul>\n<li><span style=\"font-weight: 400;\">M\u00e3 0 th\u1ec3 hi\u1ec7n s\u1ed1 0 v\u00f4 ngh\u0129a k\u00fd hi\u1ec7u #.00 t\u1ee9c l\u00e0 t\u00ednh \u0111\u1ebfn s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 hai. Do \u0111\u00f3, n\u1ebfu b\u1ea1n nh\u1eadp v\u00e0o \u00f4 tham chi\u1ebfu l\u00e0 2.5 s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 2.50.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">M\u00e3 # d\u00f9ng \u0111\u1ec3 ng\u0103n kh\u00f4ng bi\u1ec3u di\u1ec5n s\u1ed1 0. Ch\u1eb3ng h\u1ea1n nh\u01b0 #.## \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 t\u00ednh \u0111\u1ebfn s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 hai. Tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1eddi d\u00f9ng nh\u1eadp 2.5555 s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 2.56.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">M\u00e3 ? d\u00f9ng \u0111\u1ec3 ch\u1ec9 kho\u1ea3ng tr\u1ed1ng cho s\u1ed1 0 nh\u01b0ng kh\u00f4ng hi\u1ec3n th\u1ecb. M\u00e3 n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 s\u1eafp x\u1ebfp c\u00e1c s\u1ed1 trong c\u1ed9t cho c\u00e1c \u0111i\u1ec3m th\u1eadp ph\u00e2n. V\u00ed d\u1ee5 nh\u01b0 #.?? \u0111\u1ec3 bi\u1ec3u di\u1ec5n t\u1ed1i \u0111a hai ph\u1ea7n th\u1eadp ph\u00e2n.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">M\u00e3 . d\u00f9ng \u0111\u1ec3 ch\u1ec9 \u0111i\u1ec3m th\u1eadp ph\u00e2n nh\u01b0 ###.##\u00a0 v\u00e0 m\u00e3 , d\u00f9ng \u0111\u1ec3 ng\u0103n c\u00e1ch h\u00e0ng ngh\u00ecn nh\u01b0 ###, ###.##<\/span><\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">M\u00e3 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y, gi\u1edd trong h\u00e0m TEXT\u00a0<\/span><\/h3>\n<ul>\n<li><span style=\"font-weight: 400;\">M\u00e3 d c\u00f3 th\u1ec3 th\u1ec3 l\u00e0 m\u1ed9t ho\u1eb7c hai s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 31 d\u00f9ng \u0111\u1ec3 ch\u1ec9 ng\u00e0y. N\u1ebfu xu\u1ea5t hi\u1ec7n dd th\u00ec ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 th\u00eam s\u1ed1 0 t\u1eeb 01 \u0111\u1ebfn 31. N\u1ebfu xu\u1ea5t hi\u1ec7n ddd l\u00e0 k\u00fd t\u1ef1 vi\u1ebft t\u1eaft t\u1eeb th\u1ee9 hai \u0111\u1ebfn ch\u1ee7 nh\u1eadt b\u1eb1ng ti\u1ebfng Anh ch\u1eb3ng h\u1ea1n Mon, Sun,&#8230;<\/span><\/li>\n<li><span style=\"font-weight: 400;\">M\u00e3 m \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ch\u1ec9 s\u1ed1 th\u00e1ng khi nh\u1eadp <\/span><b>h\u00e0m TEXT trong Excel<\/b><span style=\"font-weight: 400;\">. K\u00fd hi\u1ec7u m bi\u1ec3u th\u1ecb t\u1eeb 1 \u0111\u1ebfn 12. K\u00fd hi\u1ec7u mm, ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0\u1ee3c ph\u00e9p th\u00eam m\u1ed9t s\u1ed1 0 \u1edf \u0111\u1ea7u ch\u1eb3ng h\u1ea1n t\u1eeb 01 \u0111\u1ebfn 12. K\u00fd hi\u1ec7u mmm l\u00e0 c\u00e1ch vi\u1ebft t\u1eaft c\u1ee7a th\u00e1ng nh\u01b0 Jan, Dec,&#8230; K\u00fd hi\u1ec7u mmmm l\u00e0 ng\u01b0\u1eddi d\u00f9ng vi\u1ebft \u0111\u1ea7y \u0111\u1ee7 t\u00ean th\u00e1ng trong n\u0103m.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">M\u00e3 y d\u00f9ng \u0111\u1ec3 ch\u1ec9 n\u0103m, n\u1ebfu k\u00fd hi\u1ec7u l\u00e0 yyyy t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 n\u0103m nh\u01b0 2023, 2024,&#8230;<\/span><\/li>\n<li><span style=\"font-weight: 400;\">M\u00e3 h d\u00f9ng \u0111\u1ec3 ch\u1ec9 gi\u1edd g\u1ed3m m\u1ed9t ho\u1eb7c hai ch\u1eef s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 24. N\u1ebfu m\u00e3 hh th\u00ec ng\u01b0\u1eddi d\u00f9ng th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u c\u1ee5 th\u1ec3 l\u00e0 t\u1eeb 01 \u0111\u1ebfn 24.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">M\u00e3 m d\u00f9ng \u0111\u1ec3 ch\u1ec9 ph\u00fat g\u1ed3m m\u1ed9t ho\u1eb7c hai ch\u1eef s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 60 (kh\u00f4ng c\u00f3 s\u1ed1 0 \u1edf \u0111\u1ea7u). N\u1ebfu k\u00fd hi\u1ec7u mm th\u00ec ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0\u1ee3c ph\u00e9p th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u t\u1ee9c l\u00e0 t\u1eeb 01 \u0111\u1ebfn 60.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">M\u00e3 s d\u00f9ng \u0111\u1ec3 bi\u1ec3u th\u1ecb s\u1ed1 gi\u00e2y g\u1ed3m m\u1ed9t ho\u1eb7c hai ch\u1eef s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 60 (kh\u00f4ng c\u00f3 s\u1ed1 0 \u1edf \u0111\u1ea7u). Tr\u01b0\u1eddng h\u1ee3p c\u00f3 hai m\u00e3 ss t\u1ee9c l\u00e0 ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0\u1ee3c ph\u00e9p th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u t\u1eeb 01 \u0111\u1ebfn 60.\u00a0<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel d\u1ec5 hi\u1ec3u\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">V\u1ec1 c\u01a1 b\u1ea3n, h\u00e0m TEXT c\u00f3 nhi\u1ec1u c\u00f4ng d\u1ee5ng d\u00f9ng \u0111\u1ec3 k\u1ebft n\u1ed1i v\u0103n b\u1ea3n v\u00e0 s\u1ed1 hay th\u00eam s\u1ed1 0 \u0111\u1ee9ng \u0111\u1ea7u, chuy\u1ec3n gi\u00e1 tr\u1ecb th\u00e0nh s\u1ed1,&#8230; \u0110\u1ec3 tr\u00e1nh x\u1ea3y ra l\u1ed7i, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n nh\u1eadp \u0111\u00fang c\u00fa ph\u00e1p, \u0111\u00fang gi\u00e1 tr\u1ecb tham chi\u1ebfu v\u00e0 \u0111\u1ea3m b\u1ea3o c\u00e1c d\u1ea5u \u0111i k\u00e8m. Sau \u0111\u00e2y, ch\u00fang t\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p cho c\u00e1c b\u1ea1n tham kh\u1ea3o:\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m TEXT \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong v\u0103n b\u1ea3n<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: D\u00f9ng<\/span><b> h\u00e0m TEXT trong Excel<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 b\u00ean trong chu\u1ed7i v\u0103n b\u1ea3n trong b\u1ea3ng g\u1ed3m \u0111\u01a1n gi\u00e1, s\u1ed1 l\u01b0\u1ee3ng v\u00e0 t\u1ef7 l\u1ec7. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ng\u01b0\u1eddi d\u00f9ng h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau \u0111\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c m\u1ee9c gi\u00e1.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, t\u1ea1i \u00f4 mu\u1ed1n hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u, b\u1ea1n h\u00e3y nh\u1eadp h\u00e0m = \u201cGi\u00e1 ti\u1ec1n c\u1ee7a b\u1ea1n l\u00e0\u201d&amp;TEXT(A7*B7*(1-C7), &#8220;$###,###.00&#8221;).\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-3-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-3-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-286502 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-3.jpg\" alt=\"ham-text-trong-excel-3\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-3-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-3-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ti\u1ebfp theo, b\u1ea1n h\u00e3y nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 trong b\u1ea3ng t\u00ednh.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-4-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-4-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-286503 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-4.jpg\" alt=\"ham-text-trong-excel-4\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-4-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-4-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 m\u1ecdi ng\u01b0\u1eddi hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m TEXT \u0111\u1ec3 k\u1ebft n\u1ed1i v\u0103n b\u1ea3n v\u00e0 s\u1ed1 ch\u00fang t\u00f4i s\u1ebd l\u1ea5y th\u00eam m\u1ed9t v\u00ed d\u1ee5 minh ho\u1ea1. \u0110\u1ec1 b\u00e0i y\u00eau c\u1ea7u b\u1ea1n h\u00e3y k\u1ebft h\u1ee3p v\u0103n b\u1ea3n v\u00e0 ng\u00e0y th\u00e1ng n\u0103m v\u1edbi \u0111\u1ecbnh d\u1ea1ng h\u00f4m nay l\u00e0.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, t\u1ea1i \u00f4 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 h\u00e3y nh\u1eadp ch\u00ednh x\u00e1c h\u00e0m =&#8221;H\u00f4m nay l\u00e0&#8221;&amp;TEXT(TODAY(),&#8221;dddd d mmm, yyyy&#8221;).\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-5-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-5-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-286504 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-5.jpg\" alt=\"ham-text-trong-excel-5\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-5-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-5-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n b\u1ea5m Enter tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 h\u00f4m nay l\u00e0 ng\u00e0y bao nhi\u00eau.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-6-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-6-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-286505 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-6.jpg\" alt=\"ham-text-trong-excel-6\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-6-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-6-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel \u0111\u1ec3 th\u00eam s\u1ed1 0 \u0111\u1ee9ng \u0111\u1ea7u<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Ch\u1eafc h\u1eb3n m\u1ecdi ng\u01b0\u1eddi s\u1ebd th\u1eafc m\u1eafc t\u1ea1i sao c\u1ea7n th\u00eam s\u1ed1 0 \u0111\u1ee9ng \u0111\u1ea7u m\u1ed7i d\u00e3y s\u1ed1 trong Excel. B\u1edfi khi nh\u1eadp s\u1ed1 0 \u1edf \u0111\u1ea7u ti\u00ean, b\u1ea3ng t\u00ednh s\u1ebd t\u1ef1 \u0111\u1ed9ng xo\u00e1. Ch\u1eb3ng h\u1ea1n nh\u01b0 nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i 0975 257 918 th\u00ec Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng xo\u00e1 s\u1ed1 0 v\u00e0 ch\u1ec9 hi\u1ec3n th\u1ecb 975 257 918. Sau \u0111\u00e2y, ch\u00fang t\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch th\u00eam s\u1ed1 0 v\u00e0o \u0111\u1ea7u d\u00e3y s\u1ed1 b\u1eb1ng h\u00e0m TEXT cho c\u00e1c b\u1ea1n tham kh\u1ea3o:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i b\u1ea3ng t\u00ednh Excel, ng\u01b0\u1eddi d\u00f9ng h\u00e3y nh\u1eadp h\u00e0m =TEXT(\u00f4 tham chi\u1ebfu, s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 0). V\u00ed d\u1ee5 nh\u01b0 nh\u1eadp h\u00e0m =TEXT(B4,\u201c0000\u201d).\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-7-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-7-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-286506 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-7.jpg\" alt=\"ham-text-trong-excel-7\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-7-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-7-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Sau khi nh\u1eadp c\u00fa ph\u00e1p h\u00e0m TEXT, ng\u01b0\u1eddi d\u00f9ng h\u00e3y nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-8-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-8-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-286507 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-8.jpg\" alt=\"ham-text-trong-excel-8\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-8-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-8-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel \u0111\u1ec3 chuy\u1ec3n th\u00e0nh s\u1ed1 \u0111i\u1ec7n tho\u1ea1i\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">M\u1ed9t trong nh\u1eefng c\u00f4ng d\u1ee5ng ti\u1ebfp theo c\u1ee7a h\u00e0m TEXT \u0111\u00f3 l\u00e0 d\u00f9ng \u0111\u1ec3 chuy\u1ec3n s\u1ed1 \u0111i\u1ec7n tho\u1ea1i theo \u0111\u1ecbnh d\u1ea1ng. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m TEXT trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=TEXT(B4,&#8221;[&lt;=9999999]###-####;(###)&gt;<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-9-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-9-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-286508 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-9.jpg\" alt=\"ham-text-trong-excel-9\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-9-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-9-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B4 l\u00e0 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb tham chi\u1ebfu.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[&lt;=9999999]###-####;(###)&gt;: \u0110\u00e2y l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 gi\u1edbi h\u1ea1n ch\u1eef s\u1ed1 c\u1ee7a s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0 ki\u1ec3u hi\u1ec3n th\u1ecb.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">(###) ###-####: L\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb tham chi\u1ebfu l\u1edbn h\u01a1n \u0111i\u1ec1u ki\u1ec7n gi\u1edbi h\u1ea1n.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Sau khi nh\u1eadp h\u00e0m c\u00f4ng th\u1ee9c tr\u00ean, b\u1ea1n h\u00e3y b\u1ea5m Enter tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-10-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-10-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-286509 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-10.jpg\" alt=\"ham-text-trong-excel-10\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-10-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-10-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 l\u1ed7i x\u1ea3y ra khi s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c gi\u00fap ng\u01b0\u1eddi d\u00f9ng gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n, x\u1eed l\u00fd s\u1ed1 li\u1ec7u, d\u1eef li\u1ec7u. Trong m\u1ed7i tr\u01b0\u1eddng h\u1ee3p t\u00ednh to\u00e1n, ng\u01b0\u1eddi d\u00f9ng s\u1ebd \u00e1p d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c ri\u00eang. Tuy nhi\u00ean, \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n nh\u1eadp \u0111\u00fang h\u00e0m v\u00e0 c\u00e1c y\u1ebfu t\u1ed1 li\u00ean quan. Sau \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u1ed7i x\u1ea3y ra \u0111\u1ed1i v\u1edbi h\u00e0m TEXT m\u00e0 c\u00e1c b\u1ea1n c\u1ea7n l\u01b0u \u00fd:\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i #NAME? xu\u1ea5t hi\u1ec7n khi s\u1eed d\u1ee5ng h\u00e0m TEXT<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 l\u1ed7i ph\u1ed5 bi\u1ebfn, th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng <\/span><b>h\u00e0m TEXT trong Excel<\/b><span style=\"font-weight: 400;\">. Nguy\u00ean nh\u00e2n d\u1eabn t\u1edbi l\u1ed7i n\u00e0y l\u00e0 do ng\u01b0\u1eddi d\u00f9ng b\u1ecb thi\u1ebfu ho\u1eb7c kh\u00f4ng d\u00f9ng d\u1ea5u ngo\u1eb7c k\u00e9p cho m\u00e3 \u0111\u1ecbnh d\u1ea1ng. \u0110\u1ec3 d\u1ec5 h\u00ecnh dung h\u01a1n, ch\u00fang t\u00f4i s\u1ebd l\u1ea5y v\u00ed d\u1ee5 nh\u01b0 =TEXT(D2, mm\/dd\/yy). N\u1ebfu b\u1ea1n nh\u1eadp h\u00e0m TEXT nh\u01b0 v\u1eady s\u1ebd d\u1eabn t\u1edbi l\u1ed7i #NAME?\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-11-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-11-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-286510 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-11.jpg\" alt=\"ham-text-trong-excel-11\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-11-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-11-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Do \u0111\u00f3, \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i #NAME? khi s\u1eed d\u1ee5ng h\u00e0m TEXT, ng\u01b0\u1eddi d\u00f9ng h\u00e3y th\u00eam d\u1ea5u ngo\u1eb7c k\u00e9p v\u00e0o m\u00e3 \u0111\u1ecbnh d\u1ea1ng =TEXT(D2, \u201cmm\/dd\/yy\u201d).\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">Excel b\u00e1o l\u1ed7i\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Khi nh\u1eadp<\/span><b> h\u00e0m TEXT trong Excel<\/b><span style=\"font-weight: 400;\"> nh\u01b0ng kh\u00f4ng t\u00ednh \u0111\u01b0\u1ee3c c\u00f3 th\u1ec3 do ng\u01b0\u1eddi d\u00f9ng nh\u1eadp sai c\u00fa ph\u00e1p. Ho\u1eb7c tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1eddi d\u00f9ng copy c\u00f4ng th\u1ee9c nh\u01b0ng b\u1ecb sai \u0111\u1ecbnh d\u1ea1ng d\u1ea5u ngo\u1eb7c k\u00e9p d\u1eabn \u0111\u1ebfn kh\u00f4ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ng\u01b0\u1eddi d\u00f9ng hay th\u1ef1c hi\u1ec7n d\u1ea5u ngo\u1eb7c k\u00e9p c\u0169 v\u00e0 thay v\u00e0o \u0111\u00f3 l\u00e0 d\u1ea5u ngo\u1eb7c k\u00e9p m\u1edbi.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-12-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-12-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-286511 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-12.jpg\" alt=\"ham-text-trong-excel-12\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-12-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-12-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">M\u1ed9t nguy\u00ean nh\u00e2n n\u1eefa d\u1eabn t\u1edbi Excel b\u00e1o l\u1ed7i khi d\u00f9ng h\u00e0m TEXT \u0111\u00f3 l\u00e0 s\u1ef1 kh\u00e1c nhau trong thi\u1ebft l\u1eadp ph\u1ea7n m\u1ec1m. M\u1ed7i ph\u1ea7n m\u1ec1m Excel \u1edf m\u1ed7i n\u01b0\u1edbc s\u1ebd c\u00f3 m\u00e3 \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau. V\u00ec v\u1eady, ng\u01b0\u1eddi d\u00f9ng h\u00e3y ki\u1ec3m tra phi\u00ean b\u1ea3n Excel \u0111ang s\u1eed d\u1ee5ng \u0111\u1ec3 ki\u1ec3m tra c\u00fa ph\u00e1p \u0111\u00fang kh\u00f4ng?\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-13-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-text-trong-excel-13-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-286512 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-13.jpg\" alt=\"ham-text-trong-excel-13\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-13-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel-13-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel c\u1ea7n nh\u1edb\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">T\u1edbi \u0111\u00e2y ch\u1eafc m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 hi\u1ec3u h\u01a1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p. \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m TEXT hi\u1ec7u qu\u1ea3, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n n\u1eafm ch\u1eafc c\u00fa ph\u00e1p, m\u00e3 \u0111\u1ecbnh d\u1ea1ng v\u00e0 linh ho\u1ea1t trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p. Sau \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd s\u1eed d\u1ee5ng h\u00e0m TEXT m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea7n n\u1eafm \u0111\u01b0\u1ee3c:\u00a0<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">N\u1ebfu s\u1eed d\u1ee5ng h\u00e0m TEXT \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i s\u1ed1 th\u00e0nh v\u0103n b\u1ea3n s\u1ebd g\u00e2y kh\u00f3 kh\u0103n trong vi\u1ec7c t\u00ednh to\u00e1n. Ng\u01b0\u1eddi d\u00f9ng c\u1ea7n nh\u1edb, k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m TEXT l\u00e0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. Nhi\u1ec1u ng\u01b0\u1eddi nh\u1ea7m l\u1eabn b\u1edfi n\u00f3 c\u00f3 h\u00ecnh th\u1ee9c gi\u1ed1ng v\u1edbi d\u00e3y s\u1ed1 d\u1eabn t\u1edbi kh\u00f4ng \u0111\u00fang v\u1edbi k\u1ebft qu\u1ea3 m\u00ecnh \u0111ang c\u1ea7n. V\u00ec v\u1eady, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n hi\u1ec3u c\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m TEXT \u0111\u1ec3 tr\u00e1nh x\u1ea3y ra sai s\u00f3t, nh\u1ea7m l\u1eabn.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Ngo\u00e0i ra, khi d\u00f9ng h\u00e0m TEXT b\u1ea1n n\u00ean gi\u1eef l\u1ea1i gi\u00e1 tr\u1ecb g\u1ed1c v\u00e0 d\u00f9ng \u00f4 kh\u00e1c \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. \u0110i\u1ec1u n\u00e0y gi\u00fap ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 tham chi\u1ebfu v\u1edbi gi\u00e1 tr\u1ecb g\u1ed1c m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, tr\u00e1nh t\u00ednh nh\u1ea7m k\u1ebft qu\u1ea3. \u0110\u1ed3ng th\u1eddi, khi nh\u1eadp c\u00fa ph\u00e1p h\u00e0m TEXT c\u1ea7n \u0111\u1ea3m b\u1ea3o c\u00f3 \u0111\u1ea7y \u0111\u1ee7 c\u00e1c th\u00e0nh ph\u1ea7n c\u1ea7n thi\u1ebft. Trong m\u1ed7i tr\u01b0\u1eddng h\u1ee3p d\u00f9ng h\u00e0m TEXT \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ebd c\u00f3 c\u00fa ph\u00e1p kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t n\u00ean ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ch\u00fa \u00fd.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m TEXT, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n th\u00eam d\u1ea5u ngo\u1eb7c k\u00e9p \u1edf m\u00e3 \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 tr\u00e1nh x\u1ea3y ra l\u1ed7i. Trong tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1eddi d\u00f9ng nh\u1eadp \u0111\u00fang c\u00fa ph\u00e1p th\u00ec th\u1ef1c hi\u1ec7n gi\u1eef v\u00e0 k\u00e9o \u00f4 vu\u00f4ng xu\u1ed1ng nh\u1eefng c\u1ed9t ti\u1ebfp theo m\u00e0 kh\u00f4ng c\u1ea7n nh\u1eadp l\u1ea1i h\u00e0m.\u00a0<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">T\u1ea1m K\u1ebft\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">B\u00e0i vi\u1ebft tr\u00ean, ch\u00fang t\u00f4i \u0111\u00e3 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng <\/span><b>h\u00e0m TEXT trong Excel<\/b><span style=\"font-weight: 400;\"> cho c\u00e1c b\u1ea1n tham kh\u1ea3o. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m r\u1ea5t h\u1eefu \u00edch, gi\u00fap ng\u01b0\u1eddi d\u00f9ng gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT trong tr\u01b0\u1eddng h\u1ee3p k\u1ebft n\u1ed1i v\u0103n b\u1ea3n v\u1edbi s\u1ed1, th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u hay chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i h\u01b0\u1edbng d\u1eabn chi ti\u1ebft. B\u00ean c\u1ea1nh \u0111\u00f3, khi s\u1eed d\u1ee5ng h\u00e0m TEXT, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ch\u00fa \u00fd \u0111\u1ebfn d\u1ea5u ngo\u1eb7c k\u00e9p, nh\u1eadp \u0111\u00fang c\u00fa ph\u00e1p \u0111\u1ec3 h\u1ec7 th\u1ed1ng tr\u1ea3 k\u1ebft qu\u1ea3 nhanh ch\u00f3ng, ch\u00ednh x\u00e1c. H\u00e3y b\u1ea5m follow fanpage <\/span><a href=\"https:\/\/www.facebook.com\/hoanghamobilecom\/?locale=vi_VN\"><b>Ho\u00e0ng H\u00e0 Mobile<\/b><\/a><span style=\"font-weight: 400;\"> v\u00e0 k\u00eanh Youtube <\/span><a href=\"https:\/\/www.youtube.com\/channel\/UCJm_GdFJzT8h1odq1oMu_7Q\"><b>Ho\u00e0ng H\u00e0 Channel<\/b><\/a><span style=\"font-weight: 400;\"> \u0111\u1ec3 c\u00f3 th\u00eam nhi\u1ec1u th\u00f4ng tin h\u1eefu \u00edch nh\u00e9<\/span><span style=\"font-weight: 400;\">!<\/span><\/p>\n<p><strong>XEM TH\u00caM:\u00a0<\/strong><\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-max\/\">C\u00e1ch d\u00f9ng h\u00e0m MIN, MAX trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u nh\u1ea5t<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-subtotal\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL trong Excel d\u1ec5 hi\u1ec3u k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-datedif\/\">C\u00e1ch d\u00f9ng h\u00e0m DATEDIF t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa 2 ng\u00e0y trong Google Sheet<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m TEXT trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c t\u1ed1i \u01b0u. Tuy nhi\u00ean, \u0111\u1ed1i v\u1edbi nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng Excel c\u00f2n ch\u01b0a n\u1eafm \u0111\u01b0\u1ee3c c\u00fa ph\u00e1p c\u0169ng nh\u01b0 c\u00e1ch d\u00f9ng c\u1ee7a h\u00e0m TEXT. Do \u0111\u00f3, b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed [&hellip;]<\/p>\n","protected":false},"author":73,"featured_media":286500,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-286181","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel chi ti\u1ebft, v\u00ed d\u1ee5 minh h\u1ecda<\/title>\n<meta name=\"description\" content=\"H\u00e0m TEXT trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-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 TEXT trong Excel chi ti\u1ebft\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m TEXT trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-19T04:04:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1ed3ng Th\u01a1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"H\u1ed3ng Th\u01a1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/\"},\"author\":{\"name\":\"H\u1ed3ng Th\u01a1\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/fca08f68130533c2fcfd9928f5016a15\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel chi ti\u1ebft\",\"datePublished\":\"2023-11-19T04:04:45+00:00\",\"dateModified\":\"2023-11-19T04:04:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/\"},\"wordCount\":2900,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel chi ti\u1ebft, v\u00ed d\u1ee5 minh h\u1ecda\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel.jpg\",\"datePublished\":\"2023-11-19T04:04:45+00:00\",\"dateModified\":\"2023-11-19T04:04:45+00:00\",\"description\":\"H\u00e0m TEXT trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-text-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel chi ti\u1ebft\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/fca08f68130533c2fcfd9928f5016a15\",\"name\":\"H\u1ed3ng Th\u01a1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g\",\"caption\":\"H\u1ed3ng Th\u01a1\"},\"description\":\"M\u00ecnh l\u00e0 Th\u01a1 - c\u00f4 g\u00e1i \u0111am m\u00ea vi\u1ebft l\u00e1ch, th\u00edch tr\u1ea3i nghi\u1ec7m nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 m\u1edbi!\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/hong-tho\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel chi ti\u1ebft, v\u00ed d\u1ee5 minh h\u1ecda","description":"H\u00e0m TEXT trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel chi ti\u1ebft","og_description":"H\u00e0m TEXT trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-11-19T04:04:45+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel.jpg","type":"image\/jpeg"}],"author":"H\u1ed3ng Th\u01a1","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1ed3ng Th\u01a1","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/"},"author":{"name":"H\u1ed3ng Th\u01a1","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/fca08f68130533c2fcfd9928f5016a15"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel chi ti\u1ebft","datePublished":"2023-11-19T04:04:45+00:00","dateModified":"2023-11-19T04:04:45+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/"},"wordCount":2900,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel chi ti\u1ebft, v\u00ed d\u1ee5 minh h\u1ecda","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel.jpg","datePublished":"2023-11-19T04:04:45+00:00","dateModified":"2023-11-19T04:04:45+00:00","description":"H\u00e0m TEXT trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-text-trong-excel.jpg","width":1200,"height":628,"caption":"ham-text-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-text-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT trong Excel chi ti\u1ebft"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/fca08f68130533c2fcfd9928f5016a15","name":"H\u1ed3ng Th\u01a1","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g","caption":"H\u1ed3ng Th\u01a1"},"description":"M\u00ecnh l\u00e0 Th\u01a1 - c\u00f4 g\u00e1i \u0111am m\u00ea vi\u1ebft l\u00e1ch, th\u00edch tr\u1ea3i nghi\u1ec7m nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 m\u1edbi!","url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/hong-tho\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/286181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/73"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=286181"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/286181\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/286500"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=286181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=286181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=286181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}