{"id":7507,"date":"2024-12-21T17:48:14","date_gmt":"2024-12-21T17:48:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/chi-lay-ra-so-trong-doan-text-bang-vba-trong-excel\/"},"modified":"2024-12-21T17:48:14","modified_gmt":"2024-12-21T17:48:14","slug":"chi-lay-ra-so-trong-doan-text-bang-vba-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/chi-lay-ra-so-trong-doan-text-bang-vba-trong-excel\/","title":{"rendered":"Ch\u1ec9 l\u1ea5y ra s\u1ed1 trong \u0111o\u1ea1n text b\u1eb1ng VBA trong Excel"},"content":{"rendered":"
\n

\u0110\u00f4i khi ch\u00fang ta c\u1ea7n ph\u1ea3i l\u1ea5y ra 1 c\u1ee5m s\u1ed1, ho\u1eb7c 1 s\u1ed1, c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng, s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, s\u1ed1 b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i trong 1 \u0111o\u1ea1n text. Vi\u1ec7c l\u1ea5y ra nh\u1eefng s\u1ed1 n\u00e0y v\u1edbi s\u1ed1 l\u01b0\u1ee3ng r\u1ea5t l\u1edbn d\u1eef li\u1ec7u l\u00e0 kh\u00f4ng kh\u1ea3 thi v\u00ec v\u1eady, ch\u00fang ta c\u00f3 th\u1ec3 v\u1eadn d\u1ee5ng ki\u1ebfn th\u1ee9c \u0111\u00e3 h\u1ecdc trong kho\u00e1 h\u1ecdc VBA c\u1ee7a H\u1ecdc Excel Online<\/a> \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y nh\u01b0 sau:<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m lay_so nh\u01b0 sau:<\/p>\n

=lay_so(A1)<\/strong><\/p>\n

K\u1ebft qu\u1ea3 \u00e1p d\u1ee5ng cho chu\u1ed7i:<\/p>\n

RRP 90 AVE DE GAULLE 92800 PUTEAUX 0109781431-0149012126 ABC<\/strong><\/p>\n

l\u00e0<\/p>\n

90 92800 0109781431 0149012126<\/strong><\/p>\n

N\u1ed9i dung c\u1ee7a h\u00e0m UDF l\u1ea5y s\u1ed1 n\u00e0y nh\u01b0 sau. \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m lay_so, b\u1ea1n c\u1ea7n copy code n\u00e0y v\u00e0o 1 module trong VBA Project.<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
View the code on Gist<\/a>.<\/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":7508,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7507","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7507","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=7507"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7507\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7508"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}