{"id":271308,"date":"2023-10-19T14:47:19","date_gmt":"2023-10-19T07:47:19","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=271308"},"modified":"2023-10-19T14:47:19","modified_gmt":"2023-10-19T07:47:19","slug":"ham-find","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/","title":{"rendered":"H\u00e0m FIND v\u00e0 SEARCH trong Excel v\u1edbi c\u00e1c v\u00ed d\u1ee5 chi ti\u1ebft"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Ng\u01b0\u1eddi d\u00f9ng Excel th\u01b0\u1eddng c\u00f3 s\u1ef1 nh\u1ea7m l\u1eabn gi\u1eefa h\u00e0m FIND v\u00e0 h\u00e0m SEARCH v\u00ec ch\u1ee9c n\u0103ng c\u1ee7a ch\u00fang kh\u00e1 t\u01b0\u01a1ng \u0111\u1ed3ng v\u1edbi nhau. V\u1eady, h\u00e0m FIND l\u00e0 g\u00ec? H\u00e0m SEARCH l\u00e0 g\u00ec? C\u00f4ng d\u1ee5ng c\u1ee7a m\u1ed7i h\u00e0m l\u00e0 g\u00ec v\u00e0 ch\u00fang kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile kh\u00e1m ph\u00e1 qua b\u00e0i vi\u1ebft \u0111\u01b0\u1ee3c chia s\u1ebb d\u01b0\u1edbi \u0111\u00e2y!<\/span><\/p>\n<h2><b>H\u00e0m FIND l\u00e0 g\u00ec?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m FIND trong Microsoft Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t chu\u1ed7i con trong chu\u1ed7i k\u00fd t\u1ef1 (hay chu\u1ed7i v\u0103n b\u1ea3n). Th\u00f4ng qua \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t t\u1eeb, m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 con n\u1eb1m trong m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 d\u00e0i h\u01a1n.\u00a0<\/span><\/p>\n<h3><b>C\u00fa ph\u00e1p<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m FIND: <\/span><strong>=FIND(find_text, within_text, [start_num])<\/strong><\/p>\n<figure id=\"attachment_271608\" aria-describedby=\"caption-attachment-271608\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-271608 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-1.jpg\" alt=\"ham-find-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-271608\" class=\"wp-caption-text\">C\u00fa ph\u00e1p h\u00e0m FIND<\/figcaption><\/figure>\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: \u0110\u00e2y l\u00e0 m\u1ed9t th\u00e0nh ph\u1ea7n b\u1eaft bu\u1ed9c, \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh k\u00fd t\u1ef1 ho\u1eb7c chu\u1ed7i k\u00fd t\u1ef1 con m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Within_text: Chu\u1ed7i v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm. Within_text th\u01b0\u1eddng \u0111\u01b0\u1ee3c xem nh\u01b0 \u00f4 tham chi\u1ebfu, ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 g\u00f5 tr\u1ef1c ti\u1ebfp chu\u1ed7i v\u0103n b\u1ea3n v\u00e0o Within_text. \u0110\u00e2y l\u00e0 m\u1ed9t th\u00e0nh ph\u1ea7n b\u1eaft bu\u1ed9c trong h\u00e0m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u00a0Start_num: \u0110\u00e2y l\u00e0 m\u1ed9t th\u00e0nh ph\u1ea7n t\u00f9y ch\u1ecdn, cho ph\u00e9p b\u1ea1n x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm. N\u1ebfu b\u1ecf tr\u1ed1ng t\u00f9y ch\u1ecdn n\u00e0y, h\u00e0m s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ecm ki\u1ebfm t\u1eeb k\u00fd t\u1ef1 th\u1ee9 nh\u1ea5t trong chu\u1ed7i ch\u1ec9 \u0111\u1ecbnh \u1edf Within_text.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: N\u1ebfu h\u00e0m FIND kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c k\u00fd t\u1ef1 ch\u1ec9 \u0111\u1ecbnh trong find_text, b\u1ea1n s\u1ebd nh\u00ecn th\u1ea5y l\u1ed7i hi\u1ec3n th\u1ecb l\u00e0 #VALUE!<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n nh\u01b0: C\u00fa ph\u00e1p <\/span><span style=\"font-weight: 400;\">\u00a0<\/span><span style=\"font-weight: 400;\">=FIND(&#8220;d&#8221;,&#8221;find&#8221;) cho k\u1ebft qu\u1ea3 l\u00e0 4 v\u00ec \u201cd\u201d n\u1eb1m \u1edf v\u1ecb tr\u00ed th\u1ee9 4 trong t\u1eeb \u201cfind\u201d, c\u00f2n v\u1edbi =FIND(&#8220;a&#8221;, &#8220;find&#8221;) s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i v\u00ec kh\u00f4ng t\u00ecm th\u1ea5y ch\u1eef \u201ca\u201d t\u01b0\u01a1ng \u1ee9ng trong \u201cfind\u201d.\u00a0<\/span><\/p>\n<h3><b>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m FIND<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">B\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec1u sau khi s\u1eed d\u1ee5ng h\u00e0m FIND:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m FIND c\u00f3 s\u1ef1 ph\u00e2n bi\u1ec7t gi\u1eefa ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng k\u00fd t\u1ef1 thay th\u1ebf v\u1edbi h\u00e0m t\u00ecm trong Excel.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu find_text ch\u1ee9a nhi\u1ec1u k\u00fd t\u1ef1, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean. Ch\u1eb3ng h\u1ea1n nh\u01b0 v\u1edbi =FIND(\u201cui\u201d,\u201dvui\u201d), h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 2 v\u00ec \u201cu\u201d l\u00e0 k\u00fd t\u1ef1 th\u1ee9 hai c\u1ee7a \u201cvui\u201d.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu within_text ch\u1ee9a c\u00f9ng l\u00fac nhi\u1ec1u k\u00fd t\u1ef1 c\u1ee7a find_text, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a k\u00fd t\u1ef1. Ch\u1eb3ng h\u1ea1n nh\u01b0 =FIND(\u201cp\u201d,\u201dhappy\u201d), k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 3 v\u00ec ch\u1eef \u201cp\u201d \u0111\u1ea7u ti\u00ean c\u1ee7a \u201chappy\u201d n\u1eb1m \u1edf v\u1ecb tr\u00ed th\u1ee9 3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu trong \u0111\u1ed1i s\u1ed1 find_text ch\u1ee9a chu\u1ed7i tr\u1ed1ng, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean t\u01b0\u01a1ng \u1ee9ng v\u1edbi chu\u1ed7i t\u00ecm ki\u1ebfm.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u1ed7i l\u00e0 #VALUE! n\u1ebfu x\u1ea3y ra 1 trong 3 tr\u01b0\u1eddng h\u1ee3p: Kh\u00f4ng t\u00ecm th\u1ea5y Find_text trong within_text, Start_num c\u00f3 nhi\u1ec1u s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 h\u01a1n so v\u1edbi within_text, ho\u1eb7c Start_num l\u00e0 s\u1ed1 0 ho\u1eb7c s\u1ed1 \u00e2m.\u00a0<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_271609\" aria-describedby=\"caption-attachment-271609\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-271609 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-2.jpg\" alt=\"ham-find-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-271609\" class=\"wp-caption-text\">H\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 #VALUE! n\u1ebfu x\u1ea3y ra l\u1ed7i<\/figcaption><\/figure>\n<h2><b>H\u00e0m SEARCH l\u00e0 g\u00ec?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1 v\u1edbi h\u00e0m FIND, h\u00e0m SEARCH c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c chu\u1ed7i k\u00fd t\u1ef1 con trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. Th\u1eadm ch\u00ed, c\u00fa ph\u00e1p v\u00e0 \u0111\u1ed1i s\u1ed1 c\u1ee7a h\u00e0m SEARCH c\u0169ng kh\u00e1 gi\u1ed1ng v\u1edbi h\u00e0m FIND:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=SEARCH (find_text,within_text,[start_num])<\/span><\/p>\n<figure id=\"attachment_271610\" aria-describedby=\"caption-attachment-271610\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-271610 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-3.jpg\" alt=\"ham-find-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-271610\" class=\"wp-caption-text\">H\u00e0m SEARCH l\u00e0 g\u00ec?<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Tuy nhi\u00ean, h\u00e0m SEARCH kh\u00e1c h\u00e0m FIND \u1edf ch\u1ed7 l\u00e0 h\u00e0m n\u00e0y cho ph\u00e9p s\u1eed d\u1ee5ng k\u00fd t\u1ef1 thay th\u1ebf v\u00e0 kh\u00f4ng ph\u00e2n bi\u1ec7t gi\u1eefa ch\u1eef hoa v\u1edbi ch\u1eef th\u01b0\u1eddng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c =SEARCH(\u201cmarket\u201d,\u201csupermarket\u201d) l\u00e0 6 v\u00ec \u201cmarket\u201d c\u00f3 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean b\u1eaft \u0111\u1ea7u \u1edf v\u1ecb tr\u00ed th\u1ee9 6 c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n \u201csupermarket\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c =SEARCH(\u201ce\u201d,\u201cExcel\u201d) l\u00e0 1 v\u00ec h\u00e0m n\u00e0y kh\u00f4ng ph\u00e2n bi\u1ec7t gi\u1eefa \u201cE\u201d v\u1edbi \u201ce\u201d.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1 h\u00e0m FIND, k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m SEARCH s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE! khi: Kh\u00f4ng t\u00ecm th\u1ea5y k\u00fd t\u1ef1 c\u00f3 trong find_text, s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a start_num d\u00e0i h\u01a1n so v\u1edbi within_text, Start_num nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 0.\u00a0<\/span><\/li>\n<\/ul>\n<h2><b>So s\u00e1nh h\u00e0m FIND v\u00e0 h\u00e0m SEARCH<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m FIND v\u00e0 h\u00e0m SEARCH c\u00f3 c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch d\u00f9ng g\u1ea7n nh\u01b0 gi\u1ed1ng nhau. Tuy nhi\u00ean, gi\u1eefa hai h\u00e0m v\u1eabn c\u00f3 m\u1ed9t v\u00e0i \u0111i\u1ec3m kh\u00e1c bi\u1ec7t nh\u01b0:\u00a0<\/span><\/p>\n<h3><b>Ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110i\u1ec3m kh\u00e1c bi\u1ec7t \u0111\u1ea7u ti\u00ean l\u00e0 h\u00e0m FIND c\u00f3 s\u1ef1 ph\u00e2n bi\u1ec7t gi\u1eefa ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng, c\u00f2n h\u00e0m SEARCH th\u00ec kh\u00f4ng.\u00a0<\/span><\/p>\n<figure id=\"attachment_271611\" aria-describedby=\"caption-attachment-271611\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-271611 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-4.jpg\" alt=\"ham-find-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-271611\" class=\"wp-caption-text\">H\u00e0m FIND c\u00f3 s\u1ef1 ph\u00e2n bi\u1ec7t gi\u1eefa ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng, c\u00f2n h\u00e0m SEARCH th\u00ec kh\u00f4ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 nh\u01b0 v\u1edbi c\u00fa ph\u00e1p =SEARCH(\u201ce\u201d,\u201cExcel\u201d)\u00a0 s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 1 v\u00ec n\u00f3 kh\u00f4ng c\u00f3 s\u1ef1 ph\u00e2n bi\u1ec7t gi\u1eefa \u201cE\u201d hay \u201ce\u201d, trong khi \u0111\u00f3 h\u00e0m FIND l\u1ea1i tr\u1ea3 v\u1ec1 4 v\u00ec h\u00e0m n\u00e0y c\u00f3 s\u1ef1 ph\u00e2n bi\u1ec7t gi\u1eefa \u201cE\u201d v\u1edbi \u201ce\u201d.\u00a0<\/span><\/p>\n<h3><b>K\u00fd t\u1ef1 thay th\u1ebf<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Ng\u01b0\u1ee3c l\u1ea1i, h\u00e0m SEARCH cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng c\u00e1c k\u00fd t\u1ef1 thay th\u1ebf trong find_text, c\u00f2n h\u00e0m FIND th\u00ec kh\u00f4ng.<\/span><\/p>\n<figure id=\"attachment_271612\" aria-describedby=\"caption-attachment-271612\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-271612 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-5.jpg\" alt=\"ham-find-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-271612\" class=\"wp-caption-text\">H\u00e0m SEARCH cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng c\u00e1c k\u00fd t\u1ef1 thay th\u1ebf trong find_text, c\u00f2n h\u00e0m FIND th\u00ec kh\u00f4ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Trong h\u00e0m SEARCH:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u1ea5u ch\u1ea5m h\u1ecfi (?) thay th\u1ebf cho 1 k\u00fd t\u1ef1.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u1ea5u sao (*) thay th\u1ebf cho chu\u1ed7i k\u00fd t\u1ef1 b\u1ea5t k\u1ef3.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n c\u1ea7n t\u00ecm m\u1ed9t d\u1ea5u sao (*) hay d\u1ea5u h\u1ecfi (?) trong chu\u1ed7i, b\u1ea1n th\u00eam v\u00e0o tr\u01b0\u1edbc k\u00fd t\u1ef1 \u0111\u00f3 m\u1ed9t d\u1ea5u ng\u00e3 (~).\u00a0<\/span><\/li>\n<\/ul>\n<h2><b>V\u00ed d\u1ee5 v\u1ec1 h\u00e0m FIND v\u00e0 h\u00e0m SEARCH<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Sau khi t\u00ecm hi\u1ec3u c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 s\u1ef1 kh\u00e1c nhau gi\u1eefa h\u00e0m FIND v\u1edbi h\u00e0m SEARCH, ch\u00fang ta s\u1ebd \u0111\u1ebfn v\u1edbi m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 \u0111\u1ec3 n\u1eafm r\u00f5 h\u01a1n v\u1ec1 2 h\u00e0m n\u00e0y:\u00a0<\/span><\/p>\n<h3><b>V\u00ed d\u1ee5 1: T\u00ecm chu\u1ed7i tr\u01b0\u1edbc &#8211; sau 1 k\u00fd t\u1ef1 c\u1ee5 th\u1ec3<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 tr\u00edch t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n \u1edf b\u00ean tr\u00e1i ho\u1eb7c b\u00ean ph\u1ea3i c\u1ee7a m\u1ed9t k\u00fd t\u1ef1 n\u00e0o \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m FIND ho\u1eb7c SEARCH v\u1edbi h\u00e0m LEFT, RIGHT v\u00e0 h\u00e0m LEN.<\/span><\/p>\n<h4><b>H\u00e0m LEFT v\u00e0 RIGHT<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m LEFT: Tr\u00edch xu\u1ea5t 1 s\u1ed1 l\u01b0\u1ee3ng nh\u1ea5t \u0111\u1ecbnh c\u00e1c k\u00fd t\u1ef1 t\u1eeb ph\u00eda b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i. C\u00fa ph\u00e1p: =LEFT(text, num_chars), trong \u0111\u00f3 text l\u00e0 chu\u1ed7i b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 t\u1eeb, c\u00f2n num_chars l\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t t\u1eeb ph\u00eda b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m RIGHT: Tr\u00edch xu\u1ea5t 1 s\u1ed1 l\u01b0\u1ee3ng nh\u1ea5t \u0111\u1ecbnh c\u00e1c k\u00fd t\u1ef1 t\u1eeb ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a chu\u1ed7i. C\u00fa ph\u00e1p: =RIGHT(text, num_chars), trong \u0111\u00f3 text l\u00e0 chu\u1ed7i b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t k\u00fd t\u1ef1 t\u1eeb, c\u00f2n num_chars l\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t t\u1eeb ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a chu\u1ed7i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m LEN: D\u00f9ng \u0111\u1ec3 t\u00ednh chi\u1ec1u d\u00e0i hay s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1. C\u00fa ph\u00e1p: =LEN(text), trong \u0111\u00f3 text l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n t\u00ednh \u0111\u1ed9 d\u00e0i.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-5-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-5-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-5-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273482 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-5-1.jpg\" alt=\"ham-find-5-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-5-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-5-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-5-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h4><b>C\u00e1ch th\u1ef1c hi\u1ec7n<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n nh\u01b0 b\u1ea1n mu\u1ed1n \u0111\u01b0a ph\u1ea7n T\u00ean v\u00e0 H\u1ecd th\u00e0nh c\u00e1c c\u1ed9t ri\u00eang trong b\u1ea3ng t\u00ednh, ta c\u00f3 c\u00fa ph\u00e1p k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m LEFT v\u1edbi h\u00e0m SEARCH ho\u1eb7c h\u00e0m FIND nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=LEFT(A2,FIND(\u201c \u201d,A2)-1)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Hay<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=LEFT(A2,SEARCH(\u201c \u201d,A2)-1)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Khi \u0111\u00f3, c\u00f4ng th\u1ee9c tr\u00ean s\u1ebd tr\u00edch xu\u1ea5t c\u00e1c k\u00fd t\u1ef1 n\u1eb1m \u1edf ph\u00eda b\u00ean tr\u00e1i c\u1ee7a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n n\u1eb1m trong A2 cho \u0111\u1ebfn tr\u01b0\u1edbc khi b\u1eaft g\u1eb7p kho\u1ea3ng tr\u1eafng \u0111\u1ea7u ti\u00ean. \u201c-1\u201d \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 b\u1ea1n kh\u00f4ng mu\u1ed1n trong k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 bao g\u1ed3m c\u1ea3 kho\u1ea3ng tr\u1eafng. V\u00ed d\u1ee5 v\u1edbi t\u00ean Ronnie Anderson, ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 Ronnie.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u00ean tr\u00ean l\u00e0 c\u00e1ch tr\u00edch xu\u1ea5t ph\u1ea7n T\u00ean th\u00e0nh m\u1ed9t c\u1ed9t. Ch\u00fang ta s\u1ebd ti\u1ebfp t\u1ee5c \u0111\u1ebfn v\u1edbi c\u00e1ch tr\u00edch xu\u1ea5t ph\u1ea7n H\u1ecd th\u00e0nh m\u1ed9t c\u1ed9t ri\u00eang v\u1edbi s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a h\u00e0m FIND\/SEARCH, h\u00e0m RIGHT v\u00e0 h\u00e0m LEN.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=RIGHT(A2,LEN(A2)-FIND(\u201d \u201c,A2))<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Hay,<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=RIGHT(A2,LEN(A2)-SEARCH(\u201d \u201c,A2))<\/span><\/p>\n<p><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 minh h\u1ecda:\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-271613 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-6.jpg\" alt=\"ham-find-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>V\u00ed d\u1ee5 2: T\u00ecm s\u1ef1 xu\u1ea5t hi\u1ec7n l\u1ea7n th\u1ee9 n c\u1ee7a 1 k\u00fd t\u1ef1 c\u1ee5 th\u1ec3 trong chu\u1ed7i<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng 1 trong 2 c\u00e1ch sau:\u00a0<\/span><\/p>\n<h4><b>C\u00e1ch 1<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 nh\u01b0 b\u1ea1n \u0111ang c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh v\u1edbi danh s\u00e1ch c\u00e1c SKU v\u00e0 b\u1ea1n c\u1ea7n t\u00ecm ki\u1ebfm v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u g\u1ea1ch (-) n\u1eb1m \u1edf v\u1ecb tr\u00ed th\u1ee9 2 trong chu\u1ed7i, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00fa ph\u00e1p sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=FIND(\u201c-\u201c,A2, FIND(\u201c-\u201c,A2)+1)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3, \u201c-\u201d v\u00e0 A2 \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh d\u1ea5u g\u1ea1ch ngang \u1edf \u00f4 A2, c\u00f2n FIND(\u201c-\u201c,A2)+1 \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ti\u1ebfp t\u1ee5c t\u00ecm l\u1ea7n xu\u1ea5t hi\u1ec7n th\u1ee9 2 c\u1ee7a d\u1ea5u g\u1ea1ch ngang.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">N\u1ebfu mu\u1ed1n t\u00ecm v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n l\u1ea7n th\u1ee9 ba c\u1ee7a d\u1ea5u g\u1ea1ch ngang, b\u1ea1n ti\u1ebfp t\u1ee5c s\u1eed d\u1ee5ng c\u00fa ph\u00e1p sau:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=FIND(\u201c-\u201c,A2, FIND(\u201c-\u201c, A2, FIND(\u201c-\u201c,A2)+1) +2)<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-271614 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-7.jpg\" alt=\"ham-find-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h4><b>C\u00e1ch 2<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng CHAR v\u00e0 SUBSTITUTE \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n l\u1ea7n th\u1ee9 n c\u1ee7a k\u00fd t\u1ef1 n\u00e0o \u0111\u00f3.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m SUBSTITUTE: \u0110\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 thay th\u1ebf cho m\u1ed9t chu\u1ed7i con c\u1ee5 th\u1ec3 b\u1eb1ng m\u1ed9t chu\u1ed7i con kh\u00e1c trong chu\u1ed7i v\u0103n b\u1ea3n. C\u00fa ph\u00e1p =SUBSTITUTE(text,old_text, new_text,[instance_num])<\/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;\">text l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1 con b\u1ea1n c\u1ea7n thay th\u1ebf.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">old_text l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 con m\u00e0 b\u1ea1n mu\u1ed1n thay th\u1ebf.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">new_text l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 con m\u1edbi m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng \u0111\u1ec3 thay th\u1ebf chu\u1ed7i k\u00fd t\u1ef1 con c\u0169.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[instance_num] l\u00e0 tham s\u1ed1 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n c\u1ee5 th\u1ec3 c\u1ee7a old_text m\u00e0 b\u1ea1n mu\u1ed1n thay th\u1ebf. B\u1ecf qua t\u00f9y ch\u1ecdn n\u00e0y, h\u00e0m s\u1ebd thay th\u1ebf t\u1ea5t c\u1ea3 c\u00e1c old_text.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">H\u00e0m CHAR: \u0110\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u00fd t\u1ef1 c\u00f3 m\u00e3 ASCII t\u01b0\u01a1ng \u1ee9ng. C\u00fa ph\u00e1p =CHAR(number), trong \u0111\u00f3 number l\u00e0 s\u1ed1 nguy\u00ean bi\u1ec3u th\u1ecb m\u00e3 ASCII c\u1ee7a k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-7-1.png.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-7-1-300x169.png.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-7-1-768x432.png.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-271623 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-7-1.png\" alt=\"ham-find-7-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-7-1.png 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-7-1-300x169.png 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-7-1-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p c\u00e1c h\u00e0m tr\u00ean v\u1edbi h\u00e0m FIND ho\u1eb7c SEARCH s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=FIND(CHAR(1),SUBSTITUTE(A2,\u201d-\u201c,CHAR(1),3))<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3, SUBSTITUTE(A2,&#8221;-&#8220;,CHAR(1),3) \u0111\u1ec3 thay th\u1ebf cho d\u1ea5u g\u1ea1ch ngang (-) th\u1ee9 3 trong chu\u1ed7i c\u1ee7a \u00f4 A2 v\u1edbi k\u00fd t\u1ef1 c\u00f3 m\u00e3 ASCII l\u00e0 1. Thay th\u1ebf th\u1ee9 3 n\u00e0y \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi tham s\u1ed1 3 cu\u1ed1i c\u00f9ng. H\u00e0m FIND \u1edf \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 c\u00f3 m\u00e3 ASCII l\u00e0 1 trong chu\u1ed7i \u0111\u00e3 \u0111\u01b0\u1ee3c thay th\u1ebf b\u1edfi SUBSTITUTE. Nh\u01b0 v\u1eady, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd cho b\u1ea1n bi\u1ebft v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u g\u1ea1ch ngang th\u1ee9 3 trong chu\u1ed7i \u00f4 A2.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-7.2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-7.2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-7.2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273483 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-7.2.jpg\" alt=\"h\u00e0m-find-7.2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-7.2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-7.2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-7.2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c chung s\u1ebd l\u00e0:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">= FIND(CHAR(1),SUBSTITUTE (\u00f4,k\u00fd t\u1ef1,CHAR(1),l\u1ea7n th\u1ee9 N x\u1ea3y ra)<\/span><\/p>\n<h3><b>V\u00ed d\u1ee5 3: T\u00ecm chu\u1ed7i v\u0103n b\u1ea3n gi\u1eefa c\u00e1c d\u1ea5u ngo\u1eb7c \u0111\u01a1n<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t chu\u1ed7i v\u0103n b\u1ea3n\/k\u00fd t\u1ef1 n\u1eb1m trong d\u1ea5u ngo\u1eb7c \u0111\u01a1n b\u1eb1ng h\u00e0m FIND ho\u1eb7c h\u00e0m SEARCH, b\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p v\u1edbi h\u00e0m MID.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3, h\u00e0m MID \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t ph\u1ea7n c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1 d\u1ef1a tr\u00ean v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean xu\u1ea5t hi\u1ec7n v\u00e0 s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh t\u1eeb tr\u01b0\u1edbc. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m MID l\u00e0 =MID(text, start_num, num_chars).<\/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;\">text: Chu\u1ed7i k\u00fd t\u1ef1 b\u1ea1n c\u1ea7n tr\u00edch xu\u1ea5t.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">start_num: V\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean tr\u00edch xu\u1ea5t chu\u1ed7i k\u00fd t\u1ef1 con, \u0111\u00e2y l\u00e0 m\u1ed9t ch\u1eef s\u1ed1 nguy\u00ean v\u00e0 kh\u00f4ng \u00e2m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">num_chars: S\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t k\u1ec3 t\u1eeb v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean. \u0110\u00e2y c\u0169ng l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean v\u00e0 kh\u00f4ng \u00e2m.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Khi k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m MID v\u1edbi h\u00e0m FIND\/SEARCH, ta c\u00f3:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=MID(A2,SEARCH(\u201c(\u201c,A2)+1, SEARCH(\u201c)\u201d,A2)-SEARCH(\u201c(\u201c,A2)-1)<\/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;\">SEARCH(\u201c)\u201d,A2) d\u00f9ng \u0111\u1ec3 t\u00ecm v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u \u0111\u00f3ng ngo\u1eb7c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">SEARCH(\u201c(\u201c,A2) s\u1ebd x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u m\u1edf ngo\u1eb7c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sau \u0111\u00f3, b\u1ea1n tr\u1eeb \u0111i 1 con s\u1ed1 \u0111\u1ec3 kh\u00f4ng hi\u1ec3n th\u1ecb c\u1ea3 2 d\u1ea5u ngo\u1eb7c trong k\u1ebft qu\u1ea3 v\u1edbi SEARCH(\u201c)\u201d,A2)-SEARCH(\u201c(\u201c,A2))-1<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-find-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-271615 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-8.jpg\" alt=\"ham-find-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e3 gi\u00fap b\u1ea1n n\u1eafm r\u00f5 v\u1ec1 h\u00e0m FIND, h\u00e0m SEARCH, s\u1ef1 kh\u00e1c bi\u1ec7t c\u1ee7a hai h\u00e0m v\u00e0 m\u1ed9t s\u1ed1 b\u00e0i t\u1eadp v\u00ed d\u1ee5. Hy v\u1ecdng b\u00e0i vi\u1ebft s\u1ebd h\u1eefu \u00edch v\u00e0 \u0111\u1eebng qu\u00ean \u0111\u1ec3 l\u1ea1i c\u00e2u h\u1ecfi b\u00ean d\u01b0\u1edbi n\u1ebfu c\u00f3 b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc n\u00e0o nh\u00e9!<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Xem th\u00eam:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/\">H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p<\/a><\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-chuyen-file-excel-sang-pdf\/\">T\u1ed5ng h\u1ee3p c\u00e1c c\u00e1ch chuy\u1ec3n Excel sang PDF \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Ng\u01b0\u1eddi d\u00f9ng Excel th\u01b0\u1eddng c\u00f3 s\u1ef1 nh\u1ea7m l\u1eabn gi\u1eefa h\u00e0m FIND v\u00e0 h\u00e0m SEARCH v\u00ec ch\u1ee9c n\u0103ng c\u1ee7a ch\u00fang kh\u00e1 t\u01b0\u01a1ng \u0111\u1ed3ng v\u1edbi nhau. V\u1eady, h\u00e0m FIND l\u00e0 g\u00ec? H\u00e0m SEARCH l\u00e0 g\u00ec? C\u00f4ng d\u1ee5ng c\u1ee7a m\u1ed7i h\u00e0m l\u00e0 g\u00ec v\u00e0 ch\u00fang kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile kh\u00e1m ph\u00e1 qua [&hellip;]<\/p>\n","protected":false},"author":97,"featured_media":271607,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-271308","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m FIND v\u00e0 SEARCH trong Excel v\u1edbi c\u00e1c v\u00ed d\u1ee5 chi ti\u1ebft<\/title>\n<meta name=\"description\" content=\"Ng\u01b0\u1eddi d\u00f9ng Excel th\u01b0\u1eddng c\u00f3 s\u1ef1 nh\u1ea7m l\u1eabn gi\u1eefa h\u00e0m FIND v\u00e0 h\u00e0m SEARCH. V\u1eady, ch\u00fang kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u t\u1ea1i \u0111\u00e2y!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m FIND v\u00e0 SEARCH trong Excel v\u1edbi c\u00e1c v\u00ed d\u1ee5 chi ti\u1ebft\" \/>\n<meta property=\"og:description\" content=\"Ng\u01b0\u1eddi d\u00f9ng Excel th\u01b0\u1eddng c\u00f3 s\u1ef1 nh\u1ea7m l\u1eabn gi\u1eefa h\u00e0m FIND v\u00e0 h\u00e0m SEARCH. V\u1eady, ch\u00fang kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u t\u1ea1i \u0111\u00e2y!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-19T07:47:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find.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=\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\" \/>\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=\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8bdc637e22d0dfe8143434576119c189\"},\"headline\":\"H\u00e0m FIND v\u00e0 SEARCH trong Excel v\u1edbi c\u00e1c v\u00ed d\u1ee5 chi ti\u1ebft\",\"datePublished\":\"2023-10-19T07:47:19+00:00\",\"dateModified\":\"2023-10-19T07:47:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/\"},\"wordCount\":2979,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/\",\"name\":\"H\u00e0m FIND v\u00e0 SEARCH trong Excel v\u1edbi c\u00e1c v\u00ed d\u1ee5 chi ti\u1ebft\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find.jpg\",\"datePublished\":\"2023-10-19T07:47:19+00:00\",\"dateModified\":\"2023-10-19T07:47:19+00:00\",\"description\":\"Ng\u01b0\u1eddi d\u00f9ng Excel th\u01b0\u1eddng c\u00f3 s\u1ef1 nh\u1ea7m l\u1eabn gi\u1eefa h\u00e0m FIND v\u00e0 h\u00e0m SEARCH. V\u1eady, ch\u00fang kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u t\u1ea1i \u0111\u00e2y!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-find\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"H\u00e0m FIND v\u00e0 SEARCH trong Excel v\u1edbi c\u00e1c v\u00ed d\u1ee5 chi ti\u1ebft\"}]},{\"@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\/8bdc637e22d0dfe8143434576119c189\",\"name\":\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/74bcebffab89aeb362901537cb11326b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/74bcebffab89aeb362901537cb11326b?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-my-lien\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m FIND v\u00e0 SEARCH trong Excel v\u1edbi c\u00e1c v\u00ed d\u1ee5 chi ti\u1ebft","description":"Ng\u01b0\u1eddi d\u00f9ng Excel th\u01b0\u1eddng c\u00f3 s\u1ef1 nh\u1ea7m l\u1eabn gi\u1eefa h\u00e0m FIND v\u00e0 h\u00e0m SEARCH. V\u1eady, ch\u00fang kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u t\u1ea1i \u0111\u00e2y!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m FIND v\u00e0 SEARCH trong Excel v\u1edbi c\u00e1c v\u00ed d\u1ee5 chi ti\u1ebft","og_description":"Ng\u01b0\u1eddi d\u00f9ng Excel th\u01b0\u1eddng c\u00f3 s\u1ef1 nh\u1ea7m l\u1eabn gi\u1eefa h\u00e0m FIND v\u00e0 h\u00e0m SEARCH. V\u1eady, ch\u00fang kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u t\u1ea1i \u0111\u00e2y!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-10-19T07:47:19+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/"},"author":{"name":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8bdc637e22d0dfe8143434576119c189"},"headline":"H\u00e0m FIND v\u00e0 SEARCH trong Excel v\u1edbi c\u00e1c v\u00ed d\u1ee5 chi ti\u1ebft","datePublished":"2023-10-19T07:47:19+00:00","dateModified":"2023-10-19T07:47:19+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/"},"wordCount":2979,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/","name":"H\u00e0m FIND v\u00e0 SEARCH trong Excel v\u1edbi c\u00e1c v\u00ed d\u1ee5 chi ti\u1ebft","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find.jpg","datePublished":"2023-10-19T07:47:19+00:00","dateModified":"2023-10-19T07:47:19+00:00","description":"Ng\u01b0\u1eddi d\u00f9ng Excel th\u01b0\u1eddng c\u00f3 s\u1ef1 nh\u1ea7m l\u1eabn gi\u1eefa h\u00e0m FIND v\u00e0 h\u00e0m SEARCH. V\u1eady, ch\u00fang kh\u00e1c nhau nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u t\u1ea1i \u0111\u00e2y!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-find.jpg","width":1200,"height":628,"caption":"ham-find"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"H\u00e0m FIND v\u00e0 SEARCH trong Excel v\u1edbi c\u00e1c v\u00ed d\u1ee5 chi ti\u1ebft"}]},{"@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\/8bdc637e22d0dfe8143434576119c189","name":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/74bcebffab89aeb362901537cb11326b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/74bcebffab89aeb362901537cb11326b?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-my-lien\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/271308","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\/97"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=271308"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/271308\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/271607"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=271308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=271308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=271308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}