{"id":271741,"date":"2023-10-13T21:58:52","date_gmt":"2023-10-13T14:58:52","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=271741"},"modified":"2023-10-13T21:58:52","modified_gmt":"2023-10-13T14:58:52","slug":"viet-hoa-chu-cai-dau-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/","title":{"rendered":"6 C\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},"content":{"rendered":"<p><strong>Vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/strong> kh\u00f4ng ch\u1ec9 gi\u00fap d\u1eef li\u1ec7u tr\u1edf n\u00ean th\u1ea9m m\u1ef9 v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n, m\u00e0 c\u00f2n gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng \u0111\u1ecdc v\u00e0 hi\u1ec3u th\u00f4ng tin. V\u00ed d\u1ee5, t\u00ean ri\u00eang ho\u1eb7c ti\u00eau \u0111\u1ec1 khi \u0111\u01b0\u1ee3c vi\u1ebft hoa \u0111\u00fang c\u00e1ch s\u1ebd n\u1ed5i b\u1eadt h\u01a1n v\u00e0 tr\u00e1nh nh\u1ea7m l\u1eabn. Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd gi\u1edbi thi\u1ec7u 6 c\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u hi\u1ec7u qu\u1ea3 nh\u1ea5t trong ph\u1ea7n m\u1ec1m Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c h\u00e0nh \u0111\u01a1n gi\u1ea3n.<\/p>\n<h2>V\u00ec sao n\u00ean vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel?<\/h2>\n<p>Khi l\u00e0m vi\u1ec7c v\u1edbi Excel, b\u1ea1n s\u1ebd th\u01b0\u1eddng xuy\u00ean g\u1eb7p ph\u1ea3i nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn v\u1edbi h\u00e0ng ng\u00e0n, th\u1eadm ch\u00ed h\u00e0ng ch\u1ee5c ng\u00e0n m\u1ee5c nh\u1eadp. Trong qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u ho\u1eb7c thu th\u1eadp d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u ngu\u1ed3n kh\u00e1c nhau, c\u00f3 th\u1ec3 m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u1ed3ng nh\u1ea5t. M\u1ed9t trong nh\u1eefng v\u1ea5n \u0111\u1ec1 ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 ch\u1eef c\u00e1i \u0111\u1ea7u c\u1ee7a t\u1eeb kh\u00f4ng \u0111\u01b0\u1ee3c vi\u1ebft hoa.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-271754 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-1.jpg\" alt=\"viet-hoa-chu-cai-dau-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u1ee3i \u00edch khi bi\u1ebft <strong>vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/strong> m\u00e0 b\u1ea1n n\u00ean bi\u1ebft:<\/p>\n<p><strong>Chuy\u00ean nghi\u1ec7p v\u00e0 Th\u1ea9m m\u1ef9<\/strong>: D\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u00fang c\u00e1ch, nh\u1ea5t l\u00e0 vi\u1ec7c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u, mang l\u1ea1i v\u1ebb chuy\u00ean nghi\u1ec7p v\u00e0 d\u1ec5 nh\u00ecn h\u01a1n. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t quan tr\u1ecdng khi b\u1ea1n t\u1ea1o b\u00e1o c\u00e1o ho\u1eb7c tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u cho ng\u01b0\u1eddi kh\u00e1c xem.<\/p>\n<p><strong>\u0110\u1ed3ng nh\u1ea5t d\u1eef li\u1ec7u<\/strong>: Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, d\u1eef li\u1ec7u nh\u1eadp v\u00e0o b\u1ea3ng t\u00ednh Excel c\u00f3 th\u1ec3 \u0111\u1ebfn t\u1eeb nhi\u1ec1u ngu\u1ed3n kh\u00e1c nhau, d\u1eabn \u0111\u1ebfn s\u1ef1 kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t. Vi\u1ec7c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u gi\u00fap d\u1eef li\u1ec7u tr\u1edf n\u00ean th\u1ed1ng nh\u1ea5t, d\u1ec5 d\u00e0ng qu\u1ea3n l\u00fd v\u00e0 ph\u00e2n t\u00edch.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-271751 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel.jpg\" alt=\"viet-hoa-chu-cai-dau-trong-excel\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><strong>Tr\u00e1nh Nh\u1ea7m L\u1eabn<\/strong>: T\u00ean ri\u00eang, \u0111\u1ecba danh ho\u1eb7c c\u00e1c thu\u1eadt ng\u1eef chuy\u00ean ng\u00e0nh th\u01b0\u1eddng c\u1ea7n \u0111\u01b0\u1ee3c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u \u0111\u1ec3 tr\u00e1nh nh\u1ea7m l\u1eabn v\u1edbi nh\u1eefng t\u1eeb ng\u1eef kh\u00e1c.<\/p>\n<p><strong>T\u0103ng t\u00ednh d\u1ec5 \u0111\u1ecdc<\/strong>: Khi c\u00e1c t\u1eeb trong m\u1ed9t ti\u00eau \u0111\u1ec1 ho\u1eb7c danh s\u00e1ch \u0111\u01b0\u1ee3c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u, ch\u00fang tr\u1edf n\u00ean d\u1ec5 \u0111\u1ecdc v\u00e0 d\u1ec5 nh\u1eadn bi\u1ebft h\u01a1n. Qua \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng s\u1ebd nhanh ch\u00f3ng t\u00ecm ki\u1ebfm v\u00e0 x\u1eed l\u00fd th\u00f4ng tin hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n<p><strong>T\u1ed1i \u01b0u h\u00f3a vi\u1ec7c L\u1ecdc v\u00e0 S\u1eafp X\u1ebfp<\/strong>: Khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u1ed3ng nh\u1ea5t, vi\u1ec7c l\u1ecdc v\u00e0 s\u1eafp x\u1ebfp tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n<h2>T\u1ed5ng h\u1ee3p 6 c\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/h2>\n<p>\u0110\u1eebng b\u1ecf qua nh\u1eefng c\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u b\u00ean d\u01b0\u1edbi \u0111\u1ec3 d\u1ec5 d\u00e0ng h\u01a1n trong vi\u1ec7c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong ph\u1ea7n m\u1ec1m Excel nh\u00e9.<\/p>\n<h3>S\u1eed d\u1ee5ng h\u00e0m PROPER<\/h3>\n<p>H\u00e0m PROPER l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m v\u0103n b\u1ea3n c\u00f3 s\u1eb5n trong Excel. H\u00e0m n\u00e0y c\u00f3 ch\u1ee9c n\u0103ng chuy\u1ec3n \u0111\u1ed5i ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed7i t\u1eeb trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh ch\u1eef in hoa v\u00e0 gi\u1eef nguy\u00ean c\u00e1c ch\u1eef c\u00e1i c\u00f2n l\u1ea1i.<\/p>\n<p><strong>B\u01b0\u1edbc chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u:<\/strong><\/p>\n<p>B\u01b0\u1edbc 1: M\u1edf b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n.<\/p>\n<p>B\u01b0\u1edbc 2: T\u00ecm \u00f4 tr\u1ed1ng ho\u1eb7c t\u1ea1o m\u1ed9t c\u1ed9t m\u1edbi \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/p>\n<p>B\u01b0\u1edbc 3: Trong \u00f4 m\u1edbi n\u00e0y, g\u00f5 c\u00f4ng th\u1ee9c =PROPER(A1) &#8211; gi\u1ea3 s\u1eed d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i n\u1eb1m \u1edf \u00f4 A1.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-271753 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-1.jpg\" alt=\"viet-hoa-chu-cai-dau-trong-excel-huong-dan-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>B\u01b0\u1edbc 4: Nh\u1ea5n Enter \u0111\u1ec3 ti\u1ebfp t\u1ee5c th\u1ef1c hi\u1ec7n <strong>vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel.<\/strong><\/p>\n<p>B\u01b0\u1edbc 5: Sau khi xu\u1ea5t hi\u1ec7n k\u1ebft qu\u1ea3, k\u00e9o g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a \u00f4 n\u00e0y \u0111\u1ec3 \u00e1p d\u1ee5ng h\u00e0m cho to\u00e0n b\u1ed9 d\u00e3y d\u1eef li\u1ec7u.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-271752 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-1-1.jpg\" alt=\"viet-hoa-chu-cai-dau-trong-excel-huong-dan-1-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-1-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-1-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-1-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h3>S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Format Cells<\/h3>\n<p>C\u00f4ng c\u1ee5 Format Cells trong Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u00f9y ch\u1ec9nh hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u trong c\u00e1c \u00f4, bao g\u1ed3m s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng, v\u00e0 m\u00e0u s\u1eafc. Tuy nhi\u00ean, c\u1ea7n l\u01b0u \u00fd r\u1eb1ng Excel kh\u00f4ng cung c\u1ea5p t\u00f9y ch\u1ecdn tr\u1ef1c ti\u1ebfp \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u b\u1eb1ng Format Cells, nh\u01b0ng ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ee5c ti\u00eau n\u00e0y.<\/p>\n<p><strong>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng ch\u1eef c\u00e1i \u0111\u1ea7u vi\u1ebft hoa:<\/strong><\/p>\n<ul>\n<li>\u0110\u1ea7u ti\u00ean, s\u1eed d\u1ee5ng h\u00e0m PROPER (nh\u01b0 h\u01b0\u1edbng d\u1eabn \u1edf tr\u00ean) \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/li>\n<li>Sau khi c\u00f3 d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i, h\u00e3y ch\u1ecdn c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u \u0111\u00f3.<\/li>\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn &#8220;Format Cells&#8221;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-271750 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-2.jpg\" alt=\"viet-hoa-chu-cai-dau-trong-excel-huong-dan-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li>Trong h\u1ed9p tho\u1ea1i &#8220;Format Cells&#8221;, Ch\u1ecdn danh m\u1ee5c &#8220;Text&#8221; v\u00e0 nh\u1ea5n OK.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-271749 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-2-1.jpg\" alt=\"viet-hoa-chu-cai-dau-trong-excel-huong-dan-2-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-2-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-2-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-2-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>D\u1eef li\u1ec7u c\u1ee7a b\u1ea1n gi\u1edd \u0111\u00e2y s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng v\u1edbi ch\u1eef c\u00e1i \u0111\u1ea7u vi\u1ebft hoa, v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c s\u1eed d\u1ee5ng ho\u1eb7c ch\u1ec9nh s\u1eeda n\u00f3 nh\u01b0 mong mu\u1ed1n.<\/p>\n<h3>S\u1eed d\u1ee5ng VBA Macro \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/h3>\n<p>VBA (Visual Basic for Applications) l\u00e0 ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh d\u00f9ng trong c\u00e1c \u1ee9ng d\u1ee5ng c\u1ee7a Microsoft Office, trong \u0111\u00f3 c\u00f3 Excel. VBA cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u1ea1o ra c\u00e1c Macro &#8211; m\u1ed9t chu\u1ed7i l\u1ec7nh t\u1ef1 \u0111\u1ed9ng &#8211; \u0111\u1ec3 th\u1ef1c hi\u1ec7n m\u1ed9t lo\u1ea1t c\u00e1c thao t\u00e1c m\u00e0 kh\u00f4ng c\u1ea7n thao t\u00e1c th\u1ee7 c\u00f4ng.<\/p>\n<p><strong>H\u01b0\u1edbng d\u1eabn vi\u1ebft v\u00e0 s\u1eed d\u1ee5ng Macro \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u:<\/strong><\/p>\n<p>M\u1edf Excel v\u00e0 ch\u1ecdn th\u1ebb &#8220;Developer&#8221;.<\/p>\n<p>Nh\u1ea5n v\u00e0o m\u1ee5c &#8220;Visual Basic&#8221; \u0111\u1ec3 ti\u1ebfn h\u00e0nh m\u1edf c\u1eeda s\u1ed5 VBA.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-271747 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-3-1.jpg\" alt=\"viet-hoa-chu-cai-dau-trong-excel-huong-dan-3-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-3-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-3-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-3-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>Trong c\u1eeda s\u1ed5 VBA, ch\u1ecdn &#8220;Insert&#8221; &gt; &#8220;Module&#8221; \u0111\u1ec3 th\u00eam m\u1ed9t module m\u1edbi.<\/p>\n<p>Trong c\u1eeda s\u1ed5 module hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh, b\u1ea1n ch\u1ec9 c\u1ea7n sao ch\u00e9p v\u00e0 d\u00e1n \u0111o\u1ea1n m\u00e3 b\u00ean d\u01b0\u1edbi:<\/p>\n<p><strong>Sub CapitalizeFirstLetter()<\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0 Dim rng As Range<\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0 Dim cell As Range<\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0 Set rng = Selection<\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0 For Each cell In rng<\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 cell.Value = StrConv(cell.Value, vbProperCase)<\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0 Next cell<\/strong><\/p>\n<p><strong>End Sub<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-271746 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-3-2.jpg\" alt=\"viet-hoa-chu-cai-dau-trong-excel-huong-dan-3-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-3-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-3-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-3-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>\u0110\u00f3ng c\u1eeda s\u1ed5 VBA.<\/p>\n<p>Tr\u1edf l\u1ea1i Excel, ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i.<\/p>\n<p>Tr\u00ean th\u1ebb &#8220;Developer&#8221;, nh\u1ea5n &#8220;Macros&#8221;, ch\u1ecdn &#8220;CapitalizeFirstLetter&#8221; v\u00e0 sau \u0111\u00f3 nh\u1ea5n &#8220;Run&#8221;.<\/p>\n<h3>S\u1eed d\u1ee5ng h\u00e0m UPPER v\u00e0 LEFT<\/h3>\n<p>H\u00e0m UPPER d\u00f9ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 c\u00e1c ch\u1eef c\u00e1i trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh ch\u1eef in hoa. H\u00e0m LEFT l\u1ea5y m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh t\u1eeb b\u00ean tr\u00e1i c\u1ee7a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n. K\u1ebft h\u1ee3p hai h\u00e0m n\u00e0y gi\u00fap ch\u00fang ta vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u c\u1ee7a m\u1ed9t t\u1eeb. \u0110\u00e2y c\u0169ng l\u00e0 <strong>c\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/strong> h\u1eefu \u00edch m\u00e0 b\u1ea1n n\u00ean th\u1eed.<\/p>\n<p><strong>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong m\u1ed9t t\u1eeb:<\/strong><\/p>\n<p>Gi\u1ea3 s\u1eed d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i n\u1eb1m \u1edf \u00f4 A1.<\/p>\n<p>Trong m\u1ed9t \u00f4 tr\u1ed1ng, g\u00f5 c\u00f4ng th\u1ee9c sau: =UPPER(LEFT(A1,1))&amp;MID(A1,2,LEN(A1)-1).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-271745 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-4.jpg\" alt=\"viet-hoa-chu-cai-dau-trong-excel-huong-dan-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>Nh\u1ea5n Enter.<\/p>\n<p>D\u1eef li\u1ec7u trong \u00f4 n\u00e0y gi\u1edd \u0111\u00e2y s\u1ebd hi\u1ec3n th\u1ecb t\u1eeb trong \u00f4 A1 v\u1edbi ch\u1eef c\u00e1i \u0111\u1ea7u \u0111\u01b0\u1ee3c vi\u1ebft hoa.<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 k\u00e9o g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a \u00f4 n\u00e0y \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 d\u00e3y d\u1eef li\u1ec7u.<\/p>\n<h3>S\u1eed d\u1ee5ng add-ins c\u1ee7a b\u00ean th\u1ee9 ba \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/h3>\n<p>Trong s\u1ed1 h\u00e0ng ng\u00e0n add-ins d\u00e0nh cho Excel, c\u00f3 m\u1ed9t s\u1ed1 add-ins \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 h\u1ed7 tr\u1ee3 vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n, trong \u0111\u00f3 bao g\u1ed3m c\u1ea3 vi\u1ec7c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u. Nh\u1eefng add-ins n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c cung c\u1ea5p b\u1edfi c\u00e1c nh\u00e0 ph\u00e1t tri\u1ec3n b\u00ean ngo\u00e0i v\u00e0 c\u00f3 th\u1ec3 gi\u1ea3m thi\u1ec3u th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c c\u1ee7a b\u1ea1n khi th\u1ef1c hi\u1ec7n c\u00e1c t\u00e1c v\u1ee5 li\u00ean quan \u0111\u1ebfn v\u0103n b\u1ea3n.<\/p>\n<p><strong>C\u00e1ch c\u00e0i \u0111\u1eb7t v\u00e0 s\u1eed d\u1ee5ng add-ins:<\/strong><\/p>\n<ul>\n<li>\u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n t\u00ecm v\u00e0 t\u1ea3i add-in t\u1eeb m\u1ed9t ngu\u1ed3n \u0111\u00e1ng tin c\u1eady.<\/li>\n<li>M\u1edf Excel, ch\u1ecdn th\u1ebb &#8220;File&#8221; &gt; &#8220;Options&#8221;.<\/li>\n<li>Trong h\u1ed9p tho\u1ea1i &#8220;Excel Options&#8221; xu\u1ea5t hi\u1ec7n tr\u00ean m\u00e0n h\u00ecnh, ch\u1ecdn &#8220;Add-Ins&#8221;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-271744 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-5.jpg\" alt=\"viet-hoa-chu-cai-dau-trong-excel-huong-dan-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li>\u1ede d\u01b0\u1edbi \u0111\u00e1y c\u1eeda s\u1ed5, ch\u1ecdn &#8220;Excel Add-ins&#8221; t\u1eeb danh s\u00e1ch r\u1ed3i nh\u1ea5n &#8220;Go&#8230;&#8221;.<\/li>\n<li>Nh\u1ea5n &#8220;Browse&#8221; \u0111\u1ec3 ch\u1ecdn file add-in b\u1ea1n \u0111\u00e3 t\u1ea3i v\u1ec1.<\/li>\n<li>Ch\u1ecdn add-in v\u00e0 nh\u1ea5n &#8220;OK&#8221;.<\/li>\n<li>Sau khi c\u00e0i \u0111\u1eb7t, b\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t n\u00fat ho\u1eb7c thanh c\u00f4ng c\u1ee5 m\u1edbi xu\u1ea5t hi\u1ec7n tr\u00ean Excel. Tu\u1ef3 thu\u1ed9c v\u00e0o add-in b\u1ea1n \u0111\u00e3 ch\u1ecdn, h\u00e3y s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u c\u1ee7a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n.<\/li>\n<\/ul>\n<h3>S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Text to Columns v\u00e0 h\u00e0m PROPER<\/h3>\n<p>Text to Columns l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 gi\u00fap ph\u00e2n t\u00e1ch d\u1eef li\u1ec7u trong m\u1ed9t \u00f4 th\u00e0nh c\u00e1c c\u1ed9t ri\u00eang bi\u1ec7t. K\u1ebft h\u1ee3p v\u1edbi h\u00e0m PROPER, ch\u00fang ta c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong m\u1ed7i t\u1eeb c\u1ee7a m\u1ed9t chu\u1ed7i d\u00e0i. V\u00ec v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch n\u00e0y \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel d\u1ec5 d\u00e0ng.<\/p>\n<p><strong>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft th\u1ef1c hi\u1ec7n t\u1eebng b\u01b0\u1edbc:<\/strong><\/p>\n<ul>\n<li>Ch\u1ecdn c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng.<\/li>\n<li>Tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn th\u1ebb &#8220;Data&#8221; v\u00e0 sau \u0111\u00f3 ch\u1ecdn &#8220;Text to Columns&#8221;.<\/li>\n<li>Ch\u1ecdn &#8220;Delimited&#8221; &gt; &#8220;Next&#8221;.<\/li>\n<li>Ch\u1ecdn d\u1ea5u c\u00e1ch l\u00e0m d\u1ea5u ph\u00e2n c\u00e1ch v\u00e0 nh\u1ea5n &#8220;Next&#8221;.<\/li>\n<li>Ch\u1ecdn &#8220;Finish&#8221;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-271743 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-6.jpg\" alt=\"viet-hoa-chu-cai-dau-trong-excel-huong-dan-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li>D\u1eef li\u1ec7u gi\u1edd \u0111\u00e2y s\u1ebd \u0111\u01b0\u1ee3c ph\u00e2n t\u00e1ch ra th\u00e0nh t\u1eebng t\u1eeb tr\u00ean c\u00e1c c\u1ed9t ri\u00eang bi\u1ec7t.<\/li>\n<li>Trong m\u1ed9t c\u1ed9t tr\u1ed1ng, s\u1eed d\u1ee5ng h\u00e0m PROPER \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u cho m\u1ed7i t\u1eeb. V\u00ed d\u1ee5: =PROPER(B1).<\/li>\n<li>L\u1eb7p l\u1ea1i b\u01b0\u1edbc 7 cho t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t ch\u1ee9a t\u1eeb.<\/li>\n<li>Cu\u1ed1i c\u00f9ng, s\u1eed d\u1ee5ng d\u1ea5u &amp; \u0111\u1ec3 n\u1ed1i l\u1ea1i c\u00e1c t\u1eeb th\u00e0nh m\u1ed9t chu\u1ed7i ho\u00e0n ch\u1ec9nh v\u1edbi ch\u1eef c\u00e1i \u0111\u1ea7u c\u1ee7a m\u1ed7i t\u1eeb vi\u1ebft hoa.<\/li>\n<\/ul>\n<h2>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng c\u00e1c c\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/h2>\n<p>Khi \u00e1p d\u1ee5ng c\u00e1c c\u00e1ch \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong ph\u1ea7n m\u1ec1m Excel, vi\u1ec7c hi\u1ec3u r\u00f5 m\u1ed9t s\u1ed1 \u0111i\u1ec3m sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n tr\u00e1nh g\u1eb7p ph\u1ea3i l\u1ed7i v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng d\u1eef li\u1ec7u kh\u00f4ng b\u1ecb th\u1ea5t l\u1ea1c ho\u1eb7c m\u1ea5t:<\/p>\n<p><strong>Sao l\u01b0u d\u1eef li\u1ec7u tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n<\/strong>: Tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng b\u1ea5t k\u1ef3 thay \u0111\u1ed5i n\u00e0o \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh, lu\u00f4n t\u1ea1o m\u1ed9t b\u1ea3n sao l\u01b0u. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 quay tr\u1edf l\u1ea1i d\u1eef li\u1ec7u g\u1ed1c n\u1ebfu c\u00f3 l\u1ed7i x\u1ea3y ra.<\/p>\n<p><strong>C\u1ea9n tr\u1ecdng v\u1edbi Macro v\u00e0 Add-ins<\/strong>: Khi s\u1eed d\u1ee5ng VBA Macro ho\u1eb7c add-ins t\u1eeb b\u00ean th\u1ee9 ba, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng ch\u00fang \u0111\u1ebfn t\u1eeb ngu\u1ed3n tin c\u1eady v\u00e0 kh\u00f4ng mang m\u00e3 \u0111\u1ed9c ho\u1eb7c l\u00e0m \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn d\u1eef li\u1ec7u.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-271742 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-goi-y.jpg\" alt=\"viet-hoa-chu-cai-dau-trong-excel-huong-dan-goi-y\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-goi-y.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-goi-y-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-huong-dan-goi-y-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><strong>Ki\u1ec3m tra k\u1ebft qu\u1ea3 sau khi th\u1ef1c hi\u1ec7n<\/strong>: Sau khi \u00e1p d\u1ee5ng h\u00e0m ho\u1eb7c c\u00f4ng c\u1ee5, lu\u00f4n ki\u1ec3m tra m\u1ed9t s\u1ed1 d\u00f2ng d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng ch\u00fang \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u00fang c\u00e1ch.<\/p>\n<p><strong>L\u01b0u \u00fd v\u1edbi d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p<\/strong>: N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n ch\u1ee9a nhi\u1ec1u t\u1eeb ho\u1eb7c c\u1ee5m t\u1eeb c\u00f3 ng\u1eef c\u1ea3nh \u0111\u1eb7c bi\u1ec7t (v\u00ed d\u1ee5: t\u1eeb vi\u1ebft t\u1eaft, t\u00ean ri\u00eang&#8230;), h\u00e3y ki\u1ec3m tra c\u00e1ch th\u1ee9c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u c\u00f3 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn ch\u00fang hay kh\u00f4ng.<\/p>\n<p><strong>Xem x\u00e9t k\u00edch th\u01b0\u1edbc d\u1eef li\u1ec7u<\/strong>: M\u1ed9t s\u1ed1 ph\u01b0\u01a1ng ph\u00e1p c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng t\u1ed1t v\u1edbi d\u1eef li\u1ec7u nh\u1ecf nh\u01b0ng ch\u1eadm tr\u1ec5 v\u1edbi d\u1eef li\u1ec7u l\u1edbn. \u0110\u1ed1i m\u1eb7t v\u1edbi d\u1eef li\u1ec7u l\u1edbn, xem x\u00e9t vi\u1ec7c s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p hi\u1ec7u qu\u1ea3 h\u01a1n v\u1ec1 th\u1eddi gian.<\/p>\n<h2>G\u1ee3i \u00fd v\u1ec1 vi\u1ec7c l\u1ef1a ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p ph\u00f9 h\u1ee3p nh\u1ea5t<\/h2>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd khi ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p c\u00e1ch <strong>vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/strong> trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3:<\/p>\n<p><strong>\u0110\u1ed1i v\u1edbi ng\u01b0\u1eddi d\u00f9ng m\u1edbi<\/strong>: N\u1ebfu b\u1ea1n m\u1edbi l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng h\u00e0m PROPER ho\u1eb7c c\u00f4ng c\u1ee5 Format Cells s\u1ebd l\u00e0 l\u1ef1a ch\u1ecdn \u0111\u01a1n gi\u1ea3n nh\u1ea5t.<\/p>\n<p><strong>D\u1eef li\u1ec7u l\u1edbn<\/strong>: \u0110\u1ed1i v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn, vi\u1ec7c s\u1eed d\u1ee5ng VBA Macro ho\u1eb7c add-ins c\u00f3 th\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian h\u01a1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-271755 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-luu-y.jpg\" alt=\"viet-hoa-chu-cai-dau-trong-excel-luu-y\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-luu-y.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-luu-y-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-luu-y-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><strong>T\u00ednh linh ho\u1ea1t<\/strong>: N\u1ebfu b\u1ea1n mu\u1ed1n c\u00f3 s\u1ef1 linh ho\u1ea1t h\u01a1n trong vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u, vi\u1ec7c k\u1ebft h\u1ee3p c\u00e1c h\u00e0m nh\u01b0 UPPER, LEFT v\u00e0 PROPER c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n.<\/p>\n<p><strong>\u0110\u1ed1i v\u1edbi d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p<\/strong>: Khi d\u1eef li\u1ec7u ch\u1ee9a nhi\u1ec1u t\u1eeb ng\u1eef \u0111\u1eb7c bi\u1ec7t ho\u1eb7c c\u1ea7n s\u1ef1 ch\u00ednh x\u00e1c cao, h\u00e3y xem x\u00e9t vi\u1ec7c th\u1ef1c hi\u1ec7n thao t\u00e1c th\u1ee7 c\u00f4ng ho\u1eb7c t\u00ecm add-ins chuy\u00ean d\u1ee5ng cho m\u1ee5c \u0111\u00edch n\u00e0y.<\/p>\n<p>T\u00f9y thu\u1ed9c v\u00e0o nhu c\u1ea7u v\u00e0 k\u1ef9 n\u0103ng c\u1ee7a b\u1ea1n, l\u1ef1a ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p ph\u00f9 h\u1ee3p s\u1ebd gi\u00fap vi\u1ec7c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong ph\u1ea7n m\u1ec1m Excel tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n<h2>T\u1ea1m k\u1ebft<\/h2>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 to\u00e0n b\u1ed9 c\u00e1c th\u00f4ng tin li\u00ean quan \u0111\u1ebfn 6 c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 <strong>vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/strong>. M\u1ed7i c\u00e1ch c\u00f3 nh\u1eefng \u01b0u v\u00e0 nh\u01b0\u1ee3c \u0111i\u1ec3m ri\u00eang, v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn l\u1ef1a c\u00e1ch ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u c\u1ee7a m\u00ecnh. D\u00f9 b\u1ea1n l\u00e0 ng\u01b0\u1eddi m\u1edbi m\u1eaft v\u1edbi Excel hay l\u00e0 m\u1ed9t ng\u01b0\u1eddi d\u00f9ng l\u00e2u n\u0103m, ch\u1eafc ch\u1eafn b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y \u00edt nh\u1ea5t m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p h\u1eefu \u00edch t\u1eeb danh s\u00e1ch n\u00e0y. N\u1ebfu mu\u1ed1n tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 th\u1ee7 thu\u1eadt kh\u00e1c li\u00ean quan \u0111\u1ebfn Excel th\u00ec h\u00e3y truy c\u1eadp trang tin nhanh c\u1ee7a Ho\u00e0ng H\u00e0 Mobile nh\u00e9.<\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/\">H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/\">5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi H\u00e0m ROUND<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel kh\u00f4ng ch\u1ec9 gi\u00fap d\u1eef li\u1ec7u tr\u1edf n\u00ean th\u1ea9m m\u1ef9 v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n, m\u00e0 c\u00f2n gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng \u0111\u1ecdc v\u00e0 hi\u1ec3u th\u00f4ng tin. V\u00ed d\u1ee5, t\u00ean ri\u00eang ho\u1eb7c ti\u00eau \u0111\u1ec1 khi \u0111\u01b0\u1ee3c vi\u1ebft hoa \u0111\u00fang c\u00e1ch s\u1ebd n\u1ed5i b\u1eadt h\u01a1n v\u00e0 tr\u00e1nh nh\u1ea7m l\u1eabn. Trong b\u00e0i vi\u1ebft [&hellip;]<\/p>\n","protected":false},"author":83,"featured_media":271756,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-271741","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>6 C\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n nh\u1eefng c\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel hi\u1ec7u qu\u1ea3, \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng l\u00e0m \u0111\u01b0\u1ee3c.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"6 C\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n nh\u1eefng c\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel hi\u1ec7u qu\u1ea3, \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng l\u00e0m \u0111\u01b0\u1ee3c.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-13T14:58:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-thumb.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Do Tuyet Nhi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Do Tuyet Nhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/viet-hoa-chu-cai-dau-trong-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/viet-hoa-chu-cai-dau-trong-excel\\\/\"},\"author\":{\"name\":\"Do Tuyet Nhi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/person\\\/88810eb4147ac2a9b8be1170af8c9598\"},\"headline\":\"6 C\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"datePublished\":\"2023-10-13T14:58:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/viet-hoa-chu-cai-dau-trong-excel\\\/\"},\"wordCount\":3159,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/viet-hoa-chu-cai-dau-trong-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/viet-hoa-chu-cai-dau-trong-excel-thumb.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/viet-hoa-chu-cai-dau-trong-excel\\\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/viet-hoa-chu-cai-dau-trong-excel\\\/\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/viet-hoa-chu-cai-dau-trong-excel\\\/\",\"name\":\"6 C\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/viet-hoa-chu-cai-dau-trong-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/viet-hoa-chu-cai-dau-trong-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/viet-hoa-chu-cai-dau-trong-excel-thumb.jpg\",\"datePublished\":\"2023-10-13T14:58:52+00:00\",\"description\":\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n nh\u1eefng c\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel hi\u1ec7u qu\u1ea3, \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng l\u00e0m \u0111\u01b0\u1ee3c.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/viet-hoa-chu-cai-dau-trong-excel\\\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/viet-hoa-chu-cai-dau-trong-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/viet-hoa-chu-cai-dau-trong-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/viet-hoa-chu-cai-dau-trong-excel-thumb.jpg\",\"contentUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/viet-hoa-chu-cai-dau-trong-excel-thumb.jpg\",\"width\":1200,\"height\":628,\"caption\":\"viet-hoa-chu-cai-dau-trong-excel-thumb\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/viet-hoa-chu-cai-dau-trong-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/category\\\/thu-thuat\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"6 C\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#website\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/logo-text.png\",\"contentUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/person\\\/88810eb4147ac2a9b8be1170af8c9598\",\"name\":\"Do Tuyet Nhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7df017b4c5c3223e2d5ba6013f7fc6a683e3fe6fa54ece398a6dd570034c71e6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7df017b4c5c3223e2d5ba6013f7fc6a683e3fe6fa54ece398a6dd570034c71e6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7df017b4c5c3223e2d5ba6013f7fc6a683e3fe6fa54ece398a6dd570034c71e6?s=96&d=mm&r=g\",\"caption\":\"Do Tuyet Nhi\"},\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/author\\\/do-tuyet-nhi\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"6 C\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n nh\u1eefng c\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel hi\u1ec7u qu\u1ea3, \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng l\u00e0m \u0111\u01b0\u1ee3c.","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":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"6 C\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","og_description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n nh\u1eefng c\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel hi\u1ec7u qu\u1ea3, \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng l\u00e0m \u0111\u01b0\u1ee3c.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-10-13T14:58:52+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-thumb.jpg","type":"image\/jpeg"}],"author":"Do Tuyet Nhi","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Do Tuyet Nhi","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/"},"author":{"name":"Do Tuyet Nhi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/88810eb4147ac2a9b8be1170af8c9598"},"headline":"6 C\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","datePublished":"2023-10-13T14:58:52+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/"},"wordCount":3159,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-thumb.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/","name":"6 C\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-thumb.jpg","datePublished":"2023-10-13T14:58:52+00:00","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n nh\u1eefng c\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel hi\u1ec7u qu\u1ea3, \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng l\u00e0m \u0111\u01b0\u1ee3c.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-thumb.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/viet-hoa-chu-cai-dau-trong-excel-thumb.jpg","width":1200,"height":628,"caption":"viet-hoa-chu-cai-dau-trong-excel-thumb"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/viet-hoa-chu-cai-dau-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"6 C\u00e1ch vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/88810eb4147ac2a9b8be1170af8c9598","name":"Do Tuyet Nhi","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/secure.gravatar.com\/avatar\/7df017b4c5c3223e2d5ba6013f7fc6a683e3fe6fa54ece398a6dd570034c71e6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7df017b4c5c3223e2d5ba6013f7fc6a683e3fe6fa54ece398a6dd570034c71e6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7df017b4c5c3223e2d5ba6013f7fc6a683e3fe6fa54ece398a6dd570034c71e6?s=96&d=mm&r=g","caption":"Do Tuyet Nhi"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/do-tuyet-nhi\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/271741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=271741"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/271741\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/271756"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=271741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=271741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=271741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}