![\"C\u00e1ch](\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/ham-left-trong-excel-300x78.jpg\")
<\/h2>\n<\/h2>\nH\u00e0m Left, H\u00e0m Right l\u00e0 2 h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00e1ch ta \u201cn\u201d k\u00fd t\u1ef1 c\u1ee7a chu\u1ed7i Text t\u1eeb b\u00ean tr\u00e1i ho\u1eb7c b\u00ean ph\u1ea3i. \u0110\u00e2y l\u00e0 2 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Excel v\u00e0 k\u1ebf to\u00e1n c\u0169ng hay s\u1eed d\u1ee5ng<\/span><\/p>\n T\u1ea1i b\u00e0i vi\u1ebft n\u00e0y K\u1ebf to\u00e1n Centax<\/a><\/strong> xin \u0111\u01b0\u1ee3c chia s\u1ebb c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT, h\u00e0m RIGHT trong c\u00f4ng t\u00e1c k\u1ebf to\u00e1n Excel. M\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n – C\u00f4ng d\u1ee5ng: H\u00e0m LEFT trong\u00a0Excel\u00a0\u0111\u01b0\u1ee3c d\u00f9ng\u00a0\u0111\u1ec3 tr\u00edch ra “n” k\u00fd t\u1ef1 trong chu\u1ed7i Text k\u1ec3 t\u1eeb ph\u00eda b\u00ean ph\u1ea3i tr\u00e1i<\/span><\/p>\n – C\u1ea5u tr\u00fac: LEFT(text,n)\u00a0<\/span><\/p>\n Trong\u00a0\u0111\u00f3:<\/span><\/p>\n V\u00ed d\u1ee5: Mu\u1ed1n tr\u00edch ra 5 k\u00fd t\u1eeb trong chu\u1ed7i “Th\u00e0nh ph\u1ed1 H\u00e0 N\u1ed9i” t\u1eeb b\u00ean tr\u00e1i, ta c\u00f3 c\u00f4ng th\u1ee9c:\u00a0LEFT(” Th\u00e0nh ph\u1ed1 H\u00e0 N\u1ed9i”,5) = Th\u00e0nh<\/span><\/p>\n Trong\u00a0\u0111\u00f3: Text l\u00e0 ” Th\u00e0nh ph\u1ed1 H\u00e0 N\u1ed9i”\u00a0<\/span><\/p>\n n=5: L\u00e0 s\u1ed1 k\u00fd t\u1ef1 s\u1ebd tr\u00edch ra<\/span><\/p>\n V\u00ed d\u1ee5: Trong k\u1ebf to\u00e1n, b\u1ea1n\u00a0\u0111\u1ecdc c\u00f3 th\u1ec3 d\u1ef1a v\u00e0o h\u00e0m LEFT\u00a0\u0111\u1ec3 t\u1eeb b\u1ea3ng danh s\u00e1ch nh\u00e2n vi\u00ean, d\u1ef1a v\u00e0o m\u00e3 s\u1ed1 nh\u00e2n vi\u00ean \u0111\u1ec3\u00a0t\u00ecm ra\u00a0ch\u1ee9c v\u1ee5 c\u1ee7a nh\u00e2n vi\u00ean<\/span><\/p>\n V\u00ec 2 ch\u1eef c\u00e1i\u00a0\u0111\u1ea7u ti\u00ean trong m\u00e3 nh\u00e2n vi\u00ean l\u00e0 vi\u1ebft t\u1eaft ch\u1ee9c v\u1ee5 c\u1ee7a nh\u00e2n vi\u00ean\u00a0\u0111\u00f3, n\u00ean t\u1eeb M\u00e3 nh\u00e2n vi\u00ean, ta c\u00f3 th\u1ec3\u00a0\u0111i\u1ec1n th\u00f4ng tin v\u1ec1 ch\u1ee9c v\u1ee5 t\u1ea1i\u00a0\u00f4 D4 b\u1eb1ng c\u00f4ng th\u1ee9c: D4= LEFT(C4,2). Sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c\u00a0\u00f4 c\u00f2n l\u1ea1i b\u00ean d\u01b0\u1edbi cho\u00a0\u0111\u1ebfn khi h\u1ebft danh s\u00e1ch, ta\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/span><\/p>\n T\u01b0\u01a1ng t\u1ef1 h\u00e0m LEFT, h\u00e0m RIGHT trong\u00a0Excel\u00a0\u0111\u01b0\u1ee3c d\u00f9ng\u00a0\u0111\u1ec3 tr\u00edch ra “n” k\u00fd t\u1ef1 trong\u00a0chu\u1ed7i Text k\u1ec3\u00a0t\u1eeb b\u00ean ph\u1ea3i<\/span><\/p>\n – C\u1ea5u tr\u00fac: RIGHT(text,n)<\/span><\/p>\n Trong\u00a0\u0111\u00f3:<\/span><\/p>\n V\u00ed d\u1ee5, t\u01b0\u01a1ng t\u1ef1 v\u1edbi v\u00ed d\u1ee5 v\u1ec1 ph\u00e2n lo\u1ea1i nh\u00e2n vi\u00ean theo ch\u1ee9c v\u1ee5, gi\u1ea3 s\u1eed, b\u1ea1n\u00a0\u0111\u1ecdc mu\u1ed1n ph\u00e2n lo\u1ea1i nh\u00e2n vi\u00ean theo s\u1ed1 hi\u1ec7u c\u1ee7a nh\u00e2n vi\u00ean, trong\u00a0\u0111\u00f3 s\u1ed1 hi\u1ec7u nh\u00e2n vi\u00ean ch\u00ednh l\u00e0 3 k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng trong m\u00e3 nh\u00e2n vi\u00ean.\u00a0<\/span><\/p>\n T\u1ea1i\u00a0\u00f4 E4 t d\u00f9ng c\u00f4ng th\u1ee9c: = RIGHT(C4,3)<\/span><\/p>\n Sao\u00a0\u0111\u00f3 sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c\u00a0\u00f4 b\u00ean d\u01b0\u1edbi\u00a0\u0111\u1ebfn khi h\u1ebft danh s\u00e1ch nh\u00e2n vi\u00ean, ta\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/span><\/p>\n M\u1eddi b\u1ea1n\u00a0\u0111\u1ecdc xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau:<\/span><\/p>\n Ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n Excel<\/a><\/span><\/p>\n T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m Excel hay d\u00f9ng trong k\u1ebf to\u00e1n<\/a><\/span><\/p>\n C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel<\/a><\/span><\/p>\n1. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong\u00a0Excel<\/span><\/h2>\n
\n
![\"C\u00e1ch](\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/C\u00e1ch-s\u1eed-d\u1ee5ng-h\u00e0m-LEFT-h\u00e0m-RIGHT-trong-Excel1.jpg\")
<\/span><\/p>\n\u00a02. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RIGHT trong\u00a0Excel<\/span><\/h2>\n
\n
![\"C\u00e1ch](\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/09\/C\u00e1ch-s\u1eed-d\u1ee5ng-h\u00e0m-LEFT-h\u00e0m-RIGHT-trong-Excel-2.jpg\")
<\/span><\/p>\n