{"id":476473,"date":"2025-07-24T08:25:07","date_gmt":"2025-07-24T01:25:07","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=476473"},"modified":"2025-07-24T08:25:07","modified_gmt":"2025-07-24T01:25:07","slug":"ham-value","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/","title":{"rendered":"H\u00e0m VALUE trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng, k\u1ebft h\u1ee3p v\u1edbi MID, LEFT, RIGHT"},"content":{"rendered":"<p style=\"text-align: justify;\"><b>H\u00e0m VALUE<\/b><span style=\"font-weight: 400;\"> trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i v\u0103n b\u1ea3n ch\u1ee9a s\u1ed1 th\u00e0nh \u0111\u1ecbnh d\u1ea1ng s\u1ed1 th\u1ef1c t\u1ebf. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c VALUE m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, \u0111\u1ed3ng th\u1eddi kh\u00e1m ph\u00e1 c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m v\u1edbi c\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i ph\u1ed5 bi\u1ebfn nh\u01b0 MID, LEFT v\u00e0 RIGHT \u0111\u1ec3 tr\u00edch xu\u1ea5t v\u00e0 chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u nhanh ch\u00f3ng, ch\u00ednh x\u00e1c h\u01a1n.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>H\u00e0m VALUE trong Excel la\u0300 gi\u0300?<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00ean Excel, \u0111\u00f4i khi b\u1ea1n s\u1ebd g\u1eb7p nh\u1eefng tr\u01b0\u1eddng h\u1ee3p gi\u00e1 tr\u1ecb s\u1ed1 l\u1ea1i \u0111\u01b0\u1ee3c l\u01b0u d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n, khi\u1ebfn cho vi\u1ec7c t\u00ednh to\u00e1n g\u1eb7p kh\u00f3 kh\u0103n ho\u1eb7c tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 sai. \u0110\u00e2y l\u00e0 l\u00fac h\u00e0m chuy\u1ec3n \u0111\u1ed5i VALUE ph\u00e1t huy t\u00e1c d\u1ee5ng v\u00ec c\u00f3 th\u1ec3 tr\u1edf th\u00e0nh c\u00f4ng c\u1ee5 cho ph\u00e9p chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n cho m\u1ed9t con s\u1ed1 sang d\u1ea1ng s\u1ed1 th\u1ef1c, gi\u00fap d\u1eef li\u1ec7u c\u00f3 th\u1ec3 tham gia v\u00e0o c\u00e1c ph\u00e9p t\u00ednh to\u00e1n h\u1ecdc, th\u1ed1ng k\u00ea ho\u1eb7c ph\u00e2n t\u00edch.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-476475 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-1.jpg\" alt=\"ham-value-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Thay v\u00ec nh\u1eadp l\u1ea1i to\u00e0n b\u1ed9 gi\u00e1 tr\u1ecb theo \u0111\u1ecbnh d\u1ea1ng s\u1ed1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng VALUE \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian, \u0111\u1ea3m b\u1ea3o \u0111\u1ed9 ch\u00ednh x\u00e1c v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c. C\u1ee5 th\u1ec3, h\u00e0m chuy\u1ec3n \u0111\u1ed5i VALUE s\u1ebd nh\u1eadn m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 (v\u00ed d\u1ee5: &#8220;123&#8221;, &#8220;2025&#8221;, &#8220;15.7&#8221;) v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb s\u1ed1 t\u01b0\u01a1ng \u1ee9ng. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch trong c\u00e1c b\u1ea3ng t\u00ednh m\u00e0 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp ho\u1eb7c xu\u1ea5t ra t\u1eeb h\u1ec7 th\u1ed1ng kh\u00e1c d\u01b0\u1edbi d\u1ea1ng text.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng \u0111\u1ed9c l\u1eadp, VALUE c\u00f2n th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p c\u00f9ng c\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i nh\u01b0 LEFT, RIGHT v\u00e0 MID. Khi b\u1ea1n c\u1ea7n tr\u00edch xu\u1ea5t m\u1ed9t ph\u1ea7n c\u1ee5 th\u1ec3 c\u1ee7a v\u0103n b\u1ea3n r\u1ed3i chuy\u1ec3n ph\u1ea7n \u0111\u00f3 sang s\u1ed1 \u2014 ch\u1eb3ng h\u1ea1n nh\u01b0 l\u1ea5y ng\u00e0y, th\u00e1ng, ho\u1eb7c m\u00e3 s\u1ed1 n\u1eb1m gi\u1eefa chu\u1ed7i \u2014 vi\u1ec7c k\u1ebft h\u1ee3p c\u00e1c h\u00e0m n\u00e0y s\u1ebd mang l\u1ea1i k\u1ebft qu\u1ea3 t\u1ed1i \u01b0u. V\u00ed d\u1ee5, d\u00f9ng MID \u0111\u1ec3 c\u1eaft m\u1ed9t \u0111o\u1ea1n gi\u1eefa chu\u1ed7i v\u00e0 VALUE \u0111\u1ec3 bi\u1ebfn ph\u1ea7n c\u1eaft \u0111\u00f3 th\u00e0nh s\u1ed1, ph\u1ee5c v\u1ee5 cho t\u00ednh to\u00e1n ti\u1ebfp theo.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>C\u00f4ng th\u01b0\u0301c h\u00e0m VALUE trong Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u d\u01b0\u1edbi d\u1ea1ng chu\u1ed7i v\u0103n b\u1ea3n nh\u01b0ng c\u1ea7n x\u1eed l\u00fd d\u01b0\u1edbi d\u1ea1ng s\u1ed1, h\u00e0m chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i th\u00e0nh s\u1ed1 s\u1ebd l\u00e0 c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c trong Excel. \u0110\u00e2y l\u00e0 h\u00e0m chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u d\u1ea1ng k\u00fd t\u1ef1 th\u00e0nh d\u1ea1ng s\u1ed1, gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh, so s\u00e1nh, ho\u1eb7c tr\u00edch xu\u1ea5t th\u00f4ng tin c\u00f3 gi\u00e1 tr\u1ecb t\u1eeb n\u1ed9i dung v\u0103n b\u1ea3n. H\u00e0m \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp t\u1eeb c\u00e1c h\u1ec7 th\u1ed1ng b\u00ean ngo\u00e0i, bi\u1ec3u m\u1eabu, ho\u1eb7c file CSV m\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 b\u1ecb hi\u1ec3u sai th\u00e0nh v\u0103n b\u1ea3n.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-476476 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-2.jpg\" alt=\"ham-value-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m kh\u00e1 \u0111\u01a1n gi\u1ea3n, d\u1ec5 \u00e1p d\u1ee5ng ngay c\u1ea3 v\u1edbi ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u. C\u1ea5u tr\u00fac nh\u01b0 sau: <\/span><b>=VALUE(text)<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3, text l\u00e0 \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c, c\u00f3 th\u1ec3 l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n n\u1eb1m trong d\u1ea5u ngo\u1eb7c k\u00e9p ho\u1eb7c l\u00e0 tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9a v\u0103n b\u1ea3n c\u1ea7n chuy\u1ec3n \u0111\u1ed5i. \u0110\u1ea7u v\u00e0o n\u00e0y c\u00f3 th\u1ec3 l\u00e0 c\u00e1c \u0111\u1ecbnh d\u1ea1ng nh\u01b0 s\u1ed1 nguy\u00ean, th\u1eadp ph\u00e2n, ng\u00e0y th\u00e1ng ho\u1eb7c gi\u1edd \u2013 mi\u1ec5n l\u00e0 Excel c\u00f3 th\u1ec3 nh\u1eadn di\u1ec7n v\u00e0 hi\u1ec3u \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng \u0111\u00f3. N\u1ebfu \u0111\u1ed1i s\u1ed1 kh\u00f4ng thu\u1ed9c nh\u00f3m \u0111\u1ecbnh d\u1ea1ng h\u1ee3p l\u1ec7, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!, b\u00e1o hi\u1ec7u \u0111\u1ea7u v\u00e0o kh\u00f4ng th\u1ec3 chuy\u1ec3n sang d\u1ea1ng s\u1ed1.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>H\u01b0\u01a1\u0301ng d\u00e2\u0303n ca\u0301ch du\u0300ng ha\u0300m VALUE c\u01a1 b\u1ea3n<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m n\u00e0y kh\u00f4ng \u0111\u00f2i h\u1ecfi k\u1ef9 n\u0103ng ph\u1ee9c t\u1ea1p. V\u1edbi c\u00fa ph\u00e1p c\u01a1 b\u1ea3n =VALUE(text), b\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u01b0a v\u00e0o m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n ph\u00f9 h\u1ee3p \u2013 Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n \u0111\u1ed5i n\u1ebfu \u0111\u00f3 l\u00e0 m\u1ed9t \u0111\u1ecbnh d\u1ea1ng h\u1ee3p l\u1ec7. \u0110i\u1ec1u n\u00e0y bao g\u1ed3m c\u00e1c chu\u1ed7i th\u1ec3 hi\u1ec7n s\u1ed1 nguy\u00ean, s\u1ed1 c\u00f3 ph\u00e2n t\u00e1ch h\u00e0ng ngh\u00ecn, \u0111\u1ecbnh d\u1ea1ng gi\u1edd, ng\u00e0y th\u00e1ng&#8230;<\/span><\/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;\">=VALUE(&#8220;12,000&#8221;) s\u1ebd tr\u1ea3 v\u1ec1 12000, th\u1ec3 hi\u1ec7n r\u00f5 r\u00e0ng r\u1eb1ng Excel \u0111\u00e3 lo\u1ea1i b\u1ecf d\u1ea5u ph\u1ea9y v\u00e0 hi\u1ec3u \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=VALUE(&#8220;15:00&#8221;) tr\u1ea3 k\u1ebft qu\u1ea3 0,625, l\u00e0 gi\u00e1 tr\u1ecb th\u1eadp ph\u00e2n \u0111\u1ea1i di\u1ec7n cho 15 gi\u1edd trong h\u1ec7 th\u1ed1ng th\u1eddi gian n\u1ed9i b\u1ed9 c\u1ee7a Excel.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">=VALUE(&#8220;4:30&#8221;) + VALUE(&#8220;0:30&#8221;) s\u1ebd cho ra 0.208333333, t\u01b0\u01a1ng \u0111\u01b0\u01a1ng 5 gi\u1edd s\u00e1ng khi c\u1ed9ng hai kho\u1ea3ng th\u1eddi gian l\u1ea1i v\u1edbi nhau.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-476477 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-3.jpg\" alt=\"ham-value-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c c\u00f4ng th\u1ee9c tr\u00ean cho th\u1ea5y h\u00e0m kh\u00f4ng ch\u1ec9 x\u1eed l\u00fd s\u1ed1 m\u00e0 c\u00f2n hi\u1ec3u \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian, gi\u00fap vi\u1ec7c t\u00ednh to\u00e1n th\u1eddi l\u01b0\u1ee3ng ho\u1eb7c c\u1ed9ng gi\u1edd tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n. Trong h\u00ecnh minh h\u1ecda \u0111i k\u00e8m, b\u1ea1n c\u00f3 th\u1ec3 quan s\u00e1t th\u00eam c\u00e1c v\u00ed d\u1ee5 tr\u1ef1c quan \u0111\u1ec3 hi\u1ec3u r\u00f5 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng v\u00e0 \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf c\u1ee7a h\u00e0m.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>H\u01b0\u01a1\u0301ng d\u00e2\u0303n ca\u0301ch du\u0300ng ha\u0300m VALUE v\u01a1\u0301i ha\u0300m MID, LEFT, RIGHT<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u v\u0103n b\u1ea3n ph\u1ee9c t\u1ea1p trong Excel, vi\u1ec7c k\u1ebft h\u1ee3p VALUE v\u1edbi c\u00e1c h\u00e0m tr\u00edch xu\u1ea5t chu\u1ed7i nh\u01b0 MID, LEFT v\u00e0 RIGHT l\u00e0 r\u1ea5t h\u1eefu \u00edch. S\u1ef1 k\u1ebft h\u1ee3p n\u00e0y cho ph\u00e9p b\u1ea1n t\u00e1ch l\u1ea5y c\u00e1c ph\u1ea7n c\u1ee5 th\u1ec3 trong chu\u1ed7i v\u0103n b\u1ea3n, sau \u0111\u00f3 chuy\u1ec3n \u0111\u1ed5i ch\u00fang th\u00e0nh s\u1ed1 \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho vi\u1ec7c t\u00ednh to\u00e1n ho\u1eb7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 linh ho\u1ea1t h\u01a1n.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>K\u1ebft h\u1ee3p h\u00e0m VALUE v\u1edbi h\u00e0m RIGHT<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Thay v\u00ec th\u1ef1c hi\u1ec7n thao t\u00e1c th\u1ee7 c\u00f4ng hay ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m RIGHT v\u00e0 VALUE \u0111\u1ec3 gi\u1ea3i quy\u1ebft nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c. H\u00e0m RIGHT \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh t\u1eeb ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n, c\u00f2n c\u00f4ng th\u1ee9c VALUE c\u00f3 nhi\u1ec7m v\u1ee5 chuy\u1ec3n \u0111\u1ed5i ph\u1ea7n tr\u00edch xu\u1ea5t \u0111\u00f3 t\u1eeb d\u1ea1ng chu\u1ed7i th\u00e0nh s\u1ed1. Vi\u1ec7c k\u1ebft h\u1ee3p hai h\u00e0m n\u00e0y r\u1ea5t h\u1eefu \u00edch trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p nh\u01b0 m\u00e3 h\u00f3a th\u00f4ng tin, ph\u00e2n t\u00edch d\u1eef li\u1ec7u h\u1ec7 th\u1ed1ng, ho\u1eb7c x\u1eed l\u00fd b\u1ea3ng m\u00e3 c\u00f3 \u0111\u1ecbnh d\u1ea1ng \u0111\u1eb7c bi\u1ec7t.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-476478 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-4.jpg\" alt=\"ham-value-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t nh\u01b0 sau: <\/span><b>=VALUE(text, num_chars))<\/b><\/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 \u0111\u1ecba ch\u1ec9 \u00f4 ch\u1ee9a v\u0103n b\u1ea3n c\u1ea7n thao t\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">num_chars l\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y t\u1eeb cu\u1ed1i chu\u1ed7i.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><b>K\u1ebft h\u1ee3p h\u00e0m VALUE v\u1edbi h\u00e0m LEFT<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong Excel, khi b\u1ea1n c\u1ea7n l\u1ea5y ph\u1ea7n k\u00fd t\u1ef1 n\u1eb1m \u1edf \u0111\u1ea7u chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 chuy\u1ec3n \u0111\u1ed5i ch\u00fang th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1 \u0111\u1ec3 ph\u1ee5c v\u1ee5 ph\u00e2n t\u00edch ho\u1eb7c t\u00ednh to\u00e1n, th\u00ec vi\u1ec7c k\u1ebft h\u1ee3p h\u00e0m LEFT v\u1edbi VALUE s\u1ebd l\u00e0 l\u1ef1a ch\u1ecdn l\u00fd t\u01b0\u1edfng. H\u00e0m LEFT gi\u00fap tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh t\u1eeb ph\u00eda b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i, trong khi \u0111\u00f3 VALUE \u0111\u1ea3m nh\u1eadn nhi\u1ec7m v\u1ee5 bi\u1ebfn \u0111\u1ed5i \u0111o\u1ea1n tr\u00edch \u0111\u00f3 t\u1eeb d\u1ea1ng v\u0103n b\u1ea3n sang d\u1ea1ng s\u1ed1. S\u1ef1 k\u1ebft h\u1ee3p n\u00e0y \u0111\u1eb7c bi\u1ec7t hi\u1ec7u qu\u1ea3 khi x\u1eed l\u00fd m\u00e3 s\u1ed1, d\u1eef li\u1ec7u m\u00e3 h\u00f3a, ho\u1eb7c b\u1ea5t k\u1ef3 th\u00f4ng tin n\u00e0o m\u00e0 s\u1ed1 li\u1ec7u n\u1eb1m \u1edf \u0111\u1ea7u chu\u1ed7i k\u00fd t\u1ef1.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-476479 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-5.jpg\" alt=\"ham-value-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t: <\/span><b>=VALUE(LEFT(text, num_chars))<\/b><\/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 \u0111\u1ecba ch\u1ec9 \u00f4 ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">num_chars l\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t t\u1eeb b\u00ean tr\u00e1i. Tham s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u0111i\u1ec1u ch\u1ec9nh t\u00f9y theo \u0111\u1ed9 d\u00e0i ph\u1ea7n c\u1ea7n l\u1ea5y.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><b>K\u1ebft h\u1ee3p h\u00e0m VALUE v\u1edbi h\u00e0m MID<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c l\u1ea5y m\u1ed9t ph\u1ea7n k\u00fd t\u1ef1 n\u1eb1m \u1edf gi\u1eefa chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 chuy\u1ec3n \u0111\u1ed5i n\u00f3 th\u00e0nh s\u1ed1 l\u00e0 y\u00eau c\u1ea7u th\u01b0\u1eddng g\u1eb7p, \u0111\u1eb7c bi\u1ec7t khi d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c m\u00e3 ho\u1eb7c th\u00f4ng tin k\u1ebft h\u1ee3p gi\u1eefa ch\u1eef v\u00e0 s\u1ed1. \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p VALUE v\u1edbi h\u00e0m MID. H\u00e0m MID cho ph\u00e9p tr\u00edch xu\u1ea5t m\u1ed9t \u0111o\u1ea1n k\u00fd t\u1ef1 b\u1ea5t k\u1ef3 t\u1eeb v\u1ecb tr\u00ed x\u00e1c \u0111\u1ecbnh trong chu\u1ed7i v\u00e0 nhi\u1ec7m v\u1ee5 c\u1ee7a VALUE s\u1ebd chuy\u1ec3n ph\u1ea7n k\u00fd t\u1ef1 \u0111\u00f3 t\u1eeb d\u1ea1ng v\u0103n b\u1ea3n sang s\u1ed1 th\u1ef1c \u0111\u1ec3 d\u1ec5 d\u00e0ng s\u1eed d\u1ee5ng trong c\u00e1c ph\u00e9p t\u00ednh ho\u1eb7c ph\u00e2n t\u00edch.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-476480 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-6.jpg\" alt=\"ham-value-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n c\u00f3 d\u1ea1ng: <\/span><b>=VALUE(MID(A, t, n))<\/b><\/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;\">A l\u00e0 \u00f4 ch\u1ee9a chu\u1ed7i v\u0103n b\u1ea3n c\u1ea7n thao t\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">t l\u00e0 v\u1ecb tr\u00ed k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u b\u1ea1n mu\u1ed1n l\u1ea5y trong chu\u1ed7i (t\u00ednh t\u1eeb k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">n l\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ea7n tr\u00edch xu\u1ea5t t\u1eeb v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><b>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m VALUE<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc h\u1ebft, \u0111\u1ea7u v\u00e0o c\u1ee7a h\u00e0m chuy\u1ec3n \u0111\u1ed5i VALUE ph\u1ea3i l\u00e0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n th\u1ec3 hi\u1ec7n s\u1ed1 h\u1ee3p l\u1ec7 ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng ng\u00e0y, gi\u1edd m\u00e0 Excel c\u00f3 th\u1ec3 nh\u1eadn di\u1ec7n. N\u1ebfu gi\u00e1 tr\u1ecb text kh\u00f4ng thu\u1ed9c m\u1ed9t trong nh\u1eefng d\u1ea1ng n\u00e0y, v\u00ed d\u1ee5 nh\u01b0 ch\u1ee9a k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t kh\u00f4ng h\u1ee3p l\u1ec7, ch\u1eef c\u00e1i n\u1eb1m l\u1eabn trong s\u1ed1, ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng kh\u00f4ng ph\u00f9 h\u1ee3p, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!. V\u00ec v\u1eady, c\u1ea7n ki\u1ec3m tra k\u1ef9 d\u1eef li\u1ec7u tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 tr\u00e1nh nh\u1eefng l\u1ed7i n\u00e0y g\u00e2y gi\u00e1n \u0111o\u1ea1n quy tr\u00ecnh x\u1eed l\u00fd.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t \u0111i\u1ec3m c\u1ea7n ch\u00fa \u00fd l\u00e0 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong chu\u1ed7i v\u0103n b\u1ea3n ph\u1ea3i ph\u00f9 h\u1ee3p v\u1edbi thi\u1ebft l\u1eadp ng\u00f4n ng\u1eef v\u00e0 v\u00f9ng mi\u1ec1n tr\u00ean m\u00e1y t\u00ednh. V\u00ed d\u1ee5, d\u1ea5u ph\u1ea9y v\u00e0 d\u1ea5u ch\u1ea5m trong s\u1ed1 th\u1eadp ph\u00e2n ho\u1eb7c ph\u00e2n c\u00e1ch h\u00e0ng ngh\u00ecn c\u00f3 th\u1ec3 kh\u00e1c nhau t\u00f9y theo v\u00f9ng, g\u00e2y sai l\u1ec7ch k\u1ebft qu\u1ea3 ho\u1eb7c l\u1ed7i chuy\u1ec3n \u0111\u1ed5i.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-476481 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-7.jpg\" alt=\"ham-value-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i ra, khi k\u1ebft h\u1ee3p VALUE v\u1edbi c\u00e1c h\u00e0m tr\u00edch xu\u1ea5t chu\u1ed7i nh\u01b0 LEFT, RIGHT, MID, c\u1ea7n \u0111\u1ea3m b\u1ea3o s\u1ed1 k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c l\u1ea5y ra l\u00e0 ph\u1ea7n ch\u1ee9a \u0111\u00fang gi\u00e1 tr\u1ecb s\u1ed1 h\u1ee3p l\u1ec7. Tr\u00edch xu\u1ea5t kh\u00f4ng ch\u00ednh x\u00e1c s\u1ebd d\u1eabn \u0111\u1ebfn l\u1ed7i ho\u1eb7c k\u1ebft qu\u1ea3 kh\u00f4ng \u0111\u00fang \u00fd mu\u1ed1n. V\u00ed d\u1ee5, vi\u1ec7c l\u1ea5y d\u01b0 k\u00fd t\u1ef1 tr\u1eafng ho\u1eb7c k\u00fd t\u1ef1 kh\u00f4ng ph\u1ea3i s\u1ed1 c\u0169ng g\u00e2y l\u1ed7i khi chuy\u1ec3n \u0111\u1ed5i.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Cu\u1ed1i c\u00f9ng, trong c\u00e1c phi\u00ean b\u1ea3n Excel c\u0169 ho\u1eb7c m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p \u0111\u1eb7c bi\u1ec7t, VALUE c\u00f3 th\u1ec3 kh\u00f4ng x\u1eed l\u00fd m\u1ed9t s\u1ed1 ki\u1ec3u d\u1eef li\u1ec7u nh\u1ea5t \u0111\u1ecbnh nh\u01b0 s\u1ed1 \u00e2m vi\u1ebft trong d\u1ea5u ngo\u1eb7c ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 ph\u1ee9c t\u1ea1p. Do \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng n\u00ean ki\u1ec3m tra k\u1ef9 d\u1eef li\u1ec7u v\u00e0 phi\u00ean b\u1ea3n ph\u1ea7n m\u1ec1m tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 ph\u1ea7n t\u1ed5ng h\u1ee3p c\u00e1c c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p li\u00ean quan \u0111\u1ebfn h\u00e0m chuy\u1ec3n \u0111\u1ed5i VALUE trong Excel, gi\u00fap b\u1ea1n gi\u1ea3i \u0111\u00e1p nhanh nh\u1eefng th\u1eafc m\u1eafc ph\u1ed5 bi\u1ebfn v\u00e0 s\u1eed d\u1ee5ng h\u00e0m hi\u1ec7u qu\u1ea3 h\u01a1n trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>H\u00e0m chuy\u1ec3n \u0111\u1ed5i VALUE c\u00f3 th\u1ec3 x\u1eed l\u00fd chu\u1ed7i ng\u00e0y th\u00e1ng \u1edf \u0111\u1ecbnh d\u1ea1ng n\u00e0o?<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c VALUE h\u1ed7 tr\u1ee3 chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i v\u0103n b\u1ea3n \u1edf \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng m\u00e0 Excel c\u00f4ng nh\u1eadn, nh\u01b0 \u201c01\/01\/2025\u201d ho\u1eb7c \u201c2025-01-01\u201d. N\u1ebfu \u0111\u1ecbnh d\u1ea1ng kh\u00f4ng \u0111\u00fang ho\u1eb7c kh\u00f4ng ph\u00f9 h\u1ee3p v\u1edbi c\u00e0i \u0111\u1eb7t h\u1ec7 th\u1ed1ng, h\u00e0m c\u00f3 th\u1ec3 b\u00e1o l\u1ed7i.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 tr\u00e1nh l\u1ed7i khi d\u00f9ng h\u00e0m VALUE v\u1edbi d\u1eef li\u1ec7u h\u1ed7n h\u1ee3p ch\u1eef v\u00e0 s\u1ed1?<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 tr\u00e1nh l\u1ed7i, b\u1ea1n n\u00ean k\u1ebft h\u1ee3p VALUE v\u1edbi c\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i nh\u01b0 LEFT, RIGHT ho\u1eb7c MID \u0111\u1ec3 tr\u00edch xu\u1ea5t ch\u00ednh x\u00e1c ph\u1ea7n s\u1ed1 c\u1ea7n chuy\u1ec3n \u0111\u1ed5i. Ngo\u00e0i ra, lo\u1ea1i b\u1ecf c\u00e1c k\u00fd t\u1ef1 kh\u00f4ng ph\u1ea3i s\u1ed1 tr\u01b0\u1edbc khi chuy\u1ec3n \u0111\u1ed5i c\u0169ng gi\u00fap gi\u1ea3m thi\u1ec3u l\u1ed7i.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/ham-value-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-476482 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-8.jpg\" alt=\"ham-value-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>C\u00f4ng th\u1ee9c VALUE c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i s\u1ed1 \u00e2m \u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n trong d\u1ea5u ngo\u1eb7c kh\u00f4ng?<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c VALUE ti\u00eau chu\u1ea9n kh\u00f4ng nh\u1eadn d\u1ea1ng s\u1ed1 \u00e2m vi\u1ebft trong d\u1ea5u ngo\u1eb7c nh\u01b0 &#8220;(123)&#8221;. \u0110\u1ec3 x\u1eed l\u00fd tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u1ea7n d\u00f9ng th\u00eam c\u00f4ng th\u1ee9c ho\u1eb7c h\u00e0m kh\u00e1c nh\u01b0 SUBSTITUTE \u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1ea5u ngo\u1eb7c tr\u01b0\u1edbc khi d\u00f9ng VALUE.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>VALUE c\u00f3 th\u1ec3 x\u1eed l\u00fd c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n ch\u1ee9a k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng th\u1eeba kh\u00f4ng?<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu chu\u1ed7i c\u00f3 kho\u1ea3ng tr\u1eafng \u1edf \u0111\u1ea7u ho\u1eb7c cu\u1ed1i, h\u00e0m chuy\u1ec3n \u0111\u1ed5i VALUE v\u1eabn c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u01b0\u1ee3c. Tuy nhi\u00ean, n\u1ebfu kho\u1ea3ng tr\u1eafng n\u1eb1m gi\u1eefa c\u00e1c ch\u1eef s\u1ed1 ho\u1eb7c k\u00fd t\u1ef1 kh\u00f4ng h\u1ee3p l\u1ec7 kh\u00e1c s\u1ebd g\u00e2y l\u1ed7i.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>K\u1ebft lu\u1eadn<\/b><\/h2>\n<p style=\"text-align: justify;\"><b>H\u00e0m VALUE<\/b><span style=\"font-weight: 400;\"> l\u00e0 c\u00f4ng c\u1ee5 quan tr\u1ecdng gi\u00fap chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1 trong Excel, h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c cho vi\u1ec7c x\u1eed l\u00fd v\u00e0 t\u00ednh to\u00e1n d\u1eef li\u1ec7u. Tuy nhi\u00ean, \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, c\u1ea7n l\u01b0u \u00fd \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o v\u00e0 c\u00e1c quy t\u1eafc s\u1eed d\u1ee5ng h\u00e0m. Hi\u1ec3u r\u00f5 v\u00e0 v\u1eadn d\u1ee5ng th\u00e0nh th\u1ea1o h\u00e0m chuy\u1ec3n \u0111\u1ed5i VALUE s\u1ebd gi\u00fap b\u1ea1n t\u1ed1i \u01b0u h\u00f3a kh\u1ea3 n\u0103ng l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh, \u0111\u1ed3ng th\u1eddi tr\u00e1nh \u0111\u01b0\u1ee3c nh\u1eefng l\u1ed7i ph\u1ed5 bi\u1ebfn khi x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng v\u0103n b\u1ea3n.<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>Xem th\u00eam:<\/strong><\/p>\n<ul>\n<li><span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/vlookup-excel\/\"><strong>H\u00e0m VLOOKUP Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda<\/strong><\/a><\/span><\/li>\n<li><span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/trong-excel-co-nghia-la-gi\/\"><strong>#### trong Excel c\u00f3 ngh\u0129a l\u00e0 g\u00ec? C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/strong><\/a><\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m VALUE trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i v\u0103n b\u1ea3n ch\u1ee9a s\u1ed1 th\u00e0nh \u0111\u1ecbnh d\u1ea1ng s\u1ed1 th\u1ef1c t\u1ebf. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c VALUE m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, \u0111\u1ed3ng th\u1eddi kh\u00e1m ph\u00e1 c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m v\u1edbi [&hellip;]<\/p>\n","protected":false},"author":84,"featured_media":476474,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-476473","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 VALUE trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f9ng h\u00e0m kh\u00e1c<\/title>\n<meta name=\"description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft cho b\u1ea1n v\u1ec1 h\u00e0m VALUE v\u1edbi c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f9ng h\u00e0m h\u00e0m MID, LEFT, RIGHT, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda.\" \/>\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-value\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m VALUE trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng, k\u1ebft h\u1ee3p v\u1edbi MID, LEFT, RIGHT\" \/>\n<meta property=\"og:description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft cho b\u1ea1n v\u1ec1 h\u00e0m VALUE v\u1edbi c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f9ng h\u00e0m h\u00e0m MID, LEFT, RIGHT, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/\" \/>\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-07-24T01:25:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value.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=\"Daisy Daisy\" \/>\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=\"Daisy Daisy\" \/>\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-value\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/\"},\"author\":{\"name\":\"Daisy Daisy\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/506edc7aab4e26e80b30c1a70bffcb30\"},\"headline\":\"H\u00e0m VALUE trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng, k\u1ebft h\u1ee3p v\u1edbi MID, LEFT, RIGHT\",\"datePublished\":\"2025-07-24T01:25:07+00:00\",\"dateModified\":\"2025-07-24T01:25:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/\"},\"wordCount\":3161,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value.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\/ham-value\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/\",\"name\":\"H\u00e0m VALUE trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f9ng h\u00e0m kh\u00e1c\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value.jpg\",\"datePublished\":\"2025-07-24T01:25:07+00:00\",\"dateModified\":\"2025-07-24T01:25:07+00:00\",\"description\":\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft cho b\u1ea1n v\u1ec1 h\u00e0m VALUE v\u1edbi c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f9ng h\u00e0m h\u00e0m MID, LEFT, RIGHT, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-value\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m VALUE trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng, k\u1ebft h\u1ee3p v\u1edbi MID, LEFT, RIGHT\"}]},{\"@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\/506edc7aab4e26e80b30c1a70bffcb30\",\"name\":\"Daisy Daisy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g\",\"caption\":\"Daisy Daisy\"},\"description\":\"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-bao-ni\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m VALUE trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f9ng h\u00e0m kh\u00e1c","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft cho b\u1ea1n v\u1ec1 h\u00e0m VALUE v\u1edbi c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f9ng h\u00e0m h\u00e0m MID, LEFT, RIGHT, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda.","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-value\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m VALUE trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng, k\u1ebft h\u1ee3p v\u1edbi MID, LEFT, RIGHT","og_description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft cho b\u1ea1n v\u1ec1 h\u00e0m VALUE v\u1edbi c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f9ng h\u00e0m h\u00e0m MID, LEFT, RIGHT, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/","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-07-24T01:25:07+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value.jpg","type":"image\/jpeg"}],"author":"Daisy Daisy","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Daisy Daisy","\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-value\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/"},"author":{"name":"Daisy Daisy","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/506edc7aab4e26e80b30c1a70bffcb30"},"headline":"H\u00e0m VALUE trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng, k\u1ebft h\u1ee3p v\u1edbi MID, LEFT, RIGHT","datePublished":"2025-07-24T01:25:07+00:00","dateModified":"2025-07-24T01:25:07+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/"},"wordCount":3161,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value.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\/ham-value\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/","name":"H\u00e0m VALUE trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f9ng h\u00e0m kh\u00e1c","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value.jpg","datePublished":"2025-07-24T01:25:07+00:00","dateModified":"2025-07-24T01:25:07+00:00","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft cho b\u1ea1n v\u1ec1 h\u00e0m VALUE v\u1edbi c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f9ng h\u00e0m h\u00e0m MID, LEFT, RIGHT, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/ham-value.jpg","width":1200,"height":628,"caption":"ham-value"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-value\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m VALUE trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng, k\u1ebft h\u1ee3p v\u1edbi MID, LEFT, RIGHT"}]},{"@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\/506edc7aab4e26e80b30c1a70bffcb30","name":"Daisy Daisy","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g","caption":"Daisy Daisy"},"description":"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-bao-ni\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/476473","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\/84"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=476473"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/476473\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/476474"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=476473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=476473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=476473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}