{"id":10901,"date":"2025-01-15T00:33:48","date_gmt":"2025-01-15T00:33:48","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-sua-loi-value-khi-su-dung-ham-concatenate-trong-excel\/"},"modified":"2025-01-15T00:33:48","modified_gmt":"2025-01-15T00:33:48","slug":"cach-sua-loi-value-khi-su-dung-ham-concatenate-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-sua-loi-value-khi-su-dung-ham-concatenate-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eeda l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m CONCATENATE trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6787026bae8b7\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-loi-value-khi-su-dung-ham-concatenate-trong-excel.html#Nguyen_nhan_gay_ra_loi_VALUE_khi_su_dung_ham_CONCATENATE\" title=\"Nguy\u00ean nh\u00e2n g\u00e2y ra l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m CONCATENATE\">Nguy\u00ean nh\u00e2n g\u00e2y ra l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m CONCATENATE<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-loi-value-khi-su-dung-ham-concatenate-trong-excel.html#Cach_khac_phuc_loi_VALUE_khi_su_dung_ham_CONCATENATE\" title=\"C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m CONCATENATE\">C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m CONCATENATE<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-loi-value-khi-su-dung-ham-concatenate-trong-excel.html#Luu_y_khi_su_dung_ham_CONCATENATE_trong_Excel\" title=\"L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m CONCATENATE trong Excel\">L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m CONCATENATE trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Nguyen_nhan_gay_ra_loi_VALUE_khi_su_dung_ham_CONCATENATE\"><\/span>Nguy\u00ean nh\u00e2n g\u00e2y ra <a href=\"http:\/\/blog.ezworkapp.com\/cach-sua-loi-value-khi-su-dung-ham-concatenate-trong-excel.html\" target=\"_blank\">l\u1ed7i #VALUE<\/a>! khi <a href=\"http:\/\/blog.ezworkapp.com\/cach-sua-loi-value-khi-su-dung-ham-concatenate-trong-excel.html\" target=\"_blank\">s\u1eed d\u1ee5ng h\u00e0m CONCATENATE<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t trong nh\u1eefng nguy\u00ean nh\u00e2n th\u01b0\u1eddng g\u1eb7p nh\u1ea5t g\u00e2y ra l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m CONCATENATE l\u00e0 trong v\u00f9ng \u0111\u01b0\u1ee3c n\u1ed1i chu\u1ed7i c\u00f3 ch\u1ee9a \u00f4 c\u00f3 gi\u00e1 tr\u1ecb #VALUE! nh\u01b0 trong v\u00ed d\u1ee5 minh ho\u1ea1 sau \u0111\u00e2y:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/cach-sua-loi-value-khi-dung-ham-concatenate-trong-excel-02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11562\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-sua-loi-value-khi-dung-ham-concatenate-trong-excel-02.png\" alt=\"cach-sua-loi-value-khi-dung-ham-concatenate-trong-excel-02\" width=\"409\" height=\"185\" title=\"cach-sua-loi-value-khi-dung-ham-concatenate-trong-excel-02\"><\/a><\/p>\n<p>\u1ede trong v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 ph\u00eda tr\u00ean, \u00f4 E2 c\u00f3 ch\u1ee9a l\u1ed7i #VALUE! v\u1eady n\u00ean k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m CONCATENATE c\u0169ng v\u00ec l\u00fd do \u0111\u00f3 m\u00e0 b\u1ecb l\u1ed7i #VALUE!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_khac_phuc_loi_VALUE_khi_su_dung_ham_CONCATENATE\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/cach-sua-loi-value-khi-su-dung-ham-concatenate-trong-excel.html\" target=\"_blank\">C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m CONCATENATE<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i #VALUE! trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eeda c\u00f4ng th\u1ee9c l\u1ea1i nh\u01b0 sau:<\/p>\n<p><strong>=IF(ISERROR(E2),CONCATENATE(D2,\u201d \u201c,0,\u201d \u201c,F2))<\/strong><\/p>\n<p>V\u1edbi c\u00f4ng th\u1ee9c n\u00e0y, h\u00e0m ISERROR s\u1ebd x\u00e1c \u0111\u1ecbnh E2 c\u00f3 ph\u1ea3i l\u00e0 \u00f4 b\u1ecb l\u1ed7i hay kh\u00f4ng, n\u1ebfu kh\u00f4ng b\u1ecb l\u1ed7i th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd c\u00f3 \u00fd ngh\u0129a h\u01a1n l\u00e0 m\u1ed9t l\u1ed7i #VALUE! nh\u01b0 c\u00e1c b\u1ea1n nh\u00ecn th\u1ea5y \u1edf ph\u00eda tr\u00ean.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Luu_y_khi_su_dung_ham_CONCATENATE_trong_Excel\"><\/span>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m CONCATENATE trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t l\u01b0u \u00fd quan tr\u1ecdng khi b\u1ea1n \u0111ang \u0111\u1ecdc b\u00e0i n\u00e0y: K\u1ec3 t\u1eeb phi\u00ean b\u1ea3n Excel 2016, Microsoft \u0111\u00e3 th\u00eam<a href=\"http:\/\/blog.ezworkapp.com\/ghep-noi-ky-tu-voi-ham-concat-va-textjoin-trong-excel.html\" target=\"_blank\"> h\u00e0m CONCAT<\/a> v\u1edbi t\u00ednh n\u0103ng \u01b0u vi\u1ec7t h\u01a1n h\u00e0m CONCATENATE nhi\u1ec1u. H\u00e0m CONCATENATE ch\u1ec9 t\u1ed3n t\u1ea1i v\u1edbi m\u1ee5c \u0111\u00edch \u201ct\u01b0\u01a1ng th\u00edch ng\u01b0\u1ee3c\u201d cho c\u00e1c phi\u00ean b\u1ea3n Excel c\u0169 h\u01a1n. \u0110\u1ec3 tham kh\u1ea3o c\u00e1c h\u00e0m m\u1edbi trong phi\u00ean b\u1ea3n Excel 2016, b\u1ea1n click v\u00e0o link n\u00e0y:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-238.gif\" title=\"ex101_92019-nho-238\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><a href=\"https:\/\/blog.hocexcel.online\/cac-ham-tinh-moi-trong-excel-2016.html\" target=\"_blank\">C\u00e1c h\u00e0m m\u1edbi trong Excel 2016<\/a><\/p>\n<p>\u00a0<\/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":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-238.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10902,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10901","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10901","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=10901"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10901\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10902"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}