{"id":1912,"date":"2017-04-30T17:38:18","date_gmt":"2017-04-30T10:38:18","guid":{"rendered":"https:\/\/engisv.info\/?p=1912"},"modified":"2017-04-30T17:38:18","modified_gmt":"2017-04-30T10:38:18","slug":"ham-excel-cac-ham-xu-ly-chuoi-thong-dung","status":"publish","type":"post","link":"https:\/\/www.engisv.info\/?p=1912","title":{"rendered":"H\u00e0m Excel &#8211; C\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i th\u00f4ng d\u1ee5ng"},"content":{"rendered":"<p>Trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i:\u00a0LOWER, UPPER, PROPER, TRIM, LEN, LEFT, RIGHT, MID, TEXT, VALUE, FIND, SEARCH, REPLACE\u00a0\u0111\u00e2y l\u00e0 nh\u1eefng h\u00e0m x\u1eed l\u00fd chu\u1ed7i r\u1ea5t th\u00f4ng d\u1ee5ng v\u00e0 th\u01b0\u1eddng g\u1eb7p trong c\u00e1c bai to\u00e1n Excel.<\/p>\n<p>\u0110\u1ed1i v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng d\u1eef li\u1ec7u ki\u1ec3u chu\u1ed7i (Text), n\u1ebfu chu\u1ed7i k\u00fd t\u1ef1 kh\u00f4ng n\u1eb1m trong \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng k\u00fd t\u1ef1 v\u00e0 s\u1eed d\u1ee5ng l\u00e0m \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m th\u00ec chu\u1ed7i k\u00fd t\u1ef1 s\u1ebd ph\u1ea3i n\u1eb1m trong d\u1ea5u ngo\u1eb7c k\u00e9p (&#8220;&#8221;). V\u00ed d\u1ee5 &#8220;test@123&#8221;. B\u1ea1n c\u00f3 th\u1ec3 xem l\u1ea1i trong b\u00e0i <a href=\"https:\/\/www.engisv.info\/?p=1191\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Excel \u2013 Ki\u1ec3u d\u1eef li\u1ec7u, \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u, \u0111\u1ecbnh d\u1ea1ng v\u00f9ng d\u1eef li\u1ec7u v\u00e0 b\u1ea3ng t\u00ednh<\/a>\u00a0\u0111\u1ec3 c\u00f3 ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong Excel.<\/p>\n<p><strong>H\u00e0m UPPER: Chuy\u1ec3n chu\u1ed7i th\u00e0nh ch\u1eef in hoa<\/strong><\/p>\n<p>=UPPER(Text)<\/p>\n<p>V\u00ed d\u1ee5: Chuy\u1ec3nT\u00caN B\u00c0I H\u00c1T\u00a0th\u00e0nh vi\u1ebft hoa.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1927 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/upper.png\" alt=\"\" width=\"838\" height=\"308\" \/><\/p>\n<p><strong>H\u00e0m PROPER: \u0110\u1ed5i c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea7u c\u1ee7a m\u1ed7i t\u1eeb trong chu\u1ed7i th\u00e0nh ch\u1eef in hoa.<\/strong><\/p>\n<p>=PROPER(Text)<\/p>\n<p>V\u00ed d\u1ee5: Chuy\u1ec3n c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea7u trong m\u1ed7i chu\u1ed7i c\u1ee7a CA S\u0129\/NH\u00d3M NH\u1ea0C th\u00e0nh ch\u1eef hoa, c\u00e1c k\u00fd t\u1ef1 c\u00f2n l\u1ea1i vi\u1ebft th\u01b0\u1eddng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1928 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/proper.png\" alt=\"\" width=\"861\" height=\"318\" \/><\/p>\n<p><strong>H\u00e0m LOWER:\u00a0Chuy\u1ec3n chu\u1ed7i text th\u00e0nh ch\u1eef th\u01b0\u1eddng<\/strong><\/p>\n<p>=LOWER(Text)<\/p>\n<p>V\u00ed d\u1ee5: Chuy\u1ec3n B\u1ea2NG X\u1ebeP H\u1ea0NG th\u00e0nh k\u00fd t\u1ef1 th\u01b0\u1eddng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1929 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/lower.png\" alt=\"\" width=\"861\" height=\"318\" \/><\/p>\n<p><strong>H\u00e0m TRIM: C\u1eaft b\u1ecf c\u00e1c k\u00fd t\u1ef1 tr\u1ed1ng v\u00f4 \u00edch trong chu\u1ed7i<\/strong><\/p>\n<p>=TRIM(Text)<\/p>\n<p>V\u00ed d\u1ee5: Lo\u1ea1i b\u1ecf c\u00e1c k\u00fd t\u1ef1 kho\u1ea3ng tr\u1ed1ng th\u1eeba trong T\u00caN B\u00c0I H\u00c1T v\u00e0 vi\u1ebft hoa (UPPER) t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 c\u1ee7a t\u00ean b\u00e0i h\u00e1t<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1930 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/trim.png\" alt=\"\" width=\"864\" height=\"328\" \/><\/p>\n<p><strong>H\u00e0m LEN:\u00a0Tr\u1ea3 v\u1ec1 \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i \u00a0(\u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i, k\u1ec3 c\u1ea3 k\u00fd t\u1ef1 kho\u1ea3ng tr\u1ed1ng)<\/strong><\/p>\n<p>=LEN(Text)<\/p>\n<p>V\u00ed d\u1ee5: \u0110\u1ebfm c\u00e1c k\u00fd t\u1ef1 c\u00f3 trong T\u00caN B\u00c0I H\u00c1T<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1931 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/len.png\" alt=\"\" width=\"832\" height=\"340\" \/><\/p>\n<p>K\u1ebft qu\u1ea3 khi d\u00f9ng LEN k\u1ebft h\u1ee3p v\u1edbi TRIM \u0111\u1ec3 lo\u1ea1i b\u1ecf nh\u1eefng k\u00fd t\u1ef1 kho\u1ea3ng tr\u1ed1ng d\u01b0.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1932 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/len-trim.png\" alt=\"\" width=\"861\" height=\"347\" \/><\/p>\n<p><strong>H\u00e0m LEFT:\u00a0Tr\u1ea3 v\u1ec1k\u00fd t\u1ef1 b\u00ean tr\u00e1i chu\u1ed7i (l\u1ea5y c\u00e1c k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i qua c\u1ee7a chu\u1ed7i)<\/strong><\/p>\n<p>=LEFT(text, [num_chars])<\/p>\n<ul>\n<li><b class=\"ocpRunInHead\">Text<\/b>\u00a0\u00a0\u00a0\u00a0B\u0103\u0301t bu\u00f4\u0323c. Chu\u00f4\u0303i v\u0103n ba\u0309n co\u0301 ch\u01b0\u0301a ca\u0301c ky\u0301 t\u01b0\u0323 ma\u0300 ba\u0323n mu\u00f4\u0301n tri\u0301ch xu\u00e2\u0301t.<\/li>\n<li><b class=\"ocpRunInHead\">Num_chars<\/b>\u00a0\u00a0\u00a0\u00a0Tu\u0300y cho\u0323n. Chi\u0309 ro\u0303 s\u00f4\u0301 ky\u0301 t\u01b0\u0323 ma\u0300 ba\u0323n mu\u00f4\u0301n ha\u0300m LEFT tri\u0301ch xu\u00e2\u0301t.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5: L\u1ea5y 3 k\u00fd t\u1ef1 \u0111\u1ea7u (t\u1eeb b\u00ean tr\u00e1i) c\u1ee7a B\u1ea2NG X\u1ebeP H\u1ea0NG<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1933 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/left.png\" alt=\"\" width=\"792\" height=\"359\" \/><\/p>\n<p><strong>H\u00e0m RIGHT: Tr\u1ea3 v\u1ec1 k\u00fd t\u1ef1 b\u00ean ph\u1ea3i chu\u1ed7i\u00a0(l\u1ea5y c\u00e1c k\u00fd t\u1ef1 t\u1eeb b\u00ean ph\u1ea3i qua c\u1ee7a chu\u1ed7i)<\/strong><\/p>\n<p>=RIGHT(text,[num_chars])<\/p>\n<ul>\n<li><b class=\"ocpRunInHead\">Text<\/b>\u00a0\u00a0\u00a0\u00a0B\u1eaft bu\u1ed9c. Chu\u00f4\u0303i v\u0103n ba\u0309n co\u0301 ch\u01b0\u0301a ca\u0301c ky\u0301 t\u01b0\u0323 ma\u0300 ba\u0323n mu\u00f4\u0301n tri\u0301ch xu\u00e2\u0301t.<\/li>\n<li><b class=\"ocpRunInHead\">Num_chars<\/b>\u00a0\u00a0\u00a0\u00a0T\u00f9y ch\u1ecdn. Chi\u0309 ro\u0303 s\u00f4\u0301 ky\u0301 t\u01b0\u0323 ma\u0300 ba\u0323n mu\u00f4\u0301n ha\u0300m RIGHT tri\u0301ch xu\u00e2\u0301t.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5: L\u1ea5y 6 k\u00fd t\u1ef1 cu\u1ed1i (t\u1eeb b\u00ean ph\u1ea3i) c\u1ee7a B\u1ea2NG X\u1ebeP H\u1ea0NG<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1934 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/right.png\" alt=\"\" width=\"757\" height=\"333\" \/><\/p>\n<p><strong>H\u00e0m MID: Tr\u1ea3 v\u1ec1 k\u00fd t\u1ef1 gi\u1eefa chu\u1ed7i b\u1eaft \u0111\u1ea7u t\u1eeb k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y.<\/strong><\/p>\n<p>=MID(text, start_num, num_chars)<\/p>\n<ul>\n<li><b class=\"ocpRunInHead\">Text<\/b>\u00a0\u00a0\u00a0\u00a0B\u1eaft bu\u1ed9c. Chu\u00f4\u0303i v\u0103n ba\u0309n co\u0301 ch\u01b0\u0301a ca\u0301c ky\u0301 t\u01b0\u0323 ma\u0300 ba\u0323n mu\u00f4\u0301n tri\u0301ch xu\u00e2\u0301t.<\/li>\n<li><b class=\"ocpRunInHead\">Start_num<\/b>\u00a0\u00a0\u00a0\u00a0B\u1eaft bu\u1ed9c. Vi\u0301 tri\u0301 cu\u0309a ky\u0301 t\u01b0\u0323 th\u01b0\u0301 nh\u00e2\u0301t ma\u0300 ba\u0323n mu\u00f4\u0301n tri\u0301ch xu\u00e2\u0301t trong v\u0103n ba\u0309n. Ky\u0301 t\u01b0\u0323 th\u01b0\u0301 nh\u00e2\u0301t trong chu\u00f4\u0303i v\u0103n ba\u0309n co\u0301 s\u00f4\u0301 b\u0103\u0301t \u0111\u00e2\u0300u la\u0300 1, va\u0300 v.v.<\/li>\n<li><b class=\"ocpRunInHead\">Num_chars<\/b>\u00a0\u00a0\u00a0\u00a0B\u1eaft bu\u1ed9c. Chi\u0309 ro\u0303 s\u00f4\u0301 ky\u0301 t\u01b0\u0323 ma\u0300 ba\u0323n mu\u00f4\u0301n ha\u0300m MID tra\u0309 v\u00ea\u0300 t\u01b0\u0300 v\u0103n ba\u0309n.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5: L\u1ea5y 2 k\u00fd t\u1ef1 \u1edf gi\u1eefa b\u1eaft \u0111\u1ea7u t\u1eeb k\u00fd t\u1ef1 th\u1ee9 4 c\u1ee7a B\u1ea2NG X\u1ebeP H\u1ea0NG.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1935 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/mid.png\" alt=\"\" width=\"786\" height=\"347\" \/><\/p>\n<p><strong>H\u00e0m FIND:\u00a0\u0111\u1ecbnh v\u1ecb m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n n\u1eb1m trong chu\u1ed7i v\u0103n b\u1ea3n th\u1ee9 hai v\u00e0 tr\u1ea3 v\u1ec1 s\u1ed1 c\u1ee7a v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n th\u1ee9 nh\u1ea5t t\u00ednh t\u1eeb k\u00fd t\u1ef1 th\u1ee9 nh\u1ea5t c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n th\u1ee9 hai. H\u00e0m FIND c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng.<\/strong><\/p>\n<p>=FIND(find_text, within_text, [start_num])<\/p>\n<ul>\n<li><b class=\"ocpRunInHead\">Find_text<\/b>\u00a0\u00a0\u00a0\u00a0B\u0103\u0301t bu\u00f4\u0323c. V\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm.<\/li>\n<li><b class=\"ocpRunInHead\">Within_text<\/b>\u00a0\u00a0\u00a0\u00a0B\u0103\u0301t bu\u00f4\u0323c. V\u0103n b\u1ea3n c\u00f3 ch\u1ee9a v\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm.<\/li>\n<li><b class=\"ocpRunInHead\">Start_num<\/b>\u00a0\u00a0\u00a0\u00a0Tu\u0300y cho\u0323n. Ch\u1ec9 r\u00f5 k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u t\u00ecm t\u1ea1i \u0111\u00f3. K\u00fd t\u1ef1 th\u1ee9 nh\u1ea5t cu\u0309a within_text l\u00e0 k\u00fd t\u1ef1 s\u1ed1 1. N\u1ebfu b\u1ea1n b\u1ecf qua start_num, th\u00ec n\u00f3 \u0111\u01b0\u1ee3c gi\u1ea3 \u0111\u1ecbnh l\u00e0 1.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5: T\u00ecm v\u1ecb tr\u00ed &#8220;you&#8221; ( vi\u1ebft th\u01b0\u1eddng, kh\u00f4ng c\u00f3 k\u00fd t\u1ef1 vi\u1ebft hoa) trong T\u00caN B\u00c0I H\u00c1T b\u1eaft \u0111\u1ea7u t\u1eeb k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1943 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/FIND.png\" alt=\"\" width=\"831\" height=\"374\" \/><\/p>\n<p><strong>H\u00e0m SEARCH: T\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m FIND nh\u01b0ng kh\u00f4ng c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng.<\/strong><\/p>\n<p>=SEARCH(find_text,within_text,[start_num])<\/p>\n<p>V\u00ed d\u1ee5: T\u00ecm v\u1ecb tr\u00ed &#8220;you&#8221; trong T\u00caN B\u00c0I H\u00c1T b\u1eaft \u0111\u1ea7u t\u1eeb k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1944 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/SEARCH.png\" alt=\"\" width=\"787\" height=\"346\" \/><\/p>\n<p><strong>H\u00e0m REPLACE:\u00a0thay th\u00ea\u0301 m\u00f4\u0323t ph\u00e2\u0300n cu\u0309a chu\u00f4\u0303i v\u0103n ba\u0309n, d\u01b0\u0323a va\u0300o s\u00f4\u0301 ky\u0301 t\u01b0\u0323 do ba\u0323n chi\u0309 \u0111i\u0323nh, b\u0103\u0300ng m\u00f4\u0323t chu\u00f4\u0303i v\u0103n ba\u0309n kha\u0301c.<\/strong><\/p>\n<p>=REPLACE(old_text, start_num, num_chars, new_text)<\/p>\n<ul>\n<li><b class=\"ocpRunInHead\">Old_text<\/b>\u00a0\u00a0\u00a0\u00a0B\u1eaft bu\u1ed9c. V\u0103n ba\u0309n ma\u0300 ba\u0323n mu\u00f4\u0301n thay th\u00ea\u0301 m\u00f4\u0323t va\u0300i ky\u0301 t\u01b0\u0323 trong \u0111o\u0301.<\/li>\n<li><b class=\"ocpRunInHead\">Start_num<\/b>\u00a0\u00a0\u00a0\u00a0B\u1eaft bu\u1ed9c. Vi\u0323 tri\u0301 cu\u0309a ky\u0301 t\u01b0\u0323 trong v\u0103n ba\u0309n cu\u0303 ma\u0300 ba\u0323n mu\u00f4\u0301n thay th\u00ea\u0301 b\u0103\u0300ng v\u0103n ba\u0309n m\u01a1\u0301i.<\/li>\n<li><b class=\"ocpRunInHead\">Num_chars<\/b>\u00a0\u00a0\u00a0\u00a0B\u1eaft bu\u1ed9c. S\u00f4\u0301 l\u01b0\u01a1\u0323ng ky\u0301 t\u01b0\u0323 trong v\u0103n ba\u0309n cu\u0303 ma\u0300 ba\u0323n mu\u00f4\u0301n ha\u0300m REPLACE thay th\u00ea\u0301 b\u0103\u0300ng v\u0103n ba\u0309n m\u01a1\u0301i.<\/li>\n<li><b class=\"ocpRunInHead\">New_text<\/b>\u00a0\u00a0\u00a0\u00a0B\u1eaft bu\u1ed9c. V\u0103n ba\u0309n se\u0303 thay th\u00ea\u0301 ca\u0301c ky\u0301 t\u01b0\u0323 trong old_text.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5: Chuy\u1ec3n thay th\u1ebf hai k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng trong B\u1ea2NG X\u1ebeP H\u1ea0NG th\u00e0nh &#8220;16&#8221;. (Bi\u1ebft l\u00e0\u00a0B\u1ea2NG X\u1ebeP H\u1ea0NG c\u00f3 11 k\u00fd t\u1ef1, v\u1eady hai k\u00fd t\u1ef1 cu\u1ed1i \u0111\u01b0\u1ee3c thay th\u1ebf s\u1ebd l\u00e0 k\u00fd t\u1ef1 th\u1ee9 10 v\u00e0 11 )<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1945 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/replace.png\" alt=\"\" width=\"827\" height=\"353\" \/><\/p>\n<p><strong>H\u00e0m VALUE: chuy\u1ec3n chu\u1ed7i c\u00f3 d\u1ea1ng s\u1ed1 th\u00e0nh tr\u1ecb s\u1ed1<\/strong><\/p>\n<p>=VALUE(Text)<\/p>\n<p>V\u00ed d\u1ee5: Chuy\u1ec3n \u0111\u1ed5i 6 k\u00fd t\u1ef1 s\u1ed1 sau c\u00f9ng B\u1ea2NG X\u1ebeP H\u1ea0NG th\u00e0nh ki\u1ec3u s\u1ed1.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1948 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/Value.png\" alt=\"\" width=\"803\" height=\"430\" \/><\/p>\n<p><strong>H\u00e0m TEXT: Chuy\u1ec3n d\u00e3y s\u1ed1(value) ho\u1eb7c m\u1ed9t d\u00e3y k\u00fd t\u1ef1 s\u1ed1 th\u00e0nh chu\u1ed7i theo \u0111\u1ecbnh d\u1ea1ng m\u1edbi.<\/strong><\/p>\n<p>=TEXT (Gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng, &#8220;M\u00e3 \u0111\u1ecbnh d\u1ea1ng b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng&#8221;)<\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng: c\u00f3 th\u1ec3 l\u00e0 ki\u1ec3u s\u1ed1, ng\u00e0y th\u00e1ng, k\u00fd t\u1ef1 s\u1ed1.<\/li>\n<li>M\u00e3 \u0111\u1ecbnh d\u1ea1ng b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng: c\u00e1c ki\u1ec3m \u0111\u1ecbnh d\u1ea1ng t\u01b0\u01a1ng t\u1ef1 trong b\u00e0i &#8220;<a href=\"https:\/\/www.engisv.info\/?p=1191\" target=\"_blank\" rel=\"noopener noreferrer\">Ki\u1ec3u d\u1eef li\u1ec7u, \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u, \u0111\u1ecbnh d\u1ea1ng v\u00f9ng d\u1eef li\u1ec7u v\u00e0 b\u1ea3ng t\u00ednh<\/a>&#8220;<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5: Chuy\u1ec3n 6 k\u00fd t\u1ef1 s\u1ed1 cu\u1ed1i c\u00f9ng c\u1ee7a B\u1ea2NG X\u1ebeP H\u1ea0NG th\u00e0nh \u0111\u1ecbnh d\u1ea1ng &#8220;00000000&#8221;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1949 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/04\/text.png\" alt=\"\" width=\"799\" height=\"421\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i:\u00a0LOWER, UPPER, PROPER, TRIM, LEN, LEFT, RIGHT, MID, TEXT, VALUE, FIND, SEARCH, REPLACE\u00a0\u0111\u00e2y l\u00e0 nh\u1eefng h\u00e0m x\u1eed l\u00fd chu\u1ed7i r\u1ea5t th\u00f4ng d\u1ee5ng v\u00e0 th\u01b0\u1eddng g\u1eb7p trong c\u00e1c bai to\u00e1n Excel. \u0110\u1ed1i v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng d\u1eef li\u1ec7u ki\u1ec3u chu\u1ed7i (Text), n\u1ebfu chu\u1ed7i k\u00fd t\u1ef1 kh\u00f4ng n\u1eb1m trong \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng k\u00fd t\u1ef1 v\u00e0 s\u1eed d\u1ee5ng l\u00e0m \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m th\u00ec chu\u1ed7i k\u00fd t\u1ef1 s\u1ebd ph\u1ea3i n\u1eb1m trong d\u1ea5u ngo\u1eb7c k\u00e9p (&#8220;&#8221;). V\u00ed d\u1ee5 &#8220;test@123&#8221;. B\u1ea1n&hellip;<\/p>\n","protected":false},"author":2,"featured_media":1108,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"footnotes":""},"categories":[14,15],"tags":[37,42],"class_list":["post-1912","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat","category-van-phong","tag-excel","tag-ham-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>H\u00e0m Excel - C\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i th\u00f4ng d\u1ee5ng - EngISV<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.engisv.info\/?p=1912\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m Excel - C\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i th\u00f4ng d\u1ee5ng - EngISV\" \/>\n<meta property=\"og:description\" content=\"Trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i:\u00a0LOWER, UPPER, PROPER, TRIM, LEN, LEFT, RIGHT, MID, TEXT, VALUE, FIND, SEARCH, REPLACE\u00a0\u0111\u00e2y l\u00e0 nh\u1eefng h\u00e0m x\u1eed l\u00fd chu\u1ed7i r\u1ea5t th\u00f4ng d\u1ee5ng v\u00e0 th\u01b0\u1eddng g\u1eb7p trong c\u00e1c bai to\u00e1n Excel. \u0110\u1ed1i v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng d\u1eef li\u1ec7u ki\u1ec3u chu\u1ed7i (Text), n\u1ebfu chu\u1ed7i k\u00fd t\u1ef1 kh\u00f4ng n\u1eb1m trong \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng k\u00fd t\u1ef1 v\u00e0 s\u1eed d\u1ee5ng l\u00e0m \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m th\u00ec chu\u1ed7i k\u00fd t\u1ef1 s\u1ebd ph\u1ea3i n\u1eb1m trong d\u1ea5u ngo\u1eb7c k\u00e9p (&#8220;&#8221;). V\u00ed d\u1ee5 &#8220;test@123&#8221;. B\u1ea1n&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.engisv.info\/?p=1912\" \/>\n<meta property=\"og:site_name\" content=\"EngISV\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/engisv\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-30T10:38:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"hoanghiepktv\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"hoanghiepktv\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1912#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1912\"},\"author\":{\"name\":\"hoanghiepktv\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\"},\"headline\":\"H\u00e0m Excel &#8211; C\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i th\u00f4ng d\u1ee5ng\",\"datePublished\":\"2017-04-30T10:38:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1912\"},\"wordCount\":1463,\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1912#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"keywords\":[\"Excel\",\"H\u00e0m Excel\"],\"articleSection\":[\"Th\u1ee7 thu\u1eadt\",\"V\u0103n ph\u00f2ng\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1912\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/?p=1912\",\"name\":\"H\u00e0m Excel - C\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i th\u00f4ng d\u1ee5ng - EngISV\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1912#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1912#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"datePublished\":\"2017-04-30T10:38:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1912#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.engisv.info\\\/?p=1912\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1912#primaryimage\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"contentUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"width\":300,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1912#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.engisv.info\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m Excel &#8211; C\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i th\u00f4ng d\u1ee5ng\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/\",\"name\":\"EngISV\",\"description\":\"H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng vi\u1ec7c nh\u1ecf!\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.engisv.info\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\",\"name\":\"EngISV\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/logo2-3-1-1.png\",\"contentUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/logo2-3-1-1.png\",\"width\":200,\"height\":76,\"caption\":\"EngISV\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/engisv\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\",\"name\":\"hoanghiepktv\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"caption\":\"hoanghiepktv\"},\"url\":\"https:\\\/\\\/www.engisv.info\\\/?author=2\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"H\u00e0m Excel - C\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i th\u00f4ng d\u1ee5ng - EngISV","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:\/\/www.engisv.info\/?p=1912","og_locale":"en_US","og_type":"article","og_title":"H\u00e0m Excel - C\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i th\u00f4ng d\u1ee5ng - EngISV","og_description":"Trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i:\u00a0LOWER, UPPER, PROPER, TRIM, LEN, LEFT, RIGHT, MID, TEXT, VALUE, FIND, SEARCH, REPLACE\u00a0\u0111\u00e2y l\u00e0 nh\u1eefng h\u00e0m x\u1eed l\u00fd chu\u1ed7i r\u1ea5t th\u00f4ng d\u1ee5ng v\u00e0 th\u01b0\u1eddng g\u1eb7p trong c\u00e1c bai to\u00e1n Excel. \u0110\u1ed1i v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng d\u1eef li\u1ec7u ki\u1ec3u chu\u1ed7i (Text), n\u1ebfu chu\u1ed7i k\u00fd t\u1ef1 kh\u00f4ng n\u1eb1m trong \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng k\u00fd t\u1ef1 v\u00e0 s\u1eed d\u1ee5ng l\u00e0m \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m th\u00ec chu\u1ed7i k\u00fd t\u1ef1 s\u1ebd ph\u1ea3i n\u1eb1m trong d\u1ea5u ngo\u1eb7c k\u00e9p (&#8220;&#8221;). V\u00ed d\u1ee5 &#8220;test@123&#8221;. B\u1ea1n&hellip;","og_url":"https:\/\/www.engisv.info\/?p=1912","og_site_name":"EngISV","article_publisher":"https:\/\/www.facebook.com\/engisv","article_published_time":"2017-04-30T10:38:18+00:00","og_image":[{"width":300,"height":300,"url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","type":"image\/png"}],"author":"hoanghiepktv","twitter_card":"summary_large_image","twitter_misc":{"Written by":"hoanghiepktv","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.engisv.info\/?p=1912#article","isPartOf":{"@id":"https:\/\/www.engisv.info\/?p=1912"},"author":{"name":"hoanghiepktv","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf"},"headline":"H\u00e0m Excel &#8211; C\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i th\u00f4ng d\u1ee5ng","datePublished":"2017-04-30T10:38:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.engisv.info\/?p=1912"},"wordCount":1463,"publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"image":{"@id":"https:\/\/www.engisv.info\/?p=1912#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","keywords":["Excel","H\u00e0m Excel"],"articleSection":["Th\u1ee7 thu\u1eadt","V\u0103n ph\u00f2ng"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.engisv.info\/?p=1912","url":"https:\/\/www.engisv.info\/?p=1912","name":"H\u00e0m Excel - C\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i th\u00f4ng d\u1ee5ng - EngISV","isPartOf":{"@id":"https:\/\/www.engisv.info\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.engisv.info\/?p=1912#primaryimage"},"image":{"@id":"https:\/\/www.engisv.info\/?p=1912#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","datePublished":"2017-04-30T10:38:18+00:00","breadcrumb":{"@id":"https:\/\/www.engisv.info\/?p=1912#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.engisv.info\/?p=1912"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/?p=1912#primaryimage","url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","contentUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","width":300,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/www.engisv.info\/?p=1912#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.engisv.info\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m Excel &#8211; C\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i th\u00f4ng d\u1ee5ng"}]},{"@type":"WebSite","@id":"https:\/\/www.engisv.info\/#website","url":"https:\/\/www.engisv.info\/","name":"EngISV","description":"H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng vi\u1ec7c nh\u1ecf!","publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.engisv.info\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.engisv.info\/#organization","name":"EngISV","url":"https:\/\/www.engisv.info\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/#\/schema\/logo\/image\/","url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/06\/logo2-3-1-1.png","contentUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/06\/logo2-3-1-1.png","width":200,"height":76,"caption":"EngISV"},"image":{"@id":"https:\/\/www.engisv.info\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/engisv"]},{"@type":"Person","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf","name":"hoanghiepktv","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","caption":"hoanghiepktv"},"url":"https:\/\/www.engisv.info\/?author=2"}]}},"_links":{"self":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/1912","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1912"}],"version-history":[{"count":0,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/1912\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/media\/1108"}],"wp:attachment":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}