{"id":11559,"date":"2025-01-15T04:22:31","date_gmt":"2025-01-15T04:22:31","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-trich-xuat-van-ban-truoc-sau-khoang-trang-hoac-dau-phay-trong-excel\/"},"modified":"2025-01-15T04:22:31","modified_gmt":"2025-01-15T04:22:31","slug":"cach-trich-xuat-van-ban-truoc-sau-khoang-trang-hoac-dau-phay-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-trich-xuat-van-ban-truoc-sau-khoang-trang-hoac-dau-phay-trong-excel\/","title":{"rendered":"C\u00e1ch tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau kho\u1ea3ng tr\u1eafng ho\u1eb7c d\u1ea5u ph\u1ea9y trong Excel"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau kho\u1ea3ng tr\u1eafng ho\u1eb7c d\u1ea5u ph\u1ea9y trong Excel.<\/p>\n

B\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n tr\u01b0\u1edbc kho\u1ea3ng tr\u1eafng t\u1eeb danh s\u00e1ch d\u01b0\u1edbi \u0111\u00e2y b\u1eb1ng c\u00f4ng th\u1ee9c:<\/p>\n

Ch\u1ecdn \u00f4 tr\u1ed1ng, nh\u1eadp c\u00f4ng th\u1ee9c\u00a0=LEFT(A1,(FIND(\u201d \u201c,A1,1)-1))<\/em><\/strong> (A1 l\u00e0 \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a danh s\u00e1ch b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t), nh\u1ea5n Enter.<\/p>\n

<\/p>\n

M\u1eb9o:<\/strong><\/p>\n

(1) N\u1ebfu b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n tr\u01b0\u1edbc ho\u1eb7c sau d\u1ea5u ph\u1ea9y, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ed5i \u201d \u201d th\u00e0nh \u201c,\u201d<\/p>\n

(2) N\u1ebfu b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n sau kho\u1ea3ng tr\u1eafng, d\u00f9ng c\u00f4ng th\u1ee9c =MID(A1,FIND(\u201d \u201c,A1)+1,256).<\/em><\/strong><\/p>\n

(3) Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n d\u1ef1a v\u00e0o kho\u1ea3ng tr\u1eafng \u0111\u1ea7u ti\u00ean c\u1ee7a \u00f4 ch\u1ec9 \u0111\u1ecbnh. N\u1ebfu c\u00f3 nhi\u1ec1u h\u01a1n 1 kho\u1ea3ng tr\u1eafng, v\u00ed d\u1ee5 \u201cKatty J James\u201d, c\u00f4ng th\u1ee9c\u00a0 =MID(A1,FIND(\u201d \u201c,A1)+1,256)<\/strong> <\/em>s\u1ebd tr\u00edch xu\u1ea5t t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 sau kho\u1ea3ng tr\u1eafng \u0111\u1ea7u ti\u00ean.<\/p>\n

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

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