{"id":8546,"date":"2024-12-22T14:50:15","date_gmt":"2024-12-22T14:50:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/iban-checker-kiem-tra-ma-iban-hop-le-trong-excel\/"},"modified":"2024-12-22T14:50:15","modified_gmt":"2024-12-22T14:50:15","slug":"iban-checker-kiem-tra-ma-iban-hop-le-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/iban-checker-kiem-tra-ma-iban-hop-le-trong-excel\/","title":{"rendered":"IBAN Checker \u2013 Ki\u1ec3m tra m\u00e3 IBAN h\u1ee3p l\u1ec7 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<figure id=\"attachment_532\" aria-describedby=\"caption-attachment-532\" style=\"width: 678px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-532 size-full\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%20678%20308'%3E%3C\/svg%3E\" alt=\"IBan Checker\" width=\"678\" height=\"308\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/iban-checker.png 678w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/07\/IBan-Checker-600x273.png 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/07\/IBan-Checker-300x136.png 300w\" data-lazy-sizes=\"(max-width: 678px) 100vw, 678px\" data-lazy-src=\"\/wp-content\/uploads\/2016\/07\/IBan-Checker.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-532 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/iban-checker.png\" alt=\"IBan Checker\" width=\"678\" height=\"308\" title=\"iban-checker\"><figcaption id=\"caption-attachment-532\" class=\"wp-caption-text\">IBan Checker<\/figcaption><\/figure>\n<p>K\u1ec3 t\u1eeb n\u0103m 2014 tr\u1edf \u0111i, theo chu\u1ea9n chung c\u1ee7a ch\u00e2u \u00c2u, <a href=\"https:\/\/en.wikipedia.org\/wiki\/International_Bank_Account_Number\">IBAN<\/a>\u00a0(<strong>I<\/strong>nternational <strong>B<\/strong>ank <strong>A<\/strong>ccount <strong>N<\/strong>umber)s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c giao d\u1ecbch ng\u00e2n h\u00e0ng \u0111\u1ec3 t\u0103ng hi\u1ec7u qu\u1ea3 trong vi\u1ec7c chi tr\u1ea3 trong c\u1ed9ng \u0111\u1ed3ng chung ch\u00e2u \u00c2u. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n m\u1ed9t ti\u1ec7n \u00edch nho nh\u1ecf trong Excel \u0111\u1ec3 c\u00f3 th\u1ec3 ki\u1ec3m tra xem m\u00e3 IBAN m\u00e0 b\u1ea1n s\u1ebd chuy\u1ec3n ti\u1ec1n c\u00f3 \u0111\u00fang chu\u1ea9n v\u00e0 h\u1ee3p l\u1ec7 hay kh\u00f4ng.<\/p>\n<p>C\u00e1ch d\u00f9ng: download file v\u00e0 s\u1eed d\u1ee5ng h\u00e0m UDF <strong>=VALIDATEIBAN(&lt;iban&gt;)<\/strong><\/p>\n<p>Download file \u1edf ph\u1ea7n d\u01b0\u1edbi.<\/p>\n<p>\u00a0<\/p>\n<p>[sociallocker id=457]<a href=\"http:\/\/bit.ly\/dtnIBANChecker\">Download<\/a>[\/sociallocker]<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>IBan Checker K\u1ec3 t\u1eeb n\u0103m 2014 tr\u1edf \u0111i, theo chu\u1ea9n chung c\u1ee7a ch\u00e2u \u00c2u, IBAN\u00a0(International..<\/p>\n","protected":false},"author":1,"featured_media":8547,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8546","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8546","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8546"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8546\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8547"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8546"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8546"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}