{"id":268606,"date":"2023-10-10T16:26:06","date_gmt":"2023-10-10T09:26:06","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=268606"},"modified":"2023-10-10T16:26:06","modified_gmt":"2023-10-10T09:26:06","slug":"cach-tach-ten-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/","title":{"rendered":"C\u00e1ch t\u00e1ch c\u1ed9t h\u1ecd v\u00e0 t\u00ean trong Excel nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Microsoft Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 tin h\u1ecdc v\u0103n ph\u00f2ng h\u1eefu \u00edch cho h\u1ea7u h\u1ebft c\u00e1c ng\u00e0nh, ngh\u1ec1. V\u1edbi r\u1ea5t nhi\u1ec1u h\u00e0m, th\u1ee7 thu\u1eadt b\u1ed5 tr\u1ee3 h\u1eefu \u00edch, \u0111\u00e1p \u1ee9ng nhu c\u1ea7u trong c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai c\u0169ng n\u1eafm b\u1eaft t\u1ea5t t\u1ea7n t\u1eadt nh\u1eefng th\u1ee7 thu\u1eadt n\u00e0y, trong \u0111\u00f3 c\u00f3 th\u1ee7 thu\u1eadt t\u00e1ch tr\u01b0\u1eddng h\u1ecd, t\u00ean th\u00e0nh nh\u1eefng c\u1ed9t ri\u00eang bi\u1ec7t. B\u00e0i vi\u1ebft h\u00f4m nay, Ho\u00e0ng H\u00e0 Mobile s\u1ebd chia s\u1ebb \u0111\u1ebfn b\u1ea1n <\/span><b>c\u00e1ch t\u00e1ch t\u00ean trong Excel<\/b><span style=\"font-weight: 400;\"> nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n nh\u1ea5t.\u00a0<\/span><\/p>\n<h2><b>T\u1ea1i sao c\u1ea7n t\u00e1ch h\u1ecd, t\u00ean trong trang t\u00ednh Excel?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">H\u1ecd v\u00e0 t\u00ean l\u00e0 nh\u1eefng th\u00f4ng tin c\u01a1 b\u1ea3n c\u1ea7n c\u00f3 khi c\u1ea7n th\u1ed1ng k\u00ea danh s\u00e1ch m\u1ed9t ng\u01b0\u1eddi, nh\u00f3m ng\u01b0\u1eddi \u0111\u1ec3 qu\u1ea3n l\u00fd, ph\u00e2n lo\u1ea1i thu\u1eadn l\u1ee3i h\u01a1n. Th\u00f4ng th\u01b0\u1eddng, khi nh\u1eadp li\u1ec7u v\u00e0o trang t\u00ednh Excel, h\u1ea7u h\u1ebft m\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u00f3i quen nh\u1eadp h\u1ecd v\u00e0 t\u00ean v\u00e0o c\u0169ng m\u1ed9t \u00f4 t\u00ednh. \u0110i\u1ec1u n\u00e0y khi\u1ebfn nh\u1eefng y\u00eau c\u1ea7u nh\u01b0 vi\u1ec7c s\u1eafp x\u1ebfp, ph\u00e2n lo\u1ea1i theo h\u1ecd, theo t\u00ean sau n\u00e0y tr\u1edf n\u00ean kh\u00f3 kh\u0103n h\u01a1n.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tuy v\u1eady, vi\u1ec7c nh\u1eadp ri\u00eang t\u1eebng c\u1ed9t h\u1ecd, t\u00ean kh\u00e1c nhau m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng ngay t\u1eeb ban \u0111\u1ea7u c\u0169ng t\u1ed1n nhi\u1ec1u th\u1eddi gian h\u01a1n. Do \u0111\u00f3, vi\u1ec7c ch\u1ecdn c\u00e1ch t\u00e1ch t\u00ean trong Excel sau khi c\u00f3 danh s\u00e1ch t\u1ed5ng s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian thao t\u00e1c. Ngo\u00e0i ra, y\u00eau c\u1ea7u t\u00e1ch h\u1ecd, t\u00ean c\u0169ng l\u00e0 m\u1ed9t trong nh\u1eefng c\u00e2u h\u1ecfi, \u0111\u1ec1 b\u00e0i th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n trong c\u00e1c b\u00e0i t\u1eadp th\u1ef1c h\u00e0nh, r\u00e8n luy\u1ec7n m\u00f4n tin h\u1ecdc trong tr\u01b0\u1eddng h\u1ecdc hay thi l\u1ea5y ch\u1ee9ng ch\u1ec9 MOS.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-270189 size-full webpexpress-processed\" title=\"T\u1ea1i sao c\u1ea7n t\u00e1ch h\u1ecd, t\u00ean trong trang t\u00ednh Excel?\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-1.jpg\" alt=\"cach-tach-ten-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">T\u00e1ch h\u1ecd, t\u00ean c\u0169ng v\u00f4 c\u00f9ng nhanh ch\u00f3ng, ch\u1ec9 c\u1ea7n m\u1ed9t v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 ngay k\u1ebft qu\u1ea3. C\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 t\u00e1ch h\u1ecd, t\u00e1ch t\u00ean trong Excel. Nh\u00ecn chung, vi\u1ec7c l\u1ef1a ch\u1ecdn c\u00e1ch n\u00e0o s\u1ebd t\u00f9y thu\u1ed9c v\u00e0o nhu c\u1ea7u, s\u1edf th\u00edch c\u1ee7a b\u1ea1n, s\u1ed1 l\u01b0\u1ee3ng tr\u01b0\u1eddng h\u1ecd v\u00e0 t\u00ean c\u1ea7n t\u00e1ch c\u0169ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u00e0i vi\u1ebft h\u00f4m nay, Ho\u00e0ng H\u00e0 Mobile s\u1ebd chia s\u1ebb \u0111\u1ebfn b\u1ea1n 3 c\u00e1ch ph\u1ed5 bi\u1ebfn nh\u1ea5t \u0111\u1ec3 t\u00e1ch t\u00ean trong Microsoft Excel. Ch\u1eafc ch\u1eafn nh\u1eefng th\u1ee7 thu\u1eadt d\u01b0\u1edbi \u0111\u00e2y s\u1ebd ph\u1ea7n n\u00e0o gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n. \u0110\u1ed3ng th\u1eddi gi\u00fap b\u1ea1n ho\u00e0n th\u00e0nh nh\u1eefng b\u00e0i t\u1eadp th\u1ef1c h\u00e0nh trong qu\u00e1 tr\u00ecnh h\u1ecdc v\u1ec1 ph\u1ea7n m\u1ec1m tin h\u1ecdc v\u0103n ph\u00f2ng c\u01a1 b\u1ea3n c\u0169ng nh\u01b0 thi l\u1ea5y ch\u1ee9ng ch\u1ec9.<\/span><\/p>\n<h2><b>C\u00e1ch t\u00e1ch t\u00ean trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 3 c\u00e1ch \u0111\u1ec3 b\u1ea1n t\u00e1ch t\u00ean c\u1ef1c nhanh, c\u1ef1c \u0111\u01a1n gi\u1ea3n ngay tr\u00ean trang t\u00ednh Excel c\u1ee7a b\u1ea1n m\u00e0 kh\u00f4ng c\u1ea7n \u0111\u1ebfn b\u1ea5t k\u1ef3 ph\u1ea7n m\u1ec1m, \u1ee9ng d\u1ee5ng h\u1ed7 tr\u1ee3 n\u00e0o kh\u00e1c:<\/span><\/p>\n<h3><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch t\u00ean trong Excel v\u1edbi c\u00f4ng c\u1ee5 Find and Replace<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n c\u00f3 nhu c\u1ea7u t\u00e1ch t\u00ean v\u00e0 h\u1ecd ra c\u00e1c h\u00e0ng, c\u1ed9t kh\u00e1c nhau th\u00ec c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Find and Replace (c\u00f3 ngh\u0129a l\u00e0 T\u00ecm ki\u1ebfm v\u00e0 Thay th\u1ebf) r\u1ea5t nhanh g\u1ecdn. Sau \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc thao t\u00e1c chu\u1ea9n ch\u1ec9nh m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o \u0111\u1ec3 t\u1ef1 th\u1ef1c hi\u1ec7n tr\u00ean file c\u1ee7a b\u1ea1n:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Sao ch\u00e9p &#8211; Copy v\u00e0 D\u00e1n &#8211; Paste c\u1ed9t H\u1ecd v\u00e0 T\u00ean sang m\u1ed9t c\u1ed9t T\u00ean kh\u00e1c.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter wp-image-270191 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch t\u00ean trong Excel v\u1edbi c\u00f4ng c\u1ee5 Find and Replace\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-3.jpg\" alt=\"cach-tach-ten-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: D\u00f9ng chu\u1ed9t ho\u1eb7c touchpad b\u00f4i \u0111en c\u1ed9t T\u00ean v\u1eeba d\u00e1n n\u1ed9i dung c\u1ee7a c\u1ed9t H\u1ecd v\u00e0 T\u00ean sang. Ti\u1ebfp \u0111\u00f3, m\u1edf h\u1ed9p tho\u1ea1i Find and Replace b\u1eb1ng c\u00e1ch nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl + H.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter wp-image-270192 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch t\u00ean trong Excel v\u1edbi c\u00f4ng c\u1ee5 Find and Replace\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-4.jpg\" alt=\"cach-tach-ten-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: L\u00fac n\u00e0y, \u1edf \u00f4 Find What, b\u1ea1n th\u00eam d\u1ea5u <strong>*<\/strong> v\u00e0 <strong>m\u1ed9t ph\u00edm c\u00e1ch<\/strong>.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270193 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch t\u00ean trong Excel v\u1edbi c\u00f4ng c\u1ee5 Find and Replace\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-5.jpg\" alt=\"cach-tach-ten-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Sau \u0111\u00f3, nh\u1ea5n ch\u1ecdn n\u00fat Replace All.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270196 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch t\u00ean trong Excel v\u1edbi c\u00f4ng c\u1ee5 Find and Replace\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-8.jpg\" alt=\"cach-tach-ten-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: Ti\u1ebfp \u0111\u1ebfn \u0111\u1ec3 t\u00e1ch H\u1ecd v\u00e0 t\u00ean l\u00f3t sang m\u1ed9t c\u1ed9t kh\u00e1c, \u1edf \u0111\u00e2y l\u00e0 c\u1ed9t C3, b\u1ea1n nh\u1eadp v\u00e0o \u00f4 \u0111\u00f3 c\u00f4ng th\u1ee9c sau \u0111\u00e2y: =LEFT(A3;LEN(A3)-LEN(C3)) v\u00e0 nh\u1ea5n n\u00fat Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3 \u0111\u00e3 t\u00e1ch.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270194 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch t\u00ean trong Excel v\u1edbi c\u00f4ng c\u1ee5 Find and Replace\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-6.jpg\" alt=\"cach-tach-ten-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: \u0110\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eefng \u00f4 c\u00f2n l\u1ea1i, b\u1ea1n \u0111\u01b0a con tr\u1ecf chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a \u00f4 v\u1eeba nh\u1eadn k\u1ebft qu\u1ea3 \u0111\u00e3 t\u00e1ch cho \u0111\u1ebfn khi xu\u1ea5t hi\u1ec7n d\u1ea5u \u201c+\u201d, l\u00fac n\u00e0y b\u1ea1n ch\u1ec9 c\u1ea7n gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o xu\u1ed1ng nh\u1eefng \u00f4 c\u00f2n l\u1ea1i l\u00e0 ho\u00e0n t\u1ea5t.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270195 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch t\u00ean trong Excel v\u1edbi c\u00f4ng c\u1ee5 Find and Replace\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-7.jpg\" alt=\"cach-tach-ten-trong-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Th\u1eadt \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh g\u1ecdn \u0111\u00fang kh\u00f4ng? Kh\u00f4ng c\u1ea7n t\u1ed1n th\u1eddi gian nh\u1eadp li\u1ec7u l\u1ea1i m\u1ed9t l\u1ea7n n\u1eefa m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng, v\u1edbi c\u00f4ng c\u1ee5 Find and Replace v\u00e0 h\u00e0m LEFT, b\u1ea1n \u0111\u00e3 t\u00e1ch \u0111\u01b0\u1ee3c t\u00ean m\u1ed9t c\u00e1ch chu\u1ea9n x\u00e1c nh\u1ea5t. \u0110\u1eebng qu\u00ean l\u01b0u l\u1ea1i th\u1ee7 thu\u1eadt n\u00e0y \u0111\u1ec3 t\u1ed1i \u01b0u c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh nh\u00e9!<\/span><\/p>\n<h3><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch h\u1ecd t\u00ean trong Excel v\u1edbi Text to Columns<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">Kh\u00f4ng ch\u1ec9 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Find and Replace nh\u01b0 \u1edf tr\u00ean, c\u00e1ch t\u00e1ch t\u00ean trong Excel b\u1eb1ng Text to Columns c\u0169ng l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn gi\u00fap ph\u1ee5c v\u1ee5, \u0111\u00e1p \u1ee9ng \u0111\u00f2i h\u1ecfi cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n. V\u1edbi Text to Columns, tin ch\u1eafc, vi\u1ec7c qu\u1ea3n l\u00fd th\u00f4ng tin \u0111\u1ed1i t\u01b0\u1ee3ng tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n v\u00e0 ti\u1ec7n l\u1ee3i h\u01a1n r\u1ea5t nhi\u1ec1u.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng Text to Columns \u0111\u1ec3 t\u00e1ch t\u00ean trong Excel hay kh\u00f4ng? N\u1ebfu v\u1eabn ch\u01b0a th\u00ec Ho\u00e0ng H\u00e0 Mobile s\u1ebd ch\u1ec9 b\u1ea1n c\u00e1ch thao t\u00e1c nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n nh\u1ea5t qua c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: S\u1eed d\u1ee5ng chu\u1ed9t \u0111\u1ec3 b\u00f4i \u0111en to\u00e0n b\u1ed9 c\u1ed9t H\u1ecd v\u00e0 T\u00ean m\u00e0 b\u1ea1n c\u1ea7n t\u00e1ch. Sau \u0111\u00f3, tr\u00ean thanh c\u00f4ng c\u1ee5, b\u1ea1n nh\u1ea5n ch\u1ecdn m\u1ee5c Data.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270197 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch h\u1ecd t\u00ean trong Excel v\u1edbi Text to Columns\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-9.jpg\" alt=\"cach-tach-ten-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ti\u1ebfp \u0111\u1ebfn b\u1ea1n ch\u1ecdn m\u1ee5c Text to Columns n\u1eb1m \u1edf g\u00f3c b\u00ean ph\u1ea3i c\u1ee7a h\u1ed9p c\u00f4ng c\u1ee5 Data tr\u1ecf xu\u1ed1ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270198 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch h\u1ecd t\u00ean trong Excel v\u1edbi Text to Columns\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10.jpg\" alt=\"cach-tach-ten-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: H\u1ed9p tho\u1ea1i Convert Text to Columns Wizard xu\u1ea5t hi\u1ec7n, b\u1ea1n nh\u1ea5n ch\u1ecdn v\u00e0o \u00f4 Delimited. Ti\u1ebfp \u0111\u00f3 nh\u1ea5n ch\u1ecdn n\u00fat Next.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270198 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch h\u1ecd t\u00ean trong Excel v\u1edbi Text to Columns\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10.jpg\" alt=\"cach-tach-ten-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Sau \u0111\u00f3, b\u1ea1n tick ch\u1ecdn v\u00e0o \u00f4 Space \u1edf m\u1ee5c Delimiters v\u00e0 ti\u1ebfp t\u1ee5c nh\u1ea5n ch\u1ecdn n\u00fat Next.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270199 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch h\u1ecd t\u00ean trong Excel v\u1edbi Text to Columns\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-11.jpg\" alt=\"cach-tach-ten-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: Ti\u1ebfp \u0111\u1ebfn, \u1edf m\u1ee5c Column data format, b\u1ea1n tick v\u00e0o \u00f4 Text. \u1ede ph\u1ea7n Destination c\u00f3 ch\u1ee9a th\u00f4ng tin sau khi ho\u00e0n t\u1ea5t vi\u1ec7c t\u00e1ch t\u00ean. \u1ede \u0111\u00e2y, b\u1ea1n c\u1ea7n ch\u1ecdn \u00f4 B3, t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u1ed9t H\u1ecd. Sau \u0111\u00f3 b\u1ea1n nh\u1ea5t n\u00fat Finish \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270200 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch h\u1ecd t\u00ean trong Excel v\u1edbi Text to Columns\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-12.jpg\" alt=\"cach-tach-ten-trong-excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture> <picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270201 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch h\u1ecd t\u00ean trong Excel v\u1edbi Text to Columns\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-13.jpg\" alt=\"cach-tach-ten-trong-excel-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Tuy nhi\u00ean, c\u00e1ch n\u00e0y th\u01b0\u1eddng ch\u1ec9 ph\u00f9 h\u1ee3p v\u1edbi t\u00ean c\u00f3 2 ch\u1eef m\u00e0 th\u00f4i. \u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p c\u00f3 3 ch\u1eef tr\u1edf l\u00ean th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 m\u1ed9t c\u1ed9t H\u1ecd, m\u1ed9t c\u1ed9t T\u00ean l\u00e0 t\u00ean \u0111\u1ec7m c\u00f2n ph\u1ea7n t\u00ean ph\u00eda sau s\u1ebd \u0111\u01b0\u1ee3c t\u00e1ch sang c\u1ed9t kh\u00e1c.<\/span><\/p>\n<h3><strong>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m &#8211; c\u00e1ch t\u00e1ch t\u00ean h\u1ecd trong Excel<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i 2 c\u00e1ch nh\u01b0 Ho\u00e0ng H\u00e0 Mobile chia s\u1ebb \u1edf tr\u00ean, m\u1ed9t c\u00e1ch t\u00e1ch t\u00ean trong Excel kh\u00e1c c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn, th\u01b0\u1eddng xuy\u00ean nh\u01b0ng v\u00f4 c\u00f9ng hi\u1ec7u qu\u1ea3 \u0111\u00f3 l\u00e0 k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m Excel. C\u1ee5 th\u1ec3, c\u00e1c h\u00e0m s\u1eed d\u1ee5ng \u1edf c\u00e1ch n\u00e0y s\u1ebd l\u00e0 h\u00e0m LEN, h\u00e0m RIGHT v\u00e0 h\u00e0m SUBSTITUTE. B\u1ea1n c\u00f3 bi\u1ebft c\u00e1ch n\u00e0y kh\u00f4ng? H\u00e3y theo d\u00f5i c\u00e1c b\u01b0\u1edbc thao t\u00e1c d\u01b0\u1edbi \u0111\u00e2y v\u00e0 th\u1ef1c h\u00e0nh tr\u00ean file c\u1ee7a b\u1ea1n ngay nhe!<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u1ede \u00f4 mu\u1ed1n t\u00e1ch t\u00ean, \u1edf \u0111\u00e2y l\u00e0 D4, b\u1ea1n nh\u1eadp v\u00e0o \u0111\u00fang chu\u1ea9n ch\u1ec9nh h\u00e0m c\u00f4ng th\u1ee9c sau \u0111\u00e2y: <strong>=RIGHT(B4,LEN(B4)-FIND(\u201c@\u201d,SUBSTITUTE(B4,\u201d \u201c,\u201d@\u201d,LEN(SUBSTITUTE(B4,\u201d \u201c,\u201d\u201d)))))<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">RIGHT l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 c\u1eaft nh\u00f3m k\u00fd t\u1ef1 t\u1eeb b\u00ean ph\u1ea3i sang.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">LEN l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 l\u1ea5y \u0111\u1ed9 d\u00e0i m\u1ed9t chu\u1ed7i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">SUBSTITUTE l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 thay th\u1ebf v\u0103n b\u1ea3n x\u00e1c \u0111\u1ecbnh trong chu\u1ed7i \u0111\u00e3 cho.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270204 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m - c\u00e1ch t\u00e1ch t\u00ean h\u1ecd trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-16.jpg\" alt=\"cach-tach-ten-trong-excel-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture> <span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Sau \u0111\u00f3 nh\u1ea5n n\u00fat Enter \u0111\u1ec3 nh\u1eadn v\u1ec1 k\u1ebft qu\u1ea3 t\u00ean v\u1eeba t\u00e1ch. \u0110\u1ec3 th\u1ef1c hi\u1ec7n t\u00e1ch t\u00ean \u1edf nh\u1eefng \u00f4 c\u00f2n l\u1ea1i, b\u1ea1n \u0111\u1eb7t con tr\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng c\u1ee7a \u00f4 k\u1ebft qu\u1ea3 v\u1eeba nh\u1eadn, \u0111\u1ebfn khi th\u1ea5y d\u1ea5u \u201c+\u201d xu\u1ea5t hi\u1ec7n, ch\u1ec9 c\u1ea7n k\u00e9o xu\u1ed1ng h\u1ebft c\u00e1c \u00f4 c\u00f2n l\u1ea1i l\u00e0 xong b\u01b0\u1edbc t\u00e1ch t\u00ean.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: \u1ede \u00f4 mu\u1ed1n t\u00e1ch h\u1ecd v\u00e0 t\u00ean \u0111\u1ec7m, \u1edf \u0111\u00e2y l\u00e0 \u00f4 C4, b\u1ea1n nh\u1eadp v\u00e0o \u0111\u00fang chu\u1ea9n ch\u1ec9nh h\u00e0m c\u00f4ng th\u1ee9c sau \u0111\u00e2y: <strong>=LEFT(B4,LEN(B4)-LEN(D4))<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">LEFT l\u00e0 h\u00e0m nh\u1eb1m c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 n\u1eb1m t\u1eeb tr\u00e1i sang ph\u1ea3i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">LEN l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 l\u1ea5y m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270205 size-full webpexpress-processed\" title=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m - c\u00e1ch t\u00e1ch t\u00ean h\u1ecd trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-17.jpg\" alt=\"cach-tach-ten-trong-excel-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Ti\u1ebfp \u0111\u00f3 nh\u1ea5n n\u00fat Enter \u0111\u1ec3 nh\u1eadn v\u00e0 ki\u1ec3m tra k\u1ebft qu\u1ea3 m\u1ed9t l\u1ea7n n\u1eefa. \u0110\u1ec3 t\u00e1ch h\u1ecd v\u00e0 t\u00ean \u0111\u1ec7m, b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c nh\u01b0 b\u01b0\u1edbc 2.<\/span><\/p>\n<h3>S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Flash Fill &#8211; c\u00e1ch t\u00e1ch t\u00ean trong Excel<\/h3>\n<p>M\u1ed9t c\u00e1ch t\u00e1ch t\u00ean trong Microsoft Excel kh\u00e1c m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft v\u00e0 s\u1eed d\u1ee5ng \u0111\u00f3 ch\u00ednh l\u00e0 t\u00ednh n\u0103ng Flash Fill. T\u00ednh n\u0103ng n\u00e0y gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n d\u1eef li\u1ec7u v\u00e0o c\u00e1c h\u00e0ng, c\u1ed9t d\u1ef1a tr\u00ean m\u1ed9t m\u1eabu c\u1ee5 th\u1ec3. Do v\u1eady, Flash Fill c\u0169ng h\u1ed7 tr\u1ee3 b\u1ea1n t\u00e1ch h\u1ecd, t\u00ean \u0111\u1ec7m v\u00e0 t\u00ean sang c\u00e1c \u00f4 t\u00ednh kh\u00e1c nhau.<\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u1ee5 th\u1ec3, chi ti\u1ebft c\u00e1c thao t\u00e1c m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o v\u00e0 l\u01b0u l\u1ea1i \u0111\u1ec3 s\u1eed d\u1ee5ng khi l\u00e0m vi\u1ec7c, h\u1ecdc t\u1eadp tr\u00ean Excel:<\/p>\n<p>B\u01b0\u1edbc 1: Th\u00eam c\u00e1c c\u1ed9t m\u1edbi \u0111\u1eb7t \u1edf b\u00ean c\u1ea1nh c\u1ed9t H\u1ecd v\u00e0 t\u00ean. L\u1ea7n l\u01b0\u1ee3t nh\u1eadp v\u00e0o c\u00e1c \u00f4 h\u1ecd, t\u00ean \u0111\u1ec7m v\u00e0 t\u00ean t\u01b0\u01a1ng \u1ee9ng v\u00e0o h\u00e0ng \u0111\u1ea7u ti\u00ean \u0111\u1ec3 l\u00e0m m\u1eabu.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270203 size-full webpexpress-processed\" title=\"S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Flash Fill - c\u00e1ch t\u00e1ch t\u00ean trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-15.jpg\" alt=\"cach-tach-ten-trong-excel-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u01b0\u1edbc 2: \u0110\u1eb7t con tr\u1ecf v\u00e0o t\u1eebng c\u1ed9t, r\u1ed3i v\u00e0o m\u1ee5c Data, sau \u0111\u00f3 ch\u1ecdn Flash Fill ho\u1eb7c nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl + E \u0111\u1ec3 b\u1ea3ng t\u00ednh Excel t\u1ef1 \u0111\u1ed9ng nh\u1eadn di\u1ec7n v\u00e0 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n th\u00f4ng tin theo m\u1eabu s\u1eb5n. B\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng nh\u01b0 h\u00ecnh \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270202 size-full webpexpress-processed\" title=\"S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Flash Fill - c\u00e1ch t\u00e1ch t\u00ean trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-14.jpg\" alt=\"cach-tach-ten-trong-excel-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>M\u1ed9t h\u1ea1n ch\u1ebf c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Flash Fill \u0111\u1ec3 t\u00e1ch t\u00ean tr\u00ean trang t\u00ednh Excel \u0111\u00f3 l\u00e0 c\u1ea7n d\u1eef li\u1ec7u \u0111\u1ed3ng nh\u1ea5t, c\u1ee5 th\u1ec3 h\u1ecd v\u00e0 t\u00ean c\u1ea7n \u0111\u1ed3ng b\u1ed9 3 ch\u1eef. Khi h\u1ecd v\u00e0 t\u00ean c\u1ee7a c\u00e1c h\u00e0ng kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t, t\u00ednh n\u0103ng Flash Fill s\u1ebd kh\u00f4ng nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c chu\u1ea9n x\u00e1c \u0111\u1ec3 t\u1ef1 \u0111\u1ed3ng \u0111i\u1ec1n theo m\u1eabu x\u00e1c \u0111\u1ecbnh ban \u0111\u1ea7u.<\/p>\n<h2><b>Nh\u1eefng l\u01b0u \u00fd khi th\u1ef1c hi\u1ec7n c\u00e1ch t\u00e1ch t\u00ean trong Excel<\/b><\/h2>\n<p>Nh\u00ecn chung, c\u00e1c c\u00e1ch \u0111\u1ec3 t\u00e1ch h\u1ecd, t\u00ean trong Excel Ho\u00e0ng H\u00e0 Mobile chia s\u1ebb \u1edf tr\u00ean \u0111\u00e2y kh\u00f4ng qu\u00e1 kh\u00f3 kh\u0103n, ph\u1ee9c t\u1ea1p \u0111\u1ec3 th\u1ef1c hi\u1ec7n. Tuy v\u1eady, \u0111\u1ec3 th\u00e0nh c\u00f4ng ngay t\u1eeb l\u1ea7n thao t\u00e1c v\u00e0 th\u1ef1c hi\u1ec7n \u0111\u1ea7u ti\u00ean, b\u1ea1n c\u0169ng c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 v\u1ea5n \u0111\u1ec1 nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p>Nh\u1eadp \u0111\u00fang, \u0111\u1ee7 h\u00e0m c\u00f4ng th\u1ee9c: \u0110\u00e2y l\u00e0 y\u00eau c\u1ea7u b\u1eaft bu\u1ed9c, do v\u1eady, b\u1ea1n c\u1ea7n nh\u1eadp \u0111\u1ea7y \u0111\u1ee7, ch\u00ednh x\u00e1c t\u1eebng k\u00fd t\u1ef1 c\u1ee7a h\u00e0m v\u00e0 ki\u1ec3m tra k\u1ef9 c\u00e0ng tr\u00e1nh sai s\u00f3t d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 kh\u00f4ng \u0111\u00fang.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/cach-tach-ten-trong-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-270190 size-full webpexpress-processed\" title=\"Nh\u1eefng l\u01b0u \u00fd khi th\u1ef1c hi\u1ec7n c\u00e1ch t\u00e1ch t\u00ean trong Excel\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-2.jpg\" alt=\"cach-tach-ten-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>\u0110\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c h\u00e0m cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i nhanh nh\u1ea5t, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Fill Handle. C\u00e1ch s\u1eed d\u1ee5ng r\u1ea5t \u0111\u01a1n gi\u1ea3n, \u0111\u00f3 l\u00e0 \u0111\u1eb7t con tr\u1ecf chu\u1ed9t c\u1ee7a b\u1ea1n \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng c\u1ee7a \u00f4 c\u00f3 k\u1ebft qu\u1ea3 t\u1eeb h\u00e0m c\u00f4ng th\u1ee9c, \u0111\u1ebfn khi xu\u1ea5t hi\u1ec7n h\u00ecnh d\u1ea5u &#8220;+&#8221; b\u1ea1n gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o xu\u1ed1ng h\u1ebft nh\u1eefng \u00f4 c\u00f2n l\u1ea1i.<\/p>\n<p>M\u1ed7i c\u00e1ch s\u1ebd th\u00edch h\u1ee3p v\u1edbi t\u1eebng nhu c\u1ea7u kh\u00e1c nhau, t\u00f9y thu\u1ed9c v\u00e0o l\u01b0\u1ee3ng d\u1eef li\u1ec7u, th\u00f4ng tin H\u1ecd v\u00e0 t\u00ean \u0111\u1ea7u v\u00e0o. V\u00ed d\u1ee5, v\u1edbi c\u00e1ch t\u00e1ch t\u00ean b\u1eb1ng Text to Columns th\u01b0\u1eddng ch\u1ec9 \u00e1p d\u1ee5ng v\u1edbi nh\u1eefng t\u00ean c\u00f3 2 ch\u1eef. Trong khi \u0111\u00f3, v\u1edbi l\u01b0\u1ee3ng d\u1eef li\u1ec7u kh\u00f4ng qu\u00e1 l\u1edbn v\u00e0 \u0111\u1ed3ng b\u1ed9 h\u01a1n, vi\u1ec7c s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Flash Fill s\u1ebd kh\u1ea3 thi h\u01a1n so v\u1edbi tr\u01b0\u1eddng d\u1eef li\u1ec7u l\u1edbn v\u00e0 H\u1ecd v\u00e0 t\u00ean kh\u00f4ng th\u1ed1ng nh\u1ea5t 2, 3 hay 4 ch\u1eef.<\/p>\n<h2><b>T\u1ed5ng k\u1ebft<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn <\/span><b>c\u00e1ch t\u00e1ch t\u00ean trong Excel <\/b><span style=\"font-weight: 400;\">\u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng d\u00e0nh cho b\u1ea1n tham kh\u1ea3o. Hy v\u1ecdng b\u00e0i vi\u1ebft \u0111\u00e3 cung c\u1ea5p cho b\u1ea1n nh\u1eefng th\u00f4ng tin v\u00e0 th\u1ee7 thu\u1eadt h\u1eefu \u00edch \u0111\u1ec3 t\u1ed1i \u01b0u hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c c\u0169ng nh\u01b0 h\u1ecdc t\u1eadp c\u1ee7a b\u1ea1n. N\u1ebfu b\u1ea1n th\u1ea5y b\u00e0i vi\u1ebft hay, \u0111\u1eebng ng\u1ea7n ng\u1ea1i theo d\u00f5i <a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/\" target=\"_blank\" rel=\"noopener\"><strong>Trang Tin T\u1ee9c &#8211; Ho\u00e0ng H\u00e0 Mobile<\/strong><\/a> \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u b\u00e0i vi\u1ebft hay v\u00e0 th\u00fa v\u1ecb v\u1edbi r\u1ea5t nhi\u1ec1u ch\u1ee7 \u0111\u1ec1 m\u1edbi m\u1ebb nh\u01b0 th\u1ee7 thu\u1eadt, App, Game, tin t\u1ee9c c\u00f4ng ngh\u1ec7\u2026n\u1eefa nh\u00e9!<\/span><\/p>\n<p><b><i>M\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft th\u1ee7 thu\u1eadt Excel \u0111\u1ebfn t\u1eeb Ho\u00e0ng H\u00e0 Mobile m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:<\/i><\/b><\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/loc-du-lieu-trung-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel hi\u1ec7u qu\u1ea3 nh\u1ea5t<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/dinh-dang-ngay-thang-trong-excel\/\" target=\"_blank\" rel=\"noopener\">\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong Excel: 6 c\u00e1ch th\u1ef1c hi\u1ec7n \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh nh\u1ea5t<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-xoa-dong-trong-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch x\u00f3a d\u00f2ng tr\u1ed1ng trong excel: T\u1ed5ng h\u1ee3p c\u00e1c c\u00e1ch nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 tin h\u1ecdc v\u0103n ph\u00f2ng h\u1eefu \u00edch cho h\u1ea7u h\u1ebft c\u00e1c ng\u00e0nh, ngh\u1ec1. V\u1edbi r\u1ea5t nhi\u1ec1u h\u00e0m, th\u1ee7 thu\u1eadt b\u1ed5 tr\u1ee3 h\u1eefu \u00edch, \u0111\u00e1p \u1ee9ng nhu c\u1ea7u trong c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai c\u0169ng n\u1eafm b\u1eaft t\u1ea5t t\u1ea7n t\u1eadt nh\u1eefng th\u1ee7 thu\u1eadt n\u00e0y, [&hellip;]<\/p>\n","protected":false},"author":72,"featured_media":270188,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-268606","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>C\u00e1ch t\u00e1ch c\u1ed9t h\u1ecd v\u00e0 t\u00ean trong Excel nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"Kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft th\u1ee7 thu\u1eadt t\u00e1ch tr\u01b0\u1eddng h\u1ecd v\u00e0 t\u00ean. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch t\u00ean trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n nh\u1ea5t.\" \/>\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\/cach-tach-ten-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch t\u00e1ch c\u1ed9t h\u1ecd v\u00e0 t\u00ean trong Excel nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"Kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft th\u1ee7 thu\u1eadt t\u00e1ch tr\u01b0\u1eddng h\u1ecd v\u00e0 t\u00ean. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch t\u00ean trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n nh\u1ea5t.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-10T09:26:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-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=\"Viet Cuong\" \/>\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=\"Viet Cuong\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/\"},\"author\":{\"name\":\"Viet Cuong\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/193f117c86913fb9ff22647e2a512291\"},\"headline\":\"C\u00e1ch t\u00e1ch c\u1ed9t h\u1ecd v\u00e0 t\u00ean trong Excel nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"datePublished\":\"2023-10-10T09:26:06+00:00\",\"dateModified\":\"2023-10-10T09:26:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/\"},\"wordCount\":3073,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/\",\"name\":\"C\u00e1ch t\u00e1ch c\u1ed9t h\u1ecd v\u00e0 t\u00ean trong Excel nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel.jpg\",\"datePublished\":\"2023-10-10T09:26:06+00:00\",\"dateModified\":\"2023-10-10T09:26:06+00:00\",\"description\":\"Kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft th\u1ee7 thu\u1eadt t\u00e1ch tr\u01b0\u1eddng h\u1ecd v\u00e0 t\u00ean. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch t\u00ean trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n nh\u1ea5t.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"cach-tach-ten-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00e1ch t\u00e1ch c\u1ed9t h\u1ecd v\u00e0 t\u00ean trong Excel nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t\"}]},{\"@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\/193f117c86913fb9ff22647e2a512291\",\"name\":\"Viet Cuong\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/07bcf1249c15161e59a7fb9d39237905?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/07bcf1249c15161e59a7fb9d39237905?s=96&d=mm&r=g\",\"caption\":\"Viet Cuong\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/viet-cuong\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch t\u00e1ch c\u1ed9t h\u1ecd v\u00e0 t\u00ean trong Excel nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t","description":"Kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft th\u1ee7 thu\u1eadt t\u00e1ch tr\u01b0\u1eddng h\u1ecd v\u00e0 t\u00ean. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch t\u00ean trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n nh\u1ea5t.","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\/cach-tach-ten-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch t\u00e1ch c\u1ed9t h\u1ecd v\u00e0 t\u00ean trong Excel nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t","og_description":"Kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft th\u1ee7 thu\u1eadt t\u00e1ch tr\u01b0\u1eddng h\u1ecd v\u00e0 t\u00ean. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch t\u00ean trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n nh\u1ea5t.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-10-10T09:26:06+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel.jpg","type":"image\/jpeg"}],"author":"Viet Cuong","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Viet Cuong","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"15 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/"},"author":{"name":"Viet Cuong","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/193f117c86913fb9ff22647e2a512291"},"headline":"C\u00e1ch t\u00e1ch c\u1ed9t h\u1ecd v\u00e0 t\u00ean trong Excel nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t","datePublished":"2023-10-10T09:26:06+00:00","dateModified":"2023-10-10T09:26:06+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/"},"wordCount":3073,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/","name":"C\u00e1ch t\u00e1ch c\u1ed9t h\u1ecd v\u00e0 t\u00ean trong Excel nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel.jpg","datePublished":"2023-10-10T09:26:06+00:00","dateModified":"2023-10-10T09:26:06+00:00","description":"Kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft th\u1ee7 thu\u1eadt t\u00e1ch tr\u01b0\u1eddng h\u1ecd v\u00e0 t\u00ean. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch t\u00ean trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n nh\u1ea5t.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/cach-tach-ten-trong-excel.jpg","width":1200,"height":628,"caption":"cach-tach-ten-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"C\u00e1ch t\u00e1ch c\u1ed9t h\u1ecd v\u00e0 t\u00ean trong Excel nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t"}]},{"@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\/193f117c86913fb9ff22647e2a512291","name":"Viet Cuong","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/07bcf1249c15161e59a7fb9d39237905?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/07bcf1249c15161e59a7fb9d39237905?s=96&d=mm&r=g","caption":"Viet Cuong"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/viet-cuong\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/268606","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\/72"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=268606"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/268606\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/270188"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=268606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=268606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=268606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}