[row_delimiter]<\/strong> \u2013 \u0110\u00e2y l\u00e0 \u0111\u1ed1i s\u1ed1 th\u1ee9 ba m\u00e0 t\u00f4i c\u1ea7n ch\u1ec9 \u0111\u1ecbnh d\u1ea5u ph\u00e2n c\u00e1ch d\u1ef1a v\u00e0o \u0111\u00f3 v\u0103n b\u1ea3n s\u1ebd \u0111\u01b0\u1ee3c chia th\u00e0nh c\u00e1c h\u00e0ng ri\u00eang bi\u1ec7t. V\u00ec t\u00f4i mu\u1ed1n ph\u00e2n t\u00e1ch \u0111\u1ecba ch\u1ec9 sau m\u1ed7i d\u1ea5u ph\u1ea9y n\u00ean t\u00f4i \u0111\u00e3 s\u1eed d\u1ee5ng \u201c,\u201d l\u00e0m d\u1ea5u ph\u00e2n c\u00e1ch. L\u01b0u \u00fd r\u1eb1ng d\u1ea5u ph\u00e2n c\u00e1ch c\u1ee7a b\u1ea1n c\u1ea7n ph\u1ea3i n\u1eb1m trong d\u1ea5u ngo\u1eb7c k\u00e9p.<\/li>\n<\/ul>\n\n\n\nL\u01b0u \u00fd<\/strong>\u00a0: H\u00e0m TEXTSPLIT c\u0169ng c\u00f3 th\u00eam ba \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn m\u00e0 ch\u00fang ta kh\u00f4ng c\u1ea7n trong v\u00ed d\u1ee5 n\u00e0y.<\/p>\n\n\n\nNgo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 c\u00f3 th\u1ec3 x\u1eed l\u00fd m\u1ecdi lo\u1ea1i t\u00ecnh hu\u1ed1ng:=TRIM(TEXTSPLIT(A2,,”,”))<\/p>\n\n\n
\n
![\"Ch\u1ee9c](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/TRIM-and-TEXTSPLIT-functoin-for-text-to-rows.png\")
<\/figure><\/div>\n\n\nH\u00e0m TRIM \u0111\u1ea3m b\u1ea3o r\u1eb1ng kh\u00f4ng c\u00f3 k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u1edf \u0111\u1ea7u trong b\u1ea5t k\u1ef3 \u00f4 n\u00e0o.<\/p>\n\n\n\n
<\/span>Ph\u00e2n chia d\u1ef1a tr\u00ean hai ho\u1eb7c nhi\u1ec1u d\u1ea5u ph\u00e2n c\u00e1ch<\/span><\/h3>\n\n\n\nD\u01b0\u1edbi \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 trong \u0111\u00f3 t\u00f4i c\u00f3 m\u1ed9t \u0111\u1ecba ch\u1ec9 trong \u00f4 A2 v\u00e0 c\u00f3 hai d\u1ea5u ph\u00e2n c\u00e1ch (d\u1ea5u g\u1ea1ch ngang ph\u00e2n t\u00e1ch t\u00ean v\u00e0 \u0111\u1ecba ch\u1ec9 v\u00e0 d\u1ea5u ph\u1ea9y ph\u00e2n t\u00e1ch t\u1ea5t c\u1ea3 c\u00e1c th\u00e0nh ph\u1ea7n kh\u00e1c nhau c\u1ee7a \u0111\u1ecba ch\u1ec9)<\/p>\n\n\n
\n
![\"\u0110\u1ecba](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/Address-with-two-delimiters.png\")
<\/figure><\/div>\n\n\n\u0110\u00e2y l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t s\u1ebd xem x\u00e9t hai d\u1ea5u ph\u00e2n c\u00e1ch trong khi chia v\u0103n b\u1ea3n trong \u00f4 th\u00e0nh c\u00e1c h\u00e0ng:=TRIM(TEXTSPLIT(A2,,{“,,”-“}))<\/p>\n\n\n
\n
![\"H\u00e0m](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/Textsplit-function-using-two-delimiters-to-convert-text-to-rows.png\")
<\/figure><\/div>\n\n\nTrong v\u00ed d\u1ee5 tr\u00ean, t\u00f4i c\u00f3 c\u00e1c \u0111\u1ed1i s\u1ed1 sau trong h\u00e0m TEXTSPLIT:<\/p>\n\n\n\n
\n- text<\/strong> \u2013 \u0110\u00e2y l\u00e0 tham chi\u1ebfu \u00f4 c\u1ee7a \u00f4 (A2) m\u00e0 t\u00f4i mu\u1ed1n t\u00e1ch<\/li>\n\n\n\n
- col_delimiter<\/strong> \u2013 \u0110\u00e2y l\u00e0 d\u1ea5u ph\u00e2n c\u00e1ch c\u1ed9t, nh\u01b0ng v\u00ec t\u00f4i mu\u1ed1n v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c chia th\u00e0nh h\u00e0ng thay v\u00ec c\u1ed9t n\u00ean \u0111\u1ed1i s\u1ed1 n\u00e0y \u0111\u01b0\u1ee3c \u0111\u1ec3 tr\u1ed1ng.<\/li>\n\n\n\n
- [row_delimiter]<\/strong> \u2013 \u0110\u00e2y l\u00e0 \u0111\u1ed1i s\u1ed1 th\u1ee9 ba m\u00e0 t\u00f4i c\u1ea7n ch\u1ec9 \u0111\u1ecbnh d\u1ea5u ph\u00e2n c\u00e1ch d\u1ef1a v\u00e0o \u0111\u00f3 v\u0103n b\u1ea3n s\u1ebd \u0111\u01b0\u1ee3c chia th\u00e0nh c\u00e1c h\u00e0ng ri\u00eang bi\u1ec7t. V\u00ec t\u00f4i mu\u1ed1n ph\u00e2n chia \u0111\u1ecba ch\u1ec9 d\u1ef1a tr\u00ean hai d\u1ea5u ph\u00e2n c\u00e1ch (d\u1ea5u g\u1ea1ch ngang v\u00e0 d\u1ea5u ph\u1ea9y), n\u00ean t\u00f4i \u0111\u00e3 s\u1eed d\u1ee5ng m\u1ed9t m\u1ea3ng {\u201c,\u201d,\u201d-\u201c}. \u0110i\u1ec1u n\u00e0y y\u00eau c\u1ea7u c\u00f4ng th\u1ee9c ki\u1ec3m tra t\u1ea5t c\u1ea3 c\u00e1c d\u1ea5u ph\u00e2n c\u00e1ch \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong d\u1ea5u ngo\u1eb7c nh\u1ecdn.<\/li>\n<\/ul>\n\n\n\n
<\/span>Ph\u00e2n chia d\u1ef1a tr\u00ean ng\u1eaft d\u00f2ng<\/span><\/h3>\n\n\n\nD\u01b0\u1edbi \u0111\u00e2y, t\u00f4i c\u00f3 v\u00ed d\u1ee5 n\u00e0y trong \u0111\u00f3 t\u00f4i c\u00f3 \u0111\u1ecba ch\u1ec9 trong \u00f4 A2 v\u00e0 c\u00f3 nhi\u1ec1u ng\u1eaft d\u00f2ng trong \u0111\u1ecba ch\u1ec9.<\/p>\n\n\n
\n
![\"\u0110\u1ecba](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/Address-with-line-breaks-in-the-same-cell.png\")
<\/figure><\/div>\n\n\nThay v\u00ec l\u1ea5y nhi\u1ec1u d\u00f2ng trong c\u00f9ng m\u1ed9t \u00f4, m\u00ecnh mu\u1ed1n t\u00e1ch n\u1ed9i dung c\u1ee7a \u0111\u1ecba ch\u1ec9 n\u00e0y ra \u0111\u1ec3 l\u1ea5y m\u1ed7i d\u00f2ng \u1edf m\u1ed9t h\u00e0ng ri\u00eang trong m\u1ed9t c\u1ed9t.<\/p>\n\n\n\n
\u0110i\u1ec1u n\u00e0y m\u1ed9t l\u1ea7n n\u1eefa c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nhanh ch\u00f3ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXTSPLIT, trong \u0111\u00f3 t\u00f4i c\u1ea7n b\u1eb1ng c\u00e1ch n\u00e0o \u0111\u00f3 s\u1eed d\u1ee5ng d\u1ea5u ng\u1eaft d\u00f2ng l\u00e0m d\u1ea5u ph\u00e2n c\u00e1ch.<\/p>\n\n\n\n
V\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00f4i l\u00e0m \u0111i\u1ec1u \u0111\u00f3?<\/p>\n\n\n\n
B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 d\u1ea5u ng\u1eaft d\u00f2ng, sau \u0111\u00f3 c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c n\u00e0y trong h\u00e0m TEXTSPLIT l\u00e0m d\u1ea5u ph\u00e2n c\u00e1ch.<\/p>\n\n\n\n
D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c s\u1ebd ph\u00e2n chia \u0111\u1ecba ch\u1ec9 b\u1eb1ng c\u00e1ch ng\u1eaft d\u00f2ng:=TEXTSPLIT(A2,,CHAR(10))<\/p>\n\n\n
\n
![\"H\u00e0m](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/Textsplit-function-to-convert-text-to-rows-using-linespace-as-delimiter.png\")
<\/figure><\/div>\n\n\nTrong c\u00f4ng th\u1ee9c tr\u00ean, t\u00f4i \u0111\u00e3 s\u1eed d\u1ee5ng CHAR(10) l\u00e0m d\u1ea5u ph\u00e2n c\u00e1ch h\u00e0ng, trong \u0111\u00f3 CHAR(10) tr\u1ea3 v\u1ec1 k\u00fd t\u1ef1 ng\u1eaft d\u00f2ng.<\/p>\n\n\n\n
<\/span>T\u00e1ch nhi\u1ec1u \u00f4 th\u00e0nh c\u00e1c h\u00e0ng trong m\u1ed9t c\u1ed9t<\/span><\/h3>\n\n\n\nD\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 v\u1ec1 nh\u1eefng g\u00ec t\u00f4i mu\u1ed1n n\u00f3i.<\/p>\n\n\n
\n
![\"T\u1eadp](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/Data-set-to-split-text-to-rows-when-you-have-multiple-cells-data.png\")
<\/figure><\/div>\n\n\nT\u00f4i c\u00f3 t\u00ean trong ba \u00f4 trong c\u1ed9t A \u0111\u01b0\u1ee3c ph\u00e2n t\u00e1ch b\u1eb1ng d\u1ea5u ph\u1ea9y v\u00e0 t\u00f4i mu\u1ed1n t\u00e1ch t\u1ea5t c\u1ea3 c\u00e1c t\u00ean n\u00e0y \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c t\u00ean ri\u00eang l\u1ebb trong c\u00e1c \u00f4 ri\u00eang bi\u1ec7t trong c\u00f9ng m\u1ed9t c\u1ed9t (nh\u01b0 hi\u1ec3n th\u1ecb b\u00ean d\u01b0\u1edbi).<\/p>\n\n\n\n
T\u00f4i t\u01b0\u1edfng t\u01b0\u1ee3ng s\u1ebd l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y n\u1ebfu kh\u00f4ng c\u00f3 TEXTSPLIT, nh\u01b0ng v\u1edbi n\u00f3, \u0111i\u1ec1u \u0111\u00f3 kh\u00f4ng kh\u00f3 \u0111\u1ebfn th\u1ebf.<\/p>\n\n\n\n
\u0110\u00e2y l\u00e0 c\u00f4ng th\u1ee9c \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y:=TRIM(TEXTSPLIT(TEXTJOIN(“,,,A2:A4),,”,”))<\/p>\n\n\n
\n
![\"H\u00e0m](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/TEXTJOIN-and-TEXTSPLIT-function-to-split-text-by-delimiter-and-combine-in-one-column.png\")
<\/figure><\/div>\n\n\nB\u00ed quy\u1ebft trong c\u00f4ng th\u1ee9c n\u00e0y l\u00e0 s\u1eed d\u1ee5ng h\u00e0m TEXTJOIn \u0111\u1ec3 k\u1ebft h\u1ee3p t\u1ea5t c\u1ea3 c\u00e1c t\u00ean trong c\u00e1c \u00f4 kh\u00e1c nhau \u0111\u1ec3 ch\u00fang ta c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t m\u1ea3ng t\u00ean \u0111\u01b0\u1ee3c ph\u00e2n t\u00e1ch b\u1eb1ng d\u1ea5u ph\u1ea9y.<\/p>\n\n\n\n
Trong h\u00e0m n\u1ed1i v\u0103n b\u1ea3n, \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 d\u1ea5u ph\u00e2n c\u00e1ch (trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 d\u1ea5u ph\u1ea9y) \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi k\u1ebft h\u1ee3p n\u1ed9i dung c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c \u00f4.<\/p>\n\n\n\n
K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m TEXTJOIN l\u00e0:<\/p>\n\n\n\n
\u201cStephen, James, Anna, Richard, Helen, Toby, Chris, Mark, Doug\u201d<\/em><\/p>\n\n\n\nSau \u0111\u00f3, m\u1ea3ng n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong h\u00e0m TEXTSPLIT, h\u00e0m n\u00e0y s\u1ebd ph\u00e2n t\u00e1ch n\u00f3 b\u1eb1ng d\u1ea5u ph\u1ea9y l\u00e0m d\u1ea5u ph\u00e2n c\u00e1ch.<\/p>\n\n\n\n
<\/span>T\u00e1ch v\u0103n b\u1ea3n th\u00e0nh h\u00e0ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng t\u00ednh n\u0103ng chuy\u1ec3n v\u0103n b\u1ea3n th\u00e0nh c\u1ed9t v\u00e0 chuy\u1ec3n \u0111\u1ed5i<\/span><\/h2>\n\n\n\nD\u01b0\u1edbi \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 trong \u0111\u00f3 t\u00f4i c\u00f3 m\u1ed9t \u0111\u1ecba ch\u1ec9 trong \u00f4 A2 m\u00e0 t\u00f4i mu\u1ed1n t\u00e1ch (s\u1eed d\u1ee5ng d\u1ea5u ph\u1ea9y l\u00e0m d\u1ea5u ph\u00e2n c\u00e1ch) v\u00e0 nh\u1eadn k\u1ebft qu\u1ea3 th\u00e0nh c\u00e1c h\u00e0ng ri\u00eang bi\u1ec7t.<\/p>\n\n\n
\n
![\"\u0110\u1ecba](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/Address-in-cell-A2-for-text-to-rows.png\")
<\/figure><\/div>\n\n\nB\u01b0\u1edbc \u0111\u1ea7u ti\u00ean l\u00e0 s\u1eed d\u1ee5ng V\u0103n b\u1ea3n th\u00e0nh C\u1ed9t \u0111\u1ec3 chia n\u00f3 th\u00e0nh c\u00e1c c\u1ed9t. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n\n\n\n
\n- Ch\u1ecdn \u00f4 (ho\u1eb7c ph\u1ea1m vi \u00f4) c\u00f3 d\u1eef li\u1ec7u<\/li>\n\n\n\n
- Nh\u1ea5p v\u00e0o tab D\u1eef li\u1ec7u<\/li>\n<\/ol>\n\n\n
\n
![\"Nh\u1ea5p](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/Click-the-data-tab.png\")
<\/figure><\/div>\n\n\n\n- B\u1ea5m v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Chuy\u1ec3n v\u0103n b\u1ea3n th\u00e0nh C\u1ed9t (n\u1eb1m trong nh\u00f3m C\u00f4ng c\u1ee5 d\u1eef li\u1ec7u)<\/li>\n<\/ol>\n\n\n
\n
![\"B\u1ea5m](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/Click-on-Text-to-columns-option-in-the-ribbon.png\")
<\/figure><\/div>\n\n\n\n- Trong ‘Tr\u00ecnh h\u01b0\u1edbng d\u1eabn chuy\u1ec3n v\u0103n b\u1ea3n th\u00e0nh c\u1ed9t’, ch\u1ecdn t\u00f9y ch\u1ecdn Ph\u00e2n c\u00e1ch r\u1ed3i nh\u1ea5p v\u00e0o Ti\u1ebfp theo.<\/li>\n<\/ol>\n\n\n
\n
![\"Ch\u1ecdn](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/Select-the-delimited-option-and-click-on-next.png\")
<\/figure><\/div>\n\n\n\n- Ch\u1ecdn ‘D\u1ea5u ph\u1ea9y’ l\u00e0m d\u1ea5u ph\u00e2n c\u00e1ch (b\u1ecf ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c t\u00f9y ch\u1ecdn kh\u00e1c) v\u00e0 nh\u1ea5p v\u00e0o Ti\u1ebfp theo.<\/li>\n<\/ol>\n\n\n
\n
![\"Ch\u1ecdn,](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/Select-as-the-delimiter-and-click-on-next.png\")
<\/figure><\/div>\n\n\n\n- Ch\u1ecdn \u00f4 \u0110\u00edch n\u01a1i b\u1ea1n mu\u1ed1n c\u00f3 k\u1ebft qu\u1ea3, sau \u0111\u00f3 b\u1ea5m K\u1ebft th\u00fac. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, t\u00f4i s\u1ebd ch\u1ecdn A4 l\u00e0m \u00f4 \u0111\u00edch.<\/li>\n<\/ol>\n\n\n
\n
![\"ch\u1ecdn](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/select-the-destination-cell-and-then-click-on-finish.png\")
<\/figure><\/div>\n\n\n\u0110i\u1ec1u n\u00e0y s\u1ebd cung c\u1ea5p cho b\u1ea1n k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb b\u00ean d\u01b0\u1edbi, n\u01a1i n\u00f3 \u0111\u00e3 ph\u00e2n chia d\u1eef li\u1ec7u c\u1ee7a ch\u00fang t\u00f4i, nh\u01b0ng ch\u00fang t\u00f4i \u0111\u00e3 ph\u00e2n chia d\u1eef li\u1ec7u theo c\u1ed9t thay v\u00ec h\u00e0ng.<\/p>\n\n\n
\n
![\"K\u1ebft](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/Result-of-text-to-columns.png\")
<\/figure><\/div>\n\n\nV\u00ec v\u1eady b\u00e2y gi\u1edd ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng chuy\u1ec3n \u0111\u1ed5i \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u n\u00e0y.<\/p>\n\n\n\n
D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y:<\/p>\n\n\n\n
\n- Ch\u1ecdn c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i.<\/li>\n\n\n\n
- Sao ch\u00e9p c\u00e1c \u00f4 n\u00e0y. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Control + C ho\u1eb7c nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o v\u00f9ng ch\u1ecdn r\u1ed3i nh\u1ea5p v\u00e0o Sao ch\u00e9p.<\/li>\n\n\n\n
- Ngay tr\u00ean \u00f4 \u0111\u00edch n\u01a1i b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i k\u1ebft qu\u1ea3.<\/li>\n\n\n\n
- Di con tr\u1ecf qua t\u00f9y ch\u1ecdn Paste Special (t\u1ea1i bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean \u0111\u1ec3 hi\u1ec3n th\u1ecb th\u00eam t\u00f9y ch\u1ecdn. Nh\u1ea5p v\u00e0o t\u00f9y ch\u1ecdn Transpose.<\/li>\n<\/ol>\n\n\n
\n
![\"Nh\u1ea5p](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/Click-on-the-paste-value-as-transpose-icon.png\")
<\/figure><\/div>\n\n\nC\u00e1c b\u01b0\u1edbc tr\u00ean s\u1ebd cung c\u1ea5p cho b\u1ea1n d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i v\u00e0 sau \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a k\u1ebft qu\u1ea3 c\u1ee7a v\u0103n b\u1ea3n th\u00e0nh c\u00e1c c\u1ed9t n\u1ebfu mu\u1ed1n.<\/p>\n\n\n
\n
![\"K\u1ebft](\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2023\/09\/Text-columns-result-is-transposed.png\")
<\/figure><\/div>\n\n\nM\u1eb7c d\u00f9 c\u00e1ch n\u00e0y c\u00f3 t\u00e1c d\u1ee5ng nh\u01b0ng n\u00f3 kh\u00f4ng tinh t\u1ebf b\u1eb1ng ph\u01b0\u01a1ng th\u1ee9c h\u00e0m TEXTSPLIT. N\u00f3 bao g\u1ed3m nhi\u1ec1u b\u01b0\u1edbc h\u01a1n v\u00e0 c\u00f3 nh\u1eefng h\u1ea1n ch\u1ebf sau:<\/p>\n\n\n\n
\n- K\u1ebft qu\u1ea3 c\u1ee7a ph\u01b0\u01a1ng ph\u00e1p n\u00e0y l\u00e0 t\u0129nh, kh\u00f4ng gi\u1ed1ng nh\u01b0 ph\u01b0\u01a1ng th\u1ee9c h\u00e0m TEXTSPLIT, trong \u0111\u00f3 k\u1ebft qu\u1ea3 l\u00e0 \u0111\u1ed9ng. V\u00ec v\u1eady, n\u1ebfu b\u1ea1n thay \u0111\u1ed5i d\u1eef li\u1ec7u g\u1ed1c, k\u1ebft qu\u1ea3 s\u1ebd kh\u00f4ng c\u1eadp nh\u1eadt (trong khi \u0111\u00f3 khi b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m TEXTSPLIT)<\/li>\n\n\n\n
- B\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 ph\u00e2n t\u00e1ch d\u1ef1a tr\u00ean m\u1ed9t d\u1ea5u ph\u00e2n c\u00e1ch, trong khi v\u1edbi h\u00e0m TEXTSPLIT, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nhi\u1ec1u d\u1ea5u ph\u00e2n c\u00e1ch.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
\u0110a s\u1ed1 d\u1eef li\u1ec7u trong Excel s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo c\u1ed9t v\u00e0 vi\u1ec7c chia v\u0103n b\u1ea3n trong m\u1ed9t \u00f4 th\u00e0nh nhi\u1ec1u c\u1ed9t thay v\u00ec […]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-1391","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-excel"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/1391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=1391"}],"version-history":[{"count":7,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/1391\/revisions"}],"predecessor-version":[{"id":1469,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/1391\/revisions\/1469"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=1391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=1391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=1391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}