{"id":830,"date":"2020-01-17T12:04:30","date_gmt":"2020-01-17T12:04:30","guid":{"rendered":"http:\/\/helpvn.mshopkeeper.misa.local\/vi\/?post_type=ht_kb&#038;p=830"},"modified":"2020-04-14T09:51:20","modified_gmt":"2020-04-14T02:51:20","slug":"tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao","status":"publish","type":"ht_kb","link":"\/v1\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao","title":{"rendered":"T\u00e1ch chu\u1ed7i k\u00fd t\u1ef1 khi khai b\u00e1o t\u1ec7p nh\u1eadp kh\u1ea9u h\u00e0ng h\u00f3a nh\u01b0 n\u00e0o?"},"content":{"rendered":"<p><strong><span>M\u1ee4C \u0110\u00cdCH:<br \/>\n<\/span><\/strong>H\u01b0\u1edbng d\u1eabn kh\u00e1ch h\u00e0ng t\u00e1ch th\u00f4ng tin m\u00e0u\/size t\u1eeb t\u00ean h\u00e0ng h\u00f3a \u0111\u1ec3 khai b\u00e1o t\u1ec7p nh\u1eadp kh\u1ea9u gi\u00fap nh\u1eadp kh\u1ea9u h\u00e0ng h\u00f3a v\u00e0o ph\u1ea7n m\u1ec1m \u0111\u01b0\u1ee3c nhanh ch\u00f3ng v\u00e0 thu\u1eadn ti\u1ec7n nh\u1ea5t. <br \/>\n<span><strong>C\u00c1C C\u00c1CH TH\u1ef0C HI\u1ec6N<\/strong><\/span><\/p>\n<p><strong>C\u00c1CH 1: L\u00c0M TH\u1ebe N\u00c0O \u0110\u1ec2 CHIA V\u0102N B\u1ea2N TRONG EXCEL B\u1eb0NG C\u00c1CH S\u1eec D\u1ee4NG C\u00d4NG TH\u1ee8C:<\/strong><\/p>\n<\/p>\n<p>\u0110\u1ec3 t\u00e1ch chu\u1ed7i trong Excel, b\u1ea1n th\u01b0\u1eddng s\u1eed d\u1ee5ng h\u00e0m LEFT, RIGHT ho\u1eb7c MID k\u1ebft h\u1ee3p v\u1edbi FIND ho\u1eb7c SEARCH. T\u00e1ch chu\u1ed7i b\u1eb1ng d\u1ea5u ph\u1ea9y, d\u1ea5u hai ch\u1ea5m, d\u1ea5u g\u1ea1ch ch\u00e9o, d\u1ea5u g\u1ea1ch ngang ho\u1eb7c d\u1ea5u ph\u00e2n c\u00e1ch kh\u00e1c. Khi ph\u00e2n chia c\u00e1c \u00f4 trong Excel, vi\u1ec7c ch\u00ednh l\u00e0 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u ph\u00e2n c\u00e1ch trong chu\u1ed7i v\u0103n b\u1ea3n. T\u00f9y thu\u1ed9c v\u00e0o c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n, \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Search kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng ho\u1eb7c h\u00e0m Find c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng. M\u1ed9t khi b\u1ea1n c\u00f3 v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u ph\u00e2n c\u00e1ch, s\u1eed d\u1ee5ng h\u00e0m RIGHT, LEFT ho\u1eb7c MID \u0111\u1ec3 tr\u00edch xu\u1ea5t ph\u1ea7n t\u01b0\u01a1ng \u1ee9ng c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n<\/p>\n<p>\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n, h\u00e3y xem x\u00e9t v\u00ed d\u1ee5 sau \u0111\u00e2y: <\/p>\n<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c SKU c\u1ee7a m\u1eabu Lo\u1ea1i-M\u00e0u-K\u00edch th\u01b0\u1edbc, v\u00e0 b\u1ea1n mu\u1ed1n chia t\u00e1ch c\u1ed9t th\u00e0nh 3 c\u1ed9t ri\u00eang bi\u1ec7t:<\/p>\n<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/v1\/wp-content\/uploads\/2020\/02\/split-string-excel.png\"><\/p>\n<\/p>\n<p>1. \u0110\u1ec3 tr\u00edch xu\u1ea5t t\u00ean m\u1ee5c (t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 tr\u01b0\u1edbc d\u1ea5u n\u1ed1i \u0111\u1ea7u ti\u00ean), ch\u00e8n c\u00f4ng th\u1ee9c sau trong B2, v\u00e0 sau \u0111\u00f3 sao ch\u00e9p n\u00f3 xu\u1ed1ng c\u1ed9t:<\/p>\n<\/p>\n<p>= LEFT (A2, search (&ldquo;-&ldquo;, A2,1) -1)<\/p>\n<\/p>\n<p>Trong c\u00f4ng th\u1ee9c n\u00e0y, h\u00e0m Search x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u n\u1ed1i \u0111\u1ea7u ti\u00ean (&ldquo;-&ldquo;) trong chu\u1ed7i v\u00e0 ch\u1ee9c n\u0103ng LEFT s\u1ebd chi\u1ebft t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 c\u00f2n l\u1ea1i (b\u1ea1n tr\u1eeb 1 t\u1eeb v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u n\u1ed1i b\u1edfi v\u00ec b\u1ea1n kh\u00f4ng mu\u1ed1n c\u00f3 d\u1ea5u n\u1ed1i).<\/p>\n<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/v1\/wp-content\/uploads\/2020\/02\/extract-text-left.png\"><\/p>\n<\/p>\n<p>2. \u0110\u1ec3 tr\u00edch xu\u1ea5t m\u00e0u s\u1eafc (t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 gi\u1eefa c\u00e1c d\u1ea5u g\u1ea1ch n\u1ed1i th\u1ee9 2 v\u00e0 th\u1ee9 3), h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c sau trong C2, v\u00e0 sau \u0111\u00f3 sao ch\u00e9p n\u00f3 xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c:<\/p>\n<\/p>\n<p>=MID(&ldquo;-&ldquo;, A2) &ndash; 1 (SEARCH(&ldquo;-&ldquo;, A2) +1) &ndash; SEARCH (&ldquo;-&ldquo;, A2) &ndash; 1) <\/p>\n<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/v1\/wp-content\/uploads\/2020\/02\/extract-text-mid.png\"> <\/p>\n<\/p>\n<p>Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 bi\u1ebft, h\u00e0m MID c\u00f3 c\u00fa ph\u00e1p sau:<\/p>\n<\/p>\n<p><strong>MID (v\u0103n b\u1ea3n, start_num, num_chars)<\/strong><\/p>\n<\/p>\n<p>Trong \u0111\u00f3: <\/p>\n<\/p>\n<ul>\n<li>V\u0103n b\u1ea3n &ndash; n\u01a1i \u0111\u1ec3 tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n t\u1eeb.<\/li>\n<li>Start_num &ndash; v\u1ecb tr\u00ed c\u1ee7a k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean \u0111\u1ec3 tr\u00edch xu\u1ea5t.<\/li>\n<li>Num_chars &ndash; s\u1ed1 k\u00fd t\u1ef1 \u0111\u1ec3 tr\u00edch xu\u1ea5t.<\/li>\n<\/ul>\n<p>Trong c\u00f4ng th\u1ee9c tr\u00ean, v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c tr\u00edch ra t\u1eeb \u00f4 A2, v\u00e0 2 \u0111\u1ed1i s\u1ed1 kh\u00e1c \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng 4 h\u00e0m SEARCH kh\u00e1c:<\/p>\n<\/p>\n<ul>\n<li>S\u1ed1 b\u1eaft \u0111\u1ea7u (start_num) l\u00e0 v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u n\u1ed1i \u0111\u1ea7u ti\u00ean +1:<\/li>\n<\/ul>\n<p><strong>SEARCH (&ldquo;-&ldquo;, A2) + 1<\/strong><\/p>\n<\/p>\n<ul>\n<li>S\u1ed1 k\u00fd t\u1ef1 \u0111\u1ec3 tr\u00edch xu\u1ea5t (num_chars): s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u n\u1ed1i th\u1ee9 hai v\u00e0 d\u1ea5u n\u1ed1i \u0111\u1ea7u ti\u00ean, tr\u1eeb \u0111i 1:<\/li>\n<\/ul>\n<p><strong>SEARCH (&ldquo;-&ldquo;, A2, SEARCH (&ldquo;-&ldquo;, A2) +1) &ndash; SEARCH (&ldquo;-&ldquo;, A2) -1<\/strong><\/p>\n<\/p>\n<\/p>\n<p>3. \u0110\u1ec3 tr\u00edch xu\u1ea5t k\u00edch th\u01b0\u1edbc (t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 sau d\u1ea5u n\u1ed1i th\u1ee9 3), h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c sau trong D2:<\/p>\n<\/p>\n<p><strong>= RIGHT (A2, LEN (A2) &ndash; SEARCH (&ldquo;-&ldquo;, A2, SEARCH (&ldquo;-&ldquo;, A2) + 1))<\/strong><\/p>\n<\/p>\n<p>Trong c\u00f4ng th\u1ee9c n\u00e0y, h\u00e0m LEN tr\u1ea3 v\u1ec1 t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i, t\u1eeb \u0111\u00f3 b\u1ea1n tr\u1eeb \u0111i v\u1ecb tr\u00ed c\u1ee7a d\u1ea5u n\u1ed1i th\u1ee9 hai. S\u1ef1 kh\u00e1c bi\u1ec7t l\u00e0 s\u1ed1 k\u00fd t\u1ef1 sau d\u1ea5u n\u1ed1i th\u1ee9 hai v\u00e0 h\u00e0m RIGHT chi\u1ebft xu\u1ea5t ch\u00fang.<\/p>\n<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/v1\/wp-content\/uploads\/2020\/02\/extract-text-right.png\"><\/p>\n<\/p>\n<p>Trong m\u1ed9t c\u00e1ch t\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 ph\u00e2n chia c\u1ed9t b\u1edfi b\u1ea5t k\u1ef3 k\u00ed t\u1ef1 n\u00e0o kh\u00e1c. T\u1ea5t c\u1ea3 b\u1ea1n ph\u1ea3i l\u00e0m l\u00e0 thay th\u1ebf &ldquo;-&rdquo; b\u1eb1ng k\u00fd t\u1ef1 ph\u00e2n c\u00e1ch b\u1eaft bu\u1ed9c, v\u00ed d\u1ee5 nh\u01b0 d\u1ea5u c\u00e1ch (&ldquo;&rdquo;), d\u1ea5u g\u1ea1ch ch\u00e9o (&ldquo;\/&rdquo;), d\u1ea5u hai ch\u1ea5m (&ldquo;;&rdquo;), d\u1ea5u ch\u1ea5m ph\u1ea9y (&ldquo;;&rdquo;) v\u00e0 v\u00e2n v\u00e2n.<\/p>\n<\/p>\n<p><strong>M\u1eb9o.<\/strong> Trong c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean, +1 v\u00e0 -1 t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 k\u00fd t\u1ef1 trong d\u1ea5u ph\u00e2n c\u00e1ch. Trong v\u00ed d\u1ee5 n\u00e0y, n\u00f3 l\u00e0 m\u1ed9t d\u1ea5u n\u1ed1i (1 k\u00fd t\u1ef1). N\u1ebfu d\u1ea5u ph\u00e2n c\u00e1ch c\u1ee7a b\u1ea1n bao g\u1ed3m 2 k\u00fd t\u1ef1, v\u00ed d\u1ee5: D\u1ea5u ph\u1ea9y v\u00e0 kho\u1ea3ng tr\u1eafng, sau \u0111\u00f3 ch\u1ec9 cung c\u1ea5p d\u1ea5u ph\u1ea9y (&ldquo;,&rdquo;) cho h\u00e0m SEARCH, v\u00e0 s\u1eed d\u1ee5ng +2 v\u00e0 -2 thay v\u00ec +1 v\u00e0 -1.<\/p>\n<\/p>\n<p><strong>C\u00c1CH 2: L\u00c0M TH\u1ebe N\u00c0O \u0110\u1ec2 PH\u00c2N CHIA CHU\u1ed6I B\u1eb0NG C\u00c1CH NG\u1eaeT D\u00d2NG TRONG EXCEL:<\/strong><\/p>\n<\/p>\n<p>\u0110\u1ec3 chia v\u0103n b\u1ea3n b\u1eb1ng kho\u1ea3ng tr\u1eafng, h\u00e3y s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c minh h\u1ecda trong v\u00ed d\u1ee5 tr\u01b0\u1edbc. S\u1ef1 kh\u00e1c bi\u1ec7t duy nh\u1ea5t l\u00e0 b\u1ea1n c\u1ea7n ch\u1ee9c n\u0103ng CHAR \u0111\u1ec3 cung c\u1ea5p cho k\u00fd t\u1ef1 ng\u1eaft d\u00f2ng v\u00ec b\u1ea1n kh\u00f4ng th\u1ec3 g\u00f5 tr\u1ef1c ti\u1ebfp v\u00e0o c\u00f4ng th\u1ee9c. Gi\u1ea3 s\u1eed, c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n chia nh\u1ecf tr\u00f4ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/p>\n<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/v1\/wp-content\/uploads\/2020\/02\/excel-split-cells.png\"><\/p>\n<\/p>\n<p>L\u1ea5y c\u00f4ng th\u1ee9c t\u1eeb v\u00ed d\u1ee5 tr\u01b0\u1edbc v\u00e0 thay d\u1ea5u g\u1ea1ch n\u1ed1i (&ldquo;-&ldquo;) b\u1eb1ng CHAR (10) trong \u0111\u00f3 10 l\u00e0 m\u00e3 ASCII cho d\u00f2ng c\u1ea5p d\u1eef li\u1ec7u.<\/p>\n<\/p>\n<ul>\n<li>\u0110\u1ec3 tr\u00edch xu\u1ea5t t\u00ean m\u1eb7t h\u00e0ng:<\/li>\n<\/ul>\n<p><strong>=LEFT(A2, SEARCH(CHAR(10),A2,1)-1)<\/strong><\/p>\n<\/p>\n<ul>\n<li>\u0110\u1ec3 tr\u00edch xu\u1ea5t m\u00e0u s\u1eafc:<\/li>\n<\/ul>\n<p><strong>=MID(A2, SEARCH(CHAR(10),A2) + 1, SEARCH(CHAR(10),A2,SEARCH(CHAR(10),A2)+1) &ndash; SEARCH(CHAR(10),A2) &ndash; 1)<\/strong><\/p>\n<\/p>\n<ul>\n<li>\u0110\u1ec3 tr\u00edch xu\u1ea5t k\u00edch th\u01b0\u1edbc:<\/li>\n<\/ul>\n<p><strong>=RIGHT(A2,LEN(A2) &ndash; SEARCH(CHAR(10), A2, SEARCH(CHAR(10), A2) + 1))<\/strong><\/p>\n<\/p>\n<\/p>\n<p>V\u00e0 \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3:<\/p>\n<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/v1\/wp-content\/uploads\/2020\/02\/split-text-line-break.png\"><\/p>\n<\/p>\n<\/p>\n<p><strong>C\u00c1CH 3: L\u00c0M TH\u1ebe N\u00c0O \u0110\u1ec2 PH\u00c2N CHIA V\u0102N B\u1ea2N V\u00c0 S\u1ed0 TRONG EXCEL:<\/strong><\/p>\n<\/p>\n<p>\u0110\u1ec3 b\u1eaft \u0111\u1ea7u, kh\u00f4ng c\u00f3 gi\u1ea3i ph\u00e1p t\u1ed5ng qu\u00e1t cho t\u1ea5t c\u1ea3 c\u00e1c chu\u1ed7i ch\u1eef s\u1ed1. C\u00f4ng th\u1ee9c n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng ph\u1ee5 thu\u1ed9c v\u00e0o m\u1eabu chu\u1ed7i c\u1ee5 th\u1ec3. D\u01b0\u1edbi \u0111\u00e2y b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y c\u00f4ng th\u1ee9c cho 3 k\u1ecbch b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u1ea5t.<\/p>\n<\/p>\n<p><strong>V\u00cd D\u1ee4 1. CHIA CHU\u1ed6I C\u1ee6A LO\u1ea0I &lsquo;V\u0102N B\u1ea2N + S\u1ed0&rsquo;<\/strong><\/p>\n<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t c\u1ed9t c\u00e1c chu\u1ed7i v\u1edbi v\u0103n b\u1ea3n v\u00e0 s\u1ed1 k\u1ebft h\u1ee3p, trong \u0111\u00f3 m\u1ed9t s\u1ed1 lu\u00f4n lu\u00f4n theo sau v\u0103n b\u1ea3n. B\u1ea1n mu\u1ed1n ph\u00e1 v\u1ee1 c\u00e1c chu\u1ed7i ban \u0111\u1ea7u \u0111\u1ec3 v\u0103n b\u1ea3n v\u00e0 s\u1ed1 xu\u1ea5t hi\u1ec7n trong c\u00e1c \u00f4 ri\u00eang bi\u1ec7t, nh\u01b0 sau:<\/p>\n<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/v1\/wp-content\/uploads\/2020\/02\/split-text-numbers.png\"><\/p>\n<\/p>\n<\/p>\n<p>\u0110\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c s\u1ed1, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng sau \u0111\u00e2y, \u0111\u01b0\u1ee3c ho\u00e0n th\u00e0nh b\u1eb1ng c\u00e1ch nh\u1ea5n Ctrl + Shift + Enter:<\/p>\n<\/p>\n<\/p>\n<p><strong>= RIGHT (A2, SUM (LEN (A2) &ndash; LEN (SUBSTITUTE (A2, &ldquo;0&rdquo;, &ldquo;1&rdquo;, &ldquo;2&rdquo;, &ldquo;3&rdquo;, &ldquo;4&rdquo;, &ldquo;5&rdquo;, &ldquo;6&rdquo;, &ldquo;7&rdquo; , &ldquo;8&rdquo;, &ldquo;9&rdquo;}, &ldquo;&rdquo;))))<\/strong><\/p>\n<\/p>\n<\/p>\n<p>\u0110\u1ec3 tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n, s\u1eed d\u1ee5ng:<\/p>\n<\/p>\n<\/p>\n<p><strong>= LEFT (A2, LEN (A2) -LEN (C2))<\/strong><\/p>\n<\/p>\n<\/p>\n<p>Tr\u01b0\u1eddng h\u1ee3p A2 l\u00e0 chu\u1ed7i ban \u0111\u1ea7u, v\u00e0 C2 l\u00e0 s\u1ed1 tr\u00edch xu\u1ea5t, nh\u01b0 th\u1ec3 hi\u1ec7n trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/v1\/wp-content\/uploads\/2020\/02\/excel-dialog-box-launcher-1-178.png\"><\/p>\n<\/p>\n<\/p>\n<p><strong>C\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o:<\/strong><\/p>\n<\/p>\n<p><strong>C\u00f4ng th\u1ee9c \u0111\u1ec3 tr\u00edch xu\u1ea5t s\u1ed1 (h\u00e0m RIGHT)<\/strong>. V\u1ec1 c\u01a1 b\u1ea3n, c\u00f4ng th\u1ee9c t\u00ecm ki\u1ebfm m\u1ecdi s\u1ed1 c\u00f3 th\u1ec3 t\u1eeb 0 \u0111\u1ebfn 9 trong chu\u1ed7i ngu\u1ed3n, t\u00ednh s\u1ed1 l\u01b0\u1ee3ng v\u00e0 tr\u1ea3 v\u1ec1 nhi\u1ec1u k\u00fd t\u1ef1 t\u1eeb k\u00fd t\u1ef1 cu\u1ed1i chu\u1ed7i ban \u0111\u1ea7u.<\/p>\n<\/p>\n<p>V\u00e0 \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c chi ti\u1ebft ph\u00e2n r\u00e3:<\/p>\n<\/p>\n<ul>\n<li>Tr<span>\u01b0\u1edbc ti\u00ean, b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m LEN v\u00e0 SUBSTITUTE \u0111\u1ec3 t<\/span><span>\u00ecm ra s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n m\u1ed9t s\u1ed1 n\u00e0o \u0111\u00f3 trong chu\u1ed7i g\u1ed1c &ndash; thay th\u1ebf s\u1ed1 b\u1eb1ng m\u1ed9t chu\u1ed7i r\u1ed7ng (&ldquo;&rdquo;), v\u00e0 sau \u0111\u00f3 tr\u1eeb \u0111i chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i m\u00e0 kh\u00f4ng c\u00f3 s\u1ed1 \u0111\u00f3 t\u1eeb t\u1ed5ng s\u1ed1 Chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i ban \u0111\u1ea7u. B\u1edfi v\u00ec \u0111\u00f3 l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng, thao t\u00e1c n\u00e0y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n tr\u00ean m\u1ed7i s\u1ed1 trong h\u1eb1ng m\u1ea3ng:<\/span><\/li>\n<\/ul>\n<p><strong>LEN (A2) -LEN (SUBSTITUTE (A2, &ldquo;0&rdquo;, &ldquo;1&rdquo;, &ldquo;2&rdquo;, &ldquo;3&rdquo;, &ldquo;4&rdquo;, &ldquo;5&rdquo;, &ldquo;6&rdquo;, &ldquo;7&rdquo;, &ldquo;8&rdquo;, &ldquo;9 &ldquo;},&rdquo; &ldquo;)<\/strong><\/p>\n<\/p>\n<ul>\n<li>Ti\u1ebfp theo, h\u00e0m SUM th\u00eam t\u1ea5t c\u1ea3 c\u00e1c l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c ch\u1eef s\u1ed1 trong chu\u1ed7i ngu\u1ed3n.<\/li>\n<li>Cu\u1ed1i c\u00f9ng, h\u00e0m RIGHT tr\u1ea3 v\u1ec1 nhi\u1ec1u k\u00fd t\u1ef1 t\u1eeb ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a chu\u1ed7i.<\/li>\n<\/ul>\n<p><strong>C\u00f4ng th\u1ee9c \u0111\u1ec3 tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n (h\u00e0m LEFT)<\/strong>. B\u1ea1n t\u00ednh to\u00e1n bao nhi\u00eau k\u00fd t\u1ef1 v\u0103n b\u1ea3n chu\u1ed7i ch\u1ee9a b\u1eb1ng c\u00e1ch tr\u1eeb s\u1ed1 ch\u1eef s\u1ed1 chi\u1ebft xu\u1ea5t (C2) t\u1eeb chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i g\u1ed1c (A2). Sau \u0111\u00f3, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m LEFT \u0111\u1ec3 tr\u1ea3 v\u1ec1 nhi\u1ec1u k\u00fd t\u1ef1 t\u1eeb \u0111\u1ea7u chu\u1ed7i.<\/p>\n<\/p>\n<p>M\u1ed9t gi\u1ea3i ph\u00e1p kh\u00e1c (c\u00f4ng th\u1ee9c kh\u00f4ng c\u00f3 m\u1ea3ng)<\/p>\n<\/p>\n<p>Gi\u1ea3i ph\u00e1p thay th\u1ebf s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a s\u1ed1 \u0111\u1ea7u ti\u00ean trong chu\u1ed7i: <strong>= MIN (SEARCH ({0,1,2,3,4,5,6,7,8,9}, A2 &#038; &ldquo;0123456789&rdquo;))<\/strong><\/p>\n<\/p>\n<p>M\u1eb7c d\u00f9 c\u00f4ng th\u1ee9c c\u0169ng ch\u1ee9a m\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng, \u0111\u00f3 l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c b\u00ecnh th\u01b0\u1eddng \u0111\u01b0\u1ee3c ho\u00e0n th\u00e0nh theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng b\u1eb1ng c\u00e1ch nh\u1ea5n ph\u00edm Enter.<\/p>\n<\/p>\n<p>Khi v\u1ecb tr\u00ed c\u1ee7a s\u1ed1 \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, b\u1ea1n c\u00f3 th\u1ec3 t\u00e1ch v\u0103n b\u1ea3n v\u00e0 s\u1ed1 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c LEFT v\u00e0 RIGHT r\u1ea5t \u0111\u01a1n gi\u1ea3n (nh\u1edb r\u1eb1ng m\u1ed9t s\u1ed1 lu\u00f4n xu\u1ea5t hi\u1ec7n sau v\u0103n b\u1ea3n):<\/p>\n<\/p>\n<ul>\n<li>\u0110\u1ec3 tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n:<\/li>\n<\/ul>\n<p><strong>= LEFT (A2, B2-1)<\/strong><\/p>\n<\/p>\n<ul>\n<li>\u0110\u1ec3 tr\u00edch xu\u1ea5t s\u1ed1:<\/li>\n<\/ul>\n<p><strong>=RIGHT(B2, LEN(A1)-B2+1)<\/strong><\/p>\n<\/p>\n<\/p>\n<p>Tr\u01b0\u1eddng h\u1ee3p A2 l\u00e0 chu\u1ed7i ban \u0111\u1ea7u, v\u00e0 B2 l\u00e0 v\u1ecb tr\u00ed c\u1ee7a s\u1ed1 \u0111\u1ea7u ti\u00ean, nh\u01b0 th\u1ec3 hi\u1ec7n trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/v1\/wp-content\/uploads\/2020\/02\/split-text-number-formula1.png\"><\/p>\n<\/p>\n<p>\u0110\u1ec3 lo\u1ea1i b\u1ecf c\u1ed9t helper gi\u1eef v\u1ecb tr\u00ed s\u1ed1 b\u1eaft \u0111\u1ea7u, b\u1ea1n c\u00f3 th\u1ec3 nh\u00fang h\u00e0m MIN v\u00e0o c\u00e1c h\u00e0m LEFT v\u00e0 RIGHT:<\/p>\n<\/p>\n<ul>\n<li>C\u00f4ng th\u1ee9c tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n:<\/li>\n<\/ul>\n<p><strong>= LEFT (A2, MIN (SEARCH ({0,1,2,3,4,5,6,7,8,9}, A2 &#038; &ldquo;0123456789&rdquo;)) &ndash; 1)<\/strong><\/p>\n<\/p>\n<ul>\n<li>C\u00f4ng th\u1ee9c tr\u00edch xu\u1ea5t c\u00e1c s\u1ed1:<\/li>\n<\/ul>\n<p><strong>= RIGHT (A2, LEN (A2) -MIN (SEARCH({0,1,2,3,4,5,6,7,8,9}, A2 &#038; &ldquo;0123456789&rdquo;)) + 1)<\/strong><\/p>\n<\/p>\n<\/p>\n<p>C\u00f4ng th\u1ee9c t\u00ednh to\u00e1n v\u1ecb tr\u00ed c\u1ee7a s\u1ed1 th\u1ee9 nh\u1ea5t<\/p>\n<\/p>\n<p>B\u1ea1n cung c\u1ea5p h\u1eb1ng s\u1ed1 m\u1ea3ng {0,1,2,3,4,5,6,7,8,9} trong \u0111\u1ed1i s\u1ed1 find_text c\u1ee7a h\u00e0m SEARCH, l\u00e0m cho n\u00f3 t\u00ecm t\u1eebng s\u1ed1 trong h\u1eb1ng s\u1ed1 m\u1ea3ng b\u00ean trong b\u1ea3n g\u1ed1c, v\u00e0 tr\u1ea3 l\u1ea1i v\u1ecb tr\u00ed c\u1ee7a ch\u00fang. B\u1edfi v\u00ec h\u1eb1ng s\u1ed1 m\u1ea3ng ch\u1ee9a 10 ch\u1eef s\u1ed1, m\u1ea3ng k\u1ebft qu\u1ea3 c\u0169ng ch\u1ee9a 10 m\u1ee5c.<\/p>\n<\/p>\n<p>H\u00e0m MIN l\u1ea5y m\u1ea3ng k\u1ebft qu\u1ea3 v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t, t\u01b0\u01a1ng \u1ee9ng v\u1edbi v\u1ecb tr\u00ed c\u1ee7a s\u1ed1 \u0111\u1ea7u ti\u00ean trong chu\u1ed7i ban \u0111\u1ea7u.<\/p>\n<\/p>\n<p>Ngo\u00e0i ra, ch\u00fang t\u00f4i s\u1eed d\u1ee5ng m\u1ed9t c\u1ea5u tr\u00fac \u0111\u1eb7c bi\u1ec7t (A2 &#038; &ldquo;0123456789&rdquo;) \u0111\u1ec3 gh\u00e9p m\u1ed7i s\u1ed1 c\u00f3 th\u1ec3 v\u1edbi chu\u1ed7i ban \u0111\u1ea7u. C\u00e1ch n\u00e0y th\u1ef1c hi\u1ec7n vai tr\u00f2 c\u1ee7a IFERROR v\u00e0 cho ph\u00e9p ch\u00fang t\u00f4i tr\u00e1nh l\u1ed7i khi m\u1ed9t s\u1ed1 nh\u1ea5t \u0111\u1ecbnh trong h\u1eb1ng s\u1ed1 m\u1ea3ng kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong chu\u1ed7i ngu\u1ed3n. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed &ldquo;gi\u1ea3 m\u1ea1o&rdquo; b\u1eb1ng chu\u1ed7i chi\u1ec1u d\u00e0i t\u1eeb 1 k\u00fd t\u1ef1 tr\u1edf l\u00ean. \u0110i\u1ec1u n\u00e0y cho ph\u00e9p h\u00e0m LEFT tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n v\u00e0 h\u00e0m RIGHT tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i r\u1ed7ng n\u1ebfu chu\u1ed7i g\u1ed1c kh\u00f4ng ch\u1ee9a b\u1ea5t k\u1ef3 s\u1ed1 n\u00e0o, nh\u01b0 trong d\u00f2ng 7 h\u00ecnh \u1edf tr\u00ean.<\/p>\n<\/p>\n<p>V\u00ed d\u1ee5: \u0111\u1ed1i v\u1edbi chu\u1ed7i &ldquo;Dress 05&rdquo; trong A2, m\u1ea3ng k\u1ebft qu\u1ea3 l\u00e0 {7,10,11,12,13,8,15,16,17,18}. V\u00e0 \u0111\u00e2y l\u00e0 c\u00e1ch ch\u00fang t\u00f4i c\u00f3:<\/p>\n<\/p>\n<p>5 l\u00e0 k\u00fd t\u1ef1 th\u1ee9 8 trong chu\u1ed7i g\u1ed1c, v\u00e0 0 l\u00e0 k\u00fd t\u1ef1 th\u1ee9 7, \u0111\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao m\u1ee5c \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ea3ng k\u1ebft qu\u1ea3 l\u00e0 &ldquo;7&rdquo;, v\u00e0 th\u1ee9 s\u00e1u l\u00e0 &ldquo;8&rdquo;.<\/p>\n<\/p>\n<p>Kh\u00f4ng c\u00f3 m\u1ee5c n\u00e0o kh\u00e1c c\u1ee7a h\u1eb1ng s\u1ed1 m\u1ea3ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong A2, v\u00e0 do \u0111\u00f3 8 ph\u1ea7n kh\u00e1c c\u1ee7a m\u1ea3ng k\u1ebft qu\u1ea3 \u0111\u1ea1i di\u1ec7n cho c\u00e1c v\u1ecb tr\u00ed c\u1ee7a c\u00e1c ch\u1eef s\u1ed1 t\u01b0\u01a1ng \u1ee9ng trong chu\u1ed7i n\u1ed1i (A2 &#038; &ldquo;0123456789&rdquo;).<\/p>\n<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/v1\/wp-content\/uploads\/2020\/02\/arrays.png\"><br \/>\nV\u00e0 b\u1edfi v\u00ec 7 l\u00e0 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong m\u1ea3ng k\u1ebft qu\u1ea3, do h\u00e0m MIN tr\u1ea3 v\u1ec1, v\u00e0 ch\u00fang ta nh\u1eadn \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ee7a s\u1ed1 \u0111\u1ea7u ti\u00ean (0) trong chu\u1ed7i v\u0103n b\u1ea3n ban \u0111\u1ea7u.<\/p>\n<\/p>\n<\/p>\n<p><strong>V\u00cd D\u1ee4 2. CHIA CHU\u1ed6I C\u1ee6A LO\u1ea0I &lsquo;S\u1ed0 + V\u0102N B\u1ea2N&rsquo;<\/strong><\/p>\n<\/p>\n<p>N\u1ebfu b\u1ea1n \u0111ang t\u00e1ch c\u00e1c \u00f4 n\u01a1i v\u0103n b\u1ea3n xu\u1ea5t hi\u1ec7n sau m\u1ed9t s\u1ed1, b\u1ea1n c\u00f3 th\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c s\u1ed1 v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng n\u00e0y (ho\u00e0n th\u00e0nh b\u1eb1ng c\u00e1ch nh\u1ea5n Ctrl + Shift + Enter):<\/p>\n<\/p>\n<p>=<strong> LEFT (A2, SUM (LEN (A2) -LEN (SUBSTITUTE (A2, {&ldquo;0&rdquo;, &ldquo;1&rdquo;, &ldquo;2&rdquo;, &ldquo;3&rdquo;, &ldquo;4&rdquo;, &ldquo;5&rdquo;, &ldquo;6&rdquo;, &ldquo;7&rdquo; , &ldquo;8&rdquo;, &ldquo;9&rdquo;}, &ldquo;&rdquo;))))<\/strong><\/p>\n<\/p>\n<p>C\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00f4ng th\u1ee9c m\u1ea3ng t\u1eeb v\u00ed d\u1ee5 tr\u01b0\u1edbc, ngo\u1ea1i tr\u1eeb b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m LEFT thay v\u00ec RIGHT, b\u1edfi v\u00ec trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y s\u1ed1 lu\u00f4n xu\u1ea5t hi\u1ec7n \u1edf ph\u00eda b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i. M\u1ed9t khi b\u1ea1n \u0111\u00e3 c\u00f3 c\u00e1c con s\u1ed1, tr\u00edch xu\u1ea5t v\u0103n b\u1ea3n b\u1eb1ng c\u00e1ch tr\u1eeb s\u1ed1 ch\u1eef s\u1ed1 t\u1eeb t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i g\u1ed1c:<\/p>\n<\/p>\n<p><strong>= RIGHT(A2, LEN (A2) -LEN (B2))<\/strong><\/p>\n<\/p>\n<\/p>\n<p>Trong c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean, A2 l\u00e0 chu\u1ed7i ban \u0111\u1ea7u v\u00e0 B2 l\u00e0 s\u1ed1 tr\u00edch xu\u1ea5t, nh\u01b0 th\u1ec3 hi\u1ec7n trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/v1\/wp-content\/uploads\/2020\/02\/split-string-number-text.png\"><\/p>\n<\/p>\n<\/p>\n<p><strong>V\u00cd D\u1ee4 3. TR\u00cdCH XU\u1ea4T CH\u1ec8 S\u1ed0 T\u1eea CHU\u1ed6I S\u1ed0 &lsquo;S\u1ed0 V\u0102N B\u1ea2N&rsquo;<\/strong><\/p>\n<\/p>\n<p>N\u1ebfu c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n \u0111\u00f2i h\u1ecfi ph\u1ea3i tr\u00edch xu\u1ea5t t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 t\u1eeb m\u1ed9t chu\u1ed7i trong \u0111\u1ecbnh d\u1ea1ng &lsquo;number-text-number&rsquo;, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u01b0\u1ee3c g\u1ee3i \u00fd b\u1edfi m\u1ed9t trong nh\u1eefng chuy\u00ean gia c\u1ee7a MrExcel:<\/p>\n<\/p>\n<\/p>\n<p><strong>= SUMPRODUCT (MID (0 &#038; A2, LARGE (INDEX (ISNUMBER (- MID (A2, ROW (INDIRECT (&ldquo;1:&rdquo; &#038; LEN (A2))), 1)) * ROW (TR\u1ef0C TI\u1ebeP (&ldquo;1:&rdquo; &#038; LEN (A2) (1: &ldquo;&#038; LEN (A2)))) + 1, 1) * 10 ^ ROW (INDIRECT (&rdquo; 1: &ldquo;&#038; LEN (A2))) \/ 10)<\/strong><\/p>\n<\/p>\n<p> <span>Tr<\/span><span>\u01b0\u1eddng h\u1ee3p A2 l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n ban \u0111\u1ea7u.<\/span> <br \/>\n<img decoding=\"async\" alt=\"\" src=\"\/v1\/wp-content\/uploads\/2020\/02\/excel-dialog-box-launcher-1-179.png\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>M\u1ee4C \u0110\u00cdCH: H\u01b0\u1edbng d\u1eabn kh\u00e1ch h\u00e0ng t\u00e1ch th\u00f4ng tin m\u00e0u\/size t\u1eeb t\u00ean h\u00e0ng h\u00f3a \u0111\u1ec3 khai b\u00e1o t\u1ec7p nh\u1eadp kh\u1ea9u gi\u00fap nh\u1eadp kh\u1ea9u h\u00e0ng h\u00f3a v\u00e0o ph\u1ea7n m\u1ec1m \u0111\u01b0\u1ee3c nhanh ch\u00f3ng v\u00e0 thu\u1eadn ti\u1ec7n nh\u1ea5t. C\u00c1C C\u00c1CH TH\u1ef0C HI\u1ec6N C\u00c1CH 1: L\u00c0M TH\u1ebe N\u00c0O \u0110\u1ec2 CHIA V\u0102N B\u1ea2N TRONG EXCEL&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[325,515],"ht-kb-tag":[],"class_list":["post-830","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-quan_ly_hang_hoa","ht_kb_category-quan-ly-hang-hoa-cau-hoi-thuong-gap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>T\u00e1ch chu\u1ed7i k\u00fd t\u1ef1 khi khai b\u00e1o t\u1ec7p nh\u1eadp kh\u1ea9u h\u00e0ng h\u00f3a nh\u01b0 n\u00e0o? - T\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn MISA eShop Vi\u1ec7t Nam<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u00e1ch chu\u1ed7i k\u00fd t\u1ef1 khi khai b\u00e1o t\u1ec7p nh\u1eadp kh\u1ea9u h\u00e0ng h\u00f3a nh\u01b0 n\u00e0o? - T\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn MISA eShop Vi\u1ec7t Nam\" \/>\n<meta property=\"og:description\" content=\"M\u1ee4C \u0110\u00cdCH: H\u01b0\u1edbng d\u1eabn kh\u00e1ch h\u00e0ng t\u00e1ch th\u00f4ng tin m\u00e0u\/size t\u1eeb t\u00ean h\u00e0ng h\u00f3a \u0111\u1ec3 khai b\u00e1o t\u1ec7p nh\u1eadp kh\u1ea9u gi\u00fap nh\u1eadp kh\u1ea9u h\u00e0ng h\u00f3a v\u00e0o ph\u1ea7n m\u1ec1m \u0111\u01b0\u1ee3c nhanh ch\u00f3ng v\u00e0 thu\u1eadn ti\u1ec7n nh\u1ea5t. C\u00c1C C\u00c1CH TH\u1ef0C HI\u1ec6N C\u00c1CH 1: L\u00c0M TH\u1ebe N\u00c0O \u0110\u1ec2 CHIA V\u0102N B\u1ea2N TRONG EXCEL...\" \/>\n<meta property=\"og:url\" content=\"http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao\" \/>\n<meta property=\"og:site_name\" content=\"T\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn MISA eShop Vi\u1ec7t Nam\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-14T02:51:20+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"15 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao\",\"url\":\"http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao\",\"name\":\"T\u00e1ch chu\u1ed7i k\u00fd t\u1ef1 khi khai b\u00e1o t\u1ec7p nh\u1eadp kh\u1ea9u h\u00e0ng h\u00f3a nh\u01b0 n\u00e0o? - T\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn MISA eShop Vi\u1ec7t Nam\",\"isPartOf\":{\"@id\":\"http:\/\/eshop.misa.vn\/help\/vi\/#website\"},\"datePublished\":\"2020-01-17T12:04:30+00:00\",\"dateModified\":\"2020-04-14T02:51:20+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/eshop.misa.vn\/help\/vi\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T\u00e1ch chu\u1ed7i k\u00fd t\u1ef1 khi khai b\u00e1o t\u1ec7p nh\u1eadp kh\u1ea9u h\u00e0ng h\u00f3a nh\u01b0 n\u00e0o?\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/eshop.misa.vn\/help\/vi\/#website\",\"url\":\"http:\/\/eshop.misa.vn\/help\/vi\/\",\"name\":\"T\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn MISA eShop Vi\u1ec7t Nam\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/eshop.misa.vn\/help\/vi\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"T\u00e1ch chu\u1ed7i k\u00fd t\u1ef1 khi khai b\u00e1o t\u1ec7p nh\u1eadp kh\u1ea9u h\u00e0ng h\u00f3a nh\u01b0 n\u00e0o? - T\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn MISA eShop Vi\u1ec7t Nam","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao","og_locale":"vi_VN","og_type":"article","og_title":"T\u00e1ch chu\u1ed7i k\u00fd t\u1ef1 khi khai b\u00e1o t\u1ec7p nh\u1eadp kh\u1ea9u h\u00e0ng h\u00f3a nh\u01b0 n\u00e0o? - T\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn MISA eShop Vi\u1ec7t Nam","og_description":"M\u1ee4C \u0110\u00cdCH: H\u01b0\u1edbng d\u1eabn kh\u00e1ch h\u00e0ng t\u00e1ch th\u00f4ng tin m\u00e0u\/size t\u1eeb t\u00ean h\u00e0ng h\u00f3a \u0111\u1ec3 khai b\u00e1o t\u1ec7p nh\u1eadp kh\u1ea9u gi\u00fap nh\u1eadp kh\u1ea9u h\u00e0ng h\u00f3a v\u00e0o ph\u1ea7n m\u1ec1m \u0111\u01b0\u1ee3c nhanh ch\u00f3ng v\u00e0 thu\u1eadn ti\u1ec7n nh\u1ea5t. C\u00c1C C\u00c1CH TH\u1ef0C HI\u1ec6N C\u00c1CH 1: L\u00c0M TH\u1ebe N\u00c0O \u0110\u1ec2 CHIA V\u0102N B\u1ea2N TRONG EXCEL...","og_url":"http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao","og_site_name":"T\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn MISA eShop Vi\u1ec7t Nam","article_modified_time":"2020-04-14T02:51:20+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"15 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao","url":"http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao","name":"T\u00e1ch chu\u1ed7i k\u00fd t\u1ef1 khi khai b\u00e1o t\u1ec7p nh\u1eadp kh\u1ea9u h\u00e0ng h\u00f3a nh\u01b0 n\u00e0o? - T\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn MISA eShop Vi\u1ec7t Nam","isPartOf":{"@id":"http:\/\/eshop.misa.vn\/help\/vi\/#website"},"datePublished":"2020-01-17T12:04:30+00:00","dateModified":"2020-04-14T02:51:20+00:00","breadcrumb":{"@id":"http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/eshop.misa.vn\/help\/vi\/kb\/tach_chuoi_ky_tu_khi_khai_bao_tep_nhap_khau_hang_hoa_nhu_nao#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/eshop.misa.vn\/help\/vi"},{"@type":"ListItem","position":2,"name":"T\u00e1ch chu\u1ed7i k\u00fd t\u1ef1 khi khai b\u00e1o t\u1ec7p nh\u1eadp kh\u1ea9u h\u00e0ng h\u00f3a nh\u01b0 n\u00e0o?"}]},{"@type":"WebSite","@id":"http:\/\/eshop.misa.vn\/help\/vi\/#website","url":"http:\/\/eshop.misa.vn\/help\/vi\/","name":"T\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn MISA eShop Vi\u1ec7t Nam","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/eshop.misa.vn\/help\/vi\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"}]}},"_links":{"self":[{"href":"\/v1\/wp-json\/wp\/v2\/ht-kb\/830","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/v1\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/v1\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/v1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/v1\/wp-json\/wp\/v2\/comments?post=830"}],"version-history":[{"count":1,"href":"\/v1\/wp-json\/wp\/v2\/ht-kb\/830\/revisions"}],"predecessor-version":[{"id":831,"href":"\/v1\/wp-json\/wp\/v2\/ht-kb\/830\/revisions\/831"}],"wp:attachment":[{"href":"\/v1\/wp-json\/wp\/v2\/media?parent=830"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/v1\/wp-json\/wp\/v2\/ht-kb-category?post=830"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/v1\/wp-json\/wp\/v2\/ht-kb-tag?post=830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}