{"id":5159,"date":"2024-12-09T11:56:23","date_gmt":"2024-12-09T11:56:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/huong-dan-xu-ly-ki-tu-voi-ham-char-va-code-trong-excel\/"},"modified":"2024-12-09T11:56:23","modified_gmt":"2024-12-09T11:56:23","slug":"huong-dan-xu-ly-ki-tu-voi-ham-char-va-code-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/huong-dan-xu-ly-ki-tu-voi-ham-char-va-code-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn x\u1eed l\u00fd k\u00ed t\u1ef1 v\u1edbi h\u00e0m CHAR v\u00e0 CODE trong Excel"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc v\u1ec1\u00a0tra c\u1ee9u k\u00ed t\u1ef1 v\u1edbi h\u00e0m CHAR v\u00e0 CODE<\/a><\/strong>, ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n nh\u1ea5t v\u1ec1 hai h\u00e0m. \u0110\u1ed1i v\u1edbi b\u00e0i vi\u1ebft l\u1ea7n n\u00e0y, H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch x\u1eed l\u00fd k\u00ed t\u1ef1 v\u1edbi h\u00e0m CHAR v\u00e0 CODE th\u00f4ng qua v\u00ed d\u1ee5 c\u1ee5 th\u1ec3.<\/p>\n

X\u1eed l\u00ed k\u00fd t\u1ef1 v\u1edbi h\u00e0m CHAR v\u00e0 CODE trong Excel<\/h3>\n

Ta h\u00e3y \u0111\u1ebfn v\u1edbi tr\u01b0\u1eddng h\u1ee3p n\u1ed5i b\u1eadt nh\u1ea5t v\u1ec1 x\u1eed l\u00ed k\u00fd t\u1ef1: X\u1eed l\u00ed kho\u1ea3ng tr\u1ed1ng. \u0110\u00e2y l\u00e0 tr\u01b0\u1eddng h\u1ee3p th\u01b0\u1eddng g\u1eb7p khi b\u1ea1n Copy v\u0103n b\u1ea3n t\u1eeb m\u1ed9t ngu\u1ed3n b\u00ean ngo\u00e0i.<\/p>\n

Nh\u01b0 th\u1ebf n\u00e0y<\/figcaption><\/figure>\n

Gi\u1ea3i ph\u00e1p \u0111\u1ea7u ti\u00ean \u1edf \u0111\u00e2y th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 c\u1eaft b\u1ecf nh\u1eefng kho\u1ea3ng tr\u1ed1ng th\u1eeba l\u00e0 h\u00e0m\u00a0TRIM<\/strong><\/a>. Ta h\u00e3y xem trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, h\u00e0m TRIM s\u1ebd l\u00e0m vi\u1ec7c ra sao nh\u00e9:<\/p>\n

<\/p>\n

Ta b\u1eaft \u0111\u1ea7u v\u1edbi c\u00f4ng th\u1ee9c\u00a0=TRIM(A2)\u00a0<\/strong>sau \u0111\u00f3 s\u1eed d\u1ee5ng\u00a0thao t\u00e1c fill<\/a>\u00a0\u0111\u1ec3 \u00e1p d\u1ee5ng cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f2n l\u1ea1i. Tuy nhi\u00ean c\u00f3 v\u1ebb nh\u01b0 h\u00e0m TRIM \u0111ang ho\u1ea1t \u0111\u1ed9ng kh\u00f4ng hi\u1ec7u qu\u1ea3 cho l\u1eafm? B\u1edfi v\u00ec h\u00e0m TRIM \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 lo\u1ea1i b\u1ecf k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng ASCII 7-bit (gi\u00e1 tr\u1ecb 32) kh\u1ecfi v\u0103n b\u1ea3n.<\/strong><\/p>\n

T\u01b0\u01a1ng t\u1ef1, h\u00e0m\u00a0CLEAN<\/strong> c\u0169ng kh\u00f4ng th\u1ec3 gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c t\u00ecnh hu\u1ed1ng n\u00e0y.<\/p>\n

<\/p>\n

\u00a0<\/p>\n

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

Gi\u1ea3i ph\u00e1p \u1edf \u0111\u00e2y ta c\u1ea7n s\u1eed d\u1ee5ng l\u00e0 t\u00ecm v\u00e0 thay th\u1ebf nh\u1eefng kho\u1ea3ng tr\u1eafng kia b\u1eb1ng kho\u1ea3ng tr\u1eafng v\u1edbi gi\u00e1 tr\u1ecb 32. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, \u0111\u1ea7u ti\u00ean c\u1ea7n ph\u1ea3i x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c gi\u00e1 tr\u1ecb c\u00e1c kho\u1ea3ng tr\u1eafng kia b\u1eb1ng h\u00e0m CODE:\u00a0=CODE(\u201d\u00a0\u201c).\u00a0<\/strong>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 con s\u1ed1 160. T\u01b0\u01a1ng t\u1ef1 \u0111\u1ed1i v\u1edbi xu\u1ed1ng d\u00f2ng, k\u00ed t\u1ef1 thu v\u1ec1 l\u00e0 10.<\/p>\n

Ti\u1ebfp \u0111\u00f3, ta ti\u1ebfn h\u00e0nh thay th\u1ebf to\u00e0n b\u1ed9 gi\u00e1 tr\u1ecb 160 v\u00e0 10 b\u1eb1ng 32 v\u1edbi s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a h\u00e0m\u00a0CHAR\u00a0<\/strong>v\u00e0\u00a0h\u00e0m\u00a0SUBSTITUTE<\/a>.<\/strong><\/p>\n

\n

=SUBSTITUTE(A2,CHAR(160),CHAR(32))<\/strong><\/p>\n<\/blockquote>\n

<\/p>\n

B\u00e2y gi\u1edd, h\u00e3y s\u1eed d\u1ee5ng l\u1ea1i h\u00e0m TRIM v\u00e0 thu k\u1ebft qu\u1ea3:<\/p>\n

<\/p>\n

\u00a0<\/p>\n

Kh\u00f4ng h\u1ec1 kh\u00f3 ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n

Ngo\u00e0i ra, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c c\u00f9ng ch\u1ee7 \u0111\u1ec1 t\u1ea1i \u0111\u00e2y:<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE b\u1ecf d\u1ea5u c\u00e1ch trong danh s\u00e1ch s\u1ed1 \u0111i\u1ec7n tho\u1ea1i hi\u1ec7u qu\u1ea3<\/a><\/p>\n

T\u00ecm hi\u1ec3u 2 c\u00e1ch b\u1ecf kho\u1ea3ng tr\u1eafng th\u1eeba trong excel th\u00f4ng d\u1ee5ng nh\u1ea5t<\/a><\/p>\n

T\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c thao t\u00e1c v\u1edbi 3 k\u00ed t\u1ef1 kho\u1ea3ng tr\u1ed1ng \u0111\u1eb7c bi\u1ec7t th\u00f4ng d\u1ee5ng trong Excel<\/a><\/p>\n

\u00a0<\/p>\n

Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t<\/p>\n

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