{"id":98666,"date":"2024-09-20T15:46:42","date_gmt":"2024-09-20T08:46:42","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=98666"},"modified":"2025-03-27T13:58:20","modified_gmt":"2025-03-27T06:58:20","slug":"cach-xuong-dong-trong-excel-google-sheet","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/cach-xuong-dong-trong-excel-google-sheet\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn xu\u1ed1ng d\u00f2ng trong Excel v\u00e0 Google Sheets \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng"},"content":{"rendered":"\n<p>So\u1ea1n th\u1ea3o m\u1ed9t b\u00e1o c\u00e1o chi ti\u1ebft tr\u00ean Excel, nh\u01b0ng n\u1ed9i dung qu\u00e1 d\u00e0i khi\u1ebfn cho c\u00e1c \u00f4 b\u1ecb tr\u00e0n. \u0110i\u1ec1u n\u00e0y kh\u00f4ng ch\u1ec9 l\u00e0m m\u1ea5t t\u00ednh th\u1ea9m m\u1ef9 c\u1ee7a b\u1ea3ng t\u00ednh m\u00e0 c\u00f2n g\u00e2y kh\u00f3 kh\u0103n cho vi\u1ec7c \u0111\u1ecdc v\u00e0 in \u1ea5n. \u0110\u1eebng lo l\u1eafng, trong b\u00e0i vi\u1ebft n\u00e0y s\u1ebd, <a href=\"https:\/\/phongvu.vn\/cong-nghe\/\">Phong V\u0169 Tech News<\/a>\u00a0s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch xu\u1ed1ng d\u00f2ng trong Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<ul>\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-tinh-so-ngay-tron-excel-don-gian-nhat\/\">C\u00e1ch t\u00ednh s\u1ed1 ng\u00e0y trong Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 quan t\u00e2m<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/mail-merge-la-gi-huong-dan-su-dung-mail-merge-trong-word-excel-co-the-ban-quan-tam\/\">Mail merge l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng mail merge trong Word, Excel c\u00f3 th\u1ec3 b\u1ea1n quan t\u00e2m&nbsp;<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/xoa-lich-su-xem-gan-day-tren-google\/\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00f3a l\u1ecbch s\u1eed xem g\u1ea7n \u0111\u00e2y tr\u00ean Google chi ti\u1ebft 2024<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-2-1024x640.jpg\" alt=\"xu\u1ed1ng d\u00f2ng trong excel\" class=\"wp-image-98675\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-2-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-2-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-2-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-2-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-2-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-2-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-2-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-2-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-2-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-2-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-2.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u1ed5ng h\u1ee3p c\u00e1ch xu\u1ed1ng d\u00f2ng trong Excel, Google Sheet.<\/figcaption><\/figure>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_55 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6a19fd5584e07\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6a19fd5584e07\"  type=\"checkbox\" id=\"item-6a19fd5584e07\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-xuong-dong-trong-excel-google-sheet\/#Su_dung_to_hop_phim_AltEnter\" title=\"S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Alt+Enter \">S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Alt+Enter <\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-xuong-dong-trong-excel-google-sheet\/#Su_dung_tinh_nang_Wrap_Text\" title=\"S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Wrap Text \">S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Wrap Text <\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-xuong-dong-trong-excel-google-sheet\/#Su_dung_ham_CHAR\" title=\"S\u1eed d\u1ee5ng h\u00e0m CHAR \">S\u1eed d\u1ee5ng h\u00e0m CHAR <\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-xuong-dong-trong-excel-google-sheet\/#Su_dung_tinh_nang_Find_Replace\" title=\"S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Find &amp; Replace \">S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Find &amp; Replace <\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-xuong-dong-trong-excel-google-sheet\/#Cach_xuong_dong_trong_Excel_tren_dien_thoai_Android_iOS\" title=\"C\u00e1ch xu\u1ed1ng d\u00f2ng trong Excel tr\u00ean \u0111i\u1ec7n tho\u1ea1i Android, iOS \">C\u00e1ch xu\u1ed1ng d\u00f2ng trong Excel tr\u00ean \u0111i\u1ec7n tho\u1ea1i Android, iOS <\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-xuong-dong-trong-excel-google-sheet\/#Tren_dien_thoai_Android\" title=\"Tr\u00ean \u0111i\u1ec7n tho\u1ea1i Android\">Tr\u00ean \u0111i\u1ec7n tho\u1ea1i Android<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-xuong-dong-trong-excel-google-sheet\/#Tren_dien_thoai_iOS\" title=\"Tr\u00ean \u0111i\u1ec7n tho\u1ea1i iOS\">Tr\u00ean \u0111i\u1ec7n tho\u1ea1i iOS<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-xuong-dong-trong-excel-google-sheet\/#Loi_ket\" title=\"L\u1eddi k\u1ebft\">L\u1eddi k\u1ebft<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_to_hop_phim_AltEnter\"><\/span><strong>S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Alt+Enter <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>T\u1ed5 h\u1ee3p ph\u00edm Alt+Enter l\u00e0 m\u1ed9t trong nh\u1eefng c\u00e1ch nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 xu\u1ed1ng d\u00f2ng trong m\u1ed9t \u00f4 khi l\u00e0m vi\u1ec7c v\u1edbi Excel v\u00e0 Google Sheets. \u0110\u1ec3 th\u1ef1c hi\u1ec7n xu\u1ed1ng d\u00f2ng trong Excel nh\u1edd v\u00e0o t\u1ed5 h\u1ee3p ph\u00edm tr\u00ean, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o v\u1ecb tr\u00ed trong \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n b\u1eaft \u0111\u1ea7u xu\u1ed1ng d\u00f2ng.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <strong>Alt+Enter<\/strong>. L\u00fac n\u00e0y, n\u1ed9i dung sau con tr\u1ecf s\u1ebd t\u1ef1 \u0111\u1ed9ng xu\u1ed1ng d\u00f2ng v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c nh\u1eadp n\u1ed9i dung \u1edf d\u00f2ng m\u1edbi.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-1-1024x640.jpg\" alt=\"\" class=\"wp-image-98676\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-1.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Alt+Enter \u0111\u1ec3 xu\u1ed1ng d\u00f2ng trong Excel.<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_tinh_nang_Wrap_Text\"><\/span><strong>S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Wrap Text <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>T\u00ednh n\u0103ng Wrap Text trong Excel gi\u00fap b\u1ea1n xu\u1ed1ng d\u00f2ng trong \u00f4 m\u00e0 kh\u00f4ng c\u1ea7n thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc c\u1ed9t ho\u1eb7c h\u00e0ng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng t\u00ednh n\u0103ng \u0111\u1ec3 xu\u1ed1ng d\u00f2ng trong Excel n\u00e0y:<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1<\/strong>: Ch\u1ecdn \u00f4 ho\u1eb7c nh\u00f3m \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng t\u00ednh n\u0103ng xu\u1ed1ng d\u00f2ng trong Excel.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2<\/strong>: V\u00e0o tab Home tr\u00ean thanh c\u00f4ng c\u1ee5. Trong nh\u00f3m Alignment (C\u0103n ch\u1ec9nh), t\u00ecm v\u00e0 nh\u1ea5n v\u00e0o n\u00fat Wrap Text (Xu\u1ed1ng d\u00f2ng v\u0103n b\u1ea3n).<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 3<\/strong>: L\u00fac n\u00e0y, v\u0103n b\u1ea3n trong \u00f4 s\u1ebd t\u1ef1 \u0111\u1ed9ng xu\u1ed1ng d\u00f2ng n\u1ebfu n\u1ed9i dung d\u00e0i h\u01a1n chi\u1ec1u r\u1ed9ng c\u1ee7a \u00f4.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-3-1024x640.jpg\" alt=\"\" class=\"wp-image-98677\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-3-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-3-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-3-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-3-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-3-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-3-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-3-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-3-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-3-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-3-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-3.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Wrap Text \u0111\u1ec3 xu\u1ed1ng d\u00f2ng trong Excel.<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_CHAR\"><\/span><strong>S\u1eed d\u1ee5ng h\u00e0m CHAR <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>H\u00e0m CHAR trong Excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i m\u1ed9t s\u1ed1 nguy\u00ean th\u00e0nh k\u00fd t\u1ef1 t\u01b0\u01a1ng \u1ee9ng theo b\u1ea3ng m\u00e3 ASCII. \u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch xu\u1ed1ng d\u00f2ng trong excel n\u00e0y, h\u00e3y l\u00e0m theo c\u00e1c thao t\u00e1c \u0111\u01a1n gi\u1ea3n sau:<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong>&nbsp;\u0110\u1eb7t con tr\u1ecf n\u1eb1m \u1edf \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n xu\u1ed1ng d\u00f2ng trong excel.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2:&nbsp;<\/strong>D\u00f9ng h\u00e0m CHAR v\u1edbi k\u00fd t\u1ef1 xu\u1ed1ng d\u00f2ng t\u01b0\u01a1ng \u1ee9ng theo b\u1ea3ng m\u00e3 ASCII: =CHAR(10).<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 3:\u00a0<\/strong>Ti\u1ebfp t\u1ee5c nh\u1ea5n Enter. L\u00fac n\u00e0y, c\u00e1c d\u00f2ng m\u1edbi s\u1ebd \u0111\u01b0\u1ee3c kh\u1edfi t\u1ea1o.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-4-1024x640.jpg\" alt=\"\" class=\"wp-image-98678\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-4-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-4-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-4-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-4-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-4-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-4-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-4-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-4-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-4-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-4-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-4.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m CHAR \u0111\u1ec3 xu\u1ed1ng d\u00f2ng trong Excel<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_tinh_nang_Find_Replace\"><\/span><strong>S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Find &amp; Replace <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>T\u00ednh n\u0103ng Find &amp; Replace trong Excel kh\u00f4ng ch\u1ec9 gi\u00fap t\u00ecm v\u00e0 thay th\u1ebf v\u0103n b\u1ea3n m\u00e0 c\u00f2n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 th\u00eam k\u00fd t\u1ef1 xu\u1ed1ng d\u00f2ng trong \u00f4, t\u1ea1o s\u1ef1 thu\u1eadn ti\u1ec7n khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c \u0111o\u1ea1n v\u0103n b\u1ea3n d\u00e0i. \u0110\u1ec3 xu\u1ed1ng d\u00f2ng trong Excel nh\u1edd t\u00ednh n\u0103ng n\u00e0y, h\u00e3y th\u1ef1c hi\u1ec7n thao t\u00e1c sau:<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1: <\/strong>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n ho\u1eb7c m\u1ed9t danh s\u00e1ch th\u00f4ng tin trong c\u00f9ng m\u1ed9t \u00f4 v\u00e0 b\u1ea1n mu\u1ed1n xu\u1ed1ng d\u00f2ng t\u1ea1i m\u1ed9t v\u1ecb tr\u00ed nh\u1ea5t \u0111\u1ecbnh. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 n\u1ed9i dung nh\u01b0 &#8220;A,B&#8221; v\u00e0 mu\u1ed1n thay th\u1ebf d\u1ea5u ph\u1ea9y b\u1eb1ng k\u00fd t\u1ef1 xu\u1ed1ng d\u00f2ng.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2:<\/strong> H\u00e3y ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n thay th\u1ebf (c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4). Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + H \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Find &amp; Replace.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 3:<\/strong> Trong h\u1ed9p tho\u1ea1i Find &amp; Replace, th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:\n<ul>\n<li><strong>Find what<\/strong> (T\u00ecm g\u00ec): Nh\u1eadp k\u00fd t\u1ef1 ho\u1eb7c chu\u1ed7i k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n thay th\u1ebf. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n mu\u1ed1n thay th\u1ebf d\u1ea5u ph\u1ea9y b\u1eb1ng xu\u1ed1ng d\u00f2ng, h\u00e3y nh\u1eadp d\u1ea5u ph\u1ea9y.<\/li>\n\n\n\n<li><strong>Replace with<\/strong> (Thay th\u1ebf b\u1eb1ng): Nh\u1ea5p v\u00e0o \u00f4 nh\u1eadp, sau \u0111\u00f3 nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <strong>Ctrl + J<\/strong>. B\u1ea1n s\u1ebd th\u1ea5y con tr\u1ecf nh\u1eadp li\u1ec7u nh\u1ea3y xu\u1ed1ng d\u00f2ng, nh\u01b0ng h\u1ed9p nh\u1eadp s\u1ebd tr\u00f4ng nh\u01b0 tr\u1ed1ng. Sau \u0111\u00f3, nh\u1ea5p <strong>Replace All<\/strong> (Thay th\u1ebf t\u1ea5t c\u1ea3).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 4:<\/strong> L\u00fac n\u00e0y, t\u1ea5t c\u1ea3 c\u00e1c v\u1ecb tr\u00ed ch\u1ee9a d\u1ea5u ph\u1ea9y (ho\u1eb7c k\u00fd t\u1ef1 b\u1ea1n ch\u1ecdn) s\u1ebd \u0111\u01b0\u1ee3c thay th\u1ebf b\u1eb1ng k\u00fd t\u1ef1 xu\u1ed1ng d\u00f2ng, l\u00e0m cho n\u1ed9i dung trong \u00f4 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb th\u00e0nh nhi\u1ec1u d\u00f2ng.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-5-1024x640.jpg\" alt=\"\" class=\"wp-image-98680\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-5-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-5-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-5-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-5-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-5-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-5-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-5-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-5-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-5-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-5-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-5.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Find &amp; Replace \u0111\u1ec3 xu\u1ed1ng d\u00f2ng trong Excel.<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Cach_xuong_dong_trong_Excel_tren_dien_thoai_Android_iOS\"><\/span><strong>C\u00e1ch xu\u1ed1ng d\u00f2ng trong Excel tr\u00ean \u0111i\u1ec7n tho\u1ea1i Android, iOS <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>M\u1eb7c d\u00f9 kh\u00f4ng tr\u1ef1c quan b\u1eb1ng khi l\u00e0m vi\u1ec7c tr\u00ean m\u00e1y t\u00ednh, nh\u01b0ng vi\u1ec7c xu\u1ed1ng d\u00f2ng trong Excel tr\u00ean \u0111i\u1ec7n tho\u1ea1i l\u00e0 ho\u00e0n to\u00e0n kh\u1ea3 thi. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft cho c\u1ea3 hai h\u1ec7 \u0111i\u1ec1u h\u00e0nh Android v\u00e0 iOS. H\u00e3y c\u00f9ng Phong V\u0169 tham kh\u1ea3o nh\u00e9!<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Tren_dien_thoai_Android\"><\/span><strong>Tr\u00ean \u0111i\u1ec7n tho\u1ea1i Android<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1<\/strong>: M\u1edf file Excel m\u00e0 b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda. Nh\u1ea5n v\u00e0o \u00f4 \u0111\u00f3.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2:<\/strong> Ti\u1ebfp t\u1ee5c nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a m\u00e0n h\u00ecnh \u0111\u1ec3 m\u1edf \u0111\u1ea7y \u0111\u1ee7 thanh c\u00f4ng c\u1ee5.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 3:<\/strong> Trong tab &#8220;Trang ch\u1ee7&#8221; (Home), cu\u1ed9n xu\u1ed1ng v\u00e0 t\u00ecm \u0111\u1ebfn m\u1ee5c &#8220;Ng\u1eaft d\u00f2ng v\u0103n b\u1ea3n&#8221;. Nh\u1ea5n v\u00e0o m\u1ee5c n\u00e0y. L\u00fac n\u00e0y, n\u1ed9i dung trong \u00f4 s\u1ebd t\u1ef1 \u0111\u1ed9ng xu\u1ed1ng d\u00f2ng khi \u0111\u1ea1t \u0111\u1ebfn gi\u1edbi h\u1ea1n c\u1ee7a \u00f4.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-6-1024x640.jpg\" alt=\"\" class=\"wp-image-98681\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-6-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-6-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-6-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-6-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-6-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-6-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-6-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-6-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-6-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-6-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/09\/xuong-dong-trong-excel-6.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Tren_dien_thoai_iOS\"><\/span><strong>Tr\u00ean \u0111i\u1ec7n tho\u1ea1i iOS<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean Android, \u0111\u1ec3 xu\u1ed1ng d\u00f2ng trong Excel v\u1edbi thi\u1ebft b\u1ecb iOS, h\u00e3y l\u00e0m theo c\u00e1c thao t\u00e1c sau:<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda. Nh\u1ea5n v\u00e0o \u00f4 c\u1ea7n xu\u1ed1ng d\u00f2ng.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2:<\/strong> T\u00ecm v\u00e0 nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng ba ch\u1ea5m (&#8230;) \u0111\u1ec3 m\u1edf menu. Trong menu n\u00e0y, t\u00ecm v\u00e0 ch\u1ecdn &#8220;Wrap Text&#8221;.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 3:<\/strong> N\u1ebfu c\u1ea7n, b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o c\u1ea1nh d\u01b0\u1edbi c\u1ee7a h\u00e0ng \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh chi\u1ec1u cao cho ph\u00f9 h\u1ee3p.<\/li>\n<\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Loi_ket\"><\/span><strong>L\u1eddi k\u1ebft<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Xu\u1ed1ng d\u00f2ng trong Excel kh\u00f4ng ch\u1ec9 l\u00e0 m\u1ed9t thao t\u00e1c \u0111\u01a1n thu\u1ea7n m\u00e0 c\u00f2n l\u00e0 m\u1ed9t ngh\u1ec7 thu\u1eadt gi\u00fap b\u1ea1n tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 \u1ea5n t\u01b0\u1ee3ng. H\u00e3y th\u1ecfa s\u1ee9c s\u00e1ng t\u1ea1o v\u00e0 kh\u00e1m ph\u00e1 th\u00eam nhi\u1ec1u c\u00e1ch th\u1ee9c kh\u00e1c nhau \u0111\u1ec3 l\u00e0m cho b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n tr\u1edf n\u00ean s\u1ed1ng \u0111\u1ed9ng v\u00e0 thu h\u00fat h\u01a1n. Phong V\u0169 ch\u00fac b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng nh\u00e9!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So\u1ea1n th\u1ea3o m\u1ed9t b\u00e1o c\u00e1o chi ti\u1ebft tr\u00ean Excel, nh\u01b0ng n\u1ed9i dung qu\u00e1 d\u00e0i khi\u1ebfn cho c\u00e1c \u00f4 b\u1ecb tr\u00e0n. \u0110i\u1ec1u n\u00e0y kh\u00f4ng ch\u1ec9 l\u00e0m m\u1ea5t t\u00ednh th\u1ea9m m\u1ef9 c\u1ee7a b\u1ea3ng t\u00ednh m\u00e0 c\u00f2n g\u00e2y kh\u00f3 kh\u0103n cho vi\u1ec7c \u0111\u1ecdc v\u00e0 in \u1ea5n. \u0110\u1eebng lo l\u1eafng, trong b\u00e0i vi\u1ebft n\u00e0y s\u1ebd, Phong V\u0169 Tech News\u00a0s\u1ebd [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":98675,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[74,1029,24],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/98666"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=98666"}],"version-history":[{"count":3,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/98666\/revisions"}],"predecessor-version":[{"id":98724,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/98666\/revisions\/98724"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/98675"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=98666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=98666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=98666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}