{"id":11065,"date":"2022-11-08T00:41:18","date_gmt":"2022-11-07T17:41:18","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11065"},"modified":"2025-04-15T17:01:53","modified_gmt":"2025-04-15T10:01:53","slug":"ham-find-trong-excel-don-gian-nhat","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/","title":{"rendered":"H\u00e0m FIND trong Excel &#8211; T\u1eeb A \u0111\u1ebfn Z c\u00e1ch s\u1eed d\u1ee5ng \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;11065&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u00e0m FIND trong Excel - T\u1eeb A \u0111\u1ebfn Z c\u00e1ch s\u1eed d\u1ee5ng \u0111\u01a1n gi\u1ea3n nh\u1ea5t&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><b><i>H\u00e0m FIND trong Excel<\/i><\/b><i><span style=\"font-weight: 400;\"> l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m th\u1ee9c c\u01a1 b\u1ea3n v\u00e0 th\u00f4ng d\u1ee5ng. M\u1eb7c d\u00f9 kh\u00f4ng c\u00f3 gi\u00e1t tr\u1ecb \u1ee9ng d\u1ee5ng nhi\u1ec1u nh\u01b0 c\u00e1c c\u00e1c h\u00e0m c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n kh\u00e1c, h\u00e0m FIND v\u1eabn c\u00f3 m\u1ed9t s\u1ed1 ch\u1ee9c n\u0103ng quan tr\u1ecdng nh\u1ea5t \u0111\u1ecbnh. V\u1ec1 quy t\u1eafc v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND kh\u00f4ng c\u00f3 g\u00ec ph\u1ee9c t\u1ea1p. Tuy nhi\u00ean, so v\u1edbi h\u00e0m SEARCH h\u00e0m FIND c\u00f3 m\u1ed9t s\u1ed1 n\u1ed9i dung \u0111\u00e1ng l\u01b0u \u00fd \u0111\u1ec3 ph\u00e2n bi\u1ec7t gi\u1eefa hai h\u00e0m n\u00e0y. Sau \u0111\u00e2y s\u1ebd l\u00e0 nh\u1eefng th\u00f4ng tin\u00a0 v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND m\u1ed9t c\u00e1ch c\u1ee5 th\u1ec3 nh\u1ea5t!<\/span><\/i><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#Ham_FIND_va_ung_dung_cua_ham_FIND_trong_Excel\" >H\u00e0m FIND v\u00e0 \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m FIND trong Excel\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#Cu_phap_cua_ham_FIND_trong_Excel\" >C\u00fa ph\u00e1p c\u1ee7a h\u00e0m FIND trong Excel\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#Luu_y_cua_ham_FIND_trong_Excel\" >L\u01b0u \u00fd c\u1ee7a h\u00e0m FIND trong Excel\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#Huong_dan_su_dung_ham_FIND_trong_Excel\" >H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#Tim_vi_tri_cua_mot_ki_tu_xuat_hien_trong_chuoi_van_ban\" >T\u00ecm v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t k\u00ed t\u1ef1 xu\u1ea5t hi\u1ec7n trong chu\u1ed7i v\u0103n b\u1ea3n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#Su_dung_ket_hop_voi_cac_ham_MID\" >S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m MID\u00a0<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#Phan_biet_ham_FIND_va_ham_SEARCH_trong_Excel\" >Ph\u00e2n bi\u1ec7t h\u00e0m FIND v\u00e0 h\u00e0m SEARCH trong Excel\u00a0<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_FIND_va_ung_dung_cua_ham_FIND_trong_Excel\"><\/span><b>H\u00e0m FIND v\u00e0 \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m FIND trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>H\u00e0m FIND trong Excel <\/b><span style=\"font-weight: 400;\">c\u00f3 ch\u1ee9c n\u0103ng t\u01b0\u01a1ng t\u1ef1 v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m nh\u01b0 MID, LEFT ho\u1eb7c RIGHT. Tuy nhi\u00ean v\u1eabn c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t nh\u1ea5t \u0111\u1ecbnh. H\u00e0m FIND l\u00e0 m\u1ed9t h\u00e0m gi\u00fap t\u00ecm ki\u1ebfm k\u00fd t\u1ef1 trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. H\u00e0m FIND s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ecm ra v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 trong chu\u1ed7i v\u0103n b\u1ea3n. Trong khi \u0111\u00f3 c\u00e1c h\u00e0m h\u00e0m t\u00e1ch chu\u1ed7i nh\u01b0 MID, LEFT ho\u1eb7c RIGHT\u00a0 th\u00ec c\u1ea7n x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc s\u1ed1 k\u00fd t\u1ef1 v\u00e0 l\u1ef1a ch\u1ecdn v\u1ecb tr\u00ed c\u1ea7n t\u00e1ch. Nh\u01b0 v\u1eady, h\u00e0m FIND ng\u1eabu nhi\u00ean v\u00e0 linh ho\u1ea1t h\u01a1n nh\u01b0ng kh\u00f4ng t\u1ef1 \u0111\u1ed9ng t\u00e1ch nh\u01b0 c\u00e1c h\u00e0m kh\u00e1c.\u00a0<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Find trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/XJ_wwxypYjQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_FIND_trong_Excel\"><\/span><b>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m FIND trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m FIND l\u00e0 m\u1ed9t h\u00e0m \u0111\u01a1n gi\u1ea3n v\u00e0 h\u00e0m n\u00e0y c\u0169ng kh\u00f4ng c\u00f3 nhi\u1ec1u l\u01b0u \u00fd khi nh\u1eadp h\u00e0m. C\u1ee5 th\u1ec3, c\u00f4ng th\u1ee9c v\u00e0 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m FIND trong Excel nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0<\/span><b>=FIND(find_text; within_text; [start_num])<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">find_text: L\u00e0 m\u1ed9t ch\u1eef, m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t n\u1ed9i d\u1ee5ng d\u1ea1ng v\u0103n b\u1ea3n mu\u1ed1n t\u00ecm ki\u1ebfm.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">within_text: L\u00e0 to\u00e0n b\u1ed9 n\u1ed9i dung d\u1ea1ng v\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm v\u1ecb tr\u00ed c\u1ee7a find_text trong \u0111\u00f3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[start_num]: L\u00e0 \u0111\u00e1nh d\u1ea5u \u0111\u1ec3 b\u1ecf qua s\u1ed1 k\u00fd t\u1ef1 \u0111\u1ea7u v\u00e0 b\u1eaft \u0111\u1ea7u t\u1ea1i v\u1ecb tr\u00ed \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh, n\u1ebfu b\u1ecf qua [start_num] th\u00ec m\u1eb7c \u0111\u1ecbnh s\u1ebd =1.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Luu_y_cua_ham_FIND_trong_Excel\"><\/span><b>L\u01b0u \u00fd c\u1ee7a h\u00e0m FIND trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 hi\u1ec3u h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel n\u00e0y, b\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1ed9t v\u1ea5n \u0111\u1ec1. C\u1ee5 th\u1ec3 sau \u0111\u00e2y:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kh\u00e1c v\u1edbi h\u00e0m SEARCH, h\u00e0m FIND s\u1ebd c\u00f3 s\u1ef1 ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 th\u01b0\u1eddng trong v\u0103n b\u1ea3n t\u00ecm ki\u1ebfm.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 b\u1ecf qua [start_num] trong khi nh\u1eadp h\u00e0m, h\u00e0m s\u1ebd m\u1eb7c \u0111\u1ecbnh s\u1ed1 l\u00e0 1. N\u1ebfu mu\u1ed1n b\u1eaft \u0111\u1ea7u t\u00ecm ki\u1ebfm t\u1ea1i v\u1ecb tr\u00ed c\u1ee5 th\u1ec3 c\u00f3 th\u1ec3 \u0111i\u1ec1n s\u1ed1 kh\u00e1c.\u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m FIND trong Excel kh\u00f4ng cho ph\u00e9p s\u1eed d\u1ee5ng k\u00fd t\u1ef1 thay th\u1ebf.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m FIND kh\u00f4ng cho ph\u00e9p s\u1eed d\u1ee5ng c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n trong \u0111\u1ed1i s\u1ed1 find_text nh\u01b0 d\u1ea5u ch\u1ea5m h\u1ecfi (?) v\u00e0 d\u1ea5u hoa th\u1ecb (*) thay cho b\u1ea5t k\u1ef3 chu\u1ed7i k\u00fd t\u1ef1 n\u00e0o.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu \u0111\u1ed1i s\u1ed1 find_text ch\u1ee9a nhi\u1ec1u k\u00fd t\u1ef1, h\u00e0m FIND s\u1ebd t\u01b0 d\u1ed9ng tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean . M\u1ed9t v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u \u0111\u00f3 l\u00e0: FIND (\u201cea\u201d, \u201csearch\u201d) tr\u1ea3 v\u1ec1 2 v\u00ec \u201ce\u201d l\u00e0 k\u00fd t\u1ef1 th\u1ee9 hai trong t\u1eeb \u201d search\u201d.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu trong ph\u1ea7n within_text ch\u1ee9a nhi\u1ec1u l\u1ea7n xu\u1ea5t hi\u1ec7n th\u00ec l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 trong k\u1ebft qu\u1ea3. V\u00ed d\u1ee5, FIND (\u201cn\u201d, \u201crunner\u201d) tr\u1ea3 v\u1ec1 3, l\u00e0 v\u1ecb tr\u00ed c\u1ee7a ch\u1eef \u201cn\u201d \u0111\u1ea7u ti\u00eanxu\u1ea5t hi\u1ec7n trong t\u1eeb \u201crunner\u201d.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu find_text l\u00e0 m\u1ed9t chu\u1ed7i tr\u1ed1ng \u201c\u201d, c\u00f4ng th\u1ee9c FIND Excel tr\u1ea3 v\u1ec1 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong chu\u1ed7i t\u00ecm ki\u1ebfm.<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/lotrinhlaptrinh.teky.vn\/\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24875\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Sale-Promotion.png\" alt=\"\u01afu \u0111\u00e3i \u0111\u1ebfn 25%\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, nh\u1eefng tr\u01b0\u1eddng h\u1ee3p tr\u1ea3 v\u1ec1 b\u00e1o l\u1ed7i #VALUE! s\u1ebd th\u01b0\u1eddng do:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Find_text kh\u00f4ng l\u00e0 gi\u00e1 tr\u1ecb t\u1ed3n t\u1ea1i trong within_text.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Start_num l\u1edbn h\u01a1n so v\u1edbi s\u1ed1 k\u00ed t\u1ef1 c\u00f3 trong within_text.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Start_num kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1 nguy\u00ean d\u01b0\u01a1ng kh\u00e1c 0.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_su_dung_ham_FIND_trong_Excel\"><\/span><b>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Tim_vi_tri_cua_mot_ki_tu_xuat_hien_trong_chuoi_van_ban\"><\/span><b><i>T\u00ecm v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t k\u00ed t\u1ef1 xu\u1ea5t hi\u1ec7n trong chu\u1ed7i v\u0103n b\u1ea3n<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Sau \u0111\u00e2y s\u1ebd l\u00e0 m\u1ed9t v\u00ed d\u1ee5 cho ch\u1ee9c n\u0103ng t\u00ecm v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t k\u00ed t\u1ef1 xu\u1ea5t hi\u1ec7n trong chu\u1ed7i v\u0103n b\u1ea3n. \u0110\u1ea7u ti\u00ean l\u00e0 k\u1ebft qu\u1ea3 t\u00ecm v\u1ecb tr\u00ed c\u1ee7a k\u00ed t\u1ef1 \u201cY\u201d trong t\u00ean \u1edf \u00f4 A2.\u00a0<\/span><\/p>\n<figure id=\"attachment_11074\" aria-describedby=\"caption-attachment-11074\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-11074\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-1-400x195.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m FIND \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed k\u00fd t\u1ef1\" width=\"400\" height=\"195\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-1-400x195.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-1.jpg 629w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-11074\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m FIND \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed k\u00fd t\u1ef1<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Ho\u1eb7c m\u1ed9t v\u00ed d\u1ee5 kh\u00e1c l\u00e0 t\u00ecm k\u00fd t\u1ef1 \u201c\u00e2n\u201d trong t\u00ean \u1edf \u00f4 A3.\u00a0<\/span><\/p>\n<figure id=\"attachment_11073\" aria-describedby=\"caption-attachment-11073\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11073 size-medium\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-2-400x202.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m FIND trong Excel \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed k\u00fd t\u1ef1\" width=\"400\" height=\"202\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-2-400x202.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-2.jpg 619w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-11073\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m FIND \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed k\u00fd t\u1ef1<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ket_hop_voi_cac_ham_MID\"><\/span><b><i>S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m MID\u00a0<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m FIND trong Excel c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m MID. Khi k\u1ebft h\u1ee3p 2 h\u00e0m n\u00e0y v\u1edbi nhau ch\u00fang ta s\u1ebd t\u00ecm \u0111\u01b0\u1ee3c k\u00fd t\u1ef1 \u1edf gi\u1eefa trong d\u00e3y v\u0103n b\u1ea3n.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 nh\u01b0 trong h\u00ecnh sau \u0111\u00e2y nh\u1eb1m t\u00ecm ra k\u00fd t\u1ef1 KYP c\u1ee7a \u0111o\u1ea1n v\u0103n b\u1ea3n trong B4. \u0110\u1ea7u ti\u00ean s\u1ebd l\u00e0 thao t\u00e1c t\u00ecm k\u00fd t\u1ef1 \u201c-\u201d \u0111\u1ea7u ti\u00ean \u1edf \u00f4 B4 b\u1eb1ng h\u00e0m FIND. Sau \u0111\u00f3, ch\u00fang ta c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m MID t\u00e1ch 3 k\u00fd t\u1ef1 \u1edf tr\u01b0\u1edbc v\u00e0 sau c\u1ee7a k\u00fd t\u1ef1 \u201c-\u201d. Nh\u01b0 v\u1eady ta s\u1ebd \u0111\u01b0\u1ee3c k\u00fd t\u1ef1 \u1edf gi\u1eefu c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n. Nh\u01b0 v\u1eady, ch\u00fang ta c\u00f3 m\u1ed9t h\u00e0m c\u00f4ng th\u1eed k\u1ebft h\u1ee3p nh\u01b0 sau: =MID(B4,FIND(&#8220;-&#8220;,B4)+1, 3). C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 quan s\u00e1t k\u1ebft qu\u1ea3 trong h\u00ecnh.\u00a0<\/span><\/p>\n<figure id=\"attachment_11072\" aria-describedby=\"caption-attachment-11072\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-11072\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-3-2-400x202.jpg\" alt=\"H\u00e0m FIND trong Excel c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m MID\" width=\"400\" height=\"202\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-3-2-400x202.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-3-2.jpg 619w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-11072\" class=\"wp-caption-text\">H\u00e0m FIND trong Excel c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m MID<\/figcaption><\/figure>\n<p><b><i>S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m LEFT ho\u1eb7c RIGHT<\/i><\/b><\/p>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1. H\u00e0m FIND trong Excel c\u0169ng c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m LEFT v\u00e0 RIGHT. V\u1ec1 c\u01a1 b\u1ea3n c\u00e1ch l\u00e0m v\u00e0 m\u1ee5c \u0111\u1ecbch c\u0169ng gi\u1ed1ng nh\u01b0 h\u00e0m MID \u1edf tr\u00ean. M\u1ee5c \u0111\u00edch th\u01b0\u1eddng l\u00e0 d\u00f9ng \u0111\u1ec3 t\u00e1ch chu\u1ed7i k\u00fd t\u1ef1 \u0111\u1ea7u trong v\u0103n b\u1ea3n h\u1ecd v\u00e0 t\u00ean, m\u00e3 v\u00f9ng, k\u00fd hi\u1ec7u\u2026\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110i\u1ec3n h\u00ecnh nh\u01b0 trong v\u00ed d\u1ee5 sau. M\u1ee5c \u0111\u00edch l\u00e0 \u0111\u1ec3 t\u00ecm ra h\u1ecd c\u1ee7a ng\u01b0\u1eddi \u1edf \u00f4 B3. \u0110\u1ea7u ti\u00ean l\u00e0 t\u00ecm k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong \u00f4 B3 t\u1eeb tr\u00e1i sang ph\u1ea3i cho \u0111\u1ebfn khi g\u1eb7p k\u00fd t\u1ef1 \u201c-\u201d v\u00e0 kh\u00f4ng l\u1ea5y k\u00fd t\u1ef1 \u201c-\u201d n\u00ean s\u1ebd c\u00f3 -1 trong c\u00f4ng th\u1ee9c h\u00e0m.V\u00e0 nh\u01b0 v\u1eady ch\u00fang ta s\u1ebd c\u00f3 m\u1ed9t h\u00e0m ph\u1ee9c h\u1ee3p =LEFT(B3,FIND(&#8220;-&#8220;,B3)-1). K\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 nh\u01b0 trong h\u00ecnh.\u00a0<\/span><\/p>\n<figure id=\"attachment_11071\" aria-describedby=\"caption-attachment-11071\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-11071\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-4-400x202.jpg\" alt=\"H\u00e0m FIND trong Excel c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m LEFT ho\u1eb7c RIGHT\" width=\"400\" height=\"202\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-4-400x202.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-4.jpg 619w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-11071\" class=\"wp-caption-text\">H\u00e0m FIND trong Excel c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m LEFT ho\u1eb7c RIGHT<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Phan_biet_ham_FIND_va_ham_SEARCH_trong_Excel\"><\/span><b>Ph\u00e2n bi\u1ec7t h\u00e0m FIND v\u00e0 h\u00e0m SEARCH trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m FIND th\u01b0\u1eddng \u0111\u01b0\u1ee3c nh\u1ea7m l\u1eabn c\u00f3 ch\u1ee9c n\u0103ng v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng gi\u1ed1ng nh\u01b0 h\u00e0m SEARCH. Tuy nhi\u00ean, n\u1ebfu th\u1eadt s\u1ef1 gi\u1ed1ng nhau th\u00ec h\u00e0m FIND \u0111\u00e3 kh\u00f4ng ra \u0111\u1eddi. V\u1ec1 c\u01a1 b\u1ea3n, s\u1ef1 kh\u00e1c bi\u1ec7t l\u1edbn nh\u1ea5t l\u00e0 vi\u1ec7c <\/span><b>h\u00e0m FIND trong Excel<\/b><span style=\"font-weight: 400;\"> ph\u00e2n bi\u1ec7t ch\u1eef hoa, th\u01b0\u1eddng. Trong khi \u0111\u00f3 th\u00ec h\u00e0m SEARCH l\u1ea1i kh\u00f4ng c\u00f3 s\u1ef1 ph\u00e2n bi\u1ec7t trong nh\u1eadn d\u1ea1ng ch\u1eef hoa. V\u00ed d\u1ee5, SEARCH (\u201cm\u201d, \u201cMama\u201d) c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 1 v\u00ec n\u00f3 nh\u1eadn \u201cM\u201d hoa. Trong khi \u0111\u1ed1i v\u1edbi h\u00e0m file FIND (\u201cm\u201d, \u201cMama\u201d)\u00a0 th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 3 v\u00ec n\u00f3 ph\u00e2n bi\u1ec7t M v\u00e0 m.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i ra th\u00ec m\u1ed9t s\u1ef1 kh\u00e1c bi\u1ec7t n\u1eefa \u0111\u00f3 l\u00e0 cho ph\u00e9p d\u00f9ng ksy t\u1ef1 thay th\u1ebf. Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp trong ph\u1ea7n l\u01b0u \u00fd h\u00e0m FIND kh\u00f4ng cho ph\u00e9p \u0111i\u1ec1u n\u00e0y. Trong khi \u0111\u00f3, h\u00e0m SEARCH l\u1ea1i kh\u00f4ng c\u00f3 b\u1eaft bu\u1ed9c \u0111\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p n\u00e0y. Nh\u00ecn chung, c\u00e1c h\u00e0m FIND v\u00e0 SEARCH hi\u1ebfm khi \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng m\u1ed9t c\u00e1ch \u0111\u1ed9c l\u1eadp. Thay v\u00e0o \u0111\u00f3, ch\u00fang th\u01b0\u1eddng \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 MID, LEFT ho\u1eb7c RIGHT.<\/span><\/p>\n<p><a href=\"https:\/\/khuyenmai.teky.vn\/tangsachlaptrinh\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24876\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Free-Asset.png\" alt=\"T\u1eb7ng s\u00e1ch mi\u1ec5n ph\u00ed\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<p><i><span style=\"font-weight: 400;\">V\u00e0 nh\u01b0 v\u1eady, tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng th\u00f4ng tin chi ti\u1ebft v\u1ec1 <\/span><\/i><b><i>h\u00e0m FIND trong Excel.<\/i><\/b><i><span style=\"font-weight: 400;\"> Hy v\u1ecdng r\u1eb1ng nh\u1eefng th\u00f4ng tin tr\u00ean \u0111\u00e2y s\u1ebd ph\u1ea7n n\u00e0o gi\u00fap cho c\u00e1c b\u1ea1n hi\u1ec3u h\u01a1n v\u1ec1 h\u00e0m n\u00e0y. Trong Excel c\u01a1 b\u1ea3n, n\u1eafm r\u00f5 c\u00e1c h\u00e0m th\u00f4ng th\u01b0\u1eddng s\u1ebd d\u1ee5ng b\u1ea1n linh ho\u1ea1t v\u00e0 \u1ee9ng d\u1ee5ng \u0111\u01b0\u1ee3c trong r\u1ea5t nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p. Nh\u1edd v\u1eady, k\u1ef9 n\u0103ng s\u1eed d\u1ee5ng Excel c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c c\u1ea3i thi\u1ec7n m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 h\u01a1n r\u1ea5t nhi\u1ec1u. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o nhi\u1ec1u ki\u1ebfn th\u1ee9c t\u1ef1 h\u1ecdc Excel kh\u00e1c t\u1ea1i T\u1ef1 h\u1ecdc Excel t\u1ea1i Teky.<\/span><\/i><\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/\" target=\"_blank\" rel=\"noopener\">B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">T\u00e1ch ch\u1eef trong Excel &#8211; M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o?<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-viet-hoa-chu-cai-dau-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel nhanh nh\u1ea5t<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m FIND trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m th\u1ee9c c\u01a1 b\u1ea3n v\u00e0 th\u00f4ng d\u1ee5ng. M\u1eb7c d\u00f9 kh\u00f4ng c\u00f3 gi\u00e1t tr\u1ecb \u1ee9ng d\u1ee5ng nhi\u1ec1u nh\u01b0 c\u00e1c c\u00e1c h\u00e0m c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n kh\u00e1c, h\u00e0m FIND v\u1eabn c\u00f3 m\u1ed9t s\u1ed1 ch\u1ee9c n\u0103ng quan tr\u1ecdng nh\u1ea5t \u0111\u1ecbnh. V\u1ec1 quy t\u1eafc v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND kh\u00f4ng &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11074,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11065","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"Sau \u0111\u00e2y l\u00e0 nh\u1eefng th\u00f4ng tin chi ti\u1ebft v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u1ee5 th\u1ec3 nh\u1ea5t d\u00e0nh cho b\u1ea1n!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"Sau \u0111\u00e2y l\u00e0 nh\u1eefng th\u00f4ng tin chi ti\u1ebft v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u1ee5 th\u1ec3 nh\u1ea5t d\u00e0nh cho b\u1ea1n!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-07T17:41:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-15T10:01:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"629\" \/>\n\t<meta property=\"og:image:height\" content=\"307\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m FIND trong Excel &#8211; T\u1eeb A \u0111\u1ebfn Z c\u00e1ch s\u1eed d\u1ee5ng \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"datePublished\":\"2022-11-07T17:41:18+00:00\",\"dateModified\":\"2025-04-15T10:01:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/\"},\"wordCount\":2008,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-1.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-1.jpg\",\"datePublished\":\"2022-11-07T17:41:18+00:00\",\"dateModified\":\"2025-04-15T10:01:53+00:00\",\"description\":\"Sau \u0111\u00e2y l\u00e0 nh\u1eefng th\u00f4ng tin chi ti\u1ebft v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u1ee5 th\u1ec3 nh\u1ea5t d\u00e0nh cho b\u1ea1n!\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-1.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-1.jpg\",\"width\":629,\"height\":307,\"caption\":\"S\u1eed d\u1ee5ng h\u00e0m FIND \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed k\u00fd t\u1ef1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m FIND trong Excel &#8211; T\u1eeb A \u0111\u1ebfn Z c\u00e1ch s\u1eed d\u1ee5ng \u0111\u01a1n gi\u1ea3n nh\u1ea5t\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","description":"Sau \u0111\u00e2y l\u00e0 nh\u1eefng th\u00f4ng tin chi ti\u1ebft v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u1ee5 th\u1ec3 nh\u1ea5t d\u00e0nh cho b\u1ea1n!","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:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","og_description":"Sau \u0111\u00e2y l\u00e0 nh\u1eefng th\u00f4ng tin chi ti\u1ebft v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u1ee5 th\u1ec3 nh\u1ea5t d\u00e0nh cho b\u1ea1n!","og_url":"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-07T17:41:18+00:00","article_modified_time":"2025-04-15T10:01:53+00:00","og_image":[{"width":629,"height":307,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-1.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"9 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m FIND trong Excel &#8211; T\u1eeb A \u0111\u1ebfn Z c\u00e1ch s\u1eed d\u1ee5ng \u0111\u01a1n gi\u1ea3n nh\u1ea5t","datePublished":"2022-11-07T17:41:18+00:00","dateModified":"2025-04-15T10:01:53+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/"},"wordCount":2008,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-1.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/","url":"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-1.jpg","datePublished":"2022-11-07T17:41:18+00:00","dateModified":"2025-04-15T10:01:53+00:00","description":"Sau \u0111\u00e2y l\u00e0 nh\u1eefng th\u00f4ng tin chi ti\u1ebft v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FIND trong Excel m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u1ee5 th\u1ec3 nh\u1ea5t d\u00e0nh cho b\u1ea1n!","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-1.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-find-trong-excel-1.jpg","width":629,"height":307,"caption":"S\u1eed d\u1ee5ng h\u00e0m FIND \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed k\u00fd t\u1ef1"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m FIND trong Excel &#8211; T\u1eeb A \u0111\u1ebfn Z c\u00e1ch s\u1eed d\u1ee5ng \u0111\u01a1n gi\u1ea3n nh\u1ea5t"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11065","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11065"}],"version-history":[{"count":2,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11065\/revisions"}],"predecessor-version":[{"id":24985,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11065\/revisions\/24985"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11074"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11065"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11065"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11065"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}