{"id":23235,"date":"2021-04-20T10:55:38","date_gmt":"2021-04-20T03:55:38","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=23235"},"modified":"2021-04-20T10:55:38","modified_gmt":"2021-04-20T03:55:38","slug":"ham-left-trong-excel-google-sheets","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-left-trong-excel-google-sheets\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel, Google Sheets"},"content":{"rendered":"

Google Sheets<\/strong> l\u00e0 c\u00f4ng c\u1ee5 b\u1ea3ng t\u00ednh mi\u1ec5n ph\u00ed tr\u1ef1c tuy\u1ebfn \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf v\u00e0 ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 Excel. C\u0169ng gi\u1ed1ng nh\u01b0 m\u1ed9t s\u1ed1 h\u00e0m Excel kh\u00e1c, h\u00e0m LEFT<\/strong> c\u0169ng ho\u1ea1t \u0111\u1ed9ng tr\u00ean Google Sheets v\u00e0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 b\u00ean tr\u00e1i. Ngo\u00e0i ra h\u00e0m LEFT tr\u00ean Google Sheets ch\u1ea5p nh\u1eadn c\u1ea3 gi\u00e1 tr\u1ecb tr\u1ef1c ti\u1ebfp v\u00e0 tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb n\u00e0y.<\/p>\n

\u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Google Sheets<\/strong>, Excel, 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 LEFT trong Google Sheets<\/strong><\/h2>\n

C\u00fa ph\u00e1p h\u00e0m LEFT tr\u00ean Google Sheets c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/em><\/p>\n

LEFT(string, [number_of_characters])<\/strong><\/p>\n

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

    \n
  • String<\/strong> (chu\u1ed7i): l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n \u0111\u1ea7u v\u00e0o b\u1eaft bu\u1ed9c c\u00f3 ch\u1ee9a k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n c\u1eaft b\u1eb1ng h\u00e0m LEFT.<\/li>\n
  • Number_of_characters<\/strong> (tham s\u1ed1 t\u00f9y ch\u1ecdn, m\u1eb7c \u0111\u1ecbnh l\u00e0 1): \u0111\u00e2y l\u00e0 s\u1ed1 k\u00fd t\u1ef1 m\u00e0 h\u00e0m LEFT t\u00ecm ki\u1ebfm b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i chu\u1ed7i v\u0103n b\u1ea3n.<\/li>\n<\/ul>\n

    C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Google Sheets<\/strong><\/h2>\n

    \u0110\u1ec3 d\u1ec5 h\u00ecnh dung c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Google Sheets nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/em><\/p>\n

    \"C\u00e1ch
    C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Google Sheets – \u1ea2nh 1<\/figcaption><\/figure>\n

    Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf, t\u01b0\u01a1ng t\u1ef1 m\u1ed9t s\u1ed1 h\u00e0m Google Sheets kh\u00e1c, h\u00e0m LEFT ch\u1ea5p nh\u1eadn c\u1ea3 gi\u00e1 tr\u1ecb tr\u1ef1c ti\u1ebfp v\u00e0 tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb n\u00e0y.<\/p>\n

    Trong v\u00ed d\u1ee5 tr\u00ean b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y h\u00e0m LEFF Google Sheets tr\u00edch xu\u1ea5t c\u00e1c k\u00fd t\u1ef1 trong chu\u1ed7i k\u00fd t\u1ef1 t\u1eeb ph\u00eda b\u00ean tr\u00e1i. Trong v\u00ed d\u1ee5 1, h\u00e0m LEFT tr\u1ea3 v\u1ec1 chu\u1ed7i “Hello there!” ban \u0111\u1ea7u th\u00e0nh chu\u1ed7i d\u00e0i 5 k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i “Hello”. T\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c v\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi kh\u00e1c.<\/p>\n

    Ngo\u00e0i ra ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c gi\u00e1 tr\u1ecb t\u0129nh cho tham s\u1ed1 number_of_characters trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu c\u1ea7n tr\u00edch xu\u1ea5t m\u1ed9t chu\u1ed7i n\u00e0o \u0111\u00f3 t\u1eeb danh s\u00e1ch c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n, m\u1ed7i chu\u1ed7i c\u00f3 \u0111\u1ed9 d\u00e0i k\u00fd t\u1ef1 kh\u00e1c nhau v\u00e0 kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t gi\u00e1 tr\u1ecb h\u1eb1ng cho number_of_characters.<\/p>\n

    Ho\u1eb7c trong tr\u01b0\u1eddng h\u1ee3p kh\u00e1c ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m FIND thay th\u1ebf \u0111\u1ec3 t\u00ecm v\u00e0 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed m\u00e0 chu\u1ed7i \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong chu\u1ed7i v\u0103n b\u1ea3n nh\u01b0 trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

    \"C\u00e1ch
    C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Google Sheets – \u1ea2nh 2<\/figcaption><\/figure>\n

    C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel<\/strong><\/h2>\n
    \"C\u00e1ch
    C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Excel<\/figcaption><\/figure>\n

    C\u00fa ph\u00e1p h\u00e0m Left trong Excel c\u00f3 d\u1ea1ng:<\/p>\n

    =LEFT(text;[num_chars])<\/strong><\/p>\n

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

      \n
    • Text<\/strong> l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c, l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n ho\u1eb7c k\u00fd t\u1ef1 m\u00e0 ch\u00fang ta mu\u1ed1n tr\u00edch xu\u1ea5t chu\u1ed7i con, k\u00fd t\u1ef1.<\/li>\n
    • Number_Chars:<\/strong> tham s\u1ed1 t\u00f9y ch\u1ecdn, l\u00e0 s\u1ed1 k\u00fd t\u1ef1 m\u00e0 ch\u00fang ta mu\u1ed1n h\u00e0m LEFT t\u00ecm ki\u1ebfm b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i text. M\u1eb7c \u0111\u1ecbnh gi\u00e1 tr\u1ecb tham s\u1ed1 n\u00e0y l\u00e0 1.<\/li>\n<\/ul>\n

      Ngo\u00e0i ra n\u1ebfu gi\u00e1 tr\u1ecb tham s\u1ed1 Num_Chars l\u1edbn h\u01a1n s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a chu\u1ed7i, h\u00e0m Left s\u1ebd tr\u1ea3 v\u1ec1 to\u00e0n b\u1ed9 chu\u1ed7i ho\u1eb7c k\u00fd t\u1ef1. N\u1ebfu b\u1ecf qua tham s\u1ed1 num_chars th\u00ec m\u1eb7c \u0111\u1ecbnh num_chars = 1.<\/p>\n

      L\u01b0u \u00fd quan tr\u1ecdng khi s\u1eed d\u1ee5ng h\u00e0m Left trong Excel<\/strong><\/h2>\n
        \n
      1. Gi\u00e1 tr\u1ecb ho\u1eb7c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ph\u1ee5 thu\u1ed9c v\u00e0o c\u00e1c tham s\u1ed1 \u0111\u01b0\u1ee3c ch\u00e8n trong c\u00f4ng th\u1ee9c, h\u00e0m Excel.<\/li>\n
      2. N\u1ebfu tham s\u1ed1 num_chars nh\u1ecf h\u01a1n 0, h\u00e0m Left Excel s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE.<\/li>\n
      3. Gi\u00e1 tr\u1ecb \u0111\u1ea7u ra ho\u1eb7c gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 c\u00f3 th\u1ec3 l\u00e0 chu\u1ed7i ho\u1eb7c v\u0103n b\u1ea3n.<\/li>\n
      4. H\u00e0m LEFT \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t k\u00fd t\u1ef1, chu\u1ed7i con t\u1eeb chu\u1ed7i v\u0103n b\u1ea3n \u0111\u00e3 cho, c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i chu\u1ed7i v\u0103n b\u1ea3n.<\/li>\n
      5. Tham s\u1ed1 num_chars l\u00e0 t\u00f9y ch\u1ecdn, gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh l\u00e0 1.<\/li>\n
      6. H\u00e0m Left ch\u1ea5p nh\u1eadn v\u00e0 c\u00f3 th\u1ec3 x\u1eed l\u00fd c\u1ea3 gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 v\u00e0 v\u0103n b\u1ea3n.<\/li>\n<\/ol>\n
        \n

        Nh\u01b0 v\u1eady b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEFT trong Google Sheets v\u00e0 Excel.<\/strong> C\u00f9ng v\u1edbi \u0111\u00f3, n\u1ebfu ch\u01b0a bi\u1ebft c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi h\u00e0m Round, Roundup 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 trang \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Excel n\u00e0y nh\u00e9.<\/p>\n

        Ngo\u00e0i ra n\u1ebfu c\u00f2n th\u1eafc m\u1eafc, c\u00e2u h\u1ecfi n\u00e0o mu\u1ed1n gi\u1ea3i \u0111\u00e1p th\u00eam, \u0111\u1eebng ng\u1ea7n ng\u1ea1i chia s\u1ebb \u00fd ki\u1ebfn c\u1ee7a b\u1ea1n cho Ben Computer trong ph\u1ea7n b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"

        Google Sheets l\u00e0 c\u00f4ng c\u1ee5 b\u1ea3ng t\u00ednh mi\u1ec5n ph\u00ed tr\u1ef1c tuy\u1ebfn \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf v\u00e0 ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 Excel. C\u0169ng gi\u1ed1ng nh\u01b0 m\u1ed9t s\u1ed1 h\u00e0m Excel kh\u00e1c, h\u00e0m LEFT c\u0169ng ho\u1ea1t \u0111\u1ed9ng tr\u00ean Google Sheets v\u00e0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00fd t\u1ef1 b\u00ean tr\u00e1i. Ngo\u00e0i ra h\u00e0m LEFT tr\u00ean Google Sheets ch\u1ea5p […]<\/p>\n","protected":false},"author":39,"featured_media":23248,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-23235","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\/23235","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=23235"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/23235\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/23248"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=23235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=23235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=23235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}