{"id":501923,"date":"2025-11-08T20:48:59","date_gmt":"2025-11-08T13:48:59","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=501923"},"modified":"2026-08-25T12:11:43","modified_gmt":"2026-08-25T05:11:43","slug":"tim-kiem-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/","title":{"rendered":"7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace"},"content":{"rendered":"<p style=\"text-align: justify;\">Trong c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi x\u1eed l\u00fd d\u1eef li\u1ec7u l\u1edbn, <strong>t\u00ecm ki\u1ebfm trong Excel<\/strong> l\u00e0 thao t\u00e1c v\u00f4 c\u00f9ng quan tr\u1ecdng gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 tr\u00e1nh sai s\u00f3t. Kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed \u00f4, d\u00f2ng ho\u1eb7c c\u1ed9t ch\u1ee9a th\u00f4ng tin c\u1ea7n t\u00ecm, Excel c\u00f2n cho ph\u00e9p thay th\u1ebf d\u1eef li\u1ec7u h\u00e0ng lo\u1ea1t ch\u1ec9 v\u1edbi v\u00e0i c\u00fa nh\u1ea5p chu\u1ed9t. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 7 c\u00e1ch t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf trong Excel c\u00f9ng c\u00e1c m\u1eb9o thay th\u1ebf th\u00f4ng minh b\u1eb1ng Find v\u00e0 Replace chi ti\u1ebft nh\u1ea5t.<\/p>\n<h2 style=\"text-align: justify;\"><strong>L\u1ee3i \u00edch khi bi\u1ebft thay th\u1ebf v\u00e0 t\u00ecm ki\u1ebfm trong Excel<\/strong><\/h2>\n<p style=\"text-align: justify;\">Vi\u1ec7c n\u1eafm v\u1eefng c\u00e1c thao t\u00e1c t\u00ecm ki\u1ebfm (Find) v\u00e0 thay th\u1ebf (Replace) trong Excel kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n thao t\u00e1c nhanh h\u01a1n m\u00e0 c\u00f2n gi\u1ea3m \u0111\u00e1ng k\u1ec3 c\u00f4ng s\u1ee9c khi x\u1eed l\u00fd d\u1eef li\u1ec7u l\u1edbn. C\u1ee5 th\u1ec3, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c nh\u1eefng l\u1ee3i \u00edch sau:<\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<p><strong>Ti\u1ebft ki\u1ec7m th\u1eddi gian:<\/strong> Kh\u00f4ng c\u1ea7n cu\u1ed9n h\u00e0ng ngh\u00ecn d\u00f2ng \u0111\u1ec3 t\u00ecm m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3.<\/p>\n<\/li>\n<li>\n<p><strong>Gi\u1ea3m sai s\u00f3t:<\/strong> T\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c gi\u00fap h\u1ea1n ch\u1ebf nh\u1eadp sai ho\u1eb7c b\u1ecf s\u00f3t d\u1eef li\u1ec7u.<\/p>\n<\/li>\n<li>\n<p><strong>Thay \u0111\u1ed5i d\u1eef li\u1ec7u h\u00e0ng lo\u1ea1t:<\/strong> Thay th\u1ebf th\u00f4ng tin c\u0169 b\u1eb1ng d\u1eef li\u1ec7u m\u1edbi nhanh ch\u00f3ng m\u00e0 kh\u00f4ng c\u1ea7n thao t\u00e1c th\u1ee7 c\u00f4ng.<\/p>\n<\/li>\n<li>\n<p><strong>N\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c:<\/strong> Gi\u00fap ph\u00e2n t\u00edch, l\u1ecdc, ch\u1ec9nh s\u1eeda b\u1ea3ng t\u00ednh chuy\u00ean nghi\u1ec7p h\u01a1n.<\/p>\n<\/li>\n<li>\n<p><strong>T\u0103ng \u0111\u1ed9 ch\u00ednh x\u00e1c:<\/strong> Khi t\u00ecm ki\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n, Excel gi\u00fap x\u00e1c \u0111\u1ecbnh \u0111\u00fang v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n thay \u0111\u1ed5i m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng ph\u1ea7n c\u00f2n l\u1ea1i.<\/p>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-504705 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-1.jpg\" alt=\"L\u1ee3i \u00edch khi bi\u1ebft thay th\u1ebf v\u00e0 t\u00ecm ki\u1ebfm trong Excel\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><strong>H\u01b0\u1edbng d\u1eabn 7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel (Find)<\/strong><\/h2>\n<p style=\"text-align: justify;\">T\u00ednh n\u0103ng Find (Ctrl + F) trong Excel c\u00f3 r\u1ea5t nhi\u1ec1u t\u00f9y ch\u1ecdn, t\u1eeb t\u00ecm ki\u1ebfm c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 7 c\u00e1ch t\u00ecm ki\u1ebfm ph\u1ed5 bi\u1ebfn v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t m\u00e0 b\u1ea1n n\u00ean bi\u1ebft.<\/p>\n<h3 style=\"text-align: justify;\"><strong>T\u00ecm ki\u1ebfm nhanh b\u1eb1ng ph\u00edm t\u1eaft Ctrl + F<\/strong><\/h3>\n<p style=\"text-align: justify;\">\u0110\u00e2y l\u00e0 c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t \u0111\u1ec3 t\u00ecm ki\u1ebfm trong Excel. B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng khi mu\u1ed1n tra c\u1ee9u nhanh m\u1ed9t con s\u1ed1, t\u00ean kh\u00e1ch h\u00e0ng ho\u1eb7c n\u1ed9i dung c\u1ee5 th\u1ec3 trong b\u1ea3ng t\u00ednh.<\/p>\n<p style=\"text-align: justify;\"><strong>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel b\u1ea1n c\u1ea7n t\u00ecm ki\u1ebfm.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <strong>Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3:<\/strong> Trong \u00f4 <strong>Find what<\/strong>, nh\u1eadp n\u1ed9i dung ho\u1eb7c gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm (v\u00ed d\u1ee5: t\u00ean s\u1ea3n ph\u1ea9m, m\u00e3 \u0111\u01a1n h\u00e0ng, s\u1ed1 \u0111i\u1ec7n tho\u1ea1i,&#8230;).<\/p>\n<p style=\"text-align: justify;\">\u00a0<img decoding=\"async\" class=\"size-full wp-image-504707 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-3.jpg\" alt=\"T\u00ecm ki\u1ebfm nhanh b\u1eb1ng ph\u00edm t\u1eaft Ctrl + F\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n <strong>Find Next<\/strong> \u0111\u1ec3 Excel t\u1ef1 \u0111\u1ed9ng di chuy\u1ec3n \u0111\u1ebfn <strong>\u00f4 ch\u1ee9a k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean<\/strong> tr\u00f9ng kh\u1edbp v\u1edbi n\u1ed9i dung t\u00ecm ki\u1ebfm.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 5:<\/strong> Ti\u1ebfp t\u1ee5c nh\u1ea5n <strong>Find Next<\/strong> \u0111\u1ec3 chuy\u1ec3n \u0111\u1ebfn <strong>k\u1ebft qu\u1ea3 ti\u1ebfp theo<\/strong> n\u1ebfu c\u00f3 nhi\u1ec1u gi\u00e1 tr\u1ecb tr\u00f9ng nhau.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 6:<\/strong> N\u1ebfu mu\u1ed1n xem <strong>to\u00e0n b\u1ed9 k\u1ebft qu\u1ea3 c\u00f9ng l\u00fac<\/strong>, ch\u1ecdn <strong>Find All<\/strong> \u2014 Excel s\u1ebd hi\u1ec3n th\u1ecb danh s\u00e1ch t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a n\u1ed9i dung tr\u00f9ng kh\u1edbp \u1edf ngay b\u00ean d\u01b0\u1edbi h\u1ed9p tho\u1ea1i.<\/p>\n<p style=\"text-align: justify;\"><strong>M\u1eb9o nh\u1ecf:<\/strong> B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p th\u00eam ph\u00edm <strong>Ctrl + H<\/strong> \u0111\u1ec3 m\u1edf ngay tab <strong>Replace<\/strong>, gi\u00fap v\u1eeba t\u00ecm ki\u1ebfm v\u1eeba thay th\u1ebf d\u1eef li\u1ec7u nhanh ch\u00f3ng trong c\u00f9ng m\u1ed9t thao t\u00e1c.<\/p>\n<h3 style=\"text-align: justify;\"><strong>T\u00ecm ki\u1ebfm trong v\u00f9ng d\u1eef li\u1ec7u c\u1ee5 th\u1ec3<\/strong><\/h3>\n<p style=\"text-align: justify;\">Khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng Excel c\u00f3 h\u00e0ng tr\u0103m d\u00f2ng d\u1eef li\u1ec7u, vi\u1ec7c gi\u1edbi h\u1ea1n ph\u1ea1m vi t\u00ecm ki\u1ebfm s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian \u0111\u00e1ng k\u1ec3. Thay v\u00ec t\u00ecm ki\u1ebfm trong Excel v\u00e0 \u0111\u1ec3 Excel qu\u00e9t to\u00e0n b\u1ed9 trang t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh v\u00f9ng c\u1ea7n t\u00ecm \u0111\u1ec3 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c v\u00e0 nhanh h\u01a1n.<\/p>\n<p style=\"text-align: justify;\"><strong>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n t\u00ecm.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> <strong>B\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u<\/strong> mu\u1ed1n t\u00ecm ki\u1ebfm, v\u00ed d\u1ee5 nh\u01b0 <strong>c\u1ed9t A<\/strong>, <strong>v\u00f9ng B2:B100<\/strong>, ho\u1eb7c m\u1ed9t <strong>b\u1ea3ng con c\u1ee5 th\u1ec3<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"size-full wp-image-504708 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-4.jpg\" alt=\"T\u00ecm ki\u1ebfm trong v\u00f9ng d\u1eef li\u1ec7u c\u1ee5 th\u1ec3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <strong>Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 4:<\/strong> Trong \u00f4 <strong>Find what<\/strong>, nh\u1eadp n\u1ed9i dung ho\u1eb7c t\u1eeb kh\u00f3a b\u1ea1n mu\u1ed1n t\u00ecm.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 5:<\/strong> Ch\u1ecdn <strong>Find All<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb t\u1ea5t c\u1ea3 c\u00e1c k\u1ebft qu\u1ea3 t\u00ecm \u0111\u01b0\u1ee3c trong <strong>ph\u1ea1m vi v\u1eeba ch\u1ecdn<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 6:<\/strong> Xem danh s\u00e1ch k\u1ebft qu\u1ea3 b\u00ean d\u01b0\u1edbi h\u1ed9p tho\u1ea1i \u2013 Excel s\u1ebd ch\u1ec9 li\u1ec7t k\u00ea <strong>nh\u1eefng \u00f4 n\u1eb1m trong v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 b\u00f4i \u0111en<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>M\u1eb9o nh\u1ecf:<\/strong> N\u1ebfu b\u1ea1n l\u1ee1 qu\u00ean ch\u1ecdn v\u00f9ng tr\u01b0\u1edbc khi nh\u1ea5n Ctrl + F, b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 thu h\u1eb9p ph\u1ea1m vi t\u00ecm ki\u1ebfm b\u1eb1ng c\u00e1ch v\u00e0o <strong>Options \u2192 Within \u2192 Sheet\/Workbook<\/strong>, r\u1ed3i ch\u1ecdn l\u1ea1i ph\u1ea1m vi mong mu\u1ed1n.<\/p>\n<h3 style=\"text-align: justify;\"><strong>T\u00ecm ki\u1ebfm theo \u0111\u1ecbnh d\u1ea1ng (Format)<\/strong><\/h3>\n<p style=\"text-align: justify;\">Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng nh\u1edb ch\u00ednh x\u00e1c n\u1ed9i dung c\u1ee7a \u00f4, nh\u01b0ng l\u1ea1i nh\u1edb r\u00f5 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a n\u00f3, v\u00ed d\u1ee5 nh\u01b0 \u00f4 c\u00f3 n\u1ec1n v\u00e0ng, ch\u1eef m\u00e0u \u0111\u1ecf ho\u1eb7c in \u0111\u1eadm. Khi \u0111\u00f3, t\u00ecm ki\u1ebfm trong Excel cho ph\u00e9p b\u1ea1n t\u00ecm ki\u1ebfm d\u1ef1a tr\u00ean \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb, gi\u00fap x\u00e1c \u0111\u1ecbnh nhanh c\u00e1c \u00f4 c\u00f3 c\u00f9ng phong c\u00e1ch tr\u00ecnh b\u00e0y.<\/p>\n<p style=\"text-align: justify;\"><strong>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n t\u00ecm.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong>Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5p v\u00e0o n\u00fat <strong>Options<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb th\u00eam c\u00e1c t\u00f9y ch\u1ecdn n\u00e2ng cao.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504712 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-8.jpg\" alt=\"T\u00ecm ki\u1ebfm theo \u0111\u1ecbnh d\u1ea1ng - h\u00ecnh 1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 4:<\/strong> Ch\u1ecdn <strong>Format\u2026<\/strong> (b\u00ean ph\u1ea3i \u00f4 \u201cFind what\u201d).<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 5:<\/strong> Trong c\u1eeda s\u1ed5 <strong>Find Format<\/strong>, ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng b\u1ea1n mu\u1ed1n t\u00ecm \u2014 ch\u1eb3ng h\u1ea1n nh\u01b0:<\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<p><strong>Font:<\/strong> ki\u1ec3u ch\u1eef, k\u00edch th\u01b0\u1edbc, m\u00e0u s\u1eafc.<\/p>\n<\/li>\n<li>\n<p><strong>Fill:<\/strong> m\u00e0u n\u1ec1n c\u1ee7a \u00f4.<\/p>\n<\/li>\n<li>\n<p><strong>Border:<\/strong> ki\u1ec3u vi\u1ec1n, \u0111\u1ed9 d\u00e0y.<\/p>\n<\/li>\n<li>\n<p><strong>Alignment:<\/strong> c\u0103n l\u1ec1 ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng canh ch\u1ec9nh.<\/p>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504710 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-6.jpg\" alt=\"T\u00ecm ki\u1ebfm theo \u0111\u1ecbnh d\u1ea1ng - h\u00ecnh 2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 6:<\/strong> Nh\u1ea5n <strong>OK<\/strong> \u0111\u1ec3 x\u00e1c nh\u1eadn \u0111\u1ecbnh d\u1ea1ng c\u1ea7n t\u00ecm.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 7:<\/strong> Ch\u1ecdn <strong>Find All<\/strong> ho\u1eb7c <strong>Find Next<\/strong> \u0111\u1ec3 Excel hi\u1ec3n th\u1ecb c\u00e1c \u00f4 c\u00f3 c\u00f9ng \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<p style=\"text-align: justify;\"><strong>M\u1eb9o nh\u1ecf:<\/strong> T\u1ea1i b\u01b0\u1edbc 4, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o <strong>Choose Format From Cell<\/strong> (bi\u1ec3u t\u01b0\u1ee3ng c\u00e2y ch\u1ed5i nh\u1ecf) \u0111\u1ec3 l\u1ea5y \u0111\u1ecbnh d\u1ea1ng t\u1eeb m\u1ed9t \u00f4 m\u1eabu, gi\u00fap thao t\u00e1c nhanh v\u00e0 ch\u00ednh x\u00e1c h\u01a1n. \u0110\u00e2y l\u00e0 c\u00e1ch c\u1ef1c k\u1ef3 h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n r\u00e0 so\u00e1t c\u00e1c \u00f4 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u \u0111\u1eb7c bi\u1ec7t trong b\u00e1o c\u00e1o, b\u1ea3ng ki\u1ec3m tra, ho\u1eb7c khi ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ecbnh d\u1ea1ng ri\u00eang.<\/p>\n<h3 style=\"text-align: justify;\"><strong>T\u00ecm ki\u1ebfm c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng<\/strong><\/h3>\n<p style=\"text-align: justify;\">Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u1ea7n t\u00ecm ki\u1ebfm trong Excel ch\u00ednh x\u00e1c d\u1eef li\u1ec7u c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng, ch\u1eb3ng h\u1ea1n nh\u01b0 m\u00e3 s\u1ea3n ph\u1ea9m, t\u00ean vi\u1ebft t\u1eaft, hay c\u00e1c tr\u01b0\u1eddng h\u1ee3p \u201cApple\u201d v\u00e0 \u201capple\u201d mang \u00fd ngh\u0129a kh\u00e1c nhau. Excel h\u1ed7 tr\u1ee3 t\u00ednh n\u0103ng Match case \u0111\u1ec3 gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y.<\/p>\n<p style=\"text-align: justify;\"><strong>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf b\u1ea3ng t\u00ednh Excel ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n t\u00ecm.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong>Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5p v\u00e0o n\u00fat <strong>Options<\/strong> \u0111\u1ec3 m\u1edf r\u1ed9ng th\u00eam c\u00e1c t\u00f9y ch\u1ecdn t\u00ecm ki\u1ebfm.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504712 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-8.jpg\" alt=\"T\u00ecm ki\u1ebfm c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng - h\u00ecnh 1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 4:<\/strong> Tick ch\u1ecdn v\u00e0o \u00f4 <strong>Match case<\/strong> (Ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng).<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 5:<\/strong> Nh\u1eadp t\u1eeb kh\u00f3a c\u1ea7n t\u00ecm v\u00e0o \u00f4 <strong>Find what<\/strong> \u2014 v\u00ed d\u1ee5: g\u00f5 \u201cApple\u201d n\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n t\u00ecm ch\u00ednh x\u00e1c t\u1eeb n\u00e0y, ch\u1ee9 kh\u00f4ng bao g\u1ed3m \u201capple\u201d.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504713 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-9.jpg\" alt=\"T\u00ecm ki\u1ebfm c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng - h\u00ecnh 2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 6:<\/strong> Nh\u1ea5n <strong>Find Next<\/strong> ho\u1eb7c <strong>Find All<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 tr\u00f9ng kh\u1edbp ho\u00e0n to\u00e0n theo \u0111\u1ecbnh d\u1ea1ng ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504714 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-10.jpg\" alt=\"T\u00ecm ki\u1ebfm c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa \u2013 ch\u1eef th\u01b0\u1eddng - h\u00ecnh 3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>M\u1eb9o nh\u1ecf:<\/strong> Khi l\u00e0m vi\u1ec7c v\u1edbi danh s\u00e1ch m\u00e3 h\u00e0ng, t\u00ean kh\u00e1ch h\u00e0ng, ho\u1eb7c d\u1eef li\u1ec7u ph\u00e2n bi\u1ec7t k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t, vi\u1ec7c b\u1eadt <strong>Match case<\/strong> s\u1ebd gi\u00fap tr\u00e1nh sai s\u00f3t trong \u0111\u1ed1i chi\u1ebfu v\u00e0 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u.<\/p>\n<h3 style=\"text-align: justify;\"><strong>T\u00ecm ki\u1ebfm to\u00e0n ph\u1ea7n ho\u1eb7c m\u1ed9t ph\u1ea7n t\u1eeb kh\u00f3a<\/strong><\/h3>\n<p style=\"text-align: justify;\"><strong>Tr\u01b0\u1eddng h\u1ee3p 1: T\u00ecm ki\u1ebfm to\u00e0n ph\u1ea7n (ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i)<\/strong><\/p>\n<p style=\"text-align: justify;\">T\u00ednh n\u0103ng t\u00ecm ki\u1ebfm trong Excel n\u00e0y gi\u00fap Excel ch\u1ec9 hi\u1ec3n th\u1ecb nh\u1eefng \u00f4 c\u00f3 n\u1ed9i dung tr\u00f9ng kh\u1edbp ho\u00e0n to\u00e0n v\u1edbi t\u1eeb kh\u00f3a b\u1ea1n nh\u1eadp.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5n <strong>Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn <strong>Options<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c t\u00f9y ch\u1ecdn n\u00e2ng cao.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504715 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-11.jpg\" alt=\"T\u00ecm ki\u1ebfm to\u00e0n ph\u1ea7n ho\u1eb7c m\u1ed9t ph\u1ea7n t\u1eeb kh\u00f3a - h\u00ecnh 1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3:<\/strong> Tick v\u00e0o \u00f4 <strong>Match entire cell contents<\/strong> (Kh\u1edbp to\u00e0n b\u1ed9 n\u1ed9i dung \u00f4).<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504716 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-12.jpg\" alt=\"T\u00ecm ki\u1ebfm to\u00e0n ph\u1ea7n ho\u1eb7c m\u1ed9t ph\u1ea7n t\u1eeb kh\u00f3a - h\u00ecnh 2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 4:<\/strong> Nh\u1eadp t\u1eeb kh\u00f3a v\u00e0o \u00f4 <strong>Find what<\/strong> v\u00e0 nh\u1ea5n <strong>Find Next<\/strong>.<\/p>\n<p style=\"text-align: justify;\">\u2192 <strong>V\u00ed d\u1ee5:<\/strong> N\u1ebfu b\u1ea1n nh\u1eadp \u201cH\u00e0 N\u1ed9i\u201d, Excel ch\u1ec9 t\u00ecm c\u00e1c \u00f4 c\u00f3 n\u1ed9i dung ch\u00ednh x\u00e1c l\u00e0<strong> \u201cH\u00e0 N\u1ed9i\u201d<\/strong>, m\u00e0 kh\u00f4ng bao g\u1ed3m \u201cH\u00e0 N\u1ed9i 2025\u201d hay \u201cTP H\u00e0 N\u1ed9i\u201d.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504717 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-13.jpg\" alt=\"T\u00ecm ki\u1ebfm to\u00e0n ph\u1ea7n ho\u1eb7c m\u1ed9t ph\u1ea7n t\u1eeb kh\u00f3a - h\u00ecnh 3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Tr\u01b0\u1eddng h\u1ee3p 2: T\u00ecm ki\u1ebfm theo ph\u1ea7n c\u1ee7a chu\u1ed7i (m\u1ed9t ph\u1ea7n t\u1eeb kh\u00f3a)<\/strong><\/p>\n<p style=\"text-align: justify;\">Khi b\u1ea1n mu\u1ed1n t\u00ecm m\u1ecdi \u00f4 c\u00f3 ch\u1ee9a c\u1ee5m t\u1eeb \u0111\u00f3, d\u00f9 l\u00e0 \u1edf \u0111\u1ea7u, gi\u1eefa hay cu\u1ed1i chu\u1ed7i, b\u1ea1n ch\u1ec9 c\u1ea7n t\u1eaft t\u00f9y ch\u1ecdn tr\u00ean.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5n <strong>Ctrl + F<\/strong> \u2192 <strong>Options<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> <strong>B\u1ecf ch\u1ecdn<\/strong> \u00f4 <strong>Match entire cell contents<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504718 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-14.jpg\" alt=\"T\u00ecm ki\u1ebfm to\u00e0n ph\u1ea7n ho\u1eb7c m\u1ed9t ph\u1ea7n t\u1eeb kh\u00f3a - h\u00ecnh 4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1eadp t\u1eeb kh\u00f3a v\u00e0 nh\u1ea5n <strong>Find All<\/strong> \u0111\u1ec3 xem to\u00e0n b\u1ed9 k\u1ebft qu\u1ea3.<\/p>\n<p style=\"text-align: justify;\">\u2192 <strong>V\u00ed d\u1ee5:<\/strong> T\u00ecm \u201cH\u00e0 N\u1ed9i\u201d s\u1ebd hi\u1ec3n th\u1ecb c\u00e1c \u00f4 ch\u1ee9a \u201cH\u00e0 N\u1ed9i 2025\u201d, \u201cTP H\u00e0 N\u1ed9i\u201d, ho\u1eb7c \u201cS\u1ef1 ki\u1ec7n t\u1ea1i H\u00e0 N\u1ed9i\u201d.<\/p>\n<p style=\"text-align: justify;\"><strong>M\u1eb9o nh\u1ecf: <\/strong>Khi t\u00ecm trong d\u1eef li\u1ec7u d\u00e0i ho\u1eb7c b\u1ea3ng nhi\u1ec1u c\u1ed9t, b\u1ea1n n\u00ean k\u1ebft h\u1ee3p Find All \u0111\u1ec3 xem danh s\u00e1ch to\u00e0n b\u1ed9 \u00f4 ch\u1ee9a k\u1ebft qu\u1ea3. C\u00e1ch n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi c\u1ea7n r\u00e0 so\u00e1t t\u00ean \u0111\u1ecba \u0111i\u1ec3m, s\u1ea3n ph\u1ea9m, ho\u1eb7c chu\u1ed7i k\u00fd t\u1ef1 c\u00f3 ti\u1ec1n t\u1ed1 \u2013 h\u1eadu t\u1ed1 kh\u00e1c nhau.<\/p>\n<h3 style=\"text-align: justify;\"><strong>T\u00ecm ki\u1ebfm theo c\u00f4ng th\u1ee9c (Formulas)<\/strong><\/h3>\n<p style=\"text-align: justify;\">Khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh ph\u1ee9c t\u1ea1p, \u0111\u00f4i khi b\u1ea1n kh\u00f4ng c\u1ea7n t\u00ecm gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb, m\u00e0 mu\u1ed1n x\u00e1c \u0111\u1ecbnh nh\u1eefng \u00f4 \u0111ang ch\u1ee9a c\u00f4ng th\u1ee9c, ch\u1eb3ng h\u1ea1n nh\u01b0 h\u00e0m SUM, VLOOKUP, IF, ho\u1eb7c c\u00e1c c\u00f4ng th\u1ee9c t\u1ef1 t\u1ea1o. Excel cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y r\u1ea5t d\u1ec5 d\u00e0ng th\u00f4ng qua t\u00f9y ch\u1ecdn Look in \u2192 Formulas.<\/p>\n<p style=\"text-align: justify;\"><strong>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel b\u1ea1n mu\u1ed1n ki\u1ec3m tra.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong>Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5p v\u00e0o <strong>Options<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb th\u00eam c\u00e1c l\u1ef1a ch\u1ecdn n\u00e2ng cao.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504719 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-15.jpg\" alt=\"T\u00ecm ki\u1ebfm theo c\u00f4ng th\u1ee9c - h\u00ecnh 1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 4:<\/strong> Trong m\u1ee5c <strong>Look in<\/strong>, ch\u1ecdn <strong>Formulas<\/strong> (C\u00f4ng th\u1ee9c).<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504720 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-16.jpg\" alt=\"T\u00ecm ki\u1ebfm theo c\u00f4ng th\u1ee9c - h\u00ecnh 2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 5:<\/strong> T\u1ea1i \u00f4 <strong>Find what<\/strong>, nh\u1eadp ph\u1ea7n n\u1ed9i dung b\u1ea1n mu\u1ed1n t\u00ecm, v\u00ed d\u1ee5:<\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<p><code>=SUM<\/code> \u0111\u1ec3 t\u00ecm c\u00e1c \u00f4 s\u1eed d\u1ee5ng h\u00e0m t\u00ednh t\u1ed5ng.<\/p>\n<\/li>\n<li>\n<p><code>=VLOOKUP<\/code> \u0111\u1ec3 t\u00ecm c\u00e1c \u00f4 tra c\u1ee9u d\u1eef li\u1ec7u.<\/p>\n<\/li>\n<li><code>IF(<\/code> \u0111\u1ec3 t\u00ecm c\u00e1c \u00f4 c\u00f3 \u0111i\u1ec1u ki\u1ec7n logic.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 6:<\/strong> Nh\u1ea5n <strong>Find All<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb danh s\u00e1ch to\u00e0n b\u1ed9 c\u00e1c \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c \u0111\u00f3.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504721 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-17.jpg\" alt=\"T\u00ecm ki\u1ebfm theo c\u00f4ng th\u1ee9c - h\u00ecnh 3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>M\u1eb9o nh\u1ecf: <\/strong>B\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n <strong>Find Next<\/strong> \u0111\u1ec3 di chuy\u1ec3n l\u1ea7n l\u01b0\u1ee3t qua t\u1eebng \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c. C\u00e1ch n\u00e0y r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n r\u00e0 so\u00e1t c\u00e1c c\u00f4ng th\u1ee9c \u0111ang d\u00f9ng, ki\u1ec3m tra l\u1ed7i trong h\u00e0m, ho\u1eb7c x\u00e1c \u0111\u1ecbnh v\u00f9ng t\u00ednh to\u00e1n t\u1ef1 \u0111\u1ed9ng trong b\u1ea3ng d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p.<\/p>\n<h3 style=\"text-align: justify;\"><strong>T\u00ecm ki\u1ebfm theo gi\u00e1 tr\u1ecb, ghi ch\u00fa ho\u1eb7c nh\u1eadn x\u00e9t<\/strong><\/h3>\n<p style=\"text-align: justify;\">Ngo\u00e0i vi\u1ec7c t\u00ecm ki\u1ebfm trong Excel truy\u1ec1n th\u1ed1ng trong \u00f4, Excel c\u00f2n cho ph\u00e9p b\u1ea1n t\u00ecm trong gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb (Values) ho\u1eb7c n\u1ed9i dung ghi ch\u00fa, nh\u1eadn x\u00e9t (Comments\/Notes). T\u00ednh n\u0103ng n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi l\u00e0m vi\u1ec7c nh\u00f3m, gi\u00fap b\u1ea1n tra c\u1ee9u nhanh c\u00e1c ghi ch\u00fa m\u00e0 \u0111\u1ed3ng nghi\u1ec7p \u0111\u00e3 \u0111\u1ec3 l\u1ea1i ho\u1eb7c x\u00e1c \u0111\u1ecbnh d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb sau khi t\u00ednh to\u00e1n.<\/p>\n<p style=\"text-align: justify;\"><strong>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel c\u1ea7n t\u00ecm ki\u1ebfm.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong>Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3:<\/strong> Ch\u1ecdn <strong>Options<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c t\u00f9y ch\u1ecdn t\u00ecm ki\u1ebfm n\u00e2ng cao.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504722 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-18.jpg\" alt=\"T\u00ecm ki\u1ebfm theo gi\u00e1 tr\u1ecb, ghi ch\u00fa ho\u1eb7c nh\u1eadn x\u00e9t - h\u00ecnh 1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 4:<\/strong> Trong ph\u1ea7n <strong>Look in<\/strong>, ch\u1ecdn lo\u1ea1i n\u1ed9i dung b\u1ea1n mu\u1ed1n t\u00ecm:<\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<p><strong>Values:<\/strong> Excel s\u1ebd t\u00ecm theo <strong>gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb<\/strong> trong \u00f4 (sau khi t\u00ednh to\u00e1n).<br \/>\u2192 V\u00ed d\u1ee5: N\u1ebfu \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c <code>=2+3<\/code> v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u201c5\u201d, khi ch\u1ecdn <strong>Values<\/strong> v\u00e0 nh\u1eadp \u201c5\u201d, Excel s\u1ebd t\u00ecm th\u1ea5y \u00f4 n\u00e0y.<\/p>\n<\/li>\n<li>\n<p><strong>Comments (ho\u1eb7c Notes):<\/strong> Excel s\u1ebd t\u00ecm trong <strong>n\u1ed9i dung ghi ch\u00fa<\/strong> ho\u1eb7c <strong>nh\u1eadn x\u00e9t<\/strong> m\u00e0 ng\u01b0\u1eddi d\u00f9ng \u0111\u00e3 th\u00eam v\u00e0o \u00f4.<br \/>\u2192 V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp \u201cki\u1ec3m tra l\u1ea1i\u201d \u0111\u1ec3 t\u00ecm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f3 ghi ch\u00fa ch\u1ee9a c\u1ee5m t\u1eeb n\u00e0y.<\/p>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504723 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-19.jpg\" alt=\"T\u00ecm ki\u1ebfm theo gi\u00e1 tr\u1ecb, ghi ch\u00fa ho\u1eb7c nh\u1eadn x\u00e9t - h\u00ecnh 2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 5:<\/strong> Nh\u1ea5n <strong>Find All<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb to\u00e0n b\u1ed9 k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p v\u1edbi lo\u1ea1i n\u1ed9i dung \u0111\u00e3 ch\u1ecdn.<\/p>\n<p style=\"text-align: justify;\"><strong>M\u1eb9o nh\u1ecf: <\/strong>Khi l\u00e0m vi\u1ec7c v\u1edbi file chia s\u1ebb nh\u00f3m, h\u00e3y th\u01b0\u1eddng xuy\u00ean d\u00f9ng <strong>Look in \u2192 Comments\/Notes<\/strong> \u0111\u1ec3 t\u1ed5ng h\u1ee3p ph\u1ea3n h\u1ed3i ho\u1eb7c x\u00e1c nh\u1eadn c\u00e1c m\u1ee5c c\u1ea7n ch\u1ec9nh s\u1eeda. K\u1ebft h\u1ee3p<strong> Look in \u2192 Values<\/strong> v\u1edbi <strong>Look in \u2192 Formulas<\/strong> s\u1ebd gi\u00fap b\u1ea1n so s\u00e1nh nhanh gi\u1eefa k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb v\u00e0 c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n.<\/p>\n<h2 style=\"text-align: justify;\"><strong>H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch thay th\u1ebf d\u1eef li\u1ec7u trong Excel<\/strong><\/h2>\n<p style=\"text-align: justify;\">Sau khi t\u00ecm ki\u1ebfm trong Excel, b\u1ea1n c\u00f3 th\u1ec3 thay th\u1ebf h\u00e0ng lo\u1ea1t m\u00e0 kh\u00f4ng c\u1ea7n thao t\u00e1c th\u1ee7 c\u00f4ng t\u1eebng \u00f4. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 4 c\u00e1ch thay th\u1ebf d\u1eef li\u1ec7u trong Excel hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\n<h3 style=\"text-align: justify;\"><strong>S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Replace c\u01a1 b\u1ea3n (Ctrl + H)<\/strong><\/h3>\n<p style=\"text-align: justify;\">\u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 quen thu\u1ed9c v\u00e0 nhanh nh\u1ea5t \u0111\u1ec3 thay th\u1ebf d\u1eef li\u1ec7u trong Excel, ph\u00f9 h\u1ee3p khi b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda to\u00e0n b\u1ed9 ho\u1eb7c t\u1eebng ph\u1ea7n n\u1ed9i dung.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5n <strong>Ctrl + H<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> T\u1ea1i \u00f4 <strong>Find what<\/strong>, nh\u1eadp n\u1ed9i dung c\u1ea7n t\u00ecm.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3:<\/strong> \u1ede \u00f4 <strong>Replace with<\/strong>, nh\u1eadp n\u1ed9i dung mu\u1ed1n thay th\u1ebf.<\/p>\n<p style=\"text-align: justify;\">\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504724 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-20.jpg\" alt=\"S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Replace c\u01a1 b\u1ea3n - h\u00ecnh 1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-20-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 4: <\/strong>Nh\u1ea5n <strong>Replace All<\/strong> n\u1ebfu mu\u1ed1n thay th\u1ebf <strong>to\u00e0n b\u1ed9<\/strong> n\u1ed9i dung trong b\u1ea3ng. Ho\u1eb7c ch\u1ecdn <strong>Replace<\/strong> n\u1ebfu ch\u1ec9 mu\u1ed1n thay <strong>t\u1eebng \u00f4 m\u1ed9t<\/strong> v\u00e0 ki\u1ec3m tra tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504725 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-21.jpg\" alt=\"S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Replace c\u01a1 b\u1ea3n - h\u00ecnh 2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-21.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-21-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-21-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>L\u01b0u \u00fd:<\/strong> N\u1ebfu b\u1ea1n kh\u00f4ng ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u tr\u01b0\u1edbc, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng thay th\u1ebf tr\u00ean to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh. H\u00e3y gi\u1edbi h\u1ea1n ph\u1ea1m vi n\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n thay m\u1ed9t v\u00f9ng nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<h3 style=\"text-align: justify;\"><strong>Thay th\u1ebf c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00f4ng c\u1ee5 Filter<\/strong><\/h3>\n<p style=\"text-align: justify;\">Khi b\u1ea1n ch\u1ec9 mu\u1ed1n thay th\u1ebf trong m\u1ed9t nh\u00f3m d\u1eef li\u1ec7u nh\u1ea5t \u0111\u1ecbnh (v\u00ed d\u1ee5: c\u00e1c \u00f4 ch\u1ee9a n\u0103m 2024, ho\u1eb7c khu v\u1ef1c \u201cH\u00e0 N\u1ed9i\u201d), h\u00e3y s\u1eed d\u1ee5ng AutoFilter \u0111\u1ec3 l\u1ecdc tr\u01b0\u1edbc.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n x\u1eed l\u00fd.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> V\u00e0o <strong>Data \u2192 Filter<\/strong> \u0111\u1ec3 b\u1eadt b\u1ed9 l\u1ecdc.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504726 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-22.jpg\" alt=\"Thay th\u1ebf c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00f4ng c\u1ee5 Filter - h\u00ecnh 1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-22.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-22-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-22-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3:<\/strong> L\u1ecdc ra <strong>nh\u1eefng \u00f4 ph\u00f9 h\u1ee3p v\u1edbi \u0111i\u1ec1u ki\u1ec7n<\/strong> b\u1ea1n mu\u1ed1n thay th\u1ebf (v\u00ed d\u1ee5: ch\u1ec9 hi\u1ec3n th\u1ecb \u201cH\u00e0 N\u1ed9i\u201d).<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504727 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-23.jpg\" alt=\"Thay th\u1ebf c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00f4ng c\u1ee5 Filter - h\u00ecnh 2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-23.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-23-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-23-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n <strong>Ctrl + H<\/strong>, nh\u1eadp n\u1ed9i dung c\u1ea7n t\u00ecm v\u00e0 thay th\u1ebf nh\u01b0 h\u01b0\u1edbng d\u1eabn \u1edf tr\u00ean.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504728 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-24.jpg\" alt=\"Thay th\u1ebf c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00f4ng c\u1ee5 Filter - h\u00ecnh 3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-24.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-24-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-24-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 5:<\/strong> Ch\u1ecdn <strong>Replace All<\/strong> \u0111\u1ec3 \u00e1p d\u1ee5ng thay th\u1ebf <strong>ch\u1ec9 trong c\u00e1c \u00f4 \u0111\u00e3 l\u1ecdc hi\u1ec3n th\u1ecb<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>M\u1eb9o nh\u1ecf:<\/strong> C\u00e1ch n\u00e0y gi\u00fap b\u1ea1n <strong>thay \u0111\u1ed5i d\u1eef li\u1ec7u ch\u00ednh x\u00e1c<\/strong> trong ph\u1ea1m vi mong mu\u1ed1n, <strong>tr\u00e1nh \u1ea3nh h\u01b0\u1edfng to\u00e0n b\u1ea3ng<\/strong>.<\/p>\n<h3 style=\"text-align: justify;\"><strong>Thay th\u1ebf b\u1eb1ng h\u00e0m Excel (SUBSTITUTE ho\u1eb7c REPLACE)<\/strong><\/h3>\n<p style=\"text-align: justify;\">Ngo\u00e0i t\u00ecm ki\u1ebfm trong Excel, Excel c\u0169ng h\u1ed7 tr\u1ee3 h\u00e0m t\u1ef1 \u0111\u1ed9ng thay th\u1ebf n\u1ed9i dung trong \u00f4, gi\u00fap x\u1eed l\u00fd d\u1eef li\u1ec7u linh ho\u1ea1t h\u01a1n, \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn ho\u1eb7c c\u1ea7n thay \u0111\u1ed5i \u0111\u1ecbnh k\u1ef3.<\/p>\n<p style=\"text-align: justify;\"><strong>H\u00e0m SUBSTITUTE<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<p><strong>C\u00fa ph\u00e1p: <\/strong><code class=\"whitespace-pre!\" style=\"font-size: 16px;\">=<span class=\"hljs-built_in\">SUBSTITUTE<\/span>(text, old_text, new_text, [instance_num])<\/code><\/p>\n<\/li>\n<li>\n<p><strong>C\u00f4ng d\u1ee5ng:<\/strong> Thay th\u1ebf <strong>chu\u1ed7i con c\u1ee5 th\u1ec3<\/strong> trong v\u0103n b\u1ea3n.<\/p>\n<\/li>\n<li>\n<p><strong>V\u00ed d\u1ee5: <\/strong><code class=\"whitespace-pre!\" style=\"font-size: 16px;\">=<span class=\"hljs-built_in\">SUBSTITUTE<\/span>(A1, <span class=\"hljs-string\">\"H\u00e0 N\u1ed9i\"<\/span>, <span class=\"hljs-string\">\"HCMC\"<\/span>)<\/code>\u2192 Thay \u201cH\u00e0 N\u1ed9i\u201d trong \u00f4 A1 th\u00e0nh \u201cHCMC\u201d.<\/p>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504729 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-25.jpg\" alt=\"Thay th\u1ebf b\u1eb1ng h\u00e0m Excel\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-25.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-25-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-25-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>H\u00e0m REPLACE<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<p><strong>C\u00fa ph\u00e1p: <\/strong><code class=\"whitespace-pre!\" style=\"font-size: 16px;\">=REPLACE(old_text, start_num, num_chars, new_text)<\/code><\/p>\n<\/li>\n<li>\n<p><strong>C\u00f4ng d\u1ee5ng:<\/strong> Thay th\u1ebf <strong>m\u1ed9t ph\u1ea7n v\u0103n b\u1ea3n d\u1ef1a theo v\u1ecb tr\u00ed k\u00fd t\u1ef1<\/strong>.<\/p>\n<\/li>\n<li>\n<p><strong>V\u00ed d\u1ee5: <\/strong><code class=\"whitespace-pre!\" style=\"font-size: 16px;\">=REPLACE(A1, <span class=\"hljs-number\">1<\/span>, <span class=\"hljs-number\">3<\/span>, \"ABC\")<\/code>\u2192 Thay 3 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong \u00f4 A1 b\u1eb1ng \u201cABC\u201d.<\/p>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>\u1ee8ng d\u1ee5ng:<\/strong> Hai h\u00e0m n\u00e0y c\u1ef1c k\u1ef3 h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n <strong>t\u1ef1 \u0111\u1ed9ng h\u00f3a vi\u1ec7c thay th\u1ebf<\/strong> ho\u1eb7c <strong>x\u1eed l\u00fd h\u00e0ng lo\u1ea1t d\u1eef li\u1ec7u<\/strong> m\u00e0 kh\u00f4ng c\u1ea7n thao t\u00e1c th\u1ee7 c\u00f4ng.<\/p>\n<h3 style=\"text-align: justify;\"><strong>Thay th\u1ebf \u0111\u1ecbnh d\u1ea1ng (Format Replace)<\/strong><\/h3>\n<p style=\"text-align: justify;\">Kh\u00f4ng ch\u1ec9 t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay n\u1ed9i dung, Excel c\u00f2n cho ph\u00e9p thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng \u00f4 h\u00e0ng lo\u1ea1t, nh\u01b0 m\u00e0u n\u1ec1n, ki\u1ec3u ch\u1eef, c\u0103n l\u1ec1 ho\u1eb7c vi\u1ec1n \u2014 r\u1ea5t ti\u1ec7n trong vi\u1ec7c chu\u1ea9n h\u00f3a b\u1ea3ng bi\u1ec3u.<\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5n <strong>Ctrl + H<\/strong> \u0111\u1ec3 m\u1edf <strong>Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504730 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-26.jpg\" alt=\"Thay th\u1ebf \u0111\u1ecbnh d\u1ea1ng - h\u00ecnh 1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-26.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-26-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-26-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn <strong>Options \u2192 Format&#8230;<\/strong> trong ph\u1ea7n <strong>Find what<\/strong> \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh <strong>\u0111\u1ecbnh d\u1ea1ng c\u1ea7n t\u00ecm<\/strong> (v\u00ed d\u1ee5: ch\u1eef m\u00e0u \u0111\u1ecf).<\/p>\n<p style=\"text-align: justify;\">\u00a0\u00a0\u00a0 \u00a0<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504731 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-27.jpg\" alt=\"Thay th\u1ebf \u0111\u1ecbnh d\u1ea1ng - h\u00ecnh 2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-27.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-27-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-27-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 3:<\/strong> Ti\u1ebfp t\u1ee5c ch\u1ecdn <strong>Format&#8230;<\/strong> trong ph\u1ea7n <strong>Replace with<\/strong> \u0111\u1ec3 ch\u1ecdn <strong>\u0111\u1ecbnh d\u1ea1ng m\u1edbi<\/strong> (v\u00ed d\u1ee5: n\u1ec1n v\u00e0ng, ch\u1eef \u0111\u1eadm).<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504732 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-28.jpg\" alt=\"Thay th\u1ebf \u0111\u1ecbnh d\u1ea1ng - h\u00ecnh 3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-28.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-28-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-28-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504733 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-29.jpg\" alt=\"Thay th\u1ebf \u0111\u1ecbnh d\u1ea1ng - h\u00ecnh 4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-29.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-29-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-29-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504734 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-30.jpg\" alt=\"Thay th\u1ebf \u0111\u1ecbnh d\u1ea1ng - h\u00ecnh 5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-30.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-30-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-30-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n <strong>Replace All<\/strong> \u0111\u1ec3 \u00e1p d\u1ee5ng thay \u0111\u1ed5i h\u00e0ng lo\u1ea1t.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504735 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-31.jpg\" alt=\"Thay th\u1ebf \u0111\u1ecbnh d\u1ea1ng - h\u00ecnh 6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-31.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-31-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-31-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>V\u00ed d\u1ee5:<\/strong> B\u1ea1n c\u00f3 th\u1ec3 <strong>\u0111\u1ed5i t\u1ea5t c\u1ea3 \u00f4 c\u00f3 ch\u1eef m\u00e0u \u0111\u1ecf sang n\u1ec1n v\u00e0ng<\/strong>, gi\u00fap c\u00e1c d\u1eef li\u1ec7u quan tr\u1ecdng tr\u1edf n\u00ean n\u1ed5i b\u1eadt v\u00e0 d\u1ec5 nh\u1eadn bi\u1ebft h\u01a1n.<\/p>\n<h2 style=\"text-align: justify;\"><strong>L\u01b0u \u00fd khi t\u00ecm ki\u1ebfm, thay th\u1ebf trong Excel<\/strong><\/h2>\n<p style=\"text-align: justify;\">D\u00f9 c\u00e1c thao t\u00e1c n\u00e0y kh\u00e1 \u0111\u01a1n gi\u1ea3n, b\u1ea1n v\u1eabn n\u00ean l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec3m quan tr\u1ecdng \u0111\u1ec3 tr\u00e1nh sai s\u00f3t khi l\u00e0m vi\u1ec7c v\u1edbi file d\u1eef li\u1ec7u l\u1edbn:<\/p>\n<ul style=\"text-align: justify;\">\n<li>\n<p><strong>Sao l\u01b0u file tr\u01b0\u1edbc khi thay th\u1ebf h\u00e0ng lo\u1ea1t: <\/strong>Tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p thay nh\u1ea7m d\u1eef li\u1ec7u kh\u00f4ng th\u1ec3 ho\u00e0n t\u00e1c.<\/p>\n<\/li>\n<li>\n<p><strong>Ki\u1ec3m tra ph\u1ea1m vi thay th\u1ebf: <\/strong>N\u1ebfu b\u1ea1n ch\u1ec9 c\u1ea7n thay v\u00e0 t\u00ecm ki\u1ebfm trong Excel trong m\u1ed9t v\u00f9ng, h\u00e3y <strong>ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u<\/strong> tr\u01b0\u1edbc khi d\u00f9ng Ctrl + H.<\/p>\n<\/li>\n<li>\n<p><strong>Ph\u00e2n bi\u1ec7t k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t: <\/strong>D\u1ea5u c\u00e1ch, d\u1ea5u ph\u1ea9y ho\u1eb7c k\u00fd t\u1ef1 \u1ea9n c\u00f3 th\u1ec3 khi\u1ebfn t\u00ecm ki\u1ebfm sai l\u1ec7ch. H\u00e3y d\u00f9ng <strong>TRIM ho\u1eb7c CLEAN<\/strong> \u0111\u1ec3 l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u tr\u01b0\u1edbc.<\/p>\n<\/li>\n<li>\n<p><strong>T\u1eaft ch\u1ebf \u0111\u1ed9 Filter khi kh\u00f4ng c\u1ea7n: <\/strong>N\u1ebfu b\u1eadt l\u1ecdc m\u00e0 thay to\u00e0n b\u1ea3ng, Excel ch\u1ec9 thay trong v\u00f9ng \u0111ang hi\u1ec3n th\u1ecb \u2192 d\u1ec5 b\u1ecf s\u00f3t d\u1eef li\u1ec7u \u1ea9n.<\/p>\n<\/li>\n<li>\n<p><strong>D\u00f9ng t\u00f9y ch\u1ecdn n\u00e2ng cao khi c\u1ea7n t\u00ecm ch\u00ednh x\u00e1c: <\/strong>T\u1eadn d\u1ee5ng c\u00e1c t\u00f9y ch\u1ecdn nh\u01b0 <em>Match case<\/em> ho\u1eb7c <em>Match entire cell contents<\/em> \u0111\u1ec3 tr\u00e1nh nh\u1ea7m l\u1eabn.<\/p>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504736 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-32.jpg\" alt=\"L\u01b0u \u00fd khi t\u00ecm ki\u1ebfm, thay th\u1ebf trong Excel\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-32.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-32-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-32-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><strong>K\u1ebft lu\u1eadn<\/strong><\/h2>\n<p style=\"text-align: justify;\">N\u1eafm v\u1eefng c\u00e1c thao t\u00e1c <strong>t\u00ecm ki\u1ebfm trong Excel<\/strong> v\u00e0 <strong>thay th\u1ebf d\u1eef li\u1ec7u b\u1eb1ng Find &amp; Replace<\/strong> kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c nhanh h\u01a1n m\u00e0 c\u00f2n n\u00e2ng cao \u0111\u1ed9 ch\u00ednh x\u00e1c khi x\u1eed l\u00fd b\u1ea3ng t\u00ednh ph\u1ee9c t\u1ea1p. T\u1eeb t\u00ecm ki\u1ebfm nhanh b\u1eb1ng <strong>Ctrl + F<\/strong>, \u0111\u1ebfn <strong>t\u00ecm theo \u0111\u1ecbnh d\u1ea1ng, c\u00f4ng th\u1ee9c, ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n<\/strong>, t\u1ea5t c\u1ea3 \u0111\u1ec1u c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u1ed1i \u01b0u h\u00f3a hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c h\u00e0ng ng\u00e0y. H\u00e3y th\u1ef1c h\u00e0nh th\u01b0\u1eddng xuy\u00ean v\u00e0 ghi nh\u1edb c\u00e1c ph\u00edm t\u1eaft \u0111\u1ec3 tr\u1edf th\u00e0nh \u201ccao th\u1ee7 Excel\u201d trong m\u00f4i tr\u01b0\u1eddng v\u0103n ph\u00f2ng! Hy v\u1ecdng n\u1ed9i dung m\u00e0 Ho\u00e0ng H\u00e0 Mobile chia s\u1ebb h\u00f4m nay \u0111\u00e3 mang l\u1ea1i nhi\u1ec1u m\u1eb9o hay v\u0103n ph\u00f2ng h\u1eefu \u00edch cho b\u1ea1n \u0111\u1ecdc.<\/p>\n<p style=\"text-align: justify;\"><em><strong>XEM TH\u00caM:<\/strong><\/em><\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/dinh-dang-so-trong-excel-2\/\">C\u00e1c lo\u1ea1i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel v\u00e0 c\u00e1ch thi\u1ebft l\u1eadp nhanh ch\u00f3ng<\/a><\/strong><\/li>\n<li style=\"text-align: justify;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-tu-nhay-trong-excel\/\">7 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 nh\u1ea3y trong Excel ch\u00ednh x\u00e1c, nhanh ch\u00f3ng<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Trong c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi x\u1eed l\u00fd d\u1eef li\u1ec7u l\u1edbn, t\u00ecm ki\u1ebfm trong Excel l\u00e0 thao t\u00e1c v\u00f4 c\u00f9ng quan tr\u1ecdng gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 tr\u00e1nh sai s\u00f3t. Kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed \u00f4, d\u00f2ng ho\u1eb7c c\u1ed9t ch\u1ee9a th\u00f4ng tin c\u1ea7n t\u00ecm, Excel c\u00f2n [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":504737,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"t\u00ecm ki\u1ebfm trong excel","_yoast_wpseo_title":"7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace","_yoast_wpseo_metadesc":"H\u01b0\u1edbng d\u1eabn 7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel b\u1eb1ng Find v\u00e0 Replace chi ti\u1ebft, gi\u00fap b\u1ea1n tra c\u1ee9u, thay th\u1ebf d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 tr\u00e1nh sai s\u00f3t.","footnotes":""},"categories":[28955,412],"tags":[],"class_list":["post-501923","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace<\/title>\n<meta name=\"description\" content=\"H\u01b0\u1edbng d\u1eabn 7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel b\u1eb1ng Find v\u00e0 Replace chi ti\u1ebft, gi\u00fap b\u1ea1n tra c\u1ee9u, thay th\u1ebf d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 tr\u00e1nh sai s\u00f3t.\" \/>\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\/tim-kiem-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace\" \/>\n<meta property=\"og:description\" content=\"H\u01b0\u1edbng d\u1eabn 7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel b\u1eb1ng Find v\u00e0 Replace chi ti\u1ebft, gi\u00fap b\u1ea1n tra c\u1ee9u, thay th\u1ebf d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 tr\u00e1nh sai s\u00f3t.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-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=\"2025-11-08T13:48:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-25T05:11:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-33.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vo Lan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vo Lan\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"23 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\\\/tim-kiem-trong-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/tim-kiem-trong-excel\\\/\"},\"author\":{\"name\":\"Vo Lan\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/person\\\/5e5f9c50d12a911fcf1b1d6a958b4d76\"},\"headline\":\"7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace\",\"datePublished\":\"2025-11-08T13:48:59+00:00\",\"dateModified\":\"2026-08-25T05:11:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/tim-kiem-trong-excel\\\/\"},\"wordCount\":4301,\"publisher\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/tim-kiem-trong-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/tim-kiem-trong-excel-33.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/tim-kiem-trong-excel\\\/\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/tim-kiem-trong-excel\\\/\",\"name\":\"7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/tim-kiem-trong-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/tim-kiem-trong-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/tim-kiem-trong-excel-33.jpg\",\"datePublished\":\"2025-11-08T13:48:59+00:00\",\"dateModified\":\"2026-08-25T05:11:43+00:00\",\"description\":\"H\u01b0\u1edbng d\u1eabn 7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel b\u1eb1ng Find v\u00e0 Replace chi ti\u1ebft, gi\u00fap b\u1ea1n tra c\u1ee9u, thay th\u1ebf d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 tr\u00e1nh sai s\u00f3t.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/tim-kiem-trong-excel\\\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/tim-kiem-trong-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/tim-kiem-trong-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/tim-kiem-trong-excel-33.jpg\",\"contentUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/tim-kiem-trong-excel-33.jpg\",\"width\":1200,\"height\":628,\"caption\":\"H\u1ed9p tho\u1ea1i t\u00ecm v\u00e0 thay th\u1ebf trong Excel v\u1edbi t\u00f9y ch\u1ecdn ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng t\u1eeb \u00f4\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/tim-kiem-trong-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace\"}]},{\"@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\\\/5e5f9c50d12a911fcf1b1d6a958b4d76\",\"name\":\"Vo Lan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/685efa863095aec320cd34d1428d3b0d65778da4ae35f5473be4defd545cb934?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/685efa863095aec320cd34d1428d3b0d65778da4ae35f5473be4defd545cb934?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/685efa863095aec320cd34d1428d3b0d65778da4ae35f5473be4defd545cb934?s=96&d=mm&r=g\",\"caption\":\"Vo Lan\"},\"description\":\"Vo Lan l\u00e0 t\u00e1c gi\u1ea3 n\u1ed9i dung tr\u00ean chuy\u00ean trang Tin t\u1ee9c c\u00f4ng ngh\u1ec7 c\u1ee7a Ho\u00e0ng H\u00e0 Mobile. C\u00e1c b\u00e0i vi\u1ebft t\u1eadp trung v\u00e0o laptop, m\u00e1y t\u00ednh v\u00e0 th\u1ee7 thu\u1eadt s\u1eed d\u1ee5ng thi\u1ebft b\u1ecb, cung c\u1ea5p th\u00f4ng tin t\u1ed5ng h\u1ee3p v\u00e0 h\u01b0\u1edbng d\u1eabn theo t\u1eebng nhu c\u1ea7u.\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/author\\\/vo-lan\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace","description":"H\u01b0\u1edbng d\u1eabn 7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel b\u1eb1ng Find v\u00e0 Replace chi ti\u1ebft, gi\u00fap b\u1ea1n tra c\u1ee9u, thay th\u1ebf d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 tr\u00e1nh sai s\u00f3t.","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\/tim-kiem-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace","og_description":"H\u01b0\u1edbng d\u1eabn 7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel b\u1eb1ng Find v\u00e0 Replace chi ti\u1ebft, gi\u00fap b\u1ea1n tra c\u1ee9u, thay th\u1ebf d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 tr\u00e1nh sai s\u00f3t.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-11-08T13:48:59+00:00","article_modified_time":"2026-08-25T05:11:43+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-33.jpg","type":"image\/jpeg"}],"author":"Vo Lan","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Vo Lan","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"23 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/"},"author":{"name":"Vo Lan","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/5e5f9c50d12a911fcf1b1d6a958b4d76"},"headline":"7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace","datePublished":"2025-11-08T13:48:59+00:00","dateModified":"2026-08-25T05:11:43+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/"},"wordCount":4301,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-33.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/","name":"7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-33.jpg","datePublished":"2025-11-08T13:48:59+00:00","dateModified":"2026-08-25T05:11:43+00:00","description":"H\u01b0\u1edbng d\u1eabn 7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel b\u1eb1ng Find v\u00e0 Replace chi ti\u1ebft, gi\u00fap b\u1ea1n tra c\u1ee9u, thay th\u1ebf d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 tr\u00e1nh sai s\u00f3t.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-33.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-33.jpg","width":1200,"height":628,"caption":"H\u1ed9p tho\u1ea1i t\u00ecm v\u00e0 thay th\u1ebf trong Excel v\u1edbi t\u00f9y ch\u1ecdn ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng t\u1eeb \u00f4"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace"}]},{"@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\/5e5f9c50d12a911fcf1b1d6a958b4d76","name":"Vo Lan","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/secure.gravatar.com\/avatar\/685efa863095aec320cd34d1428d3b0d65778da4ae35f5473be4defd545cb934?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/685efa863095aec320cd34d1428d3b0d65778da4ae35f5473be4defd545cb934?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/685efa863095aec320cd34d1428d3b0d65778da4ae35f5473be4defd545cb934?s=96&d=mm&r=g","caption":"Vo Lan"},"description":"Vo Lan l\u00e0 t\u00e1c gi\u1ea3 n\u1ed9i dung tr\u00ean chuy\u00ean trang Tin t\u1ee9c c\u00f4ng ngh\u1ec7 c\u1ee7a Ho\u00e0ng H\u00e0 Mobile. C\u00e1c b\u00e0i vi\u1ebft t\u1eadp trung v\u00e0o laptop, m\u00e1y t\u00ednh v\u00e0 th\u1ee7 thu\u1eadt s\u1eed d\u1ee5ng thi\u1ebft b\u1ecb, cung c\u1ea5p th\u00f4ng tin t\u1ed5ng h\u1ee3p v\u00e0 h\u01b0\u1edbng d\u1eabn theo t\u1eebng nhu c\u1ea7u.","url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/501923","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=501923"}],"version-history":[{"count":1,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/501923\/revisions"}],"predecessor-version":[{"id":588221,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/501923\/revisions\/588221"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/504737"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=501923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=501923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=501923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}