{"id":24200,"date":"2021-05-08T09:13:01","date_gmt":"2021-05-08T02:13:01","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24200"},"modified":"2021-05-08T09:13:20","modified_gmt":"2021-05-08T02:13:20","slug":"ham-right-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-right-trong-excel\/","title":{"rendered":"C\u00fa ph\u00e1p h\u00e0m Right trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng"},"content":{"rendered":"

T\u01b0\u01a1ng t\u1ef1 h\u00e0m Left trong Excel, h\u00e0m Right<\/strong> c\u0169ng l\u00e0 h\u00e0m c\u1eaft chu\u1ed7i k\u00fd t\u1ef1, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 t\u1eeb b\u00ean ph\u1ea3i trong d\u00e3y k\u00fd t\u1ef1 m\u00e0 ng\u01b0\u1eddi d\u00f9ng \u0111\u00e3 ch\u1ecdn. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n v\u1ec1 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Right trong Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o nh\u00e9.<\/p>\n

H\u00e0m Right trong Excel<\/strong><\/h2>\n

Nh\u01b0 Ben Computer \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean, h\u00e0m Right trong Excel<\/strong>\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00e1ch chu\u1ed7i k\u00fd t\u1ef1i t\u1eeb b\u00ean ph\u1ea3i trong chu\u1ed7i k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh, cho tr\u01b0\u1edbc. H\u00e0m Excel n\u00e0y tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t ho\u1eb7c nhi\u1ec1u k\u00fd t\u1ef1 cu\u1ed1i trong chu\u1ed7i v\u0103n b\u1ea3n, d\u1ef1a v\u00e0o s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 hi\u1ec3n th\u1ecb trong \u00f4 trong b\u1ea3ng t\u00ednh Excel.<\/p>\n

\"H\u00e0m<\/p>\n

C\u00fa ph\u00e1p h\u00e0m Right trong Excel<\/strong><\/h2>\n

H\u00e0m Right trong Excel<\/strong> c\u00f3 c\u00fa ph\u00e1p nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=RIGHT(text,[num_chars])<\/strong><\/p><\/blockquote>\n

Trong \u0111\u00f3:<\/p>\n

\u2013 Text<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n c\u00f3 ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 c\u1ea7n tr\u00edch xu\u1ea5t.<\/p>\n

\u2013 num_chars<\/strong>\u00a0(tham s\u1ed1 t\u00f9y ch\u1ecdn): l\u00e0 s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n tr\u00edch xu\u1ea5t b\u1eb1ng h\u00e0m Right, b\u1eaft \u0111\u1ea7u t\u1eeb k\u00fd t\u1ef1 b\u00ean ph\u1ea3i. M\u1eb7c \u0111\u1ecbnh tham s\u1ed1 n\u00e0y l\u00e0 1.<\/p>\n

M\u1eb7c \u0111\u1ecbnh gi\u00e1 tr\u1ecb tham s\u1ed1 num_chars<\/strong> l\u00e0 1 v\u00e0 ph\u1ea3i l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 0. N\u1ebfu tham s\u1ed1 num_chars l\u1edbn h\u01a1n \u0111\u1ed9 d\u00e0i chu\u1ed7i v\u0103n b\u1ea3n, h\u00e0m Right s\u1ebd tr\u1ea3 v\u1ec1 chu\u1ed7i v\u0103n b\u1ea3n ho\u00e0n ch\u1ec9nh.<\/p>\n

Ngo\u00e0i ra, h\u00e0m Right trong Excel<\/strong> kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng v\u00e0 kh\u00f4ng h\u1ed7 tr\u1ee3 c\u00e1c gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1.<\/p>\n

L\u01b0u \u00fd:<\/strong>\u00a0H\u00e0m Right ch\u1ec9 s\u1eed d\u1ee5ng v\u1edbi chu\u1ed7i v\u0103n b\u1ea3n khi ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n d\u01b0\u1edbi d\u1ea1ng con s\u1ed1 \u1ea9n trong Excel v\u00e0 kh\u00f4ng th\u1ec3 l\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb nh\u01b0 ng\u00e0y, th\u00e1ng hay n\u0103m. Thay v\u00e0o \u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m Excel l\u1ea5y ng\u00e0y th\u00e1ng n\u0103m nh\u01b0 h\u00e0m Day, Month v\u00e0 Year.<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Right trong Excel<\/strong><\/h2>\n

H\u00e0m Right Excel<\/strong> c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u00f9ng c\u00e1c h\u00e0m Excel kh\u00e1c nh\u01b0 h\u00e0m Find, Search, Len, Left, \u2026 . B\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o ti\u1ebfp m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Right.<\/p>\n

V\u00ed d\u1ee5 1<\/strong><\/h3>\n

Gi\u1ea3 s\u1eed cho chu\u1ed7i v\u0103n b\u1ea3n nh\u01b0 trong \u00f4 A3, y\u00eau c\u1ea7u l\u00e0 tr\u00edch xu\u1ea5t 6 ch\u1eef c\u00e1i \u1edf cu\u1ed1i chu\u1ed7i v\u0103n b\u1ea3n n\u00e0y.<\/p>\n

\"1<\/p>\n

Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Right Excel<\/strong> \u0111\u1ec3 tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n \u201cstring\u201d trong chu\u1ed7i v\u0103n b\u1ea3n trong \u00f4 A3. C\u00f4ng th\u1ee9c h\u00e0m Right c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n

\"6<\/p>\n

RIGHT(A3, 6)<\/strong><\/p>\n

H\u00e0m Right tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 v\u0103n b\u1ea3n \u201cstring\u201d trong chu\u1ed7i:<\/p>\n

\"3<\/p>\n

V\u00ed d\u1ee5 2<\/strong><\/h3>\n

Cho v\u00ed d\u1ee5, gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 danh s\u00e1ch ch\u1ee9a c\u00e1c ID bao g\u1ed3m ID2101, ID2102, ID2103, \u2026 trong m\u1ed9t c\u1ed9t nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\"4<\/p>\n

Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ID ch\u1ec9 bao g\u1ed3m 4 ch\u1eef s\u1ed1 cu\u1ed1i c\u00f9ng, c\u00e1c k\u00fd t\u1ef1 ID \u1edf \u0111\u1ea7u l\u00e0 th\u1eeba. \u0110\u1ec3 x\u00f3a \u201cID\u201d kh\u1ecfi chu\u1ed7i n\u00e0y, ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c, c\u00fa ph\u00e1p h\u00e0m Right Excel c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n

RIGHT(A3, 4)<\/strong><\/p>\n

\"5<\/p>\n

H\u00e0m Right tr\u00ean s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 2101.<\/p>\n

\"6<\/p>\n

L\u01b0u \u00fd quan tr\u1ecdng khi s\u1eed d\u1ee5ng h\u00e0m Right trong Excel<\/strong><\/h2>\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng m\u00e0 b\u1ea1n c\u1ea7n l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Right trong Excel<\/strong>:<\/p>\n

    \n
  1. H\u00e0m Right<\/strong> tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE! n\u1ebfu tham s\u1ed1 [num_chars] \u0111\u00e3 cho nh\u1ecf h\u01a1n 0.<\/li>\n
  2. H\u00e0m Excel n\u00e0y kh\u00f4ng h\u1ed7 tr\u1ee3 tr\u00edch xu\u1ea5t ho\u1eb7c \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1.<\/li>\n
  3. H\u00e0m Right Excel<\/strong> \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c k\u00fd t\u1ef1 t\u1eeb ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/li>\n
  4. Trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu ch\u00fang ta kh\u00f4ng ch\u1ec9 \u0111\u1ecbnh tham s\u1ed1 cu\u1ed1i c\u00f9ng, m\u1eb7c \u0111\u1ecbnh h\u00e0m Right<\/strong> s\u1ebd s\u1eed d\u1ee5ng gi\u00e1 tr\u1ecb l\u00e0 1.<\/li>\n
  5. Gi\u00e1 tr\u1ecb tham s\u1ed1 Num_chars ph\u1ea3i l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 0. N\u1ebfu tham s\u1ed1 l\u00e0 gi\u00e1 tr\u1ecb \u00e2m, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE.<\/li>\n
  6. H\u00e0m RIGHT<\/strong> kh\u00f4ng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu tham s\u1ed1 \u00f4 ch\u1ee9a \u0111\u1ecbnh d\u1ea1ng ng\u00e0y.<\/li>\n
  7. H\u00e0m Right<\/strong> c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c nh\u01b0 h\u00e0m LEN, SEARCH, FIND v\u00e0 SUBSTITUTE.<\/li>\n<\/ol>\n

    Tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba gi\u1edbi thi\u1ec7u cho b\u1ea1n v\u1ec1 h\u00e0m Right trong Excel,<\/strong> c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng. Ngo\u00e0i ra n\u1ebfu ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i chu\u1ed7i trong Excel<\/a> nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"

    T\u01b0\u01a1ng t\u1ef1 h\u00e0m Left trong Excel, h\u00e0m Right c\u0169ng l\u00e0 h\u00e0m c\u1eaft chu\u1ed7i k\u00fd t\u1ef1, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 t\u1eeb b\u00ean ph\u1ea3i trong d\u00e3y k\u00fd t\u1ef1 m\u00e0 ng\u01b0\u1eddi d\u00f9ng \u0111\u00e3 ch\u1ecdn. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n v\u1ec1 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Right […]<\/p>\n","protected":false},"author":39,"featured_media":24201,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24200","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24200"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24200\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24201"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}