{"id":11358,"date":"2025-01-15T02:42:01","date_gmt":"2025-01-15T02:42:01","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/hop-nhat-va-ket-hop-nhieu-cot-ma-khong-lam-mat-du-lieu-trong-excel\/"},"modified":"2025-01-15T02:42:01","modified_gmt":"2025-01-15T02:42:01","slug":"hop-nhat-va-ket-hop-nhieu-cot-ma-khong-lam-mat-du-lieu-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/hop-nhat-va-ket-hop-nhieu-cot-ma-khong-lam-mat-du-lieu-trong-excel\/","title":{"rendered":"H\u1ee3p nh\u1ea5t v\u00e0 k\u1ebft h\u1ee3p nhi\u1ec1u c\u1ed9t m\u00e0 kh\u00f4ng l\u00e0m m\u1ea5t d\u1eef li\u1ec7u trong Excel"},"content":{"rendered":"
\n

N\u1ebfu b\u1ea1n h\u1ee3p nh\u1ea5t nhi\u1ec1u c\u1ed9t trong b\u1ea5t k\u1ef3 phi\u00ean b\u1ea3n Excel n\u00e0o b\u1eb1ng l\u1ec7nh Merge and Center<\/em><\/strong> trong nh\u00f3m Alignment<\/em><\/strong>\u00a0c\u1ee7a\u00a0th\u1ebb Home<\/em><\/strong>, ch\u1ec9 c\u00f3 c\u1ed9t b\u00ean tr\u00e1i \u0111\u01b0\u1ee3c gi\u1eef, d\u1eef li\u1ec7u c\u1ee7a c\u00e1c c\u1ed9t kh\u00e1c s\u1ebd b\u1ecb x\u00f3a. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n k\u1ebft h\u1ee3p nhi\u1ec1u c\u1ed9t d\u1eef li\u1ec7u kh\u00e1c nhau th\u00e0nh m\u1ed9t c\u1ed9t.<\/p>\n

H\u1ee3p nh\u1ea5t nhi\u1ec1u c\u1ed9t d\u1eef li\u1ec7u th\u00e0nh m\u1ed9t c\u1ed9t b\u1eb1ng c\u00f4ng th\u1ee9c<\/strong><\/h1>\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 nhi\u1ec1u c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u v\u00e0 b\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p c\u00e1c d\u1eef li\u1ec7u n\u00e0y th\u00e0nh m\u1ed9t c\u1ed9t nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

<\/p>\n

H\u1ee3p nh\u1ea5t c\u00e1c c\u1ed9t d\u1eef li\u1ec7u kh\u00f4ng ch\u1ee9a kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c d\u1eef li\u1ec7u: =A1&B1&C1&\u2026<\/em><\/strong><\/p>\n

H\u1ee3p nh\u1ea5t c\u00e1c c\u1ed9t d\u1eef li\u1ec7u ch\u1ee9a kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c d\u1eef li\u1ec7u: =A1&\u201d \u201c&B1&\u201d \u201c&C1&\u2026<\/em><\/strong><\/p>\n

    \n
  1. Trong \u00f4 t\u00ednh E1, nh\u1eadp c\u00f4ng th\u1ee9c m\u1ed9t trong hai c\u00f4ng th\u1ee9c tr\u00ean.<\/li>\n<\/ol>\n

    \"doc-merge-columns-data3\"<\/p>\n

      \n
    1. Nh\u1ea5n Enter v\u00e0 ch\u1ecdn \u00f4 t\u00ednh E1, sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c \u00f4 t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n.<\/li>\n
    2. Nh\u01b0 v\u1eady, c\u00e1c d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c h\u1ee3p nh\u1ea5t th\u00e0nh m\u1ed9t c\u1ed9t. B\u1edfi v\u00ec ch\u00fang l\u00e0 c\u00f4ng th\u1ee9c, b\u1ea1n c\u1ea7n sao ch\u00e9p v\u00e0 d\u00e1n ch\u00fang d\u01b0\u1edbi d\u1ea1ng Values<\/em><\/strong> nh\u01b0 h\u00ecnh sau\u00a0:<\/li>\n<\/ol>\n

      <\/p>\n

      \u00a0<\/strong><\/p>\n

      \n
      \n
      \n
      \n<\/a>\n<\/div>\n<\/div>\n
      \n
      \n
      \n
      \n<\/a>\n<\/div>\n<\/div>\n<\/div>\n
      \n

      Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

      T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

      H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

      HKD H\u1ecdc Excel Online
      S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

      \n

      \u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

      \n
      \n
      \n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11359,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11358","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\/11358","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=11358"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11358\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11359"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}