{"id":483327,"date":"2025-08-21T11:56:56","date_gmt":"2025-08-21T04:56:56","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=483327"},"modified":"2025-08-21T11:56:56","modified_gmt":"2025-08-21T04:56:56","slug":"ham-left-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/","title":{"rendered":"H\u00e0m Left trong Excel: C\u00fa ph\u00e1p chu\u1ea9n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng Excel, vi\u1ec7c thao t\u00e1c v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u0103n b\u1ea3n lu\u00f4n \u0111\u00f3ng vai tr\u00f2 then ch\u1ed1t, \u0111\u1eb7c bi\u1ec7t khi c\u1ea7n t\u00e1ch ho\u1eb7c tr\u00edch xu\u1ea5t th\u00f4ng tin t\u1eeb c\u00e1c chu\u1ed7i k\u00fd t\u1ef1. M\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 \u0111\u00e1ng tin c\u1eady nh\u1ea5t \u0111\u1ec3 th\u1ef1c hi\u1ec7n nhi\u1ec7m v\u1ee5 n\u00e0y ch\u00ednh l\u00e0 <\/span><b>h\u00e0m LEFT trong Excel<\/b><span style=\"font-weight: 400;\">. Ngay sau \u0111\u00e2y, <strong>Ho\u00e0ng H\u00e0 Mobile<\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 d\u1ec5 d\u00e0ng.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m Left trong Excel l\u00e0 g\u00ec?<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, vi\u1ec7c x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00e1ch d\u1eef li\u1ec7u chu\u1ed7i v\u0103n b\u1ea3n l\u00e0 m\u1ed9t trong nh\u1eefng t\u00e1c v\u1ee5 xu\u1ea5t hi\u1ec7n th\u01b0\u1eddng xuy\u00ean nh\u1ea5t. M\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c cho nhu c\u1ea7u n\u00e0y ch\u00ednh l\u00e0 h\u00e0m LEFT. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m v\u0103n b\u1ea3n c\u01a1 b\u1ea3n, \u0111\u01b0\u1ee3c Microsoft t\u00edch h\u1ee3p s\u1eb5n trong Excel, gi\u00fap ng\u01b0\u1eddi d\u00f9ng nhanh ch\u00f3ng l\u1ea5y ra m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh b\u1eaft \u0111\u1ea7u t\u1eeb ph\u00eda b\u00ean tr\u00e1i c\u1ee7a m\u1ed9t chu\u1ed7i.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/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-483329 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-1.jpg\" alt=\"ham-LEFT-trong-Excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110i\u1ec3m n\u1ed5i b\u1eadt c\u1ee7a h\u00e0m LEFT n\u1eb1m \u1edf ch\u1ed7, thay v\u00ec ph\u1ea3i thao t\u00e1c th\u1ee7 c\u00f4ng nh\u01b0 c\u1eaft chu\u1ed7i b\u1eb1ng tay ho\u1eb7c vi\u1ebft l\u1ea1i d\u1eef li\u1ec7u, ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c ng\u1eafn g\u1ecdn. Ch\u1ec9 \u0111\u1ecbnh chu\u1ed7i g\u1ed1c v\u00e0 s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y, Excel s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 ngay l\u1eadp t\u1ee9c. \u0110i\u1ec1u n\u00e0y gi\u00fap ti\u1ebft ki\u1ec7m \u0111\u00e1ng k\u1ec3 th\u1eddi gian, nh\u1ea5t l\u00e0 trong tr\u01b0\u1eddng h\u1ee3p ph\u1ea3i x\u1eed l\u00fd h\u00e0ng tr\u0103m ho\u1eb7c h\u00e0ng ngh\u00ecn d\u00f2ng d\u1eef li\u1ec7u.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t \u0111i\u1ec3m c\u1ea7n l\u01b0u \u00fd l\u00e0 h\u00e0m LEFT ch\u1ec9 l\u00e0m vi\u1ec7c v\u1edbi v\u0103n b\u1ea3n ho\u1eb7c chu\u1ed7i k\u00fd t\u1ef1, nh\u01b0ng v\u1eabn c\u00f3 th\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c s\u1ed1 khi ch\u00fang n\u1eb1m trong v\u0103n b\u1ea3n. Tuy nhi\u00ean, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 m\u1eb7c \u0111\u1ecbnh v\u1eabn \u1edf d\u1ea1ng chu\u1ed7i, v\u00ec v\u1eady n\u1ebfu ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n s\u1eed d\u1ee5ng ch\u00fang cho t\u00ednh to\u00e1n s\u1ed1 h\u1ecdc th\u00ec c\u1ea7n k\u1ebft h\u1ee3p th\u00eam c\u00e1c h\u00e0m kh\u00e1c.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p chu\u1ea9n c\u1ee7a h\u00e0m Left trong Excel<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 khai th\u00e1c t\u1ed1i \u0111a hi\u1ec7u qu\u1ea3 c\u1ee7a h\u00e0m LEFT, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n n\u1eafm r\u00f5 c\u00fa ph\u00e1p chu\u1ea9n m\u00e0 Excel cung c\u1ea5p. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m n\u00e0y r\u1ea5t \u0111\u01a1n gi\u1ea3n, ph\u00f9 h\u1ee3p cho c\u1ea3 nh\u1eefng ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u s\u1eed d\u1ee5ng Excel:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=LEFT(text; [num_chars])<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">text: L\u00e0 chu\u1ed7i v\u0103n b\u1ea3n g\u1ed1c ho\u1eb7c \u00f4 d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t. \u0110\u1ed1i s\u1ed1 n\u00e0y b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3, n\u1ebfu kh\u00f4ng c\u00f4ng th\u1ee9c s\u1ebd b\u00e1o l\u1ed7i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">num_chars: L\u00e0 s\u1ed1 k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n l\u1ea5y ra t\u00ednh t\u1eeb ph\u00eda b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i. \u0110\u00e2y l\u00e0 \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn. N\u1ebfu b\u1ecf tr\u1ed1ng, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3u l\u00e0 b\u1ea1n ch\u1ec9 mu\u1ed1n l\u1ea5y duy nh\u1ea5t 1 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/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-483330 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-2.jpg\" alt=\"ham-LEFT-trong-Excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c <\/span><span style=\"font-weight: 400;\">=LEFT(&#8220;Excel&#8221;; 2)<\/span><span style=\"font-weight: 400;\"> s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 &#8220;Ex&#8221;.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu vi\u1ebft <\/span><span style=\"font-weight: 400;\">=LEFT(&#8220;Excel&#8221;)<\/span><span style=\"font-weight: 400;\"> m\u00e0 kh\u00f4ng ch\u1ec9 r\u00f5 s\u1ed1 k\u00fd t\u1ef1, Excel s\u1ebd tr\u1ea3 v\u1ec1 &#8220;E&#8221;.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p s\u1ed1 k\u00fd t\u1ef1 ch\u1ec9 \u0111\u1ecbnh l\u1edbn h\u01a1n \u0111\u1ed9 d\u00e0i chu\u1ed7i, Excel s\u1ebd tr\u1ea3 v\u1ec1 to\u00e0n b\u1ed9 chu\u1ed7i. V\u00ed d\u1ee5 <\/span><span style=\"font-weight: 400;\">=LEFT(&#8220;Data&#8221;; 10)<\/span><span style=\"font-weight: 400;\"> v\u1eabn tr\u1ea3 v\u1ec1 &#8220;Data&#8221;.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu nh\u1eadp s\u1ed1 \u00e2m, c\u00f4ng th\u1ee9c s\u1ebd kh\u00f4ng h\u1ee3p l\u1ec7 v\u00e0 hi\u1ec3n th\u1ecb l\u1ed7i #VALUE!.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110i\u1ec3m quan tr\u1ecdng \u1edf \u0111\u00e2y l\u00e0 h\u00e0m LEFT lu\u00f4n tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n. Ngay c\u1ea3 khi b\u1ea1n tr\u00edch ra c\u00e1c k\u00fd t\u1ef1 l\u00e0 con s\u1ed1, Excel c\u0169ng coi ch\u00fang nh\u01b0 chu\u1ed7i k\u00fd t\u1ef1. Do \u0111\u00f3, \u0111\u1ec3 d\u00f9ng cho t\u00ednh to\u00e1n, b\u1ea1n c\u1ea7n chuy\u1ec3n \u0111\u1ed5i sang d\u1ea1ng s\u1ed1 b\u1eb1ng c\u00e1c h\u00e0m b\u1ed5 tr\u1ee3 nh\u01b0 VALUE.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Left trong Excel \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 b\u00ean tr\u00e1i<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m LEFT \u0111\u1ec3 c\u1eaft chu\u1ed7i t\u1eeb b\u00ean tr\u00e1i kh\u00e1 \u0111\u01a1n gi\u1ea3n v\u00e0 tr\u1ef1c quan. Ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n x\u00e1c \u0111\u1ecbnh chu\u1ed7i d\u1eef li\u1ec7u v\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ea7n tr\u00edch xu\u1ea5t. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Kh\u1edfi \u0111\u1ed9ng file Excel m\u00e0 b\u1ea1n mu\u1ed1n thao t\u00e1c v\u1edbi d\u1eef li\u1ec7u. X\u00e1c \u0111\u1ecbnh c\u1ed9t ho\u1eb7c \u00f4 ch\u1ee9a v\u0103n b\u1ea3n g\u1ed1c m\u00e0 b\u1ea1n mu\u1ed1n c\u1eaft chu\u1ed7i.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/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-483331 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-3.jpg\" alt=\"ham-LEFT-trong-Excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: X\u00e1c \u0111\u1ecbnh v\u00e0 nh\u1ea5p v\u00e0o \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: G\u00f5 c\u00f4ng th\u1ee9c h\u00e0m LEFT v\u1edbi c\u00fa ph\u00e1p chu\u1ea9n. V\u00ed d\u1ee5:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=LEFT(B3;4)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3, \u00f4 B2 ch\u1ee9a chu\u1ed7i g\u1ed1c v\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y 4 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean t\u1eeb b\u00ean tr\u00e1i.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/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-483332 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-4.jpg\" alt=\"ham-LEFT-trong-Excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Nh\u1ea5n Enter \u0111\u1ec3 Excel tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3. N\u1ebfu mu\u1ed1n \u00e1p d\u1ee5ng cho nhi\u1ec1u \u00f4 kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng to\u00e0n b\u1ed9 c\u1ed9t.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/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-483333 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-5.jpg\" alt=\"ham-LEFT-trong-Excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t v\u00ed d\u1ee5 minh h\u1ecda: Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch m\u00e3 s\u1ea3n ph\u1ea9m trong c\u1ed9t B, v\u1edbi \u0111\u1ecbnh d\u1ea1ng \u201cAB1234\u201d. B\u1ea1n mu\u1ed1n l\u1ea5y ph\u1ea7n ti\u1ec1n t\u1ed1 \u201cAB\u201d \u0111\u1ec3 ph\u00e2n lo\u1ea1i. Khi nh\u1eadp c\u00f4ng th\u1ee9c <\/span><span style=\"font-weight: 400;\">=LEFT(B2;2)<\/span><span style=\"font-weight: 400;\">, Excel s\u1ebd tr\u1ea3 v\u1ec1 \u201cAB\u201d.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110i\u1ec3m c\u1ea7n l\u01b0u \u00fd l\u00e0 s\u1ed1 k\u00fd t\u1ef1 b\u1ea1n nh\u1eadp trong c\u00f4ng th\u1ee9c ph\u1ea3i ph\u00f9 h\u1ee3p v\u1edbi c\u1ea5u tr\u00fac d\u1eef li\u1ec7u. N\u1ebfu nh\u1eadp nhi\u1ec1u h\u01a1n s\u1ed1 k\u00fd t\u1ef1 th\u1ef1c t\u1ebf, Excel s\u1ebd kh\u00f4ng b\u00e1o l\u1ed7i m\u00e0 ch\u1ec9 tr\u1ea3 v\u1ec1 to\u00e0n b\u1ed9 chu\u1ed7i. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu nh\u1eadp gi\u00e1 tr\u1ecb \u00e2m, c\u00f4ng th\u1ee9c s\u1ebd b\u00e1o l\u1ed7i #VALUE!.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m Left trong Excel v\u1edbi c\u00e1c h\u00e0m kh\u00e1c<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong th\u1ef1c t\u1ebf, h\u00e0m LEFT hi\u1ebfm khi \u0111\u1ee9ng m\u1ed9t m\u00ecnh. \u0110\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p h\u01a1n, ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng k\u1ebft h\u1ee3p LEFT v\u1edbi c\u00e1c h\u00e0m kh\u00e1c.\u00a0<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p h\u00e0m Value v\u00e0 Left<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m LEFT tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u1ea1ng chu\u1ed7i, ngay c\u1ea3 khi k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t l\u00e0 s\u1ed1. \u0110i\u1ec1u n\u00e0y \u0111\u00f4i khi g\u00e2y b\u1ea5t ti\u1ec7n khi b\u1ea1n mu\u1ed1n ti\u1ebfp t\u1ee5c t\u00ednh to\u00e1n. \u0110\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m VALUE \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i th\u00e0nh s\u1ed1.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: B\u1ea1n c\u00f3 chu\u1ed7i \u201c2023ABC\u201d, c\u1ea7n l\u1ea5y ra 4 k\u00fd t\u1ef1 \u0111\u1ea7u v\u00e0 s\u1eed d\u1ee5ng ch\u00fang nh\u01b0 m\u1ed9t s\u1ed1. N\u1ebfu ch\u1ec9 d\u00f9ng <\/span><span style=\"font-weight: 400;\">=LEFT(A2;4)<\/span><span style=\"font-weight: 400;\">, Excel s\u1ebd tr\u1ea3 v\u1ec1 \u201c2023\u201d nh\u01b0ng \u1edf d\u1ea1ng v\u0103n b\u1ea3n. Khi k\u1ebft h\u1ee3p:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=VALUE(LEFT(A2;4))<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Excel s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 2023 \u1edf d\u1ea1ng s\u1ed1 nguy\u00ean, c\u00f3 th\u1ec3 d\u00f9ng cho ph\u00e9p c\u1ed9ng, tr\u1eeb, nh\u00e2n, chia.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/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-483334 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-6.jpg\" alt=\"ham-LEFT-trong-Excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch k\u1ebft h\u1ee3p n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch trong qu\u1ea3n l\u00fd d\u1eef li\u1ec7u nh\u01b0 m\u00e3 nh\u00e2n vi\u00ean, s\u1ed1 seri, ho\u1eb7c n\u0103m trong chu\u1ed7i k\u00fd t\u1ef1. B\u1ea1n v\u1eeba gi\u1eef \u0111\u01b0\u1ee3c kh\u1ea3 n\u0103ng tr\u00edch xu\u1ea5t, v\u1eeba thu\u1eadn ti\u1ec7n cho vi\u1ec7c t\u00ednh to\u00e1n ti\u1ebfp theo.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p h\u00e0m Left v\u00e0 h\u00e0m Len<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, khi s\u1eed d\u1ee5ng <\/span><b>h\u00e0m LEFT trong Excel<\/b><span style=\"font-weight: 400;\">, b\u1ea1n kh\u00f4ng ch\u1ec9 mu\u1ed1n l\u1ea5y k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i m\u00e0 c\u00f2n c\u1ea7n b\u1ecf \u0111i m\u1ed9t ph\u1ea7n n\u00e0o \u0111\u00f3 t\u1eeb cu\u1ed1i chu\u1ed7i. \u0110\u00e2y l\u00e0 l\u00fac h\u00e0m LEN ph\u00e1t huy t\u00e1c d\u1ee5ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: B\u1ea1n c\u00f3 chu\u1ed7i \u201cExcel2025\u201d v\u00e0 mu\u1ed1n b\u1ecf 4 k\u00fd t\u1ef1 cu\u1ed1i (\u201c2025\u201d), ch\u1ec9 gi\u1eef l\u1ea1i ch\u1eef \u201cExcel\u201d. Khi \u0111\u00f3 c\u00f4ng th\u1ee9c s\u1ebd l\u00e0:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=LEFT(A2; LEN(A2)-4)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/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-483335 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-7.jpg\" alt=\"ham-LEFT-trong-Excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m LEN t\u00ednh t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 trong \u00f4, sau \u0111\u00f3 tr\u1eeb \u0111i s\u1ed1 l\u01b0\u1ee3ng b\u1ea1n mu\u1ed1n b\u1ecf \u0111i. H\u00e0m LEFT s\u1ebd tr\u00edch xu\u1ea5t ph\u1ea7n c\u00f2n l\u1ea1i t\u1eeb b\u00ean tr\u00e1i.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch k\u1ebft h\u1ee3p n\u00e0y th\u01b0\u1eddng d\u00f9ng khi x\u1eed l\u00fd d\u1eef li\u1ec7u c\u00f3 h\u1eadu t\u1ed1 c\u1ed1 \u0111\u1ecbnh, ch\u1eb3ng h\u1ea1n lo\u1ea1i b\u1ecf m\u00e3 n\u0103m, k\u00fd t\u1ef1 ki\u1ec3m tra, ho\u1eb7c \u0111u\u00f4i s\u1ea3n ph\u1ea9m. \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf ph\u1ed5 bi\u1ebfn nh\u1ea5t c\u1ee7a LEFT k\u1ebft h\u1ee3p v\u1edbi LEN.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p h\u00e0m Left v\u00e0 h\u00e0m Search<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m SEARCH (ho\u1eb7c FIND) gi\u00fap x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c chu\u1ed7i con trong v\u0103n b\u1ea3n. Khi k\u1ebft h\u1ee3p v\u1edbi <\/span><b>h\u00e0m LEFT trong Excel<\/b><span style=\"font-weight: 400;\">, b\u1ea1n c\u00f3 th\u1ec3 linh ho\u1ea1t h\u01a1n trong vi\u1ec7c c\u1eaft chu\u1ed7i theo v\u1ecb tr\u00ed mong mu\u1ed1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: B\u1ea1n c\u00f3 danh s\u00e1ch h\u1ecd t\u00ean \u0111\u1ea7y \u0111\u1ee7 nh\u01b0 \u201cNguy\u1ec5n V\u0103n A\u201d v\u00e0 mu\u1ed1n t\u00e1ch ph\u1ea7n h\u1ecd. C\u00f4ng th\u1ee9c s\u1ebd l\u00e0:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=LEFT(A2; SEARCH(&#8221; &#8220;; A2)-1)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/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-483336 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-8.jpg\" alt=\"ham-LEFT-trong-Excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u1ede \u0111\u00e2y, h\u00e0m SEARCH t\u00ecm kho\u1ea3ng tr\u1eafng \u0111\u1ea7u ti\u00ean trong \u00f4, sau \u0111\u00f3 tr\u1eeb 1 \u0111\u1ec3 l\u1ea5y ch\u00ednh x\u00e1c ph\u1ea7n h\u1ecd. H\u00e0m LEFT s\u1ebd tr\u00edch xu\u1ea5t s\u1ed1 k\u00fd t\u1ef1 t\u01b0\u01a1ng \u1ee9ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u1ee8ng d\u1ee5ng n\u00e0y r\u1ea5t m\u1ea1nh m\u1ebd trong x\u1eed l\u00fd d\u1eef li\u1ec7u th\u1ef1c t\u1ebf nh\u01b0 t\u00e1ch h\u1ecd t\u00ean, ph\u00e2n lo\u1ea1i chu\u1ed7i tr\u01b0\u1edbc k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t (d\u1ea5u g\u1ea1ch ngang, d\u1ea5u ch\u1ea5m, kho\u1ea3ng tr\u1eafng).<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 v\u1ec1 \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf c\u1ee7a h\u00e0m Left<\/span><\/h2>\n<p style=\"text-align: justify;\"><b>H\u00e0m LEFT trong Excel<\/b><span style=\"font-weight: 400;\"> kh\u00f4ng ch\u1ec9 mang t\u00ednh l\u00fd thuy\u1ebft m\u00e0 c\u00f2n \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng r\u1ea5t nhi\u1ec1u trong c\u00e1c t\u00ecnh hu\u1ed1ng x\u1eed l\u00fd d\u1eef li\u1ec7u th\u1ef1c t\u1ebf. Nh\u1eefng v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n h\u00ecnh dung r\u00f5 r\u00e0ng h\u01a1n c\u00e1ch h\u00e0m n\u00e0y h\u1ed7 tr\u1ee3 c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u00e1ch h\u1ecd t\u1eeb danh s\u00e1ch h\u1ecd t\u00ean<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi qu\u1ea3n l\u00fd danh s\u00e1ch h\u1ecdc sinh ho\u1eb7c nh\u00e2n vi\u00ean, b\u1ea1n th\u01b0\u1eddng c\u1ea7n t\u00e1ch ri\u00eang h\u1ecd \u0111\u1ec3 s\u1eafp x\u1ebfp ho\u1eb7c l\u1ecdc d\u1eef li\u1ec7u. V\u00ed d\u1ee5, t\u1eeb chu\u1ed7i \u201cNguy\u1ec5n V\u0103n An\u201d, c\u00f4ng th\u1ee9c:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=LEFT(A2; SEARCH(&#8221; &#8220;;A2)-1)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/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-483337 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-9.jpg\" alt=\"ham-LEFT-trong-Excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">s\u1ebd cho k\u1ebft qu\u1ea3 \u201cNguy\u1ec5n\u201d. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n nhanh ch\u00f3ng ph\u00e2n lo\u1ea1i theo h\u1ecd, thu\u1eadn ti\u1ec7n cho vi\u1ec7c b\u00e1o c\u00e1o v\u00e0 th\u1ed1ng k\u00ea.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00edch m\u00e3 khu v\u1ef1c t\u1eeb s\u1ed1 \u0111i\u1ec7n tho\u1ea1i<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u1edbi \u0111\u1ecbnh d\u1ea1ng \u201c0987654321\u201d v\u00e0 mu\u1ed1n l\u1ea5y 3 s\u1ed1 \u0111\u1ea7u \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh nh\u00e0 m\u1ea1ng ho\u1eb7c khu v\u1ef1c. Khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=LEFT(B2;3)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/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-483338 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-10.jpg\" alt=\"ham-LEFT-trong-Excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Excel s\u1ebd tr\u1ea3 v\u1ec1 \u201c098\u201d. \u0110\u00e2y l\u00e0 \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn khi ph\u00e2n t\u00edch d\u1eef li\u1ec7u kh\u00e1ch h\u00e0ng, gi\u00fap nh\u00f3m theo khu v\u1ef1c ho\u1eb7c nh\u00e0 cung c\u1ea5p d\u1ecbch v\u1ee5.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1ea5y ti\u1ec1n t\u1ed1 s\u1ea3n ph\u1ea9m trong danh s\u00e1ch m\u00e3 h\u00e0ng<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong qu\u1ea3n l\u00fd kho, m\u00e3 h\u00e0ng h\u00f3a th\u01b0\u1eddng g\u1ed3m ti\u1ec1n t\u1ed1 v\u00e0 s\u1ed1 seri. V\u00ed d\u1ee5: \u201cSP2025-001\u201d. N\u1ebfu b\u1ea1n mu\u1ed1n l\u1ea5y ph\u1ea7n ti\u1ec1n t\u1ed1 \u201cSP2025\u201d, ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=LEFT(C2;6)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/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-483339 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-11.jpg\" alt=\"ham-LEFT-trong-Excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 s\u1ebd gi\u00fap b\u1ea1n ph\u00e2n lo\u1ea1i s\u1ea3n ph\u1ea9m theo d\u00f2ng, n\u0103m s\u1ea3n xu\u1ea5t ho\u1eb7c nh\u00f3m h\u00e0ng. \u0110\u00e2y l\u00e0 \u1ee9ng d\u1ee5ng r\u1ea5t thi\u1ebft th\u1ef1c cho doanh nghi\u1ec7p trong qu\u1ea3n l\u00fd d\u1eef li\u1ec7u quy m\u00f4 l\u1edbn.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m Left trong Excel<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u1eadp s\u1ed1 \u00e2m trong \u0111\u1ed1i s\u1ed1 num_chars: Khi b\u1ea1n nh\u1eadp gi\u00e1 tr\u1ecb \u00e2m cho num_chars, v\u00ed d\u1ee5 <\/span><span style=\"font-weight: 400;\">=LEFT(A2;-2)<\/span><span style=\"font-weight: 400;\">, Excel s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!. \u0110\u1ec3 kh\u1eafc ph\u1ee5c, h\u00e3y lu\u00f4n \u0111\u1ea3m b\u1ea3o s\u1ed1 k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t l\u00e0 s\u1ed1 d\u01b0\u01a1ng ho\u1eb7c b\u1eb1ng 0 n\u1ebfu mu\u1ed1n l\u1ea5y to\u00e0n b\u1ed9 chu\u1ed7i.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kh\u00f4ng ch\u1ec9 \u0111\u1ecbnh s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y: Khi tr\u00edch xu\u1ea5t s\u1ed1, Excel coi l\u00e0 v\u0103n b\u1ea3n. D\u00f9ng h\u00e0m VALUE \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i, v\u00ed d\u1ee5 =VALUE(LEFT(A2<\/span><span style=\"font-weight: 400;\">;<\/span><span style=\"font-weight: 400;\">4)).<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 d\u1ea1ng v\u0103n b\u1ea3n thay v\u00ec s\u1ed1: Khi tr\u00edch xu\u1ea5t c\u00e1c k\u00fd t\u1ef1 l\u00e0 s\u1ed1, Excel v\u1eabn coi k\u1ebft qu\u1ea3 l\u00e0 v\u0103n b\u1ea3n. N\u1ebfu mu\u1ed1n s\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 cho ph\u00e9p t\u00ednh, b\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p th\u00eam h\u00e0m VALUE, v\u00ed d\u1ee5: <\/span><span style=\"font-weight: 400;\">=VALUE(LEFT(A2;4))<\/span><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/ham-LEFT-trong-Excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/08\/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-483340 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-12.jpg\" alt=\"ham-LEFT-trong-Excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng v\u1edbi d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng: Excel l\u01b0u ng\u00e0y th\u00e1ng d\u01b0\u1edbi d\u1ea1ng s\u1ed1 n\u1ed9i b\u1ed9, n\u00ean d\u00f9ng LEFT tr\u1ef1c ti\u1ebfp s\u1ebd kh\u00f4ng tr\u1ea3 v\u1ec1 ng\u00e0y \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng. Gi\u1ea3i ph\u00e1p l\u00e0 d\u00f9ng h\u00e0m TEXT \u0111\u1ec3 chuy\u1ec3n ng\u00e0y sang chu\u1ed7i tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng LEFT, v\u00ed d\u1ee5: <\/span><span style=\"font-weight: 400;\">=LEFT(TEXT(A2;&#8221;dd\/mm\/yyyy&#8221;);5)<\/span><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kho\u1ea3ng tr\u1eafng ho\u1eb7c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t \u1edf \u0111\u1ea7u chu\u1ed7i: Kho\u1ea3ng tr\u1eafng th\u1eeba ho\u1eb7c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t c\u00f3 th\u1ec3 g\u00e2y sai l\u1ec7ch. D\u00f9ng TRIM tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng LEFT.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng LEFT v\u1edbi \u00f4 r\u1ed7ng ho\u1eb7c d\u1eef li\u1ec7u kh\u00f4ng ph\u1ea3i chu\u1ed7i: N\u1ebfu \u00f4 tr\u1ed1ng ho\u1eb7c ch\u1ee9a d\u1eef li\u1ec7u d\u1ea1ng l\u1ed7i, h\u00e0m LEFT c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 l\u1ed7i ho\u1eb7c k\u1ebft qu\u1ea3 kh\u00f4ng mong mu\u1ed1n. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, n\u00ean ki\u1ec3m tra d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o ho\u1eb7c k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IFERROR \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i, v\u00ed d\u1ee5: <\/span><span style=\"font-weight: 400;\">=IFERROR(LEFT(A2;4);&#8221;&#8221;)<\/span><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1eddi k\u1ebft<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 th\u1ea5y, <\/span><b>h\u00e0m LEFT trong Excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u01a1n gi\u1ea3n nh\u01b0ng mang l\u1ea1i gi\u00e1 tr\u1ecb \u1ee9ng d\u1ee5ng l\u1edbn trong c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y. Ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c c\u01a1 b\u1ea3n, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 tr\u00edch xu\u1ea5t ch\u00ednh x\u00e1c d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft t\u1eeb chu\u1ed7i v\u0103n b\u1ea3n, ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 gi\u1ea3m thi\u1ec3u sai s\u00f3t. \u0110\u1ec3 \u00e1p d\u1ee5ng h\u00e0m m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, b\u1ea1n ch\u1ec9 c\u1ea7n th\u00e0nh th\u1ea1o c\u00fa ph\u00e1p, nh\u1eadn bi\u1ebft c\u00e1c t\u00ecnh hu\u1ed1ng \u0111\u1eb7c bi\u1ec7t v\u00e0 bi\u1ebft c\u00e1ch kh\u1eafc ph\u1ee5c nh\u1eefng l\u1ed7i ph\u1ed5 bi\u1ebfn.<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>XEM TH\u00caM:<\/strong><\/p>\n<p><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tong-trong-excel\/\">15 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m t\u1ed5ng trong Excel k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-tu-nhay-trong-excel\/\">7 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 nh\u1ea3y trong Excel ch\u00ednh x\u00e1c, nhanh ch\u00f3ng<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng Excel, vi\u1ec7c thao t\u00e1c v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u0103n b\u1ea3n lu\u00f4n \u0111\u00f3ng vai tr\u00f2 then ch\u1ed1t, \u0111\u1eb7c bi\u1ec7t khi c\u1ea7n t\u00e1ch ho\u1eb7c tr\u00edch xu\u1ea5t th\u00f4ng tin t\u1eeb c\u00e1c chu\u1ed7i k\u00fd t\u1ef1. M\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 \u0111\u00e1ng tin c\u1eady nh\u1ea5t \u0111\u1ec3 th\u1ef1c hi\u1ec7n nhi\u1ec7m v\u1ee5 n\u00e0y ch\u00ednh l\u00e0 h\u00e0m [&hellip;]<\/p>\n","protected":false},"author":65,"featured_media":483328,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-483327","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\u00fa ph\u00e1p chu\u1ea9n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5<\/title>\n<meta name=\"description\" content=\"Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 d\u1ec5 d\u00e0ng.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-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\u00fa ph\u00e1p chu\u1ea9n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\" \/>\n<meta property=\"og:description\" content=\"Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 d\u1ec5 d\u00e0ng.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/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:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-21T04:56:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/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 Giang\" \/>\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 Giang\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/\"},\"author\":{\"name\":\"Vo Giang\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/1dbf45f7c12e8c56d4c60fdc934ee23c\"},\"headline\":\"H\u00e0m Left trong Excel: C\u00fa ph\u00e1p chu\u1ea9n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\",\"datePublished\":\"2025-08-21T04:56:56+00:00\",\"dateModified\":\"2025-08-21T04:56:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/\"},\"wordCount\":3002,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/\",\"name\":\"H\u00e0m Left trong Excel: C\u00fa ph\u00e1p chu\u1ea9n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel.jpg\",\"datePublished\":\"2025-08-21T04:56:56+00:00\",\"dateModified\":\"2025-08-21T04:56:56+00:00\",\"description\":\"Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 d\u1ec5 d\u00e0ng.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-LEFT-trong-Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/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\u00fa ph\u00e1p chu\u1ea9n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\"}]},{\"@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\/1dbf45f7c12e8c56d4c60fdc934ee23c\",\"name\":\"Vo Giang\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b985c49235fa8fa4ce5f8cc9fa149e97?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b985c49235fa8fa4ce5f8cc9fa149e97?s=96&d=mm&r=g\",\"caption\":\"Vo Giang\"},\"description\":\"M\u00ecnh l\u00e0 Giang, m\u1ed9t ng\u01b0\u1eddi k\u1ec3 chuy\u1ec7n c\u00f4ng ngh\u1ec7, ch\u1ecdn c\u00e1ch tr\u1ea3i nghi\u1ec7m v\u00e0 chia s\u1ebb nh\u1eefng gi\u1ea3i ph\u00e1p th\u1ef1c t\u1ebf. V\u1edbi m\u00ecnh, m\u1ed9t thi\u1ebft b\u1ecb t\u1ed1t ch\u1ec9 khi n\u00f3 th\u1ef1c s\u1ef1 l\u00e0m cho cu\u1ed9c s\u1ed1ng h\u00e0ng ng\u00e0y c\u1ee7a b\u1ea1n tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 th\u00fa v\u1ecb h\u01a1n.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/giang-vo\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m Left trong Excel: C\u00fa ph\u00e1p chu\u1ea9n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5","description":"Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 d\u1ec5 d\u00e0ng.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m Left trong Excel: C\u00fa ph\u00e1p chu\u1ea9n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda","og_description":"Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 d\u1ec5 d\u00e0ng.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-08-21T04:56:56+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel.jpg","type":"image\/jpeg"}],"author":"Vo Giang","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Vo Giang","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/"},"author":{"name":"Vo Giang","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/1dbf45f7c12e8c56d4c60fdc934ee23c"},"headline":"H\u00e0m Left trong Excel: C\u00fa ph\u00e1p chu\u1ea9n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda","datePublished":"2025-08-21T04:56:56+00:00","dateModified":"2025-08-21T04:56:56+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/"},"wordCount":3002,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/","name":"H\u00e0m Left trong Excel: C\u00fa ph\u00e1p chu\u1ea9n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel.jpg","datePublished":"2025-08-21T04:56:56+00:00","dateModified":"2025-08-21T04:56:56+00:00","description":"Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 d\u1ec5 d\u00e0ng.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-left-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/08\/ham-LEFT-trong-Excel.jpg","width":1200,"height":628,"caption":"ham-LEFT-trong-Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/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\u00fa ph\u00e1p chu\u1ea9n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda"}]},{"@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\/1dbf45f7c12e8c56d4c60fdc934ee23c","name":"Vo Giang","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b985c49235fa8fa4ce5f8cc9fa149e97?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b985c49235fa8fa4ce5f8cc9fa149e97?s=96&d=mm&r=g","caption":"Vo Giang"},"description":"M\u00ecnh l\u00e0 Giang, m\u1ed9t ng\u01b0\u1eddi k\u1ec3 chuy\u1ec7n c\u00f4ng ngh\u1ec7, ch\u1ecdn c\u00e1ch tr\u1ea3i nghi\u1ec7m v\u00e0 chia s\u1ebb nh\u1eefng gi\u1ea3i ph\u00e1p th\u1ef1c t\u1ebf. V\u1edbi m\u00ecnh, m\u1ed9t thi\u1ebft b\u1ecb t\u1ed1t ch\u1ec9 khi n\u00f3 th\u1ef1c s\u1ef1 l\u00e0m cho cu\u1ed9c s\u1ed1ng h\u00e0ng ng\u00e0y c\u1ee7a b\u1ea1n tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 th\u00fa v\u1ecb h\u01a1n.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/giang-vo\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/483327","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\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=483327"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/483327\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/483328"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=483327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=483327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=483327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}