{"id":6104,"date":"2024-12-21T13:34:13","date_gmt":"2024-12-21T13:34:13","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua\/"},"modified":"2024-12-21T13:34:13","modified_gmt":"2024-12-21T13:34:13","slug":"cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua\/","title":{"rendered":"C\u00e1c H\u00e0m Text Trong Excel: 19 C\u00e1ch Gi\u00fap X\u1eed L\u00fd V\u0103n B\u1ea3n Hi\u1ec7u Qu\u1ea3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00e0ng n\u00e0y c\u00f4ng vi\u1ec7c kinh doanh c\u1ee7a b\u1ea1n t\u1ea1o ra h\u00e0ng tri\u1ec7u d\u1eef li\u1ec7u v\u00e0 h\u1ea7u h\u1ebft ch\u00fang kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo c\u1ea5u tr\u00fac, th\u1eadm ch\u00ed c\u00f4ng ngh\u1ec7 t\u1ed1t nh\u1ea5t tr\u00ean th\u1ebf gi\u1edbi hi\u1ec7n nay c\u0169ng kh\u00f4ng th\u1ec3 cho ra nh\u1eefng d\u1eef li\u1ec7u s\u1eb5n c\u00f3 \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 d\u1ef1a v\u00e0o ch\u00fang m\u00e0 ra quy\u1ebft \u0111\u1ecbnh ngay \u0111\u01b0\u1ee3c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9855\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/24-09-01-300x163-1.png\" width=\"600\" height=\"326\" title=\"24-09-01-300x163-1\"><\/p>\n<p>\u0110\u1ea5y l\u00e0 l\u00fd do v\u00ec sao m\u00e0 ch\u00fang ta ph\u1ea3i ph\u1ee5 thu\u1ed9c nhi\u1ec1u v\u00e0o MS Excel t\u1eeb nh\u1eefng \u0111i\u1ec1u \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1eadp nh\u1ea5t.<\/p>\n<p>B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u th\u00eam v\u1ec1 c\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html\">h\u00e0m v\u0103n b\u1ea3n trong Excel<\/a>\u00a0v\u00e0 l\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 \u00e1p d\u1ee5ng ch\u00fang m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 khi ph\u00e2n t\u00edch d\u1eef li\u1ec7u theo h\u1ec7 th\u1ed1ng.<\/p>\n<p>Danh s\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html\">c\u00e1c h\u00e0m x\u1eed l\u00fd v\u0103n b\u1ea3n trong Exce<\/a>l<\/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-6766c3d4636c4\" 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\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_CONCATENATE\" title=\"H\u00e0m CONCATENATE\">H\u00e0m CONCATENATE<\/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\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_EXACT\" title=\"H\u00e0m EXACT ( )\">H\u00e0m EXACT ( )<\/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\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_FIND\" title=\"H\u00e0m FIND\">H\u00e0m FIND<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_LEFT\" title=\"H\u00e0m LEFT\">H\u00e0m LEFT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_LEN\" title=\"H\u00e0m LEN\">H\u00e0m LEN<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_LOWER\" title=\"H\u00e0m LOWER\">H\u00e0m LOWER<\/a><\/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\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_MID\" title=\"H\u00e0m MID\">H\u00e0m MID<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_PROPER\" title=\"H\u00e0m PROPER\">H\u00e0m PROPER<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_REPLACE\" title=\"H\u00e0m REPLACE\n\">H\u00e0m REPLACE<br \/>\n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_REPT\" title=\"H\u00e0m REPT\">H\u00e0m REPT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_SEARCH\" title=\"H\u00e0m SEARCH\n\">H\u00e0m SEARCH<br \/>\n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_RIGHT\" title=\"H\u00e0m RIGHT\">H\u00e0m RIGHT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_SUBSTITUE\" title=\"H\u00e0m SUBSTITUE\">H\u00e0m SUBSTITUE<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_TRIM\" title=\"H\u00e0m TRIM\">H\u00e0m TRIM<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ham_UPPER\" title=\"H\u00e0m UPPER\">H\u00e0m UPPER<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_CONCATENATE\"><\/span><strong>H\u00e0m CONCATENATE<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m n\u00e0y cho ph\u00e9p n\u1ed1i hai hay nhi\u1ec1u chu\u1ed7i v\u0103n b\u1ea3n v\u1edbi nhau , max l\u00e0 255<\/p>\n<p>C\u00fa ph\u00e1p:\u00a0 CONCATENATE (text1, [text2],\u2026)<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-548.gif\" title=\"ex101_92019-nho-548\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Text 1: V\u0103n b\u1ea3n \u0111\u1ea7u ti\u00ean b\u1ea1n mu\u1ed1n th\u00eam<\/p>\n<p>Text 2: Th\u1ee9 hai, ba , b\u1ed1n\u2026 cho \u0111\u1ebfn 255<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 1: N\u1ed1i t\u00ean ch\u00ednh \u1edf c\u1ed9t A v\u1edbi t\u00ean \u0111\u1ec7m \u1edf c\u1ed9t B<\/p>\n<p>Ta c\u00f3:<\/p>\n<p>=CONCATENATE(A2,\u201d.\u201d,B2)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9856\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/24-09-02-300x61-1.png\" width=\"600\" height=\"123\" title=\"24-09-02-300x61-1\"><\/p>\n<p>Trong c\u00f4ng th\u1ee9c tr\u00ean A1 v\u00e0 B2 l\u00e0 c\u00e1c \u00f4 d\u1eef li\u1ec7u c\u00f2n d\u1ea5u ch\u1ea5m \u0111\u1ec3 ph\u00e2n t\u00e1ch gi\u1eefa t\u00ean ch\u00ednh v\u00e0 t\u00ean \u0111\u1ec7m<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 b\u1ea1n c\u00f3 th\u1ec3 th\u00eam c\u00e1c k\u00fd hi\u1ec7u kh\u00e1c nh\u01b0 , \u2013 * etc.<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 2: V\u00ec ch\u00fang ta \u0111\u00e3 c\u00f3 c\u1ed9t C g\u1ed3m c\u1ea3 t\u00ean ch\u00ednh v\u00e0 t\u00ean \u0111\u1ec7m n\u00ean gi\u1edd h\u00e3y chuy\u1ec3n ch\u00fang v\u1ec1 d\u1ea1ng email b\u1eb1ng c\u00e1ch th\u00eam \u201c@xyz.com\u201d \u1edf cu\u1ed1i.<\/p>\n<p>\u0110\u00e2y l\u00e0 c\u00f4ng th\u1ee9c:<\/p>\n<p>=CONCATENATE(C2,\u201d@xyz.com\u201d)<\/p>\n<p>= <a href=\"mailto:Lillie.Merrit@xyz.com\">Lillie.Merrit@xyz.com<\/a><\/p>\n<p>Trong c\u00f4ng th\u1ee9c n\u00e0y, l\u1ea5y \u00f4 C2 b\u1edfi v\u00ec n\u00f3 l\u00e0 n\u01a1i m\u00e0 ch\u00fang ta v\u1eeba t\u1ea1o c\u00f4ng th\u1ee9c n\u1ed1i t\u00ean ch\u00ednh v\u00e0 t\u00ean \u0111\u1ec7m v\u1edbi nhau.<\/p>\n<p>\u201c@xyz.com\u201d l\u00e0 ph\u1ea7n m\u1edf r\u1ed9ng c\u1ee7a e-mail,n\u00f3 c\u0169ng gi\u1ed1ng nh\u01b0 : @hp.com. @oracle.com..<\/p>\n<p>L\u01b0u \u00fd: b\u1ea1n c\u00f3 th\u1ec3 n\u1ed1i b\u1ea5t k\u00ec v\u0103n b\u1ea3n n\u00e0o nh\u01b0ng ch\u00fang ph\u1ea3i n\u1eb1m gi\u1eefa hai d\u1ea5u ngo\u1eb7c k\u00e9p theo c\u00f4ng th\u1ee9c \u201cyour text\u201d.<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 3:\u00a0 B\u00e2y gi\u1edd ch\u00fang ta \u0111\u00e3 c\u00f3 \u0111\u1ecba ch\u1ec9 e-mail \u1edf c\u1ed9t D, v\u1edbi n\u00f3 ta c\u00f3 th\u1ec3 g\u1eedi email \u0111\u1ebfn t\u1ea5t c\u1ea3 m\u1ecdi ng\u01b0\u1eddi. Nh\u01b0ng \u0111i\u1ec1u b\u1ea1n ph\u1ea3i l\u00e0m l\u00e0 copy paste t\u1ea5t c\u1ea3 email n\u00e0y cho ch\u00fang n\u1eb1m c\u1ea1nh nhau \u0111\u1ec3 g\u1eedi \u0111\u1ed3ng lo\u1ea1t.<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u1eady \u0111\u1ec3 t\u1ea1o ra m\u1ed9t mailing list, c\u00f3 2 b\u01b0\u1edbc trong c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p>B\u01b0\u1edbc 1: N\u1ed1i mail \u0111\u1ea7u ti\u00ean v\u00e0 mail th\u1ee9 hai v\u00e0o \u00f4 E2<\/p>\n<p>=CONCATENATE(D2,\u201d;\u201d,D3)<\/p>\n<p>B\u01b0\u1edbc 2: N\u1ed1i \u00f4 E2 v\u1edbi \u00f4 D4 \u0111\u1ec3 khi ch\u00fang ta k\u00e9o c\u00f4ng th\u1ee9c \u0111\u1ebfn h\u00e0ng cu\u1ed1i n\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u1ea1o th\u00e0nh m\u1ed9t mailing list.<\/p>\n<p>=CONCATENATE(E2,\u201d;\u201d,D4)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9857\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/24-09-03-300x103-1.png\" width=\"600\" height=\"206\" title=\"24-09-03-300x103-1\"><\/p>\n<p>E2: l\u00e0 \u00f4 n\u1ed1i mail \u0111\u1ea7u ti\u00ean vs mail th\u1ee9 hai<\/p>\n<p>D4: l\u00e0 mail ti\u1ebfp theo mu\u1ed1n th\u00eam trong mailing list<\/p>\n<p>Note: \u0111\u1eebng l\u1ef1a ch\u1ecdn D3 cho c\u00f4ng th\u1ee9c s\u1ed1 2 b\u1edfi v\u00ec n\u00f3 s\u1ebd th\u00eam m\u1ed7i \u0111\u1ecba ch\u1ec9 email \u0111\u1ebfn 2 l\u1ea7n<\/p>\n<p>Cu\u1ed1i c\u00f9ng, \u0111i \u0111\u1ebfn h\u00e0ng cu\u1ed1i c\u00f9ng \u0111\u1ec3 xem mailing list<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_EXACT\"><\/span><strong>H\u00e0m EXACT ( )<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u00e2y l\u00e0 h\u00e0m so s\u00e1nh hai v\u0103n b\u1ea3n xem li\u1ec7u ch\u00fang c\u00f3 gi\u1ed1ng nhau hay kh\u00f4ng? N\u1ebfu \u201cc\u00f3\u201d k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 \u201cTrue\u201d,\u201d kh\u00f4ng\u201d l\u00e0 \u201cFalse\u201d<\/p>\n<p>C\u00fa ph\u00e1p: EXACT(text1, text2)<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 4: Trong <em>V\u00ed d\u1ee5<\/em> n\u00e0y, ch\u00fang ta so s\u00e1nh t\u00ean c\u00e1c saleman \u0111\u1ec3 ki\u1ec3m tra s\u1ef1 ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u t\u1eeb hai ngu\u1ed3n kh\u00e1c nhau<\/p>\n<p>=EXACT(A2,B2)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9858\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/24-09-04-300x88-1.png\" width=\"600\" height=\"176\" title=\"24-09-04-300x88-1\"><\/p>\n<p>Nh\u00ecn v\u00e0o <em>V\u00ed d\u1ee5<\/em>, ta \u0111ang xem li\u1ec7u t\u00ean \u1edf c\u1ed9t A c\u00f3 n\u1ed1i v\u1edbi \u0111\u00fang d\u00f2ng trong c\u1ed9t B hay kh\u00f4ng.<\/p>\n<p>\u1ede \u00f4 C2 cho ra k\u1ebft qu\u1ea3 l\u00e0 \u201cFalse\u201d b\u1edfi 2 t\u00ean kh\u00f4ng gi\u1ed1ng nhau, c\u00f2n \u00f4 C4 ra \u201c False\u201d l\u00e0 do ch\u1eef D kh\u00f4ng vi\u1ebft hoa.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_FIND\"><\/span><strong>H\u00e0m FIND<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m\u00a0 find n\u00e0y tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n b\u1ea1n mu\u1ed1n t\u00ecm.<br \/>\nXem th\u00eam: <strong>C\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-find-va-search-voi-cac-cong-thuc-vi-du.html\">h\u00e0m d\u00f2 t\u00ecm k\u00fd t\u1ef1 trong excel<\/a><\/strong><\/p>\n<p>C\u00fa ph\u00e1p: FIND(find_text, within_text, [start_num])<\/p>\n<p>find_text: v\u0103n b\u1ea3n b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm (chu\u1ed7i con)<\/p>\n<p>within_text: v\u0103n b\u1ea3n \u0111\u00edch, ch\u1ee9a chu\u1ed7i mu\u1ed1n t\u00ecm (chu\u1ed7i m\u1eb9)<\/p>\n<p>[start_num]: b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ecdn \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u t\u1eeb n\u01a1i b\u1ea1n mu\u1ed1n ki\u1ec3m tra trong within_text<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 5:<\/p>\n<p>Trong tr\u01b0\u1eddn h\u1ee3p n\u00e0y, ch\u00fang ta c\u00f3 t\u00ean c\u1ee7a m\u1ed9t c\u00f4ng nh\u00e2n b\u00ean d\u01b0\u1edbi, b\u1ea1n h\u00e3y t\u00ecm v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u c\u1ee7a t\u00ean \u0111\u1ec7m (d\u1ea5u ch\u1ea5m)<\/p>\n<p>=FIND(\u201c.\u201d,\u201dBarry.Chee\u201d) = 6<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_LEFT\"><\/span><strong>H\u00e0m LEFT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m l\u1ea5y ra ch\u00ednh x\u00e1c s\u1ed1 k\u00fd t\u1ef1 t\u1eeb v\u0103n b\u1ea3n cho tr\u01b0\u1edbc<\/p>\n<p>C\u00fa ph\u00e1p: LEFT(text, [num_chars])<\/p>\n<p>Text: v\u0103n b\u1ea3n<\/p>\n<p>[num_chars]): s\u1ed1 k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n t\u00e1ch ra<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 6: Trong b\u00e0i n\u00e0y, ch\u00fang ta c\u00f3 m\u1ed9t danh s\u00e1ch s\u1ea3n ph\u1ea9m bao g\u1ed3m c\u1ea3 m\u00e3 s\u1ea3n ph\u1ea9m, b\u00e2y gi\u1edd h\u00e3y l\u1ea5y ra ch\u1ec9 m\u00e3 s\u1ea3n ph\u1ea9m \u0111\u1ec3 t\u00e1ch ch\u00fang th\u00e0nh c\u1ed9t ri\u00eang bi\u1ec7t. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p>=LEFT(A2,6)<\/p>\n<p>A2: v\u0103n b\u1ea3n<\/p>\n<p>6: b\u1ea1n mu\u1ed1n l\u1ea5y 6 k\u00fd t\u1ef1 \u0111\u1ea7u t\u1eeb b\u00ean tr\u00e1i sang<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9861\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/29-04-05-1-300x117-1.png\" width=\"600\" height=\"234\" title=\"29-04-05-1-300x117-1\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9859\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/29-04-05-300x117-1.png\" width=\"300\" height=\"117\" title=\"29-04-05-300x117-1\"><\/p>\n<p>K\u1ebft h\u1ee3p h\u00e0m Left v\u00e0 Find<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m c\u00e1c ph\u00e2n t\u00edch ph\u1ee9c t\u1eadp b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p 2-3 c\u00f4ng th\u1ee9c .<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 7: Ch\u00fang ta th\u1ea5y s\u1ed1 v\u00e0 t\u00ean c\u1ee7a c\u00f4ng nh\u00e2n \u1edf chung m\u1ed9t c\u1ed9t, b\u00e2y gi\u1edd h\u00e3y t\u00e1ch l\u1ea5y s\u1ed1<\/p>\n<p>V\u1ea5n \u0111\u1ec1 l\u00e0 c\u00e1c s\u1ed1 n\u00e0y kh\u00f4ng c\u00f3 s\u1ed1 k\u00fd t\u1ef1 c\u1ee5 th\u1ec3, c\u00f3 ng\u01b0\u1eddi c\u00f3 3 s\u1ed1, c\u00f3 ng\u01b0\u1eddi c\u00f3 5 s\u1ed1<\/p>\n<p>Ch\u00fang ta s\u1ebd chia c\u00f4ng th\u1ee9c th\u00e0nh 2 ph\u1ea7n, \u0111\u1ea7u ti\u00ean l\u00e0 x\u00e1c \u0111\u1ecbnh s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n t\u00e1ch, \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m FIND<\/p>\n<p>B\u01b0\u1edbc 1:<\/p>\n<p>FIND(\u201d \u201c,A2)\u00a0 = 7<\/p>\n<p>Trong find_text, th\u00eam kho\u1ea3ng tr\u1ed1ng \u201c \u201c\u0111\u1ec3 ch\u1ec9 r\u1eb1ng ch\u00fang ta mu\u1ed1n t\u00ecm ki\u1ebfm kho\u1ea3ng tr\u1ed1ng trong chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n<p>A2 l\u00e0 v\u0103n b\u1ea3n g\u1ed1c<\/p>\n<p>V\u1edbi c\u00f4ng th\u1ee9c n\u00e0y b\u1ea1n s\u1ebd th\u1ea5y s\u1ed1 ch\u1eef c\u00e1i c\u1ea7n t\u00e1ch d\u1ef1a tr\u00ean v\u1ecb tr\u00ed c\u1ee7a kho\u1ea3ng tr\u1ed1ng<\/p>\n<p>B\u01b0\u1edbc 2:<\/p>\n<p>LEFT(A2,FIND(\u201d \u201c,A2))<\/p>\n<p>\u0110\u1ec3 \u00fd r\u1eb1ng khi d\u00f9ng h\u00e0m FIND \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh \u00a0s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n t\u00e1ch ra, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 theo mong mu\u1ed1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9862\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/24-09-06-300x103-1.png\" width=\"600\" height=\"207\" title=\"24-09-06-300x103-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_LEN\"><\/span><strong>H\u00e0m LEN<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m n\u00e0y \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong v\u0103n b\u1ea3n<\/p>\n<p>C\u00fa ph\u00e1p: LEN(text)<\/p>\n<p>LEN l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i b\u1edfi h\u1ea7u h\u1ebft c\u00e1c chuy\u00ean gia Excel.<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 8: Trong <em>V\u00ed d\u1ee5<\/em> n\u00e0y, ch\u00fang ta c\u00f3 \u0111\u1ecba ch\u1ec9 e-mail \u1edf trong m\u1ed9t c\u1ed9t, c\u00f3 bao nhi\u00eau k\u00fd t\u1ef1 trong m\u1ed7i e-mail?<\/p>\n<p>LEN(\u201cLillie.Merrit@xyz.com\u201d)\u00a0 = 21<\/p>\n<p>Note: LEN c\u0169ng \u0111\u1ebfm c\u1ea3 kho\u1ea3ng tr\u1ed1ng<\/p>\n<p>S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m Len v\u1edbi Left<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 9: Ch\u00fang ta s\u1eed d\u1ee5ng \u0111\u1ecba ch\u1ec9 email t\u1eeb <em>V\u00ed d\u1ee5<\/em> tr\u01b0\u1edbc, b\u00e2y gi\u1edd h\u00e3y t\u00e1ch t\u00ean c\u1ee7a c\u00e1c c\u00f4ng nh\u00e2n t\u1eeb \u0111\u1ecba ch\u1ec9 mail n\u00e0y.<\/p>\n<p>=LEFT(A2,LEN(A2)-8)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9863\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/24-09-07-300x100-1.png\" width=\"600\" height=\"200\" title=\"24-09-07-300x100-1\"><\/p>\n<p>A2 l\u00e0 v\u0103n b\u1ea3n- \u0111\u1ecba ch\u1ec9 mail<\/p>\n<p>LEN(A2): \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong mail<\/p>\n<p>-8: tr\u1eeb \u0111i s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a \u201c@xyz.com\u201d<\/p>\n<p>V\u1eady, ch\u00fang ta \u0111ang s\u1eed d\u1ee5ng h\u00e0m Len \u0111\u1ec3 \u0111\u1ebfm to\u00e0n b\u1ed9 k\u00fd t\u1ef1 v\u00e0 tr\u1eeb 8 k\u00fd t\u1ef1 \u0111\u1ec3 c\u00f2n l\u1ea1i c\u00e1c k\u00fd t\u1ef1 (t\u00ean) c\u1ea7n t\u00e1ch ra.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_LOWER\"><\/span><strong>H\u00e0m LOWER<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m chuy\u1ec3n t\u1ea5t c\u1ea3 v\u0103n b\u1ea3n v\u1ec1 d\u1ea1ng ch\u1eef c\u00e1i th\u01b0\u1eddng<\/p>\n<p>C\u00fa ph\u00e1p: LOWER(text)<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 10: Trong <em>V\u00ed d\u1ee5<\/em> n\u00e0y ch\u00fang ta c\u00f3 v\u0103n b\u1ea3n vi\u1ebft hoa,b\u00e2y gi\u1edd h\u00e3y chuy\u1ec3n ch\u00fang sang ki\u1ec3u ch\u1eef th\u01b0\u1eddng.<\/p>\n<p>=LOWER(\u201cHELLO JAY GOOD MORNING..!!\u201d) = hello jay good morning..!!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_MID\"><\/span><strong>H\u00e0m MID<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m n\u00e0y l\u1ea5y gi\u00e1 tr\u1ecb \u1edf gi\u1eefa v\u0103n b\u1ea3n theo \u00fd c\u1ee7a ng\u01b0\u1eddi d\u00f9ng<\/p>\n<p>C\u00fa ph\u00e1p: MID(text, start_num, num_chars)<\/p>\n<p>Text: v\u0103n b\u1ea3n b\u1ea1n mu\u1ed1n l\u1ea5y k\u00fd t\u1ef1<\/p>\n<p>Start_num: \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u l\u1ea5y k\u00fd t\u1ef1<\/p>\n<p>Num_chars: s\u1ed1 k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 11: Trong <em>V\u00ed d\u1ee5<\/em> n\u00e0y, ch\u00fang ta c\u00f3 danh s\u00e1ch s\u1ea3n ph\u1ea9m g\u1ed3m t\u00ean c\u00f4ng ty, t\u00ean s\u1ea3n ph\u1ea9m v\u00e0 m\u00e3 s\u1ea3n ph\u1ea9m. B\u1ea1n h\u00e3y t\u00e1ch l\u1ea5y m\u1ed7i t\u00ean c\u1ee7a s\u1ea3n ph\u1ea9m<\/p>\n<p>=MID(A1,8,40)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9864\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/24-09-08-300x118-1.png\" width=\"600\" height=\"237\" title=\"24-09-08-300x118-1\"><\/p>\n<p>A1: \u00f4 d\u1eef li\u1ec7u<\/p>\n<p>8: \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u c\u1ee7a t\u00ean. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y \u201c Ballon\u201d c\u00f3 6 ch\u1eef c\u1ed9ng v\u1edbi 1 kho\u1ea3ng tr\u1ed1ng =7 n\u00ean \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u s\u1ebd l\u00e0 8<\/p>\n<p>40: S\u1ed1 ch\u1eef c\u00e1i trong s\u1ea3n ph\u1ea9m, n\u00f3 thay \u0111\u1ed5i theo s\u1ea3n ph\u1ea9m n\u00ean \u0111\u1ec3 40 l\u00e0 maximum.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_PROPER\"><\/span><strong>H\u00e0m PROPER<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m n\u00e0y vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed7i t\u1eeb<\/p>\n<p><em>V\u00ed d\u1ee5<\/em><\/p>\n<p>=PROPER(\u201cHELLO JaY GOoD MoRnINg..!!\u201d) = Hello Jay Good Morning..!!<\/p>\n<h2><strong>H\u00e0m REPLACE<br \/>\n<\/strong><\/h2>\n<p>H\u00e0m n\u00e0y thay th\u1ebf m\u1ed9t ph\u1ea7n v\u0103n b\u1ea3n<\/p>\n<p>C\u00fa ph\u00e1p: REPLACE(old_text, start_num, num_chars, new_text)<\/p>\n<p>Old_ text: v\u0103n b\u1ea3n c\u0169<\/p>\n<p>start_num: v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u mu\u1ed1n thay trong v\u0103n b\u1ea3n<\/p>\n<p>num_chars: s\u1ed1 k\u00fd t\u1ef1 mu\u1ed1n thay th\u1ebf<\/p>\n<p>new_text: v\u0103n b\u1ea3n mu\u1ed1n th\u00eam v\u00e0o<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 13: S\u1eed d\u1ee5ng d\u1eef li\u1ec7u t\u1eeb <em>V\u00ed d\u1ee5<\/em> 11. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, h\u00e3y thay th\u1ebf m\u00e3 s\u1ea3n ph\u1ea9m th\u00e0nh kho\u1ea3ng tr\u1ed1ng.<\/p>\n<p>=REPLACE(A1,19,3,\u201d\u201d)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9866\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/24-09-10-300x110-1.png\" width=\"600\" height=\"221\" title=\"24-09-10-300x110-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_REPT\"><\/span><strong>H\u00e0m REPT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1eb7p l\u1ea1i v\u0103n b\u1ea3n ho\u1eb7c k\u00fd hi\u1ec7u d\u1ef1a theo \u00fd ng\u01b0\u1eddi d\u00f9ng<\/p>\n<p><em>V\u00ed d\u1ee5<\/em>, b\u1ea1n mu\u1ed1n l\u1eb7p k\u00fd t\u1ef1 * 10 l\u1ea7n trong m\u1ed9t \u00f4, b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p>=REPT(\u201c*\u201d,10) = **********<\/p>\n<p>H\u00e0m REPT s\u1ebd r\u1ea5t gi\u00fap \u00edch trong vi\u1ec7c t\u1ea1o bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1eddng trong ph\u1ea1m vi c\u00e1c \u00f4 m\u00e0 ng\u01b0\u1eddi d\u00f9ng t\u00f9y ch\u1ec9nh.<\/p>\n<h2><strong>H\u00e0m SEARCH<br \/>\n<\/strong><\/h2>\n<p>H\u00e0m n\u00e0y \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed v\u0103n b\u1ea3n con trong m\u1ed9t v\u0103n b\u1ea3n kh\u00e1c<\/p>\n<p>C\u00fa ph\u00e1p: SEARCH(find_text,within_text,[start_num]<\/p>\n<p>find_text: v\u0103n b\u1ea3n, ch\u1eef c\u00e1i hay k\u00ed hi\u1ec7u c\u1ea7n t\u00ecm (v\u0103n b\u1ea3n con)<\/p>\n<p>within_text: v\u0103n b\u1ea3n ch\u1ee9a v\u0103n b\u1ea3n c\u1ea7n t\u00ecm<\/p>\n<p>[start_num]: t\u00f9y ch\u1ecdn \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm trong within_text<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 14: Danh s\u00e1ch t\u00ean c\u00f4ng nh\u00e2n \u1edf c\u1ed9t A, t\u00ecm v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u c\u1ee7a t\u00ean h\u1ecd ng\u01b0\u1eddi c\u00f4ng nh\u00e2n \u0111\u00f3 (last name)<\/p>\n<p>A2 = Lillie Merrit<\/p>\n<p>=SEARCH(\u201d \u201c,A2) = 7<\/p>\n<p>7 l\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1, c\u00f3 nghi\u00e3 l\u00e0 t\u00ean h\u1ecd c\u1ee7a c\u00f4ng nh\u00e2n trong A2 b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed th\u1ee9 7<\/p>\n<p><strong><em>Bi\u1ebfn th\u1ec3:<\/em><\/strong> N\u1ebfu v\u0103n b\u1ea3n c\u00f3 nhi\u1ec1u kho\u1ea3ng tr\u1ed1ng th\u00ec \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p>=SEARCH(\u201d \u201c,E2,SEARCH(\u201d \u201c,E2)+1)<\/p>\n<p>H\u00e0m SEARCH \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed \u00a0kho\u1ea3ng tr\u1ed1ng \u0111\u1ea7u ti\u00ean v\u00e0 c\u1ed9ng th\u00eam m\u1ed9t \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 b\u1eaft \u0111\u00e2u cho kho\u1ea3ng tr\u1ed1ng th\u1ee9 hai<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9867\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/24-09-11-300x161-1.png\" width=\"600\" height=\"321\" title=\"24-09-11-300x161-1\"><\/p>\n<p><em>V\u00ed d\u1ee5<\/em>, d\u1ef1a v\u00e0o c\u00f4ng th\u1ee9c th\u1ee9 nh\u1ea5t, ta c\u00f3 \u201c7\u201d l\u00e0 v\u1ecb tr\u00ed kho\u1ea3ng tr\u1ed1ng \u0111\u1ea7u ti\u00ean. V\u00ec v\u1eady th\u00eam 1 s\u1ebd l\u00e0 8 l\u00e0 s\u1ed1 b\u1eaft \u0111\u1ea7u ph\u1ea7n ti\u1ebfp theo. Ch\u00fang ta \u0111ang \u00a0d\u1eabn Excel t\u00ecm kho\u1ea3ng tr\u1ed1ng b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed th\u1ee9 8 c\u1ee7a v\u0103n b\u1ea3n<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_RIGHT\"><\/span><strong>H\u00e0m RIGHT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m t\u00e1ch k\u00fd t\u1ef1 t\u1eeb b\u00ean ph\u1ea3i v\u0103n b\u1ea3n<\/p>\n<p>C\u00fa ph\u00e1p: RIGHT(text,[num_chars])<\/p>\n<p>Text: v\u0103n b\u1ea3n<\/p>\n<p>[num_chars]: s\u1ed1 k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 15: Ta c\u00f3 t\u00ean \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a c\u00f4ng nh\u00e2n \u1edf c\u1ed9t A, b\u00e2y gi\u1edd h\u00e3y l\u1ea5y ra t\u00ean h\u1ecd \u1edf c\u1ed9t B<\/p>\n<p>Text in A2 : Lillie.Merrit<\/p>\n<p>=RIGHT(A2,6) = Merrit<\/p>\n<p><strong><em>Bi\u1ebfn th\u1ec3<\/em><\/strong><\/p>\n<p>Ph\u1ea3i l\u00e0m sao n\u1ebfu b\u1ea1n kh\u00f4ng bi\u1ebft ch\u00ednh x\u00e1c s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n t\u00e1ch?<\/p>\n<p>\u0110\u00e2y l\u00e0 c\u00f4ng th\u1ee9c t\u1ef1 \u0111\u1ed9ng x\u00e1c \u0111\u1ecbnh t\u00ean h\u1ecd v\u00e0 t\u00e1ch ra<\/p>\n<p>=RIGHT(A2,LEN(A2)-SEARCH(\u201c.\u201d,A2))<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9868\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/24-09-12-300x127-1.png\" width=\"600\" height=\"255\" title=\"24-09-12-300x127-1\"><\/p>\n<p>H\u00e0m LEN \u0111\u1ec3 \u0111\u1ebfm t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 trong v\u0103n b\u1ea3n v\u00e0 h\u00e0m SERACh \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed c\u1ee5 th\u1ec3<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_SUBSTITUE\"><\/span><strong>H\u00e0m SUBSTITUE<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m \u0111\u1ec3 thay th\u1ebf v\u0103n b\u1ea3n, k\u00fd hi\u1ec7u v\u00e0 ch\u1eef s\u1ed1 theo \u00fd ng\u01b0\u01a1i d\u00f9ng<\/p>\n<p>C\u00fa ph\u00e1p: SUBSTITUTE(text, old_text, new_text, [instance_num])<\/p>\n<p>Text: v\u0103n b\u1ea3n<\/p>\n<p>old_text : v\u0103n b\u1ea3n mu\u1ed1n thay th\u1ebf<\/p>\n<p>new_text : v\u0103n b\u1ea3n thay th\u1ebf<\/p>\n<p>[instance_num] : t\u00f9y ch\u1ecdn thay th\u1ebf \u1edf v\u1ecb tr\u00ed n\u00e0o th\u1ee9 nh\u1ea5t hay th\u1ee9 hai\u2026<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 16: Ch\u00fang ta c\u00f3 t\u00ean \u1edf c\u1ed9t A, h\u00e3y \u00a0thay th\u1ebf kho\u1ea3ng tr\u1ed1ng gi\u1eefa t\u00ean v\u00e0 t\u00ean \u0111\u1ec7m th\u00e0nh k\u00fd t\u1ef1 \u00a0g\u1ea1ch d\u01b0\u1edbi \u201c_\u201d<\/p>\n<p>Text in A2 : Lillie.Merrit<\/p>\n<p>=SUBSTITUTE(A2,\u201d.\u201d,\u201d_\u201d) = Lillie_Merrit<\/p>\n<p><strong><em>Bi\u1ebfn th\u1ec3<\/em><\/strong>: trong <em>V\u00ed d\u1ee5<\/em> n\u00e0y ch\u00fang ta c\u00f3 kho\u1ea3ng tr\u1ed1ng c\u1ea3 \u1edf gi\u1eefa t\u00ean, t\u00ean \u0111\u1ec7m v\u00e0 m\u00e3 s\u1ed1.\u00a0 H\u00e3y thay th\u1ebf k\u00fd t\u1ef1 \u00a0g\u1ea1ch d\u01b0\u1edbi \u201c_\u201d ch\u1ec9 cho t\u00ean c\u00f2n m\u00e3 s\u1ed1 th\u00ec gi\u1eef nguy\u00ean.<\/p>\n<p>=SUBSTITUTE(E2,\u201d \u201c,\u201d_\u201d,1)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9869\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/24-09-13-300x151-1.png\" width=\"600\" height=\"303\" title=\"24-09-13-300x151-1\"><\/p>\n<p>\u0110i\u1ec1u thay \u0111\u1ed5i duy nh\u1ea5t l\u00e0 c\u00f4ng th\u1ee9c tr\u00ean l\u00e0 th\u00eam 1- insurance number, c\u00f3 ngh\u0129a l\u00e0 h\u00e0m n\u00e0y s\u1ebd ch\u1ec9 \u00a0thay th\u1ebf v\u0103n b\u1ea3n \u1edf v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean v\u00e0 b\u1ecf qua c\u00e1c v\u1ecb tr\u00ed kh\u00e1c.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_TRIM\"><\/span><strong>H\u00e0m TRIM<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1ed1ng th\u1eeba trong c\u00e2u<\/p>\n<p>C\u00fa ph\u00e1p: TRIM(text)<\/p>\n<p><em>V\u00ed d\u1ee5<\/em> 17: H\u00e3y b\u1ecf c\u00e1c kho\u1ea3ng tr\u1ed1ng trong v\u0103n b\u1ea3n sau<\/p>\n<p>\u00a0<\/p>\n<p>=TRIM(\u201cHello\u00a0 Jay\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Good\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Morning..!!\u201d) = Hello Jay Good Morning..!!<\/p>\n<p>V\u1edbi h\u00e0m tr\u00ean, ta c\u00f3 th\u1ebb x\u00f3a \u0111\u01b0\u1ee3c c\u00e1c kho\u1ea3ng tr\u1ed1ng th\u1eeba, ch\u1ec9 gi\u1eef l\u1ea1i m\u1ed9t kho\u1ea3ng tr\u1ed1ng gi\u1eefa c\u00e1c t\u1eeb<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_UPPER\"><\/span><strong>H\u00e0m UPPER<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m chuy\u1ec3n v\u0103n b\u1ea3n t\u1eeb ch\u1eef th\u01b0\u1eddng sang ch\u1eef hoa<\/p>\n<p>C\u00fa ph\u00e1p: UPPER(text)<\/p>\n<p><em>V\u00ed d\u1ee5<\/em>, chuy\u1ec3n \u201chi good morning\u201dsang d\u1ea1ng vi\u1ebft hoa<\/p>\n<p>=UPPER(\u201chi good morning\u201d) =\u00a0 HI GOOD MORNING<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span><strong>K\u1ebft lu\u1eadn<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1ch \u00e1p d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-text-trong-excel-19-cach-giup-xu-ly-van-ban-hieu-qua.html\">c\u00e1c h\u00e0m v\u0103n b\u1ea3n trong Excel<\/a> l\u00e0 v\u1ea5n \u0111\u1ec1 l\u1edbn \u0111\u1ed1i v\u1edbi c\u00e1c nh\u00e0 ph\u00e2n t\u00edch, d\u1eef li\u1ec7u c\u00e0ng ph\u1ee9c t\u1ea1p th\u00ec ch\u00fang ta c\u00e0ng ph\u1ea3i ph\u1ee5 thu\u1ed9c nhi\u1ec1u v\u00e0o n\u00f3. V\u00ec v\u1eady n\u1ebfu b\u1ea1n v\u1eabn ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m n\u00e0y th\u00ec h\u00e3y luy\u1ec7n t\u1eadp h\u00e0ng ng\u00e0y trong c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh.<\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-548.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6105,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6104","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\/6104","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=6104"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6104\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6105"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}