{"id":8666,"date":"2021-08-23T20:43:47","date_gmt":"2021-08-23T13:43:47","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=8666"},"modified":"2021-08-23T20:43:47","modified_gmt":"2021-08-23T13:43:47","slug":"cach-bo-dau-phay-truoc-so-trong-excel","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/cach-bo-dau-phay-truoc-so-trong-excel\/","title":{"rendered":"C\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 trong Excel"},"content":{"rendered":"<h3 dir=\"ltr\"><strong>C\u00e1ch 1: S\u1eed d\u1ee5ng l\u1ec7nh Paster As Values<\/strong><\/h3>\n<p dir=\"ltr\">B\u01b0\u1edbc 1: M\u1edf File Excel, sau \u0111\u00f3 b\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf d\u1ea5u ph\u1ea9y. sau \u0111\u00f3 ti\u1ebfn h\u00e0nh sao ch\u00e9p ch\u00fang b\u1eb1ng ph\u00edm \u201c<strong>Ctrl + C\u201d<\/strong><\/p>\n<p dir=\"ltr\">B\u01b0\u1edbc 2: Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, trong m\u1ee5c<strong>\u201cPaste Options\u201d<\/strong>\u00a0\u1ea5n ch\u1ecdn\u00a0<strong>\u201c123 Value\u201d<\/strong>.<\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8668\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623467934-cach-bo-dau-phay-truoc-so-trong-excel-1.jpg\" alt=\"\" width=\"355\" height=\"401\" \/><\/p>\n<p dir=\"ltr\">Sau khi ho\u00e0n th\u00e0nh xong b\u01b0\u1edbc n\u00e0y l\u00e0 d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 \u0111\u00e3 \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf.<\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8669\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623468006-cach-bo-dau-phay-truoc-so-trong-excel-2.jpg\" alt=\"\" width=\"547\" height=\"287\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623468006-cach-bo-dau-phay-truoc-so-trong-excel-2.jpg 547w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623468006-cach-bo-dau-phay-truoc-so-trong-excel-2-400x210.jpg 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623468006-cach-bo-dau-phay-truoc-so-trong-excel-2-510x268.jpg 510w\" sizes=\"auto, (max-width: 547px) 100vw, 547px\" \/><\/p>\n<h3 dir=\"ltr\"><strong>C\u00e1ch 2: X\u00f3a d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 b\u1eb1ng \u201cText to Columns\u201d<\/strong><\/h3>\n<p dir=\"ltr\">B\u01b0\u1edbc 1:\u00a0 M\u1edf File Excel, sau \u0111\u00f3 b\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf d\u1ea5u ph\u1ea9y<\/p>\n<p dir=\"ltr\">B\u01b0\u1edbc 2: Ti\u1ebfp t\u1ee5c ch\u1ecdn<strong>\u201cData\u201d<\/strong>\u00a0-&gt;<strong>Text to Column\u00a0<\/strong><\/p>\n<p dir=\"ltr\">B\u01b0\u1edbc 3: Trong b\u1ea3ng hi\u1ec7n th\u1ecb\u00a0<strong>Convert Text to Columns Wizard<\/strong>, b\u1ea1n ch\u1ecdn<strong>\u201cFinish\u201d<\/strong>\u00a0\u1edf g\u00f3c ph\u00eda d\u01b0\u1edbi c\u00f9ng b\u00ean tay ph\u1ea3i.<\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8673\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623467356-cach-bo-dau-phay-truoc-so-trong-excel-3-1.jpg\" width=\"572\" height=\"630\" alt=\"C\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 trong excel\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623467356-cach-bo-dau-phay-truoc-so-trong-excel-3-1.jpg 572w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623467356-cach-bo-dau-phay-truoc-so-trong-excel-3-1-363x400.jpg 363w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623467356-cach-bo-dau-phay-truoc-so-trong-excel-3-1-510x562.jpg 510w\" sizes=\"auto, (max-width: 572px) 100vw, 572px\" \/><\/p>\n<p dir=\"ltr\">Sau khi ho\u00e0n th\u00e0nh xong b\u01b0\u1edbc n\u00e0y l\u00e0 d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 \u0111\u00e3 \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf.<\/p>\n<h3 dir=\"ltr\"><strong>C\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 trong Excel b\u1eb1ng VBA<\/strong><\/h3>\n<p dir=\"ltr\">N\u1ebfu b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf d\u1ea5u nh\u1ea3y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Code VBA. C\u00e1c thao t\u00e1c th\u1ef1c hi\u1ec7n nh\u01b0 sau:<br \/>\nB\u01b0\u1edbc 1: \u1ea4n ph\u00edm t\u1eaft\u00a0<strong>\u201cAlt +F11\u201d<\/strong>\u00a0\u0111\u1ec3 m\u1edf ch\u01b0\u01a1ng tr\u00ecnh VBA.<\/p>\n<p dir=\"ltr\">B\u01b0\u1edbc 2: Ch\u1ecdn<strong>Insert &gt;Module<\/strong>, sau \u0111\u00f3 Coppy \u0111o\u1ea1n code d\u01b0\u1edbi \u0111\u00e2y v\u00e0o\u00a0<strong>Module Window.\u00a0<\/strong><\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8670\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623468412-cach-bo-dau-phay-truoc-so-trong-excel-5.jpg\" alt=\"\" width=\"1111\" height=\"524\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623468412-cach-bo-dau-phay-truoc-so-trong-excel-5.jpg 1111w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623468412-cach-bo-dau-phay-truoc-so-trong-excel-5-400x189.jpg 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623468412-cach-bo-dau-phay-truoc-so-trong-excel-5-800x377.jpg 800w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623468412-cach-bo-dau-phay-truoc-so-trong-excel-5-768x362.jpg 768w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623468412-cach-bo-dau-phay-truoc-so-trong-excel-5-510x241.jpg 510w\" sizes=\"auto, (max-width: 1111px) 100vw, 1111px\" \/><\/p>\n<p dir=\"ltr\">B\u01b0\u1edbc 3: Ti\u1ebfp t\u1ee5c nh\u1ea5n F5 r\u1ed3i ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n b\u1ecf d\u1ea5u nh\u00e1y<\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8671\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623468427-cach-bo-dau-phay-truoc-so-trong-excel-4.jpg\" alt=\"\" width=\"436\" height=\"263\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623468427-cach-bo-dau-phay-truoc-so-trong-excel-4.jpg 436w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/1623468427-cach-bo-dau-phay-truoc-so-trong-excel-4-400x241.jpg 400w\" sizes=\"auto, (max-width: 436px) 100vw, 436px\" \/><\/p>\n<p dir=\"ltr\">B\u01b0\u1edbc 4: Nh\u1ea5n<strong>\u201cOk\u201d<\/strong>\u00a0l\u00e0 ho\u00e0n th\u00e0nh.<\/p>\n<p dir=\"ltr\">Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng..<\/p>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch 1: S\u1eed d\u1ee5ng l\u1ec7nh Paster As Values B\u01b0\u1edbc 1: M\u1edf File Excel, sau \u0111\u00f3 b\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf d\u1ea5u ph\u1ea9y. sau \u0111\u00f3 ti\u1ebfn h\u00e0nh sao ch\u00e9p ch\u00fang b\u1eb1ng ph\u00edm \u201cCtrl + C\u201d B\u01b0\u1edbc 2: Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, trong m\u1ee5c\u201cPaste [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":8669,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[508],"tags":[],"class_list":["post-8666","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=8666"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8666\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/8669"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=8666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=8666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=8666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}