{"id":23916,"date":"2021-05-05T10:11:42","date_gmt":"2021-05-05T03:11:42","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=23916"},"modified":"2021-05-05T10:41:11","modified_gmt":"2021-05-05T03:41:11","slug":"ham-len-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-len-trong-excel\/","title":{"rendered":"Gi\u1edbi thi\u1ec7u H\u00e0m Len trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng"},"content":{"rendered":"

H\u00e0m Len trong Excel<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4. H\u00e0m Excel n\u00e0y ch\u1ea5p nh\u1eadn c\u1ea3 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t, kho\u1ea3ng tr\u1eafng v\u00e0 b\u1ea3ng ch\u1eef c\u00e1i. Tuy nhi\u00ean m\u1ed9t l\u01b0u \u00fd quan tr\u1ecdng l\u00e0 h\u00e0m Len trong Excel ch\u1ec9 \u0111\u1ebfm \u0111\u1ed9 d\u00e0i s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4 duy nh\u1ea5t. Trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu ch\u00fang ta ch\u1ecdn m\u1ea3ng ho\u1eb7c ph\u1ea1m vi d\u1eef li\u1ec7u, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #Value.<\/p>\n

\u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Len trong Excel<\/strong>, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ben Computer.<\/p>\n

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

H\u00e0m Len trong Excel<\/strong> \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m v\u0103n b\u1ea3n, h\u00e0m text. H\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm v\u00e0 tr\u1ea3 v\u1ec1 s\u1ed1 k\u00fd t\u1ef1 trong m\u1ed9t \u00f4, bao g\u1ed3m c\u1ea3 d\u1ea5u c\u00e1ch.<\/p>\n

C\u00fa ph\u00e1p, c\u00f4ng th\u1ee9c h\u00e0m Len trong Excel<\/strong> c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=LEN(text)<\/strong><\/p>\n

H\u00e0m Len Excel<\/strong> ch\u1ec9 s\u1eed d\u1ee5ng m\u1ed9t tham s\u1ed1 duy nh\u1ea5t:<\/p>\n

\u2013 text<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 v\u0103n b\u1ea3n m\u00e0 ch\u00fang ta c\u1ea7n \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1. Tham s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 l\u00e0 v\u0103n b\u1ea3n tr\u1ef1c ti\u1ebfp, ho\u1eb7c chu\u1ed7i v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 t\u1eeb c\u00f4ng th\u1ee9c kh\u00e1c, ho\u1eb7c c\u00f3 th\u1ec3 l\u00e0 tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9 chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n

\"C\u00fa<\/p>\n

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

\u0110\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Len trong Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

V\u00ed d\u1ee5 1:<\/strong><\/p>\n

Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 b\u1ea3ng t\u00ednh ch\u1ee9a c\u00e1c d\u1eef li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\"1<\/p>\n

Y\u00eau c\u1ea7u l\u00e0 s\u1eed d\u1ee5ng h\u00e0m Len \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 t\u1ef1 k\u00fd v\u0103n b\u1ea3n trong \u00f4 B4, B5, B6 v\u00e0 B7. C\u00f4ng th\u1ee9c h\u00e0m Len Excel<\/strong> v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng nh\u01b0 trong \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n

\"2<\/p>\n

Trong v\u00ed d\u1ee5 tr\u00ean, d\u1ea5u c\u00e1ch c\u0169ng \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 m\u1ed9t k\u00fd t\u1ef1. V\u00ec v\u1eady h\u00e0m Len tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 13 k\u00fd t\u1ef1 cho v\u0103n b\u1ea3n trong \u00f4 B5. Ngo\u00e0i ra s\u1ed1 k\u00fd t\u1ef1 trong \u00f4 tr\u1ed1ng l\u00e0 0.<\/p>\n

V\u00ed d\u1ee5 2:<\/strong><\/p>\n

Trong v\u00ed d\u1ee5 n\u00e0y ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m LEN \u0111\u1ec3 x\u00f3a c\u00e1c k\u00fd t\u1ef1 kh\u1ecfi d\u1eef li\u1ec7u trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\"3<\/p>\n

C\u1ee5 th\u1ec3 ch\u00fang ta mu\u1ed1n x\u00f3a c\u00e1c k\u00fd t\u1ef1 v\u0103n b\u1ea3n l\u00e0 miles trong c\u1ed9t Distance. \u0110\u1ec3 x\u00f3a n k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng kh\u1ecfi chu\u1ed7i v\u0103n b\u1ea3n, ch\u00fang ta s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m Left v\u00e0 h\u00e0m Len.<\/p>\n

C\u00f4ng th\u1ee9c h\u00e0m Excel c\u00f3 d\u1ea1ng:<\/p>\n

=VALUE(LEFT(D5,LEN(D5)-6))<\/strong><\/p>\n

K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\"4<\/p>\n

Trong c\u00f4ng th\u1ee9c tr\u00ean, h\u00e0m Left s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c k\u00fd t\u1ef1 t\u1eeb ph\u00eda b\u00ean tr\u00e1i c\u1ee7a gi\u00e1 tr\u1ecb. H\u00e0m Len \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a m\u1ed7i gi\u00e1 tr\u1ecb.<\/p>\n

\u0110\u1ec3 l\u1ea5y s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ea7n tr\u00edch xu\u1ea5t, ch\u00fang ta tr\u1eeb \u0111i 6, l\u00e0 s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a \u201cmiles\u201d (bao g\u1ed3m c\u1ea3 k\u00fd t\u1ef1 d\u1ea5u c\u00e1ch). K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 4, \u0111\u01b0\u1ee3c chuy\u1ec3n sang cho h\u00e0m Left s\u1eed d\u1ee5ng l\u00e0m s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n tr\u00edch xu\u1ea5t. H\u00e0m Left s\u1ebd tr\u1ea3 v\u1ec1 v\u0103n b\u1ea3n \u201c1035\u201d d\u01b0\u1edbi d\u1ea1ng gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n.<\/p>\n

M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Len trong Excel<\/strong><\/h2>\n

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