{"id":622,"date":"2024-12-02T02:34:26","date_gmt":"2024-12-02T02:34:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-chuyen-doi-dinh-dang-number-thanh-text-bang-ham-text-hoac-cac-tuy-chon\/"},"modified":"2024-12-02T02:34:26","modified_gmt":"2024-12-02T02:34:26","slug":"huong-dan-chuyen-doi-dinh-dang-number-thanh-text-bang-ham-text-hoac-cac-tuy-chon","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-chuyen-doi-dinh-dang-number-thanh-text-bang-ham-text-hoac-cac-tuy-chon\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text b\u1eb1ng h\u00e0m text ho\u1eb7c c\u00e1c t\u00f9y ch\u1ecdn"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, Blog <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text th\u00f4ng qua h\u00e0m\u00a0<strong>TEXT<\/strong>, \u0111\u1ecbnh d\u1ea1ng s\u1ed1 th\u00e0nh chu\u1ed7i, thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng b\u1eb1ng\u00a0<strong>Format Cells\u2026\u00a0<\/strong>v\u00e0 t\u00f9y ch\u1ecdn\u00a0<strong>Text to Columns<\/strong>.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d1cb17e3c4\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-chuyen-doi-dinh-dang-number-thanh-text-bang-ham-text-hoac-cac-tuy-chon.html#Ham_TEXT_va_chuyen_doi_dinh_dang_number_thanh_text\" title=\"H\u00e0m TEXT v\u00e0 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text:\">H\u00e0m TEXT v\u00e0 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-chuyen-doi-dinh-dang-number-thanh-text-bang-ham-text-hoac-cac-tuy-chon.html#Su_dung_tuy_chon_Format_Cells_de_chuyen_doi_dinh_dang_number_thanh_text\" title=\"S\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn Format Cells \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text\">S\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn Format Cells \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-chuyen-doi-dinh-dang-number-thanh-text-bang-ham-text-hoac-cac-tuy-chon.html#Them_mot_dau_nhay_don_de_thay_doi_dinh_dang_number_thanh_text\" title=\"Th\u00eam m\u1ed9t d\u1ea5u nh\u00e1y \u0111\u01a1n \u0111\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text\">Th\u00eam m\u1ed9t d\u1ea5u nh\u00e1y \u0111\u01a1n \u0111\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-chuyen-doi-dinh-dang-number-thanh-text-bang-ham-text-hoac-cac-tuy-chon.html#Su_dung_cong_cu_Text_to_Columns_de_chuyen_doi_dinh_dang_number_thanh_text\" title=\"S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Text to Columns \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text\">S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Text to Columns \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_TEXT_va_chuyen_doi_dinh_dang_number_thanh_text\"><\/span><strong>H\u00e0m TEXT v\u00e0 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">1. Th\u00eam m\u1ed9t c\u1ed9t ph\u1ee5 k\u1ebf b\u00ean c\u1ed9t ch\u1ee9a s\u1ed1 c\u1ea7n \u0111\u1ecbnh d\u1ea1ng. V\u00ed d\u1ee5, c\u1ed9t D.<\/p>\n<p style=\"text-align: justify\">2. Nh\u1eadp c\u00f4ng th\u1ee9c\u00a0<strong>=TEXT(C2,\u201d0\u2033)\u00a0<\/strong>v\u00e0o \u00f4 D2. Trong c\u00f4ng th\u1ee9c, C2 l\u00e0 \u0111\u1ecba ch\u1ec9 \u00f4 \u0111\u1ea7u ti\u00ean ch\u1ee9a s\u1ed1 c\u1ea7n chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<p style=\"text-align: justify\">3. Sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1edbi c\u1ea3 c\u1ed9t b\u1eb1ng c\u00e1ch\u00a0<em><strong>fill handle<\/strong>.<\/em><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-formula-fill-handle.png\" alt=\"Copy the formula across the column using the fill handle\" title=\"excel-formula-fill-handle\"><\/p>\n<p style=\"text-align: justify\">4. B\u1ea1n s\u1ebd th\u1ea5y c\u1ed9t ph\u1ee5 c\u0103n l\u1ec1 tr\u00e1i sau khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-formula-fill-result.png\" alt=\"See the alignment change to left in the helper column\" title=\"excel-formula-fill-result\"><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-9.gif\" title=\"vba101_92019-nho-9\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-32.gif\" title=\"ex101_92019-nho-32\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">5. B\u1ea1n c\u1ea7n chuy\u1ec3n \u0111\u1ed5i c\u00f4ng th\u1ee9c th\u00e0nh gi\u00e1 tr\u1ecb trong c\u1ed9t ph\u1ee5. H\u00e3y ch\u1ecdn c\u1ed9t \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">6. Nh\u1ea5n\u00a0<strong>Ctrl + C\u00a0<\/strong>\u0111\u1ec3 sao ch\u00e9p. Sau \u0111\u00f3 nh\u1ea5n\u00a0<strong>Ctrl + Alt + V\u00a0<\/strong>\u0111\u1ec3 hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i\u00a0<em><strong>Paste Special<\/strong><\/em>.<\/p>\n<p style=\"text-align: justify\">7. Trong h\u1ed9p tho\u1ea1i\u00a0<em><strong>Paste Special<\/strong><\/em>, \u0111\u00e1nh d\u1ea5u ch\u1ecdn\u00a0<em><strong>Values\u00a0<\/strong><\/em>trong nh\u00f3m\u00a0<em><strong>Paste<\/strong><\/em>.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4744 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-paste-special-values.png\" width=\"600\" height=\"354\" title=\"excel-paste-special-values\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t d\u1ea5u tam gi\u00e1c nh\u1ecf \u1edf g\u00f3c tr\u00ean b\u00ean tr\u00e1i m\u1ed7i \u00f4 t\u00ednh trong c\u1ed9t ph\u1ee5, ngh\u0129a l\u00e0 c\u00e1c ch\u1eef s\u1ed1 trong c\u1ed9t n\u00e0y \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>text\u00a0<\/strong>khi ch\u00fang \u1edf c\u1ed9t ch\u00ednh.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t t\u00ean l\u1ea1i cho c\u1ed9t ph\u1ee5 v\u00e0 x\u00f3a c\u1ed9t g\u1ed1c, ho\u1eb7c sao ch\u00e9p k\u1ebft qu\u1ea3 sang c\u1ed9t ch\u00ednh v\u00e0 x\u00f3a c\u1ed9t t\u1ea1m th\u1eddi.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong> Tham s\u1ed1 th\u1ee9 hai trong h\u00e0m Excel <strong>TEXT<\/strong> cho bi\u1ebft s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng tr\u01b0\u1edbc khi chuy\u1ec3n \u0111\u1ed5i. B\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n \u0111i\u1ec1u ch\u1ec9nh \u0111i\u1ec1u n\u00e0y \u0111\u1ed1i v\u1edbi ch\u00fang:<\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 c\u1ee7a <strong><code>=TEXT(123.25,\"0\") <\/code><\/strong><code><\/code><code>l\u00e0<\/code>\u00a0123.<\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 c\u1ee7a\u00a0<strong><code>=TEXT(123.25,\"0.0\")<\/code><\/strong>\u00a0l\u00e0 123.3.<\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 c\u1ee7a\u00a0<strong><code>=TEXT(123.25,\"0.00\")<\/code><\/strong>\u00a0l\u00e0 123.25.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 gi\u1eef m\u1ed7i s\u1ed1 th\u1eadp ph\u00e2n, s\u1eed d\u1ee5ng\u00a0<strong><code>=TEXT(A2,\"General\")<\/code><\/strong><code>.<\/code><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>Gi\u1ea3 s\u1eed b\u1ea1n c\u1ea7n \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ti\u1ec1n m\u1eb7t, nh\u01b0ng \u0111\u1ecbnh d\u1ea1ng kh\u00f4ng c\u00f3 s\u1eb5n. V\u00ed d\u1ee5: s\u1ed1 ti\u1ec1n n\u00e0y kh\u00f4ng hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng B\u1ea3ng Anh (\u00a3) khi b\u1ea1n s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng \u00a0t\u00edch h\u1ee3p trong phi\u00ean b\u1ea3n Excel Hoa K\u1ef3. <a href=\"http:\/\/blog.ezworkapp.com\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel.html\"><strong>H\u00e0m TEXT<\/strong><\/a> s\u1ebd gi\u00fap b\u1ea1n chuy\u1ec3n \u0111\u1ed5i con s\u1ed1 n\u00e0y th\u00e0nh Pounds n\u1ebfu b\u1ea1n nh\u1eadp: <strong>= TEXT (A12, \u201c\u00a3 #, ###, ###. ##\u201d)<\/strong>. Ch\u1ec9 c\u1ea7n nh\u1eadp \u0111\u1ecbnh d\u1ea1ng mu\u1ed1n s\u1eed d\u1ee5ng trong ngo\u1eb7c k\u00e9p -&gt; ch\u00e8n bi\u1ec3u t\u01b0\u1ee3ng \u00a3 b\u1eb1ng c\u00e1ch gi\u1eef ph\u00edm Alt v\u00e0 nh\u1ea5n 0163 tr\u00ean b\u00e0n ph\u00edm s\u1ed1 -&gt; g\u00f5 #, ###. ## sau bi\u1ec3u t\u01b0\u1ee3ng \u00a3 \u0111\u1ec3 l\u1ea5y d\u1ea5u ph\u1ea9y ph\u00e2n bi\u1ec7t gi\u1eefa ph\u1ea7n nguy\u00ean v\u00e0 ph\u1ea7n th\u1eadp ph\u00e2n, \u0111\u1ed3ng th\u1eddi ph\u00e2n t\u00e1ch c\u00e1c nh\u00f3m th\u1eadp ph\u00e2n b\u1eb1ng d\u1ea5u ch\u1ea5m.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: B\u00f4\u0323 gia\u0301o tri\u0300nh\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">Excel c\u01a1 ba\u0309n<\/a> hay nh\u00e2\u0301t 2018<\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_tuy_chon_Format_Cells_de_chuyen_doi_dinh_dang_number_thanh_text\"><\/span><strong>S\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn Format Cells \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 th\u00e0nh chu\u1ed7i nhanh ch\u00f3ng, h\u00e3y s\u1eed d\u1ee5ng <em><strong>Format Cells\u2026\u00a0<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">1. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<p style=\"text-align: justify\">2. Nh\u1ea5p ph\u1ea3i v\u00e0o ch\u00fang, ch\u1ecdn <em><strong>Format Cells\u2026\u00a0<\/strong><\/em>t\u1eeb danh s\u00e1ch ch\u1ecdn.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-format-cells-option.png\" alt=\"Pick the Format Cells\u2026 option from the menu list\" title=\"excel-format-cells-option\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>B\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb c\u1eeda s\u1ed5\u00a0<em><strong>Format Cells\u2026\u00a0<\/strong><\/em>b\u1eb1ng ph\u00edm t\u1eaft\u00a0<strong>Ctrl + 1<\/strong>.<\/p>\n<p style=\"text-align: justify\">3. Tr\u00ean c\u1eeda s\u1ed5\u00a0<em><strong>Format Cells<\/strong><\/em> ch\u1ecdn\u00a0<em><strong>Text\u00a0<\/strong><\/em>trong th\u1ebb\u00a0<em><strong>Number\u00a0<\/strong><\/em>v\u00e0 nh\u1ea5n OK.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-format-cells-text.png\" alt=\"Select the Text option and click OK\" title=\"excel-format-cells-text\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n s\u1ebd th\u1ea5y d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh \u0111\u01b0\u1ee3c c\u0103n l\u1ec1 tr\u00e1i, ngh\u0129a l\u00e0 c\u00e1c ch\u1eef s\u1ed1 \u0111ang \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>text<\/strong>.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0H\u1ecdc Excel n\u00e2ng cao Online<\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Them_mot_dau_nhay_don_de_thay_doi_dinh_dang_number_thanh_text\"><\/span><strong>Th\u00eam m\u1ed9t d\u1ea5u nh\u00e1y \u0111\u01a1n \u0111\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu c\u00f3 2 ho\u1eb7c 3 \u00f4 t\u00ednh b\u1ea1n c\u1ea7n chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng, h\u00e3y t\u1eadn d\u1ee5ng d\u1ea5u nh\u00e1y \u0111\u01a1n tr\u01b0\u1edbc d\u1eef li\u1ec7u s\u1ed1.<\/p>\n<p style=\"text-align: justify\">Ch\u1ec9 c\u1ea7n nh\u1ea5n chu\u1ed9t hai l\u1ea7n v\u00e0o \u00f4 t\u00ednh, sau \u0111\u00f3 nh\u1eadp d\u1ea5u nh\u00e1y \u0111\u01a1n v\u00e0o tr\u01b0\u1edbc gi\u00e1 tr\u1ecb s\u1ed1.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-format-cells-apostrophe.png\" alt=\"Add an apostrophe to convert number to test\" title=\"excel-format-cells-apostrophe\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t tam gi\u00e1c nh\u1ecf \u0111\u01b0\u1ee3c th\u00eam v\u00e0o g\u00f3c tr\u00e1i c\u1ee7a \u00f4 t\u00ednh n\u00e0y. \u0110\u00e2y kh\u00f4ng ph\u1ea3i c\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng t\u1eeb\u00a0<strong>number\u00a0<\/strong>th\u00e0nh\u00a0<strong>text<\/strong>, nh\u01b0ng \u0111\u00f3 l\u00e0 c\u00e1ch nhanh nh\u1ea5t n\u1ebfu b\u1ea1n c\u1ea7n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng ch\u1ec9 2 ho\u1eb7c 3 \u00f4 t\u00ednh.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_cong_cu_Text_to_Columns_de_chuyen_doi_dinh_dang_number_thanh_text\"><\/span><strong>S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Text to Columns \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh text<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">1. Ch\u1ecdn c\u1ed9t c\u1ea7n chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<p style=\"text-align: justify\">2. Di chuy\u1ec3n \u0111\u1ebfn th\u1ebb\u00a0<em><strong>Data<\/strong><\/em>, nh\u1ea5p chu\u1ed9t v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng\u00a0<em><strong>Text to Columns<\/strong><\/em>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-text-tocolumns-icon.png\" alt=\"Navigate to the Data tab in Excel and click on the Text to Columns icon\" title=\"excel-text-tocolumns-icon\"><\/p>\n<p style=\"text-align: justify\">3. Nh\u1ea5n chu\u1ed9t b\u1ecf qua b\u01b0\u1edbc 1 v\u00e0 2. \u1ede b\u01b0\u1edbc 3, \u0111\u00e1nh d\u1ea5u ch\u1ecdn\u00a0<em><strong>Text\u00a0<\/strong><\/em>trong ph\u1ea7n\u00a0<em><strong>Column data format<\/strong><\/em>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-text-tocolumns-text.png\" alt=\"Navigate to the Data tab in Excel and click on the Text to Columns icon\" title=\"excel-text-tocolumns-text\"><\/p>\n<p style=\"text-align: justify\">4. Nh\u1ea5n\u00a0<em><strong>Finish\u00a0<\/strong><\/em>v\u00e0 xem k\u1ebft qu\u1ea3.<\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/p>\n<p style=\"text-align: justify\">\u2014\u2014\u2014<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-9.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":623,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-622","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/622","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=622"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/622\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/623"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=622"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=622"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}