{"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":"2025-11-08T20:48:59","modified_gmt":"2025-11-08T13:48:59","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;\" data-start=\"189\" data-end=\"649\">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 data-start=\"251\" data-end=\"275\">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;\" data-start=\"656\" data-end=\"712\"><strong data-start=\"659\" data-end=\"712\">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;\" data-start=\"714\" data-end=\"890\">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;\" data-start=\"937\" data-end=\"1459\">\n<li data-start=\"937\" data-end=\"1023\">\n<p data-start=\"939\" data-end=\"1023\"><strong data-start=\"939\" data-end=\"963\">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 data-start=\"1024\" data-end=\"1107\">\n<p data-start=\"1026\" data-end=\"1107\"><strong data-start=\"1026\" data-end=\"1043\">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 data-start=\"1108\" data-end=\"1226\">\n<p data-start=\"1110\" data-end=\"1226\"><strong data-start=\"1110\" data-end=\"1141\">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 data-start=\"1227\" data-end=\"1323\">\n<p data-start=\"1229\" data-end=\"1323\"><strong data-start=\"1229\" data-end=\"1261\">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 data-start=\"1324\" data-end=\"1459\">\n<p data-start=\"1326\" data-end=\"1459\"><strong data-start=\"1326\" data-end=\"1348\">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;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-504705 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-1.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-1\" 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\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\" data-start=\"1466\" data-end=\"1517\"><strong data-start=\"1469\" data-end=\"1517\">H\u01b0\u1edbng d\u1eabn 7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel (Find)<\/strong><\/h2>\n<p style=\"text-align: justify;\" data-start=\"1519\" data-end=\"1691\">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;\" data-start=\"1698\" data-end=\"1746\"><strong data-start=\"1702\" data-end=\"1746\">T\u00ecm ki\u1ebfm nhanh b\u1eb1ng ph\u00edm t\u1eaft Ctrl + F<\/strong><\/h3>\n<p style=\"text-align: justify;\" data-start=\"223\" data-end=\"399\">\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;\" data-start=\"401\" data-end=\"429\"><strong data-start=\"406\" data-end=\"429\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n<p style=\"text-align: justify;\" data-start=\"431\" data-end=\"1095\"><strong data-start=\"431\" data-end=\"442\">B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel b\u1ea1n c\u1ea7n t\u00ecm ki\u1ebfm.<\/p>\n<p style=\"text-align: justify;\" data-start=\"431\" data-end=\"1095\"><strong data-start=\"477\" data-end=\"488\">B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <strong data-start=\"506\" data-end=\"518\">Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong data-start=\"535\" data-end=\"555\">Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"431\" data-end=\"1095\"><strong data-start=\"559\" data-end=\"570\">B\u01b0\u1edbc 3:<\/strong> Trong \u00f4 <strong data-start=\"579\" data-end=\"592\">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;\" data-start=\"431\" data-end=\"1095\">\u00a0<picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-504707 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-3.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-3\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"431\" data-end=\"1095\"><strong data-start=\"691\" data-end=\"702\">B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n <strong data-start=\"708\" data-end=\"721\">Find Next<\/strong> \u0111\u1ec3 Excel t\u1ef1 \u0111\u1ed9ng di chuy\u1ec3n \u0111\u1ebfn <strong data-start=\"753\" data-end=\"780\">\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;\" data-start=\"431\" data-end=\"1095\"><strong data-start=\"817\" data-end=\"828\">B\u01b0\u1edbc 5:<\/strong> Ti\u1ebfp t\u1ee5c nh\u1ea5n <strong data-start=\"843\" data-end=\"856\">Find Next<\/strong> \u0111\u1ec3 chuy\u1ec3n \u0111\u1ebfn <strong data-start=\"871\" data-end=\"892\">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;\" data-start=\"431\" data-end=\"1095\"><strong data-start=\"928\" data-end=\"939\">B\u01b0\u1edbc 6:<\/strong> N\u1ebfu mu\u1ed1n xem <strong data-start=\"953\" data-end=\"981\">to\u00e0n b\u1ed9 k\u1ebft qu\u1ea3 c\u00f9ng l\u00fac<\/strong>, ch\u1ecdn <strong data-start=\"988\" data-end=\"1000\">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;\" data-start=\"1097\" data-end=\"1258\"><strong data-start=\"1100\" data-end=\"1112\">M\u1eb9o nh\u1ecf:<\/strong> B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p th\u00eam ph\u00edm <strong data-start=\"1142\" data-end=\"1154\">Ctrl + H<\/strong> \u0111\u1ec3 m\u1edf ngay tab <strong data-start=\"1170\" data-end=\"1181\">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;\" data-start=\"2249\" data-end=\"2294\"><strong data-start=\"2253\" data-end=\"2294\">T\u00ecm ki\u1ebfm trong v\u00f9ng d\u1eef li\u1ec7u c\u1ee5 th\u1ec3<\/strong><\/h3>\n<p style=\"text-align: justify;\" data-start=\"229\" data-end=\"465\">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;\" data-start=\"467\" data-end=\"495\"><strong data-start=\"472\" data-end=\"495\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n<p style=\"text-align: justify;\" data-start=\"497\" data-end=\"1052\"><strong data-start=\"497\" data-end=\"508\">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;\" data-start=\"497\" data-end=\"1052\"><strong data-start=\"547\" data-end=\"558\">B\u01b0\u1edbc 2:<\/strong> <strong data-start=\"559\" data-end=\"583\">B\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u<\/strong> mu\u1ed1n t\u00ecm ki\u1ebfm, v\u00ed d\u1ee5 nh\u01b0 <strong data-start=\"609\" data-end=\"618\">c\u1ed9t A<\/strong>, <strong data-start=\"620\" data-end=\"636\">v\u00f9ng B2:B100<\/strong>, ho\u1eb7c m\u1ed9t <strong data-start=\"647\" data-end=\"666\">b\u1ea3ng con c\u1ee5 th\u1ec3<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"497\" data-end=\"1052\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-504708 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-4.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-4\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"497\" data-end=\"1052\"><strong data-start=\"670\" data-end=\"681\" data-is-only-node=\"\">B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <strong data-start=\"699\" data-end=\"711\">Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong data-start=\"728\" data-end=\"748\">Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"497\" data-end=\"1052\"><strong data-start=\"752\" data-end=\"763\">B\u01b0\u1edbc 4:<\/strong> Trong \u00f4 <strong data-start=\"772\" data-end=\"785\">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;\" data-start=\"497\" data-end=\"1052\"><strong data-start=\"830\" data-end=\"841\">B\u01b0\u1edbc 5:<\/strong> Ch\u1ecdn <strong data-start=\"847\" data-end=\"859\">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 data-start=\"906\" data-end=\"926\">ph\u1ea1m vi v\u1eeba ch\u1ecdn<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"497\" data-end=\"1052\"><strong data-start=\"930\" data-end=\"941\">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 data-start=\"1006\" data-end=\"1051\">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;\" data-start=\"1054\" data-end=\"1245\"><strong data-start=\"1057\" data-end=\"1069\">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 data-start=\"1175\" data-end=\"1212\">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;\" data-start=\"2641\" data-end=\"2684\"><strong data-start=\"2645\" data-end=\"2684\">T\u00ecm ki\u1ebfm theo \u0111\u1ecbnh d\u1ea1ng (Format)<\/strong><\/h3>\n<p style=\"text-align: justify;\" data-start=\"205\" data-end=\"497\">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;\" data-start=\"499\" data-end=\"527\"><strong data-start=\"504\" data-end=\"527\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n<p style=\"text-align: justify;\" data-start=\"529\" data-end=\"873\"><strong data-start=\"529\" data-end=\"540\">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;\" data-start=\"529\" data-end=\"873\"><strong data-start=\"579\" data-end=\"590\">B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong data-start=\"596\" data-end=\"608\">Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong data-start=\"625\" data-end=\"645\">Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"529\" data-end=\"873\"><strong data-start=\"649\" data-end=\"660\">B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5p v\u00e0o n\u00fat <strong data-start=\"674\" data-end=\"685\">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;\" data-start=\"529\" data-end=\"873\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504712 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-8.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-8\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"529\" data-end=\"873\"><strong data-start=\"728\" data-end=\"739\">B\u01b0\u1edbc 4:<\/strong> Ch\u1ecdn <strong data-start=\"745\" data-end=\"756\" data-is-only-node=\"\">Format\u2026<\/strong> (b\u00ean ph\u1ea3i \u00f4 \u201cFind what\u201d).<\/p>\n<p style=\"text-align: justify;\" data-start=\"529\" data-end=\"873\"><strong data-start=\"785\" data-end=\"796\">B\u01b0\u1edbc 5:<\/strong> Trong c\u1eeda s\u1ed5 <strong data-start=\"810\" data-end=\"825\">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;\" data-start=\"874\" data-end=\"1184\">\n<li data-start=\"874\" data-end=\"918\">\n<p data-start=\"876\" data-end=\"918\"><strong data-start=\"876\" data-end=\"885\">Font:<\/strong> ki\u1ec3u ch\u1eef, k\u00edch th\u01b0\u1edbc, m\u00e0u s\u1eafc.<\/p>\n<\/li>\n<li data-start=\"919\" data-end=\"947\">\n<p data-start=\"921\" data-end=\"947\"><strong data-start=\"921\" data-end=\"930\">Fill:<\/strong> m\u00e0u n\u1ec1n c\u1ee7a \u00f4.<\/p>\n<\/li>\n<li data-start=\"948\" data-end=\"982\">\n<p data-start=\"950\" data-end=\"982\"><strong data-start=\"950\" data-end=\"961\">Border:<\/strong> ki\u1ec3u vi\u1ec1n, \u0111\u1ed9 d\u00e0y.<\/p>\n<\/li>\n<li data-start=\"948\" data-end=\"982\">\n<p data-start=\"950\" data-end=\"982\"><strong data-start=\"985\" data-end=\"999\">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;\" data-start=\"985\" data-end=\"1184\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504710 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-6.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-6\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"985\" data-end=\"1184\"><strong data-start=\"1036\" data-end=\"1047\">B\u01b0\u1edbc 6:<\/strong> Nh\u1ea5n <strong data-start=\"1053\" data-end=\"1059\">OK<\/strong> \u0111\u1ec3 x\u00e1c nh\u1eadn \u0111\u1ecbnh d\u1ea1ng c\u1ea7n t\u00ecm.<\/p>\n<p style=\"text-align: justify;\" data-start=\"985\" data-end=\"1184\"><strong data-start=\"1093\" data-end=\"1104\">B\u01b0\u1edbc 7:<\/strong> Ch\u1ecdn <strong data-start=\"1110\" data-end=\"1122\">Find All<\/strong> ho\u1eb7c <strong data-start=\"1128\" data-end=\"1141\">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;\" data-start=\"1186\" data-end=\"1360\"><strong data-start=\"1189\" data-end=\"1201\">M\u1eb9o nh\u1ecf:<\/strong> T\u1ea1i b\u01b0\u1edbc 4, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o <strong data-start=\"1234\" data-end=\"1261\">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;\" data-start=\"3120\" data-end=\"3173\"><strong data-start=\"3124\" data-end=\"3173\">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;\" data-start=\"226\" data-end=\"502\">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;\" data-start=\"504\" data-end=\"532\"><strong data-start=\"509\" data-end=\"532\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n<p style=\"text-align: justify;\" data-start=\"534\" data-end=\"1084\"><strong data-start=\"534\" data-end=\"545\">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;\" data-start=\"534\" data-end=\"1084\"><strong data-start=\"589\" data-end=\"600\">B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong data-start=\"606\" data-end=\"618\">Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong data-start=\"635\" data-end=\"655\">Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"534\" data-end=\"1084\"><strong data-start=\"659\" data-end=\"670\">B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5p v\u00e0o n\u00fat <strong data-start=\"684\" data-end=\"695\">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;\" data-start=\"534\" data-end=\"1084\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504712 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-8.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-8\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"534\" data-end=\"1084\"><strong data-start=\"737\" data-end=\"748\">B\u01b0\u1edbc 4:<\/strong> Tick ch\u1ecdn v\u00e0o \u00f4 <strong data-start=\"765\" data-end=\"779\">Match case<\/strong> (Ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng).<\/p>\n<p style=\"text-align: justify;\" data-start=\"534\" data-end=\"1084\"><strong data-start=\"817\" data-end=\"828\">B\u01b0\u1edbc 5:<\/strong> Nh\u1eadp t\u1eeb kh\u00f3a c\u1ea7n t\u00ecm v\u00e0o \u00f4 <strong data-start=\"856\" data-end=\"869\">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;\" data-start=\"534\" data-end=\"1084\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504713 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-9.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-9\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"534\" data-end=\"1084\"><strong data-start=\"958\" data-end=\"969\">B\u01b0\u1edbc 6:<\/strong> Nh\u1ea5n <strong data-start=\"975\" data-end=\"988\">Find Next<\/strong> ho\u1eb7c <strong data-start=\"994\" data-end=\"1006\">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;\" data-start=\"534\" data-end=\"1084\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504714 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-10.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-10\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"1086\" data-end=\"1287\"><strong data-start=\"1089\" data-end=\"1101\">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 data-start=\"1214\" data-end=\"1228\">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;\" data-start=\"3555\" data-end=\"3606\"><strong data-start=\"3559\" data-end=\"3606\">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;\" data-start=\"470\" data-end=\"533\"><strong data-start=\"475\" data-end=\"533\">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;\" data-start=\"535\" data-end=\"639\">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;\" data-start=\"662\" data-end=\"950\"><strong data-start=\"662\" data-end=\"673\">B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5n <strong data-start=\"679\" data-end=\"691\">Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong data-start=\"708\" data-end=\"728\">Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"662\" data-end=\"950\"><strong data-start=\"732\" data-end=\"743\">B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn <strong data-start=\"749\" data-end=\"760\">Options<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c t\u00f9y ch\u1ecdn n\u00e2ng cao.<\/p>\n<p style=\"text-align: justify;\" data-start=\"662\" data-end=\"950\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504715 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-11.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-11\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"662\" data-end=\"950\"><strong data-start=\"798\" data-end=\"809\">B\u01b0\u1edbc 3:<\/strong> Tick v\u00e0o \u00f4 <strong data-start=\"821\" data-end=\"851\">Match entire cell contents<\/strong> (Kh\u1edbp to\u00e0n b\u1ed9 n\u1ed9i dung \u00f4).<\/p>\n<p style=\"text-align: justify;\" data-start=\"662\" data-end=\"950\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504716 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-12.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-12\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"662\" data-end=\"950\"><strong data-start=\"881\" data-end=\"892\">B\u01b0\u1edbc 4:<\/strong> Nh\u1eadp t\u1eeb kh\u00f3a v\u00e0o \u00f4 <strong data-start=\"912\" data-end=\"925\">Find what<\/strong> v\u00e0 nh\u1ea5n <strong data-start=\"934\" data-end=\"947\">Find Next<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"952\" data-end=\"1102\">\u2192 <strong data-start=\"954\" data-end=\"964\">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 data-start=\"1024\" data-end=\"1049\"> \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;\" data-start=\"952\" data-end=\"1102\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504717 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-13.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-13\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"1109\" data-end=\"1179\"><strong data-start=\"1114\" data-end=\"1179\">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;\" data-start=\"1181\" data-end=\"1293\">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;\" data-start=\"1316\" data-end=\"1492\"><strong data-start=\"1316\" data-end=\"1327\">B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5n <strong data-start=\"1333\" data-end=\"1345\">Ctrl + F<\/strong> \u2192 <strong data-start=\"1348\" data-end=\"1359\">Options<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"1316\" data-end=\"1492\"><strong data-start=\"1363\" data-end=\"1374\">B\u01b0\u1edbc 2:<\/strong> <strong data-start=\"1375\" data-end=\"1386\">B\u1ecf ch\u1ecdn<\/strong> \u00f4 <strong data-start=\"1389\" data-end=\"1419\">Match entire cell contents<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"1316\" data-end=\"1492\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504718 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-14.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-14\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"1316\" data-end=\"1492\"><strong data-start=\"1423\" data-end=\"1434\">B\u01b0\u1edbc 3:<\/strong> Nh\u1eadp t\u1eeb kh\u00f3a v\u00e0 nh\u1ea5n <strong data-start=\"1456\" data-end=\"1468\">Find All<\/strong> \u0111\u1ec3 xem to\u00e0n b\u1ed9 k\u1ebft qu\u1ea3.<\/p>\n<p style=\"text-align: justify;\" data-start=\"1494\" data-end=\"1597\">\u2192 <strong data-start=\"1496\" data-end=\"1506\">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;\" data-start=\"1599\" data-end=\"1616\"><strong data-start=\"1602\" data-end=\"1614\">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;\" data-start=\"4022\" data-end=\"4067\"><strong data-start=\"4026\" data-end=\"4067\">T\u00ecm ki\u1ebfm theo c\u00f4ng th\u1ee9c (Formulas)<\/strong><\/h3>\n<p style=\"text-align: justify;\" data-start=\"225\" data-end=\"528\">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;\" data-start=\"530\" data-end=\"558\"><strong data-start=\"535\" data-end=\"558\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n<p style=\"text-align: justify;\" data-start=\"560\" data-end=\"894\"><strong data-start=\"560\" data-end=\"571\">B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel b\u1ea1n mu\u1ed1n ki\u1ec3m tra.<\/p>\n<p style=\"text-align: justify;\" data-start=\"560\" data-end=\"894\"><strong data-start=\"607\" data-end=\"618\">B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong data-start=\"624\" data-end=\"636\">Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong data-start=\"653\" data-end=\"673\">Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"560\" data-end=\"894\"><strong data-start=\"677\" data-end=\"688\">B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5p v\u00e0o <strong data-start=\"698\" data-end=\"709\">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;\" data-start=\"560\" data-end=\"894\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504719 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-15.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-15\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"560\" data-end=\"894\"><strong data-start=\"752\" data-end=\"763\">B\u01b0\u1edbc 4:<\/strong> Trong m\u1ee5c <strong data-start=\"774\" data-end=\"785\" data-is-only-node=\"\">Look in<\/strong>, ch\u1ecdn <strong data-start=\"792\" data-end=\"804\">Formulas<\/strong> (C\u00f4ng th\u1ee9c).<\/p>\n<p style=\"text-align: justify;\" data-start=\"560\" data-end=\"894\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504720 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-16.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-16\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"560\" data-end=\"894\"><strong data-start=\"820\" data-end=\"831\">B\u01b0\u1edbc 5:<\/strong> T\u1ea1i \u00f4 <strong data-start=\"838\" data-end=\"851\">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 data-start=\"895\" data-end=\"941\">\n<p data-start=\"897\" data-end=\"941\"><code data-start=\"897\" data-end=\"903\">=SUM<\/code> \u0111\u1ec3 t\u00ecm c\u00e1c \u00f4 s\u1eed d\u1ee5ng h\u00e0m t\u00ednh t\u1ed5ng.<\/p>\n<\/li>\n<li data-start=\"942\" data-end=\"986\">\n<p data-start=\"944\" data-end=\"986\"><code data-start=\"944\" data-end=\"954\">=VLOOKUP<\/code> \u0111\u1ec3 t\u00ecm c\u00e1c \u00f4 tra c\u1ee9u d\u1eef li\u1ec7u.<\/p>\n<\/li>\n<li data-start=\"989\" data-end=\"1114\"><code data-start=\"989\" data-end=\"994\">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;\" data-start=\"989\" data-end=\"1114\"><strong data-start=\"1030\" data-end=\"1041\">B\u01b0\u1edbc 6:<\/strong> Nh\u1ea5n <strong data-start=\"1047\" data-end=\"1059\">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;\" data-start=\"989\" data-end=\"1114\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504721 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-17.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-17\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"1116\" data-end=\"1133\"><strong data-start=\"1119\" data-end=\"1131\">M\u1eb9o nh\u1ecf: <\/strong>B\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n <strong data-start=\"1152\" data-end=\"1165\">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;\" data-start=\"4477\" data-end=\"4532\"><strong data-start=\"4481\" data-end=\"4532\">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;\" data-start=\"231\" data-end=\"553\">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;\" data-start=\"555\" data-end=\"583\"><strong data-start=\"560\" data-end=\"583\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n<p style=\"text-align: justify;\" data-start=\"585\" data-end=\"842\"><strong data-start=\"585\" data-end=\"596\">B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel c\u1ea7n t\u00ecm ki\u1ebfm.<\/p>\n<p style=\"text-align: justify;\" data-start=\"585\" data-end=\"842\"><strong data-start=\"627\" data-end=\"638\">B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong data-start=\"644\" data-end=\"656\">Ctrl + F<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong data-start=\"673\" data-end=\"693\">Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"585\" data-end=\"842\"><strong data-start=\"697\" data-end=\"708\">B\u01b0\u1edbc 3:<\/strong> Ch\u1ecdn <strong data-start=\"714\" data-end=\"725\">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;\" data-start=\"585\" data-end=\"842\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504722 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-18.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-18\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"585\" data-end=\"842\"><strong data-start=\"772\" data-end=\"783\">B\u01b0\u1edbc 4:<\/strong> Trong ph\u1ea7n <strong data-start=\"795\" data-end=\"806\" data-is-only-node=\"\">Look in<\/strong>, ch\u1ecdn lo\u1ea1i n\u1ed9i dung b\u1ea1n mu\u1ed1n t\u00ecm:<\/p>\n<ul style=\"text-align: justify;\" data-start=\"843\" data-end=\"1353\">\n<li data-start=\"843\" data-end=\"1050\">\n<p data-start=\"845\" data-end=\"1050\"><strong data-start=\"845\" data-end=\"856\">Values:<\/strong> Excel s\u1ebd t\u00ecm theo <strong data-start=\"875\" data-end=\"895\">gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb<\/strong> trong \u00f4 (sau khi t\u00ednh to\u00e1n).<br data-start=\"924\" data-end=\"927\" \/>\u2192 V\u00ed d\u1ee5: N\u1ebfu \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c <code data-start=\"959\" data-end=\"965\">=2+3<\/code> v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u201c5\u201d, khi ch\u1ecdn <strong data-start=\"1000\" data-end=\"1010\">Values<\/strong> v\u00e0 nh\u1eadp \u201c5\u201d, Excel s\u1ebd t\u00ecm th\u1ea5y \u00f4 n\u00e0y.<\/p>\n<\/li>\n<li data-start=\"1051\" data-end=\"1353\">\n<p data-start=\"1053\" data-end=\"1353\"><strong data-start=\"1053\" data-end=\"1079\">Comments (ho\u1eb7c Notes):<\/strong> Excel s\u1ebd t\u00ecm trong <strong data-start=\"1099\" data-end=\"1119\">n\u1ed9i dung ghi ch\u00fa<\/strong> ho\u1eb7c <strong data-start=\"1125\" data-end=\"1137\">nh\u1eadn x\u00e9t<\/strong> m\u00e0 ng\u01b0\u1eddi d\u00f9ng \u0111\u00e3 th\u00eam v\u00e0o \u00f4.<br data-start=\"1166\" data-end=\"1169\" \/>\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;\" data-start=\"1053\" data-end=\"1353\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504723 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-19.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-19\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"1053\" data-end=\"1353\"><strong data-start=\"1261\" data-end=\"1272\">B\u01b0\u1edbc 5:<\/strong> Nh\u1ea5n <strong data-start=\"1278\" data-end=\"1290\">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;\" data-start=\"1355\" data-end=\"1372\"><strong data-start=\"1358\" data-end=\"1370\">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;\" data-start=\"4888\" data-end=\"4942\"><strong data-start=\"4891\" data-end=\"4942\">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;\" data-start=\"4944\" data-end=\"5109\">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;\" data-start=\"509\" data-end=\"563\"><strong data-start=\"513\" data-end=\"563\">S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Replace c\u01a1 b\u1ea3n (Ctrl + H)<\/strong><\/h3>\n<p style=\"text-align: justify;\" data-start=\"565\" data-end=\"706\">\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;\" data-start=\"738\" data-end=\"944\"><strong data-start=\"738\" data-end=\"749\">B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5n <strong data-start=\"755\" data-end=\"767\">Ctrl + H<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong data-start=\"784\" data-end=\"804\">Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"738\" data-end=\"944\"><strong data-start=\"808\" data-end=\"819\">B\u01b0\u1edbc 2:<\/strong> T\u1ea1i \u00f4 <strong data-start=\"826\" data-end=\"839\">Find what<\/strong>, nh\u1eadp n\u1ed9i dung c\u1ea7n t\u00ecm.<\/p>\n<p style=\"text-align: justify;\" data-start=\"738\" data-end=\"944\"><strong data-start=\"866\" data-end=\"877\">B\u01b0\u1edbc 3:<\/strong> \u1ede \u00f4 <strong data-start=\"882\" data-end=\"898\">Replace with<\/strong>, nh\u1eadp n\u1ed9i dung mu\u1ed1n thay th\u1ebf.<\/p>\n<p style=\"text-align: justify;\" data-start=\"738\" data-end=\"944\">\u00a0<picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-20-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504724 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-20.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-20\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"738\" data-end=\"944\"><strong data-start=\"931\" data-end=\"942\">B\u01b0\u1edbc 4: <\/strong>Nh\u1ea5n <strong data-start=\"952\" data-end=\"967\">Replace All<\/strong> n\u1ebfu mu\u1ed1n thay th\u1ebf <strong data-start=\"986\" data-end=\"997\">to\u00e0n b\u1ed9<\/strong> n\u1ed9i dung trong b\u1ea3ng. Ho\u1eb7c ch\u1ecdn <strong data-start=\"1033\" data-end=\"1044\">Replace<\/strong> n\u1ebfu ch\u1ec9 mu\u1ed1n thay <strong data-start=\"1063\" data-end=\"1077\">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;\" data-start=\"738\" data-end=\"944\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-21.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-21-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-21-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504725 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-21.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-21\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"1112\" data-end=\"1285\"><strong data-start=\"1115\" data-end=\"1125\">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;\" data-start=\"1292\" data-end=\"1344\"><strong data-start=\"1296\" data-end=\"1344\">Thay th\u1ebf c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00f4ng c\u1ee5 Filter<\/strong><\/h3>\n<p style=\"text-align: justify;\" data-start=\"1346\" data-end=\"1502\">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;\" data-start=\"1534\" data-end=\"1915\"><strong data-start=\"1534\" data-end=\"1545\">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;\" data-start=\"1534\" data-end=\"1915\"><strong data-start=\"1581\" data-end=\"1592\">B\u01b0\u1edbc 2:<\/strong> V\u00e0o <strong data-start=\"1597\" data-end=\"1614\">Data \u2192 Filter<\/strong> \u0111\u1ec3 b\u1eadt b\u1ed9 l\u1ecdc.<\/p>\n<p style=\"text-align: justify;\" data-start=\"1534\" data-end=\"1915\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-22.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-22-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-22-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504726 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-22.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-22\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"1534\" data-end=\"1915\"><strong data-start=\"1632\" data-end=\"1643\">B\u01b0\u1edbc 3:<\/strong> L\u1ecdc ra <strong data-start=\"1651\" data-end=\"1684\">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;\" data-start=\"1534\" data-end=\"1915\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-23.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-23-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-23-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504727 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-23.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-23\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"1534\" data-end=\"1915\"><strong data-start=\"1737\" data-end=\"1748\">B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n <strong data-start=\"1754\" data-end=\"1766\">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;\" data-start=\"1534\" data-end=\"1915\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-24.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-24-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-24-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504728 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-24.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-24\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"1534\" data-end=\"1915\"><strong data-start=\"1826\" data-end=\"1837\">B\u01b0\u1edbc 5:<\/strong> Ch\u1ecdn <strong data-start=\"1843\" data-end=\"1858\">Replace All<\/strong> \u0111\u1ec3 \u00e1p d\u1ee5ng thay th\u1ebf <strong data-start=\"1879\" data-end=\"1914\">ch\u1ec9 trong c\u00e1c \u00f4 \u0111\u00e3 l\u1ecdc hi\u1ec3n th\u1ecb<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"1917\" data-end=\"2037\"><strong data-start=\"1920\" data-end=\"1932\">M\u1eb9o nh\u1ecf:<\/strong> C\u00e1ch n\u00e0y gi\u00fap b\u1ea1n <strong data-start=\"1951\" data-end=\"1981\">thay \u0111\u1ed5i d\u1eef li\u1ec7u ch\u00ednh x\u00e1c<\/strong> trong ph\u1ea1m vi mong mu\u1ed1n, <strong data-start=\"2007\" data-end=\"2036\">tr\u00e1nh \u1ea3nh h\u01b0\u1edfng to\u00e0n b\u1ea3ng<\/strong>.<\/p>\n<h3 style=\"text-align: justify;\" data-start=\"2044\" data-end=\"2104\"><strong data-start=\"2048\" data-end=\"2104\">Thay th\u1ebf b\u1eb1ng h\u00e0m Excel (SUBSTITUTE ho\u1eb7c REPLACE)<\/strong><\/h3>\n<p style=\"text-align: justify;\" data-start=\"2106\" data-end=\"2279\">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;\" data-start=\"2281\" data-end=\"2304\"><strong data-start=\"2286\" data-end=\"2304\">H\u00e0m SUBSTITUTE<\/strong><\/p>\n<ul style=\"text-align: justify;\" data-start=\"2306\" data-end=\"2562\">\n<li data-start=\"2306\" data-end=\"2390\">\n<p data-start=\"2308\" data-end=\"2322\"><strong data-start=\"2308\" data-end=\"2320\">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 data-start=\"2391\" data-end=\"2454\">\n<p data-start=\"2393\" data-end=\"2454\"><strong data-start=\"2393\" data-end=\"2407\">C\u00f4ng d\u1ee5ng:<\/strong> Thay th\u1ebf <strong data-start=\"2417\" data-end=\"2437\">chu\u1ed7i con c\u1ee5 th\u1ec3<\/strong> trong v\u0103n b\u1ea3n.<\/p>\n<\/li>\n<li data-start=\"2455\" data-end=\"2562\">\n<p data-start=\"2457\" data-end=\"2469\"><strong data-start=\"2457\" data-end=\"2467\">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;\" data-start=\"2564\" data-end=\"2584\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-25.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-25-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-25-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504729 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-25.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-25\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"2564\" data-end=\"2584\"><strong data-start=\"2569\" data-end=\"2584\">H\u00e0m REPLACE<\/strong><\/p>\n<ul style=\"text-align: justify;\" data-start=\"2586\" data-end=\"2845\">\n<li data-start=\"2586\" data-end=\"2667\">\n<p data-start=\"2588\" data-end=\"2602\"><strong data-start=\"2588\" data-end=\"2600\">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 data-start=\"2668\" data-end=\"2739\">\n<p data-start=\"2670\" data-end=\"2739\"><strong data-start=\"2670\" data-end=\"2684\">C\u00f4ng d\u1ee5ng:<\/strong> Thay th\u1ebf <strong data-start=\"2694\" data-end=\"2736\">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 data-start=\"2740\" data-end=\"2845\">\n<p data-start=\"2742\" data-end=\"2754\"><strong data-start=\"2742\" data-end=\"2752\">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;\" data-start=\"2847\" data-end=\"2998\"><strong data-start=\"2850\" data-end=\"2863\">\u1ee8ng d\u1ee5ng:<\/strong> Hai h\u00e0m n\u00e0y c\u1ef1c k\u1ef3 h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n <strong data-start=\"2904\" data-end=\"2933\">t\u1ef1 \u0111\u1ed9ng h\u00f3a vi\u1ec7c thay th\u1ebf<\/strong> ho\u1eb7c <strong data-start=\"2939\" data-end=\"2966\">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;\" data-start=\"3005\" data-end=\"3051\"><strong data-start=\"3009\" data-end=\"3051\">Thay th\u1ebf \u0111\u1ecbnh d\u1ea1ng (Format Replace)<\/strong><\/h3>\n<p style=\"text-align: justify;\" data-start=\"3053\" data-end=\"3219\">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;\" data-start=\"3251\" data-end=\"3621\"><strong data-start=\"3251\" data-end=\"3262\">B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5n <strong data-start=\"3268\" data-end=\"3280\">Ctrl + H<\/strong> \u0111\u1ec3 m\u1edf <strong data-start=\"3287\" data-end=\"3307\">Find and Replace<\/strong>.<\/p>\n<p style=\"text-align: justify;\" data-start=\"3251\" data-end=\"3621\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-26.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-26-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-26-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504730 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-26.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-26\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"3251\" data-end=\"3621\"><strong data-start=\"3311\" data-end=\"3322\">B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn <strong data-start=\"3328\" data-end=\"3351\">Options \u2192 Format&#8230;<\/strong> trong ph\u1ea7n <strong data-start=\"3363\" data-end=\"3376\">Find what<\/strong> \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh <strong data-start=\"3389\" data-end=\"3410\">\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;\" data-start=\"3251\" data-end=\"3621\">\u00a0\u00a0\u00a0 \u00a0<picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-27.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-27-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-27-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504731 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-27.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-27\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"3251\" data-end=\"3621\"><strong data-start=\"3434\" data-end=\"3445\">B\u01b0\u1edbc 3:<\/strong> Ti\u1ebfp t\u1ee5c ch\u1ecdn <strong data-start=\"3460\" data-end=\"3473\">Format&#8230;<\/strong> trong ph\u1ea7n <strong data-start=\"3485\" data-end=\"3501\">Replace with<\/strong> \u0111\u1ec3 ch\u1ecdn <strong data-start=\"3510\" data-end=\"3527\">\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;\" data-start=\"3251\" data-end=\"3621\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-28.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-28-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-28-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504732 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-28.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-28\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"3251\" data-end=\"3621\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-29.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-29-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-29-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504733 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-29.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-29\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"3251\" data-end=\"3621\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-30.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-30-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-30-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504734 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-30.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-30\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"3251\" data-end=\"3621\"><strong data-start=\"3558\" data-end=\"3569\">B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n <strong data-start=\"3575\" data-end=\"3590\">Replace All<\/strong> \u0111\u1ec3 \u00e1p d\u1ee5ng thay \u0111\u1ed5i h\u00e0ng lo\u1ea1t.<\/p>\n<p style=\"text-align: justify;\" data-start=\"3251\" data-end=\"3621\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-31.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-31-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-31-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504735 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-31.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-31\" 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\"><\/picture><\/p>\n<p style=\"text-align: justify;\" data-start=\"3623\" data-end=\"3758\"><strong data-start=\"3626\" data-end=\"3636\">V\u00ed d\u1ee5:<\/strong> B\u1ea1n c\u00f3 th\u1ec3 <strong data-start=\"3648\" data-end=\"3692\">\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;\" data-start=\"7088\" data-end=\"7135\"><strong data-start=\"7091\" data-end=\"7135\">L\u01b0u \u00fd khi t\u00ecm ki\u1ebfm, thay th\u1ebf trong Excel<\/strong><\/h2>\n<p style=\"text-align: justify;\" data-start=\"7137\" data-end=\"7263\">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;\" data-start=\"7265\" data-end=\"7962\">\n<li data-start=\"7265\" data-end=\"7376\">\n<p data-start=\"7268\" data-end=\"7376\"><strong data-start=\"7268\" data-end=\"7314\">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 data-start=\"7378\" data-end=\"7506\">\n<p data-start=\"7381\" data-end=\"7506\"><strong data-start=\"7381\" data-end=\"7411\">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 data-start=\"7458\" data-end=\"7479\">ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u<\/strong> tr\u01b0\u1edbc khi d\u00f9ng Ctrl + H.<\/p>\n<\/li>\n<li data-start=\"7508\" data-end=\"7668\">\n<p data-start=\"7511\" data-end=\"7668\"><strong data-start=\"7511\" data-end=\"7540\">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 data-start=\"7620\" data-end=\"7639\">TRIM ho\u1eb7c CLEAN<\/strong> \u0111\u1ec3 l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u tr\u01b0\u1edbc.<\/p>\n<\/li>\n<li data-start=\"7670\" data-end=\"7811\">\n<p data-start=\"7673\" data-end=\"7811\"><strong data-start=\"7673\" data-end=\"7709\">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 data-start=\"7813\" data-end=\"7962\">\n<p data-start=\"7816\" data-end=\"7962\"><strong data-start=\"7816\" data-end=\"7865\">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 data-start=\"7897\" data-end=\"7909\">Match case<\/em> ho\u1eb7c <em data-start=\"7915\" data-end=\"7943\">Match entire cell contents<\/em> \u0111\u1ec3 tr\u00e1nh nh\u1ea7m l\u1eabn.<\/p>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-32.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-32-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/11\/tim-kiem-trong-excel-32-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-504736 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/11\/tim-kiem-trong-excel-32.jpg\" alt=\"7-cach-tim-kiem-trong-excel-va-thay-the-voi-find-va-replace-32\" 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\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\" data-start=\"7969\" data-end=\"7984\"><strong data-start=\"7972\" data-end=\"7984\">K\u1ebft lu\u1eadn<\/strong><\/h2>\n<p style=\"text-align: justify;\" data-start=\"7986\" data-end=\"8337\">N\u1eafm v\u1eefng c\u00e1c thao t\u00e1c <strong data-start=\"8008\" data-end=\"8032\">t\u00ecm ki\u1ebfm trong Excel<\/strong> v\u00e0 <strong data-start=\"8036\" data-end=\"8076\">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 data-start=\"8199\" data-end=\"8211\">Ctrl + F<\/strong>, \u0111\u1ebfn <strong data-start=\"8217\" data-end=\"8266\">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;\" data-start=\"8339\" data-end=\"8446\"><em><strong>XEM TH\u00caM:<\/strong><\/em><\/p>\n<ul>\n<li style=\"text-align: justify;\" data-start=\"8339\" data-end=\"8446\"><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;\" data-start=\"8339\" data-end=\"8446\"><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":{"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 v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\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=\"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\/bc2d94dde92f5ae5c9cfdd919216cd98\"},\"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\":\"2025-11-08T13:48:59+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\":\"2025-11-08T13:48:59+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},{\"@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\/bc2d94dde92f5ae5c9cfdd919216cd98\",\"name\":\"Vo Lan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/99c001002186b6496fee18e795301746.jpg?ver=1775470018\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/99c001002186b6496fee18e795301746.jpg?ver=1775470018\",\"caption\":\"Vo Lan\"},\"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","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\/bc2d94dde92f5ae5c9cfdd919216cd98"},"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":"2025-11-08T13:48:59+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":"2025-11-08T13:48:59+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},{"@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\/bc2d94dde92f5ae5c9cfdd919216cd98","name":"Vo Lan","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/99c001002186b6496fee18e795301746.jpg?ver=1775470018","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/99c001002186b6496fee18e795301746.jpg?ver=1775470018","caption":"Vo Lan"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/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":5,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/501923\/revisions"}],"predecessor-version":[{"id":504889,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/501923\/revisions\/504889"}],"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}]}}