{"id":231402,"date":"2023-07-17T12:18:40","date_gmt":"2023-07-17T05:18:40","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=231402"},"modified":"2025-12-25T22:16:45","modified_gmt":"2025-12-25T15:16:45","slug":"5-cach-dung-ham-left-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/","title":{"rendered":"H\u00e0m LEFT trong Excel: C\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">H\u00e0m LEFT trong Excel l\u00e0 h\u00e0m v\u0103n b\u1ea3n ph\u1ed5 bi\u1ebfn gi\u00fap tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i chu\u1ed7i (v\u00ed d\u1ee5: l\u1ea5y m\u00e3 t\u1ec9nh t\u1eeb m\u00e3 b\u01b0u \u0111i\u1ec7n). Kh\u00f4ng ch\u1ec9 c\u01a1 b\u1ea3n, h\u00e0m LEFT c\u00f2n k\u1ebft h\u1ee3p m\u1ea1nh m\u1ebd v\u1edbi SEARCH, LEN, VALUE \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p. B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf, l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1ch d\u00f9ng trong Google Sheets.<\/span><\/p>\n<h2><strong>H\u00e0m LEFT trong Excel l\u00e0 g\u00ec?<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">Th\u00eam ph\u1ea7n m\u1edbi ngay sau c\u00fa ph\u00e1p: H\u00e0m LEFT kh\u00e1c bi\u1ec7t v\u1edbi c\u00e1c h\u00e0m t\u01b0\u01a1ng t\u1ef1:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">LEFT: L\u1ea5y k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">RIGHT: L\u1ea5y t\u1eeb b\u00ean ph\u1ea3i.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">MID: L\u1ea5y t\u1eeb v\u1ecb tr\u00ed gi\u1eefa.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">B\u1ea3ng so s\u00e1nh:<\/span><\/p>\n<table>\n<thead>\n<tr>\n<th><span style=\"font-weight: 400;\">H\u00e0m<\/span><\/th>\n<th><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c<\/span><\/th>\n<th><span style=\"font-weight: 400;\">\u1ee8ng d\u1ee5ng v\u00ed d\u1ee5<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">LEFT<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=LEFT(text, num_chars)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">L\u1ea5y &#8220;HN&#8221; t\u1eeb &#8220;HN123&#8221;<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">RIGHT<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=RIGHT(text, num_chars)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">L\u1ea5y &#8220;123&#8221; t\u1eeb &#8220;HN123&#8221;<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">MID<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=MID(text, start, num)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">L\u1ea5y &#8220;12&#8221; t\u1eeb v\u1ecb tr\u00ed 3 trong &#8220;HN123&#8221;<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c<\/strong><\/h2>\n<p>H\u00e0m LEFT th\u01b0\u1eddng \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 SEARCH, LEN, MID, SUBSTITUTE,&#8230; \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c t\u00e1c v\u1ee5 ph\u1ee9c t\u1ea1p. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEFT v\u00e0 LEN \u0111\u1ec3 ki\u1ec3m tra \u0111\u1ed9 d\u00e0i c\u1ee7a m\u1ed9t chu\u1ed7i v\u00e0 l\u1ea5y ra m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i \u0111\u00f3. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEFT v\u00e0 SUBSTITUTE \u0111\u1ec3 thay th\u1ebf m\u1ed9t ph\u1ea7n c\u1ee7a chu\u1ed7i b\u1eb1ng m\u1ed9t chu\u1ed7i kh\u00e1c. Theo d\u00f5i ti\u1ebfp n\u1ed9i dung h\u01b0\u1edbng d\u1eabn chi ti\u1ebft sau \u0111\u00e2y nh\u00e9.<\/p>\n<h3><strong>C\u00e1ch d\u00f9ng h\u00e0m LEFT trong Excel k\u1ebft h\u1ee3p v\u1edbi h\u00e0m SEARCH<\/strong><\/h3>\n<p>Khi k\u1ebft h\u1ee3p h\u00e0m LEFT v\u00e0 h\u00e0m SEARCH, ch\u00fang ta c\u00f3 th\u1ec3 truy xu\u1ea5t d\u1eef li\u1ec7u \u0111\u1ee9ng tr\u01b0\u1edbc m\u1ed9t k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh trong chu\u1ed7i. C\u1ee5 th\u1ec3, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SEARCH \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a k\u00fd t\u1ef1 \u0111\u00f3 trong chu\u1ed7i, sau \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m LEFT \u0111\u1ec3 l\u1ea5y ra t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 t\u1eeb \u0111\u1ea7u chu\u1ed7i cho \u0111\u1ebfn tr\u01b0\u1edbc k\u00fd t\u1ef1 \u0111\u00f3.<\/p>\n<p><strong>Ta c\u00f3 c\u00f4ng th\u1ee9c h\u00e0m LEFT k\u1ebft h\u1ee3p h\u00e0m SEARCH nh\u01b0 sau: =LEFT(text, SEARCH(\u201dk\u00fd t\u1ef1 truy xu\u1ea5t\u201c,text)-1).<\/strong><\/p>\n<p>V\u00ed d\u1ee5, gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 m\u1ed9t danh s\u00e1ch t\u00ean \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean trong c\u00f4ng ty v\u00e0 b\u1ea1n ch\u1ec9 mu\u1ed1n l\u1ea5y ra h\u1ecd c\u1ee7a h\u1ecd. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SEARCH \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a kho\u1ea3ng tr\u1eafng trong chu\u1ed7i t\u00ean \u0111\u1ea7y \u0111\u1ee7, sau \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m LEFT \u0111\u1ec3 l\u1ea5y ra t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 t\u1eeb \u0111\u1ea7u chu\u1ed7i cho \u0111\u1ebfn tr\u01b0\u1edbc kho\u1ea3ng tr\u1eafng \u0111\u00f3. K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 h\u1ecd c\u1ee7a nh\u00e2n vi\u00ean. C\u1ee5 th\u1ec3 c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c minh h\u1ecda nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u b\u00ean d\u01b0\u1edbi g\u1ed3m 3 c\u1ed9t: H\u1ecd v\u00e0 t\u00ean, L\u1edbp, M\u00e3 sinh vi\u00ean. Cho \u0111\u1ec1 b\u00e0i y\u00eau c\u1ea7u truy xu\u1ea5t ph\u1ea7n <strong>H\u1ecd<\/strong> t\u1eeb c\u1ed9t <strong>H\u1ecd v\u00e0 t\u00ean<\/strong>.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-231682 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-1.jpg\" alt=\"5-cach-dung-ham-left-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng trong b\u1ea3ng v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c =LEFT(B3, SEARCH(\u201d \u201c, B3)-1).<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-231683 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-2.jpg\" alt=\"5-cach-dung-ham-left-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n Enter \u0111\u1ec3 t\u00ednh to\u00e1n k\u1ebft qu\u1ea3 v\u00e0 Excel s\u1ebd hi\u1ec3n th\u1ecb ph\u1ea7n H\u1ecd c\u1ee7a d\u1eef li\u1ec7u trong c\u1ed9t H\u1ecd v\u00e0 t\u00ean.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-231684 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-3.jpg\" alt=\"5-cach-dung-ham-left-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><strong>C\u00e1ch d\u00f9ng h\u00e0m LEFT trong Excel k\u1ebft h\u1ee3p v\u1edbi h\u00e0m FIND<\/strong><\/h3>\n<p>Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m SEARCH \u0111\u1ec3 t\u00ecm ki\u1ebfm k\u00fd t\u1ef1, ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m FIND \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f9ng m\u1ed9t t\u00e1c v\u1ee5. Tuy nhi\u00ean, \u0111i\u1ec3m kh\u00e1c bi\u1ec7t gi\u1eefa hai h\u00e0m n\u00e0y l\u00e0 h\u00e0m SEARCH kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng trong khi h\u00e0m FIND l\u1ea1i ph\u00e2n bi\u1ec7t. Do \u0111\u00f3, khi s\u1eed d\u1ee5ng h\u00e0m SEARCH, ch\u00fang ta c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm k\u00fd t\u1ef1 b\u1ea5t k\u1ef3 trong chu\u1ed7i m\u00e0 kh\u00f4ng c\u1ea7n quan t\u00e2m \u0111\u1ebfn ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng.<\/p>\n<h3><strong>C\u00e1ch d\u00f9ng h\u00e0m LEFT trong Excel k\u1ebft h\u1ee3p v\u1edbi h\u00e0m VALUE<\/strong><\/h3>\n<p>Khi k\u1ebft h\u1ee3p h\u00e0m VALUE v\u1edbi h\u00e0m LEFT, b\u1ea1n c\u00f3 th\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i c\u1ee7a m\u1ed9t chu\u1ed7i d\u1eef li\u1ec7u v\u0103n b\u1ea3n v\u00e0 chuy\u1ec3n \u0111\u1ed5i ch\u00fang th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1. C\u1ee5 th\u1ec3, sau khi truy xu\u1ea5t \u0111\u01b0\u1ee3c chu\u1ed7i k\u00fd t\u1ef1 c\u1ea7n thi\u1ebft b\u1eb1ng h\u00e0m LEFT, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VALUE \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i \u0111\u00f3 th\u00e0nh m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p><strong>Ta c\u00f3 c\u00f4ng th\u1ee9c h\u00e0m LEFT k\u1ebft h\u1ee3p h\u00e0m VALUE nh\u01b0 sau: =VALUE(LEFT((text);[num_chars]))<\/strong><\/p>\n<p>V\u00ed d\u1ee5, gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch sinh vi\u00ean nh\u01b0 b\u00ean d\u01b0\u1edbi c\u00f3 m\u1ed9t c\u1ed9t l\u00e0 M\u00e3 sinh vi\u00ean. B\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t 2 k\u00fd t\u1ef1 s\u1ed1 \u0111\u1ea7u ti\u00ean trong m\u1ed7i \u00f4 c\u1ee7a c\u1ed9t M\u00e3 sinh vi\u00ean n\u00e0y v\u00e0 chuy\u1ec3n \u0111\u1ed5i ch\u00fang th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEFT \u0111\u1ec3 truy xu\u1ea5t m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i M\u00e3 sinh vi\u00ean, sau \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m VALUE \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i \u0111\u00f3 th\u00e0nh m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Cho th\u00f4ng tin trong b\u1ea3ng b\u00ean d\u01b0\u1edbi, tr\u00edch xu\u1ea5t 2 k\u00fd t\u1ef1 s\u1ed1 \u0111\u1ea7u ti\u00ean trong m\u1ed7i \u00f4 c\u1ee7a c\u1ed9t M\u00e3 sinh vi\u00ean v\u00e0 chuy\u1ec3n \u0111\u1ed5i ch\u00fang th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-231679 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-4.jpg\" alt=\"5-cach-dung-ham-left-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn m\u1ed9t \u00f4 ng\u1eabu nhi\u00ean v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c =VALUE(LEFT(D3,2)).<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-231680 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-5.jpg\" alt=\"5-cach-dung-ham-left-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n Enter \u0111\u1ec3 t\u00ednh to\u00e1n k\u1ebft qu\u1ea3 v\u00e0 Excel s\u1ebd hi\u1ec3n th\u1ecb 2 k\u00fd t\u1ef1 s\u1ed1 \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t mang gi\u00e1 tr\u1ecb s\u1ed1 c\u00f3 th\u1ec3 t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-231681 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-6.jpg\" alt=\"5-cach-dung-ham-left-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>L\u01b0u \u00fd r\u1eb1ng khi s\u1eed d\u1ee5ng h\u00e0m VALUE, b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng chu\u1ed7i d\u1eef li\u1ec7u v\u0103n b\u1ea3n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1. N\u1ebfu chu\u1ed7i kh\u00f4ng th\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1, h\u00e0m VALUE s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #VALUE!.<\/p>\n<h3><strong>C\u00e1ch d\u00f9ng h\u00e0m LEFT trong Excel k\u1ebft h\u1ee3p v\u1edbi h\u00e0m LEN<\/strong><\/h3>\n<p>H\u00e0m LEN trong Excel l\u00e0 m\u1ed9t h\u00e0m d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t chu\u1ed7i d\u1eef li\u1ec7u v\u0103n b\u1ea3n. N\u00f3 c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u00ednh to\u00e1n s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 trong m\u1ed9t \u00f4 ho\u1eb7c chu\u1ed7i v\u0103n b\u1ea3n b\u1ea5t k\u1ef3. Ngo\u00e0i vi\u1ec7c \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 trong chu\u1ed7i, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEN \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 ch\u1ec9 \u0111\u1ecbnh t\u00ednh t\u1eeb cu\u1ed1i chu\u1ed7i. \u0110i\u1ec1u n\u00e0y v\u00f4 c\u00f9ng thu\u1eadn ti\u1ec7n khi b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng kh\u1ecfi chu\u1ed7i ho\u1eb7c t\u00ednh to\u00e1n s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u00f2n l\u1ea1i trong chu\u1ed7i sau khi lo\u1ea1i b\u1ecf \u0111i m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng.<\/p>\n<p>V\u00ed d\u1ee5, gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 m\u1ed9t danh s\u00e1ch t\u00ean \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean trong c\u00f4ng ty v\u00e0 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf 4 k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng trong H\u1ecd v\u00e0 t\u00ean. C\u1ee5 th\u1ec3 c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c minh h\u1ecda nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Cho b\u1ea3ng d\u1eef li\u1ec7u b\u00ean d\u01b0\u1edbi trong \u0111\u00f3 c\u00f3 c\u1ed9t H\u1ecd v\u00e0 t\u00ean.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-231673 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-7.jpg\" alt=\"5-cach-dung-ham-left-trong-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn m\u1ed9t \u00f4 ng\u1eabu nhi\u00ean v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c =LEFT(B3,LEN(B3)-3).<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-231674 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-8.jpg\" alt=\"5-cach-dung-ham-left-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n Enter \u0111\u1ec3 t\u00ednh to\u00e1n k\u1ebft qu\u1ea3 v\u00e0 Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ea1i H\u1ecd v\u00e0 t\u00ean \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1eaft b\u1ecf \u0111i 4 k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-231675 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-9.jpg\" alt=\"5-cach-dung-ham-left-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>L\u01b0u \u00fd r\u1eb1ng khi s\u1eed d\u1ee5ng h\u00e0m LEN \u0111\u1ec3 t\u00ednh to\u00e1n s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 t\u1eeb cu\u1ed1i chu\u1ed7i, b\u1ea1n c\u1ea7n ph\u1ea3i tr\u1eeb \u0111i s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n lo\u1ea1i b\u1ecf kh\u1ecfi t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i.<\/p>\n<h3><strong>H\u00e0m LEFT trong Google Sheets<\/strong><\/h3>\n<p>H\u00e0m LEFT trong Google Sheets \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i c\u1ee7a m\u1ed9t chu\u1ed7i d\u1eef li\u1ec7u v\u0103n b\u1ea3n. N\u00f3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m LEFT trong Excel v\u00e0 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c ph\u1ea7n t\u1eed con t\u1eeb chu\u1ed7i d\u1eef li\u1ec7u v\u0103n b\u1ea3n. Ngo\u00e0i c\u00e1ch s\u1eed d\u1ee5ng th\u00f4ng th\u01b0\u1eddng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 trong Excel v\u1eeba \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u \u1edf tr\u00ean, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m LEFT v\u1edbi h\u00e0m FIND \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t chu\u1ed7i con b\u1eaft \u0111\u1ea7u t\u1eeb m\u1ed9t v\u1ecb tr\u00ed c\u1ee5 th\u1ec3 trong chu\u1ed7i d\u1eef li\u1ec7u v\u0103n b\u1ea3n.<\/p>\n<p><strong>Ta c\u00f3 c\u00f4ng th\u1ee9c h\u00e0m LEFT k\u1ebft h\u1ee3p h\u00e0m FIND trong Google Sheets =LEFT(text,FIND(&#8221; &#8220;,text)-1).<\/strong><\/p>\n<p>V\u00ed d\u1ee5, gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 m\u1ed9t danh s\u00e1ch t\u00ean \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean trong c\u00f4ng ty v\u00e0 b\u1ea1n ch\u1ec9 mu\u1ed1n l\u1ea5y ra h\u1ecd c\u1ee7a h\u1ecd. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m FIND \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a kho\u1ea3ng tr\u1eafng trong chu\u1ed7i t\u00ean \u0111\u1ea7y \u0111\u1ee7, sau \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m LEFT \u0111\u1ec3 l\u1ea5y ra t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 t\u1eeb \u0111\u1ea7u chu\u1ed7i cho \u0111\u1ebfn tr\u01b0\u1edbc kho\u1ea3ng tr\u1eafng \u0111\u00f3. K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 h\u1ecd c\u1ee7a nh\u00e2n vi\u00ean. C\u1ee5 th\u1ec3 c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c minh h\u1ecda nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn \u00f4 ch\u1ee9a d\u1eef li\u1ec7u ph\u1ee5c v\u1ee5 nhu c\u1ea7u truy xu\u1ea5t.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-231676 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-10.jpg\" alt=\"5-cach-dung-ham-left-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn m\u1ed9t \u00f4 ng\u1eabu nhi\u00ean v\u00e0 g\u00f5 c\u00f4ng th\u1ee9c =LEFT(text,FIND(&#8220;&#8221;,text)-1).<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-231677 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-11.jpg\" alt=\"5-cach-dung-ham-left-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n Enter \u0111\u1ec3 t\u00ednh to\u00e1n k\u1ebft qu\u1ea3 v\u00e0 Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ea1i H\u1ecd t\u1eeb c\u1ed9t H\u1ecd v\u00e0 t\u00ean.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-left-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-231678 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-12.jpg\" alt=\"5-cach-dung-ham-left-trong-excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Left trong Excel<\/strong><\/h2>\n<p>Khi s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel, c\u00f3 m\u1ed9t s\u1ed1 l\u01b0u \u00fd nh\u01b0 sau:<\/p>\n<ul>\n<li>H\u00e0m LEFT trong Excel c\u00f3 kh\u1ea3 n\u0103ng l\u1ea5y ra c\u00e1c k\u00fd t\u1ef1 t\u1eeb ph\u00eda b\u00ean tr\u00e1i c\u1ee7a v\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t. Khi s\u1eed d\u1ee5ng h\u00e0m, b\u1ea1n c\u1ea7n nh\u1eadp v\u0103n b\u1ea3n c\u1ea7n tr\u00edch xu\u1ea5t v\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y v\u00e0o trong h\u00e0m LEFT.<\/li>\n<li>Trong ph\u1ea7n num_chars c\u1ee7a h\u00e0m, b\u1ea1n c\u1ea7n nh\u1eadp s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y sau \u0111\u00f3 b\u1ea5m d\u1ea5u ngo\u1eb7c ph\u1ea3i &#8220;)&#8221; \u0111\u1ec3 k\u1ebft th\u00fac tham s\u1ed1. N\u1ebfu \u0111\u1ec3 tr\u1ed1ng ph\u1ea7n n\u00e0y, m\u00e1y s\u1ebd t\u1ef1 \u0111i\u1ec1n 0 ho\u1eb7c 1, tuy nhi\u00ean, \u0111\u1ec3 tr\u00e1nh ph\u00e1t sinh l\u1ed7i, n\u00ean nh\u1eadp gi\u00e1 tr\u1ecb s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ea7n tr\u00edch xu\u1ea5t.<\/li>\n<li>H\u00e0m LEFT trong Excel c\u0169ng c\u00f3 th\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c ch\u1eef s\u1ed1 t\u1eeb 0-9, t\u1eeb c\u00e1c s\u1ed1. Tuy nhi\u00ean, n\u1ebfu s\u1ed1 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng trong Excel v\u1edbi k\u00fd hi\u1ec7u ti\u1ec1n t\u1ec7 ($) th\u00ec k\u00fd hi\u1ec7u n\u00e0y kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t ph\u1ea7n c\u1ee7a s\u1ed1 v\u00e0 kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ednh ho\u1eb7c tr\u00edch xu\u1ea5t b\u1edfi h\u00e0m LEFT.<\/li>\n<li>N\u1ebfu b\u1ea1n c\u1ea7n tr\u00edch xu\u1ea5t c\u00e1c k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a v\u0103n b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m RIGHT.<\/li>\n<li>Ngo\u00e0i ra, n\u1ebfu b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t m\u1ed9t ph\u1ea7n c\u1ee7a v\u0103n b\u1ea3n t\u1eeb v\u1ecb tr\u00ed b\u1ea5t k\u1ef3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m MID.<\/li>\n<li>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEFT \u0111\u1ec3 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb c\u00e1c \u00f4 kh\u00e1c trong b\u1ea3ng t\u00ednh Excel.<\/li>\n<li>Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng h\u00e0m LEFT, b\u1ea1n c\u1ea7n ki\u1ec3m tra k\u1ef9 \u0111\u1ea7u v\u00e0o c\u1ee7a h\u00e0m v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng n\u00f3 \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 tr\u00e1nh ph\u00e1t sinh l\u1ed7i trong c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n.<\/li>\n<\/ul>\n<h2><strong>C\u00e1ch x\u1eed l\u00fd c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m LEFT<\/strong><\/h2>\n<p>Khi s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel, c\u00f3 m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea7n l\u01b0u \u00fd \u0111\u1ec3 tr\u00e1nh ph\u00e1t sinh sai s\u00f3t trong c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n:<\/p>\n<h3><strong>L\u1ed7i #VALUE!<\/strong><\/h3>\n<p>\u0110\u00e2y l\u00e0 l\u1ed7i th\u01b0\u1eddng x\u1ea3y ra khi chu\u1ed7i \u0111\u1ea7u v\u00e0o c\u1ee7a h\u00e0m LEFT kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, v\u00ed d\u1ee5 nh\u01b0 m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 ho\u1eb7c m\u1ed9t gi\u00e1 tr\u1ecb r\u1ed7ng. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i \u0111\u1ea7u v\u00e0o c\u1ee7a h\u00e0m v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng n\u00f3 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n. N\u1ebfu \u0111\u1ea7u v\u00e0o c\u1ee7a h\u00e0m l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m TEXT \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u00e1 tr\u1ecb s\u1ed1 sang gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n tr\u01b0\u1edbc khi truy\u1ec1n v\u00e0o h\u00e0m LEFT.<\/p>\n<h3><strong>L\u1ed7i #REF!<\/strong><\/h3>\n<p>L\u1ed7i #REF! x\u1ea3y ra khi b\u1ea1n c\u1ed1 g\u1eafng tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 l\u1edbn h\u01a1n s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 trong chu\u1ed7i \u0111\u1ea7u v\u00e0o. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng n\u00f3 kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i \u0111\u1ea7u v\u00e0o. N\u1ebfu s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ea7n tr\u00edch xu\u1ea5t l\u1edbn h\u01a1n \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i \u0111\u1ea7u v\u00e0o, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t h\u00e0m IF \u0111\u1ec3 ki\u1ec3m tra \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i \u0111\u1ea7u v\u00e0o tr\u01b0\u1edbc khi tr\u00edch xu\u1ea5t.<\/p>\n<h3><strong>L\u1ed7i #NUM!<\/strong><\/h3>\n<p>L\u1ed7i #NUM! x\u1ea3y ra khi b\u1ea1n c\u1ed1 g\u1eafng tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 b\u1eb1ng ho\u1eb7c nh\u1ecf h\u01a1n 0. \u0110i\u1ec1u b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 ki\u1ec3m tra l\u1ea1i s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng n\u00f3 l\u1edbn h\u01a1n 0.<\/p>\n<h3><strong>L\u1ed7i #NAME?<\/strong><\/h3>\n<p>L\u1ed7i #NAME? x\u1ea3y ra khi b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t t\u00ean h\u00e0m kh\u00f4ng h\u1ee3p l\u1ec7 ho\u1eb7c kh\u00f4ng t\u1ed3n t\u1ea1i trong Excel. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i t\u00ean c\u1ee7a h\u00e0m v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng n\u00f3 \u0111\u01b0\u1ee3c vi\u1ebft \u0111\u00fang c\u00fa ph\u00e1p v\u00e0 l\u00e0 m\u1ed9t t\u00ean h\u00e0m h\u1ee3p l\u1ec7 trong Excel.<\/p>\n<p>\u0110\u1ec3 tr\u00e1nh c\u00e1c l\u1ed7i tr\u00ean khi s\u1eed d\u1ee5ng h\u00e0m LEFT, b\u1ea1n c\u1ea7n ki\u1ec3m tra k\u1ef9 \u0111\u1ea7u v\u00e0o c\u1ee7a h\u00e0m v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng n\u00f3 \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng v\u00e0 \u0111\u00fang \u0111\u1ed9 d\u00e0i c\u1ea7n thi\u1ebft. N\u1ebfu g\u1eb7p ph\u1ea3i l\u1ed7i, b\u1ea1n c\u00f3 th\u1ec3 s\u1eeda ch\u1eefa c\u00f4ng th\u1ee9c ho\u1eb7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 tr\u00edch xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 t\u1eeb v\u1ecb tr\u00ed c\u1ee5 th\u1ec3 trong chu\u1ed7i \u0111\u1ea7u v\u00e0o. Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c, n\u1ebfu b\u1ea1n g\u1eb7p ph\u1ea3i l\u1ed7i trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng h\u00e0m LEFT, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Debugging c\u1ee7a Excel \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh nguy\u00ean nh\u00e2n c\u1ee7a l\u1ed7i v\u00e0 s\u1eeda ch\u1eefa c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c t\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn ho\u1eb7c h\u1ecfi \u0111\u00e1p tr\u00ean c\u00e1c di\u1ec5n \u0111\u00e0n Excel \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch kh\u1eafc ph\u1ee5c c\u00e1c l\u1ed7i c\u1ee5 th\u1ec3 trong Excel.<\/p>\n<div class=\"ChatMessage_messageRow__7yIr2\" data-complete=\"true\">\n<div class=\"ChatMessage_messageWrapper__Zf87D\">\n<div>\n<div class=\"Message_botOptimisticFooter__aQiG9\">\n<p><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/tong-hop-cac-cach-tu-hoc-excel-online\">Trong Excel<\/a>, h\u00e0m LEFT l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m ph\u1ed5 bi\u1ebfn \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c k\u00fd t\u1ef1 t\u1eeb m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n b\u1eaft \u0111\u1ea7u t\u1eeb ph\u00eda b\u00ean tr\u00e1i. B\u00ean c\u1ea1nh \u0111\u00f3, <a href=\"https:\/\/hoanghamobile.com\/\">Ho\u00e0ng H\u00e0 Mobile<\/a> c\u0169ng t\u1ed5ng h\u1ee3p th\u00eam m\u1ed9t s\u1ed1 c\u00e1ch d\u00f9ng h\u00e0m LEFT trong Excel c\u0169ng th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1c. Mong r\u1eb1ng b\u00e0i vi\u1ebft n\u00e0y mang l\u1ea1i nhi\u1ec1u th\u00f4ng tin h\u1eefu \u00edch d\u00e0nh cho b\u1ea1n.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m LEFT trong Excel l\u00e0 h\u00e0m v\u0103n b\u1ea3n ph\u1ed5 bi\u1ebfn gi\u00fap tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i chu\u1ed7i (v\u00ed d\u1ee5: l\u1ea5y m\u00e3 t\u1ec9nh t\u1eeb m\u00e3 b\u01b0u \u0111i\u1ec7n). Kh\u00f4ng ch\u1ec9 c\u01a1 b\u1ea3n, h\u00e0m LEFT c\u00f2n k\u1ebft h\u1ee3p m\u1ea1nh m\u1ebd v\u1edbi SEARCH, LEN, VALUE \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p. B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn chi [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":231688,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-231402","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"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>H\u00e0m LEFT trong Excel: C\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft k\u00e8m v\u00ed d\u1ee5 th\u1ef1c t\u1ebf<\/title>\n<meta name=\"description\" content=\"H\u00e0m LEFT trong Excel d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 b\u00ean tr\u00e1i chu\u1ed7i v\u0103n b\u1ea3n. H\u01b0\u1edbng d\u1eabn c\u00fa ph\u00e1p, v\u00ed d\u1ee5 k\u1ebft h\u1ee3p SEARCH, LEN, VALUE chi ti\u1ebft. \u00c1p d\u1ee5ng ngay cho Excel &amp; Google Sheets\" \/>\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\/5-cach-dung-ham-left-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m LEFT trong Excel: C\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m LEFT trong Excel d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 b\u00ean tr\u00e1i chu\u1ed7i v\u0103n b\u1ea3n. H\u01b0\u1edbng d\u1eabn c\u00fa ph\u00e1p, v\u00ed d\u1ee5 k\u1ebft h\u1ee3p SEARCH, LEN, VALUE chi ti\u1ebft. \u00c1p d\u1ee5ng ngay cho Excel &amp; Google Sheets\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-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-07-17T05:18:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-25T15:16:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-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=\"Vo Lan\" \/>\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=\"Vo Lan\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 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\/5-cach-dung-ham-left-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/\"},\"author\":{\"name\":\"Vo Lan\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0\"},\"headline\":\"H\u00e0m LEFT trong Excel: C\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao\",\"datePublished\":\"2023-07-17T05:18:40+00:00\",\"dateModified\":\"2025-12-25T15:16:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/\"},\"wordCount\":3370,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/\",\"name\":\"H\u00e0m LEFT trong Excel: C\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft k\u00e8m v\u00ed d\u1ee5 th\u1ef1c t\u1ebf\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel.jpg\",\"datePublished\":\"2023-07-17T05:18:40+00:00\",\"dateModified\":\"2025-12-25T15:16:45+00:00\",\"description\":\"H\u00e0m LEFT trong Excel d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 b\u00ean tr\u00e1i chu\u1ed7i v\u0103n b\u1ea3n. H\u01b0\u1edbng d\u1eabn c\u00fa ph\u00e1p, v\u00ed d\u1ee5 k\u1ebft h\u1ee3p SEARCH, LEN, VALUE chi ti\u1ebft. \u00c1p d\u1ee5ng ngay cho Excel & Google Sheets\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"5-cach-dung-ham-left-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m LEFT trong Excel: C\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao\"}]},{\"@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\/0a812d5b8175a4091883285291c094d0\",\"name\":\"Vo Lan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g\",\"caption\":\"Vo Lan\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m LEFT trong Excel: C\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft k\u00e8m v\u00ed d\u1ee5 th\u1ef1c t\u1ebf","description":"H\u00e0m LEFT trong Excel d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 b\u00ean tr\u00e1i chu\u1ed7i v\u0103n b\u1ea3n. H\u01b0\u1edbng d\u1eabn c\u00fa ph\u00e1p, v\u00ed d\u1ee5 k\u1ebft h\u1ee3p SEARCH, LEN, VALUE chi ti\u1ebft. \u00c1p d\u1ee5ng ngay cho Excel & Google Sheets","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\/5-cach-dung-ham-left-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m LEFT trong Excel: C\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao","og_description":"H\u00e0m LEFT trong Excel d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 b\u00ean tr\u00e1i chu\u1ed7i v\u0103n b\u1ea3n. H\u01b0\u1edbng d\u1eabn c\u00fa ph\u00e1p, v\u00ed d\u1ee5 k\u1ebft h\u1ee3p SEARCH, LEN, VALUE chi ti\u1ebft. \u00c1p d\u1ee5ng ngay cho Excel & Google Sheets","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-07-17T05:18:40+00:00","article_modified_time":"2025-12-25T15:16:45+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel.jpg","type":"image\/jpeg"}],"author":"Vo Lan","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Vo Lan","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"15 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/"},"author":{"name":"Vo Lan","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0"},"headline":"H\u00e0m LEFT trong Excel: C\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao","datePublished":"2023-07-17T05:18:40+00:00","dateModified":"2025-12-25T15:16:45+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/"},"wordCount":3370,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/","name":"H\u00e0m LEFT trong Excel: C\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft k\u00e8m v\u00ed d\u1ee5 th\u1ef1c t\u1ebf","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel.jpg","datePublished":"2023-07-17T05:18:40+00:00","dateModified":"2025-12-25T15:16:45+00:00","description":"H\u00e0m LEFT trong Excel d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 b\u00ean tr\u00e1i chu\u1ed7i v\u0103n b\u1ea3n. H\u01b0\u1edbng d\u1eabn c\u00fa ph\u00e1p, v\u00ed d\u1ee5 k\u1ebft h\u1ee3p SEARCH, LEN, VALUE chi ti\u1ebft. \u00c1p d\u1ee5ng ngay cho Excel & Google Sheets","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-left-trong-excel.jpg","width":1200,"height":628,"caption":"5-cach-dung-ham-left-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/5-cach-dung-ham-left-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m LEFT trong Excel: C\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao"}]},{"@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\/0a812d5b8175a4091883285291c094d0","name":"Vo Lan","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g","caption":"Vo Lan"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/231402","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\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=231402"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/231402\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/231688"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=231402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=231402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=231402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}