{"id":11680,"date":"2025-01-15T04:50:11","date_gmt":"2025-01-15T04:50:11","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-chia-cac-gia-tri-ngan-cach-bang-dau-phay-thanh-cac-dong-hoac-cac-cot-trong-excel\/"},"modified":"2025-01-15T04:50:11","modified_gmt":"2025-01-15T04:50:11","slug":"cach-chia-cac-gia-tri-ngan-cach-bang-dau-phay-thanh-cac-dong-hoac-cac-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-chia-cac-gia-tri-ngan-cach-bang-dau-phay-thanh-cac-dong-hoac-cac-cot-trong-excel\/","title":{"rendered":"C\u00e1ch chia c\u00e1c gi\u00e1 tr\u1ecb ng\u0103n c\u00e1ch b\u1eb1ng d\u1ea5u ph\u1ea9y th\u00e0nh c\u00e1c d\u00f2ng ho\u1eb7c c\u00e1c c\u1ed9t trong Excel"},"content":{"rendered":"
\n

<\/h2>\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1c ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ec3 chia c\u00e1c gi\u00e1 tr\u1ecb ng\u0103n c\u00e1ch b\u1eb1ng d\u1ea5u ph\u1ea9y th\u00e0nh c\u00e1c d\u00f2ng ho\u1eb7c c\u00e1c c\u1ed9t.<\/p>\n

Chia c\u00e1c gi\u00e1 tr\u1ecb ng\u0103n c\u00e1ch b\u1eb1ng d\u1ea5u ph\u1ea9y th\u00e0nh c\u00e1c c\u1ed9t b\u1eb1ng Text To Columns<\/strong><\/p>\n

1. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n chia c\u00e1c gi\u00e1 tr\u1ecb th\u00e0nh c\u1ed9t, nh\u1ea5p ch\u1ecdn Data > Text to Columns<\/strong><\/em>.<\/p>\n

<\/p>\n

2. Trong h\u1ed9p tho\u1ea1i Convert Text to Columns Wizard\u00a0<\/strong><\/em>\u0111\u1ea7u ti\u00ean, ch\u1ecdn Delimited<\/strong><\/em>, nh\u1ea5n n\u00fat Next<\/strong><\/em>.<\/p>\n

<\/p>\n

3. Trong h\u1ed9p tho\u1ea1i Convert Text to Columns Wizard<\/strong><\/em>\u00a0th\u1ee9 hai, ch\u1ec9 \u0111\u00e1nh d\u1ea5u ch\u1ecdn\u00a0Comma\u00a0<\/strong><\/em>trong ph\u1ea7n\u00a0Delimiters<\/strong><\/em>, nh\u1ea5n\u00a0Next.<\/strong><\/em><\/p>\n

<\/p>\n

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

4. Trong h\u1ed9p tho\u1ea1i Convert Text to Columns Wizard<\/strong><\/em>\u00a0cu\u1ed1i c\u00f9ng, ch\u1ecdn m\u1ed9t \u00f4 t\u00ednh \u0111\u1eb7t gi\u00e1 tr\u1ecb ph\u00e2n t\u00e1ch v\u00e0o \u00f4 Destination<\/strong><\/em>, nh\u1ea5n n\u00fat Finish<\/strong><\/em>.<\/p>\n

<\/p>\n

T\u1ea5t c\u1ea3 gi\u00e1 tr\u1ecb trong \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn t\u1eebng \u0111\u01b0\u1ee3c ng\u0103n b\u1eb1ng d\u1ea5u ph\u1ea9y b\u00e2y gi\u1edd \u0111\u00e3 \u0111\u01b0\u1ee3c chia v\u00e0o c\u00e1c c\u1ed9t kh\u00e1c nhau nh\u01b0 h\u00ecnh sau:<\/p>\n

<\/a><\/p>\n

Chia c\u00e1c gi\u00e1 tr\u1ecb ng\u0103n c\u00e1ch b\u1eb1ng d\u1ea5u ph\u1ea9y th\u00e0nh c\u00e1c h\u00e0ng b\u1eb1ng VBA<\/strong><\/p>\n

1. Nh\u1ea5n gi\u1eef ph\u00edm\u00a0Alt + F11<\/strong><\/em>, c\u1eeda s\u1ed5 Microsoft Visual Basic for Applications\u00a0<\/strong><\/em>m\u1edf ra.<\/p>\n

2. Nh\u1ea5p Insert > Module<\/strong><\/em>, d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o Module Window<\/strong><\/em>.<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n
<\/div>\n
<\/div>\n
3. Nh\u1ea5n\u00a0F5\u00a0<\/strong><\/em>\u0111\u1ec3 ch\u1ea1y m\u00e3, m\u1ed9t h\u1ed9p tho\u1ea1i hi\u1ec7n ra \u0111\u1ec3 b\u1ea1n ch\u1ecdn \u00f4 t\u00ednh b\u1ea1n mu\u1ed1n chia t\u00e1ch, nh\u1ea5n OK.<\/div>\n
\u00a04. Trong h\u1ed9p tho\u1ea1i th\u1ee9 hai, ch\u1ecdn m\u1ed9t \u00f4 t\u00ednh \u0111\u1ec3 \u0111\u1eb7t gi\u00e1 tr\u1ecb ph\u00e2n t\u00e1ch, nh\u1ea5n OK.<\/div>\n
\u00a0Sau \u0111\u00f3 b\u1ea1n th\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb t\u1eebng \u0111\u01b0\u1ee3c ng\u0103n b\u1eb1ng d\u1ea5u ph\u1ea9y trong c\u00e1c \u00f4 t\u00ednh \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u00e3 \u0111\u01b0\u1ee3c chia th\u00e0nh c\u00e1c d\u00f2ng nh\u01b0 h\u00ecnh sau:<\/div>\n
<\/div>\n
\n

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