{"id":34484,"date":"2022-04-12T15:04:11","date_gmt":"2022-04-12T08:04:11","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=34484"},"modified":"2022-04-12T15:04:11","modified_gmt":"2022-04-12T08:04:11","slug":"bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/","title":{"rendered":"B\u1eadt m\u00ed ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m thay th\u1ebf trong Excel hi\u1ec7u qu\u1ea3, ti\u1ec7n l\u1ee3i khi x\u1eed l\u00fd t\u00e0i li\u1ec7u"},"content":{"rendered":"<div class=\"content-inner\">\n<p><strong>B\u1ea1n \u0111ang m\u1ec7t m\u1ecfi, lo l\u1eafng khi ph\u1ea3i thay th\u1ebf m\u1ed9t v\u00e0i k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t ph\u1ea7n n\u1ed9i dung chu\u1ed7i v\u0103n b\u1ea3n trong Excel nh\u01b0ng file d\u1eef li\u1ec7u \u0111\u00f3 qu\u00e1 l\u1edbn, khi\u1ebfn b\u1ea1n m\u1ea5t nhi\u1ec1u th\u1eddi gian, c\u00f4ng s\u1ee9c \u0111\u1ec3 ch\u1ec9nh s\u1eeda. <\/strong><\/p>\n<p><span style=\"font-weight: 400\">Do \u0111\u00f3, b\u00e0i vi\u1ebft d\u01b0\u1edbi d\u00e2y Divine Shop s\u1ebd m\u00e1ch b\u1ea1n b\u00ed k\u00edp s\u1eed d\u1ee5ng h\u00e0m thay th\u1ebf trong Excel v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c th\u1eddi gian, n\u00e2ng cao hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c. H\u00e3y ti\u1ebfp t\u1ee5c theo d\u00f5i nh\u00e9! <img loading=\"lazy\" class=\"aligncenter size-full wp-image-547121\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu_623985b44c51a.jpeg\" alt=\"B\u1eadt m\u00ed ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m thay th\u1ebf trong Excel hi\u1ec7u qu\u1ea3, ti\u1ec7n l\u1ee3i khi x\u1eed l\u00fd t\u00e0i li\u1ec7u\" width=\"2000\" height=\"1125\" \/><\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy counter-decimal ez-toc-grey\">\n<h2><span class=\"ez-toc-section\" id=\"Ham_thay_the_trong_Excel_la_gi\"><\/span><span id=\"Ham_thay_the_trong_Excel_la_gi\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><b>H\u00e0m thay th\u1ebf trong Excel l\u00e0 g\u00ec?\u00a0<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><strong>H\u00e0m thay th\u1ebf trong Excel<\/strong>, hay c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 h\u00e0m <strong>REPLACE<\/strong>, \u0111\u00e2y l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 thay \u0111\u1ed5i m\u1ed9t ho\u1eb7c nhi\u1ec1u k\u00fd t\u1ef1 trong chu\u1ed7i v\u0103n b\u1ea3n c\u0169 th\u00e0nh m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n m\u1edbi.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u00e0m REPLACE, c\u00f3 c\u00fa ph\u00e1p: <\/span><b>=REPLACE (old_text, start_num, num_chars, new_text)\u00a0<\/b><\/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\"><em>old_text<\/em>: K\u00fd t\u1ef1 ho\u1eb7c v\u0103n b\u1ea3n c\u1ea7n thay th\u1ebf, chuy\u1ec3n \u0111\u1ed5i.\u00a0\u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><em>start_num<\/em>: V\u1ecb tr\u00ed c\u1ee7a k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong \u0111o\u1ea1n v\u0103n b\u1ea3n c\u1ea7n thay th\u1ebf, t\u00ednh t\u1eeb b\u00ean tr\u00e1i sang.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><em>num_chars<\/em>: S\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 m\u00e0 b\u1ea1n c\u1ea7n thay \u0111\u1ed5i.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><em>new_text<\/em>: K\u00fd t\u1ef1 ho\u1eb7c v\u0103n b\u1ea3n m\u1edbi \u0111\u1ec3 thay \u0111\u1ed5i cho k\u00fd t\u1ef1 ho\u1eb7c v\u0103n b\u1ea3n g\u1ed1c. <\/span><b>\u00a0<\/b><\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-547118\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu_623985b87d6f6.jpeg\" alt=\"H\u00e0m thay th\u1ebf trong Excel l\u00e0 g\u00ec?\u00a0\" width=\"2000\" height=\"1125\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_chi_tiet_cach_dung_ham_thay_the_trong_Excel\"><\/span><span id=\"Huong_dan_chi_tiet_cach_dung_ham_thay_the_trong_Excel\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><b>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch d\u00f9ng h\u00e0m thay th\u1ebf trong Excel\u00a0<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 c\u00f3 th\u1ec3 hi\u1ec3u r\u00f5 \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m REPLACE trong Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 ti\u1ebfp theo d\u01b0\u1edbi \u0111\u00e2y Divine Shop s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n m\u1ed9t v\u00e0i v\u00ed d\u1ee5 thay th\u1ebf ph\u1ed5 bi\u1ebfn trong Excel nh\u00e9:\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_1_Thay_the_mot_ky_tu_bat_ky_co_trong_van_ban\"><\/span><span id=\"Cach_1_Thay_the_mot_ky_tu_bat_ky_co_trong_van_ban\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 14pt\"><strong>C\u00e1ch 1: Thay th\u1ebf m\u1ed9t k\u00fd t\u1ef1 b\u1ea5t k\u1ef3 c\u00f3 trong v\u0103n b\u1ea3n.\u00a0<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n s\u1ebd th\u1ef1c hi\u1ec7n \u0111\u1ed5i s\u1ea3n ph\u1ea9m<em> AirPods 2<\/em> th\u00e0nh <em>AirPods 3<\/em>. T\u1ea1i \u00f4 c\u00f4ng th\u1ee9c b\u1ea1n h\u00e3y nh\u1eadp nh\u01b0 sau: <\/span><b>=REPLACE(A2;9;1;3).\u00a0<\/b><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-547115\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu_623985bed3b70.jpeg\" alt=\"C\u00e1ch 1: Thay th\u1ebf m\u1ed9t k\u00fd t\u1ef1 b\u1ea5t k\u1ef3 c\u00f3 trong v\u0103n b\u1ea3n\" width=\"2000\" height=\"1125\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_2_Su_dung_long_ghep_ham_tim_kiem_FIND_va_ham_REPLACE\"><\/span><span id=\"Cach_2_Su_dung_long_ghep_ham_tim_kiem_FIND_va_ham_REPLACE\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 14pt\"><strong>C\u00e1ch 2: S\u1eed d\u1ee5ng l\u1ed3ng gh\u00e9p h\u00e0m t\u00ecm ki\u1ebfm FIND v\u00e0 h\u00e0m REPLACE<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">N\u1ebfu nh\u01b0 b\u1ea1n g\u1eb7p ph\u1ea3i m\u1ed9t \u0111o\u1ea1n n\u1ed9i dung d\u00e0i v\u00e0 c\u1ea7n thay \u0111\u1ed5i m\u1ed9t ph\u1ea7n k\u00fd t\u1ef1 trong \u0111\u00f3 th\u00ec b\u1ea1n h\u00e3y l\u1ed3ng gh\u00e9p 2 h\u00e0m FIND v\u00e0 REPLACE v\u1edbi nhau \u0111\u1ec3 t\u1ed1i \u01b0u \u0111\u01b0\u1ee3c th\u1eddi gian nh\u00e9. V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, \u0111\u00f3 l\u00e0 b\u1ea1n h\u00e3y thay \u0111\u1ed5i <\/span><i><span style=\"font-weight: 400\">iPhone Xs Max 256GB<\/span><\/i><span style=\"font-weight: 400\"> th\u00e0nh <\/span><i><span style=\"font-weight: 400\">iPhone Xs Max 64GB. <\/span><\/i><span style=\"font-weight: 400\">B\u1ea1n h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y: <\/span><b>=REPLACE(A3;FIND(256;A3;3);3;64)<\/b><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-547116\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu_623985c965492.jpeg\" alt=\"C\u00e1ch 2: S\u1eed d\u1ee5ng l\u1ed3ng gh\u00e9p h\u00e0m t\u00ecm ki\u1ebfm FIND v\u00e0 h\u00e0m REPLACE\" width=\"2000\" height=\"1125\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_3_Su_dung_2_ham_REPLACE_de_chuyen_doi_dinh_dang_cho_so_dien_thoai\"><\/span><span id=\"Cach_3_Su_dung_2_ham_REPLACE_de_chuyen_doi_dinh_dang_cho_so_dien_thoai\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 14pt\"><strong>C\u00e1ch 3: S\u1eed d\u1ee5ng 2 h\u00e0m REPLACE \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng cho s\u1ed1 \u0111i\u1ec7n tho\u1ea1i.\u00a0<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch d\u00f9ng h\u00e0m REPLACE 2 l\u1ea7n \u0111\u1ec3 ch\u00e8n d\u1ea5u \u201c.\u201d v\u00e0o \u0111\u1ec3 ng\u0103n c\u00e1ch s\u1ed1. C\u00fa ph\u00e1p nh\u01b0 sau: =<\/span><b>REPLACE(REPLACE(B2;5;0;\u201d.\u201d);9;0;\u201d.\u201d)<\/b><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-547117\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu_623985d34965b.jpeg\" alt=\"C\u00e1ch 3: S\u1eed d\u1ee5ng 2 h\u00e0m REPLACE \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng cho s\u1ed1 \u0111i\u1ec7n tho\u1ea1i\" width=\"2000\" height=\"1125\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tam_ket\"><\/span><span id=\"Tam_ket\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><b>T\u1ea1m k\u1ebft\u00a0<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Qua b\u00e0i vi\u1ebft tr\u00ean, Divine Shop \u0111\u00e3 gi\u1edbi thi\u1ec7u v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 thay \u0111\u1ed5i k\u00fd t\u1ef1 trong Excel gi\u00fap b\u1ea1n x\u1eed l\u00fd t\u00e0i li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 nhanh ch\u00f3ng h\u01a1n. Hy v\u1ecdng r\u1eb1ng v\u1edbi nh\u1eefng v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh tr\u00ean \u0111\u00e2y s\u1ebd l\u00e0 ngu\u1ed3n tham kh\u1ea3o h\u1eefu \u00edch d\u00e0nh cho b\u1ea1n. Ch\u00fac b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng.\u00a0<\/span><\/p>\n<p><em><strong>\u00a0<\/strong><\/em><\/p>\n<p style=\"text-align: center\">\u00a0<\/p>\n<\/div>\n<\/div>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/divineshop.vn\/search?q=h%E1%BB%8Dc+t%E1%BA%ADp\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap.png\" alt=\"\" class=\"wp-image-285219\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/12\/Hoc-tap-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<!--nextpage-->\n\n\n\n<div class=\"wp-container-69e57a2d98384 wp-block-group\"><div class=\"wp-block-group__inner-container\"><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n \u0111ang m\u1ec7t m\u1ecfi, lo l\u1eafng khi ph\u1ea3i thay th\u1ebf m\u1ed9t v\u00e0i k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t ph\u1ea7n n\u1ed9i dung chu\u1ed7i v\u0103n b\u1ea3n trong Excel nh\u01b0ng file d\u1eef li\u1ec7u \u0111\u00f3 qu\u00e1 l\u1edbn, khi\u1ebfn b\u1ea1n m\u1ea5t nhi\u1ec1u th\u1eddi gian, c\u00f4ng s\u1ee9c \u0111\u1ec3 ch\u1ec9nh s\u1eeda. Do \u0111\u00f3, b\u00e0i vi\u1ebft d\u01b0\u1edbi d\u00e2y Divine Shop s\u1ebd m\u00e1ch b\u1ea1n b\u00ed k\u00edp [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":34485,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[216],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.1 (Yoast SEO v18.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"B\u1ea1n \u0111ang m\u1ec7t m\u1ecfi, lo l\u1eafng khi ph\u1ea3i thay th\u1ebf m\u1ed9t v\u00e0i k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t ph\u1ea7n n\u1ed9i dung chu\u1ed7i v\u0103n b\u1ea3n trong Excel nh\u01b0ng file d\u1eef li\u1ec7u \u0111\u00f3 qu\u00e1 l\u1edbn, khi\u1ebfn b\u1ea1n m\u1ea5t\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"B\u1eadt m\u00ed ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m thay th\u1ebf trong Excel hi\u1ec7u qu\u1ea3, ti\u1ec7n l\u1ee3i khi x\u1eed l\u00fd t\u00e0i li\u1ec7u\" \/>\n<meta property=\"og:description\" content=\"B\u1ea1n \u0111ang m\u1ec7t m\u1ecfi, lo l\u1eafng khi ph\u1ea3i thay th\u1ebf m\u1ed9t v\u00e0i k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t ph\u1ea7n n\u1ed9i dung chu\u1ed7i v\u0103n b\u1ea3n trong Excel nh\u01b0ng file d\u1eef li\u1ec7u \u0111\u00f3 qu\u00e1 l\u1edbn, khi\u1ebfn b\u1ea1n m\u1ea5t\" \/>\n<meta property=\"og:url\" content=\"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/\" \/>\n<meta property=\"og:site_name\" content=\"Divine News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/divineshop.vn\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-12T08:04:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu_623985b0adf46.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"2000\" \/>\n\t<meta property=\"og:image:height\" content=\"1125\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CTV\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\",\"name\":\"Divine News\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/divineshop.vn\",\"https:\/\/www.instagram.com\/divineshop.game\/\",\"https:\/\/www.youtube.com\/DivineTVN\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"width\":960,\"height\":960,\"caption\":\"Divine News\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"name\":\"Divine News\",\"description\":\"Tin hay m\u1ed7i ng\u00e0y\",\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu_623985b0adf46.jpeg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu_623985b0adf46.jpeg\",\"width\":2000,\"height\":1125},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#webpage\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/\",\"name\":\"B\u1eadt m\u00ed ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m thay th\u1ebf trong Excel hi\u1ec7u qu\u1ea3, ti\u1ec7n l\u1ee3i khi x\u1eed l\u00fd t\u00e0i li\u1ec7u - Divine News\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#primaryimage\"},\"datePublished\":\"2022-04-12T08:04:11+00:00\",\"dateModified\":\"2022-04-12T08:04:11+00:00\",\"description\":\"B\u1ea1n \u0111ang m\u1ec7t m\u1ecfi, lo l\u1eafng khi ph\u1ea3i thay th\u1ebf m\u1ed9t v\u00e0i k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t ph\u1ea7n n\u1ed9i dung chu\u1ed7i v\u0103n b\u1ea3n trong Excel nh\u01b0ng file d\u1eef li\u1ec7u \u0111\u00f3 qu\u00e1 l\u1edbn, khi\u1ebfn b\u1ea1n m\u1ea5t\",\"breadcrumb\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/divineshop.vn\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"B\u1eadt m\u00ed ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m thay th\u1ebf trong Excel hi\u1ec7u qu\u1ea3, ti\u1ec7n l\u1ee3i khi x\u1eed l\u00fd t\u00e0i li\u1ec7u\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#webpage\"},\"author\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\"},\"headline\":\"B\u1eadt m\u00ed ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m thay th\u1ebf trong Excel hi\u1ec7u qu\u1ea3, ti\u1ec7n l\u1ee3i khi x\u1eed l\u00fd t\u00e0i li\u1ec7u\",\"datePublished\":\"2022-04-12T08:04:11+00:00\",\"dateModified\":\"2022-04-12T08:04:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#webpage\"},\"wordCount\":727,\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu_623985b0adf46.jpeg\",\"keywords\":[\"excel\"],\"articleSection\":[\"M\u1eb8O HAY\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2022\",\"copyrightHolder\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\",\"name\":\"CTV\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"caption\":\"CTV\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"description":"B\u1ea1n \u0111ang m\u1ec7t m\u1ecfi, lo l\u1eafng khi ph\u1ea3i thay th\u1ebf m\u1ed9t v\u00e0i k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t ph\u1ea7n n\u1ed9i dung chu\u1ed7i v\u0103n b\u1ea3n trong Excel nh\u01b0ng file d\u1eef li\u1ec7u \u0111\u00f3 qu\u00e1 l\u1edbn, khi\u1ebfn b\u1ea1n m\u1ea5t","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/","og_locale":"vi_VN","og_type":"article","og_title":"B\u1eadt m\u00ed ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m thay th\u1ebf trong Excel hi\u1ec7u qu\u1ea3, ti\u1ec7n l\u1ee3i khi x\u1eed l\u00fd t\u00e0i li\u1ec7u","og_description":"B\u1ea1n \u0111ang m\u1ec7t m\u1ecfi, lo l\u1eafng khi ph\u1ea3i thay th\u1ebf m\u1ed9t v\u00e0i k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t ph\u1ea7n n\u1ed9i dung chu\u1ed7i v\u0103n b\u1ea3n trong Excel nh\u01b0ng file d\u1eef li\u1ec7u \u0111\u00f3 qu\u00e1 l\u1edbn, khi\u1ebfn b\u1ea1n m\u1ea5t","og_url":"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/","og_site_name":"Divine News","article_publisher":"https:\/\/www.facebook.com\/divineshop.vn","article_published_time":"2022-04-12T08:04:11+00:00","og_image":[{"width":2000,"height":1125,"url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu_623985b0adf46.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"CTV","Est. reading time":"4 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization","name":"Divine News","url":"https:\/\/divineshop.vn\/tin-tuc\/","sameAs":["https:\/\/www.facebook.com\/divineshop.vn","https:\/\/www.instagram.com\/divineshop.game\/","https:\/\/www.youtube.com\/DivineTVN"],"logo":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","width":960,"height":960,"caption":"Divine News"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo"}},{"@type":"WebSite","@id":"https:\/\/divineshop.vn\/tin-tuc\/#website","url":"https:\/\/divineshop.vn\/tin-tuc\/","name":"Divine News","description":"Tin hay m\u1ed7i ng\u00e0y","publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#primaryimage","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu_623985b0adf46.jpeg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu_623985b0adf46.jpeg","width":2000,"height":1125},{"@type":"WebPage","@id":"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#webpage","url":"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/","name":"B\u1eadt m\u00ed ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m thay th\u1ebf trong Excel hi\u1ec7u qu\u1ea3, ti\u1ec7n l\u1ee3i khi x\u1eed l\u00fd t\u00e0i li\u1ec7u - Divine News","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#primaryimage"},"datePublished":"2022-04-12T08:04:11+00:00","dateModified":"2022-04-12T08:04:11+00:00","description":"B\u1ea1n \u0111ang m\u1ec7t m\u1ecfi, lo l\u1eafng khi ph\u1ea3i thay th\u1ebf m\u1ed9t v\u00e0i k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t ph\u1ea7n n\u1ed9i dung chu\u1ed7i v\u0103n b\u1ea3n trong Excel nh\u01b0ng file d\u1eef li\u1ec7u \u0111\u00f3 qu\u00e1 l\u1edbn, khi\u1ebfn b\u1ea1n m\u1ea5t","breadcrumb":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/divineshop.vn\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"B\u1eadt m\u00ed ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m thay th\u1ebf trong Excel hi\u1ec7u qu\u1ea3, ti\u1ec7n l\u1ee3i khi x\u1eed l\u00fd t\u00e0i li\u1ec7u"}]},{"@type":"Article","@id":"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#article","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#webpage"},"author":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a"},"headline":"B\u1eadt m\u00ed ngay c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m thay th\u1ebf trong Excel hi\u1ec7u qu\u1ea3, ti\u1ec7n l\u1ee3i khi x\u1eed l\u00fd t\u00e0i li\u1ec7u","datePublished":"2022-04-12T08:04:11+00:00","dateModified":"2022-04-12T08:04:11+00:00","mainEntityOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#webpage"},"wordCount":727,"publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu\/#primaryimage"},"thumbnailUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/bat-mi-ngay-cach-su-dung-ham-thay-the-trong-excel-hieu-qua-tien-loi-khi-xu-ly-tai-lieu_623985b0adf46.jpeg","keywords":["excel"],"articleSection":["M\u1eb8O HAY"],"inLanguage":"vi","copyrightYear":"2022","copyrightHolder":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"}},{"@type":"Person","@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a","name":"CTV","image":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#personlogo","inLanguage":"vi","url":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","caption":"CTV"}}]}},"_links":{"self":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/34484"}],"collection":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=34484"}],"version-history":[{"count":2,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/34484\/revisions"}],"predecessor-version":[{"id":73029,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/34484\/revisions\/73029"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/34485"}],"wp:attachment":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=34484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=34484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=34484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}