{"id":13329,"date":"2022-11-30T22:17:41","date_gmt":"2022-11-30T15:17:41","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=13329"},"modified":"2022-12-07T16:59:25","modified_gmt":"2022-12-07T09:59:25","slug":"bo-dau-cach-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/","title":{"rendered":"C\u00e1ch b\u1ecf d\u1ea5u c\u00e1ch trong Excel ph\u01b0\u01a1ng ph\u00e1p si\u00eau nhanh"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;13329&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch b\u1ecf d\u1ea5u c\u00e1ch trong Excel ph\u01b0\u01a1ng ph\u00e1p si\u00eau nhanh&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400; color: #000000;\"><strong>B\u1ecf d\u1ea5u c\u00e1ch trong Excel<\/strong> ra sao? Tr\u00ean th\u1ef1c t\u1ebf, Kho\u1ea3ng tr\u1eafng trong Excel c\u00f3 th\u1ec3 khi\u1ebfn vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n tr\u1edf n\u00ean ph\u1ee9c t\u1ea1p, l\u00e0m cho trang t\u00ednh c\u1ee7a b\u1ea1n m\u1ea5t th\u1ea9m m\u1ef9. Ch\u00ednh v\u00ec \u0111i\u1ec1u \u0111\u00f3, b\u1ea1n c\u1ea7n \u201cb\u1ecf t\u00fai\u201d ngay nh\u1eefng b\u00ed k\u00edp b\u1ecf d\u1ea5u c\u00e1ch trong Excel. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd chia s\u1ebb cho c\u00e1c b\u1ea1n nh\u1eefng c\u00e1ch l\u00e0m \u0111\u01a1n gi\u1ea3n, ai c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c.<\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 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\" style=\"cursor:inherit\">N\u1ed9i dung <\/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\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" 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><\/span><\/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:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#Cach_bo_dau_cham_trong_excel_sieu_don_gian\" >C\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong excel si\u00eau \u0111\u01a1n gi\u1ea3n<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#Dung_cong_cu_Find_and_Replace\" >D\u00f9ng c\u00f4ng c\u1ee5\u00a0 Find and Replace\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#Xoa_dau_cham_bang_ham_Substitute\" >X\u00f3a d\u1ea5u ch\u1ea5m b\u1eb1ng h\u00e0m Substitute<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#Cach_bo_dau_phay_truoc_so_trong_Excel\" >C\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 trong Excel\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#Su_dung_lenh_Paster_As_Values\" >S\u1eed d\u1ee5ng l\u1ec7nh Paster As Values<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#Xoa_dau_phay_truoc_so_bang_%E2%80%9CText_to_Columns%E2%80%9D\" >X\u00f3a d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 b\u1eb1ng \u201cText to Columns\u201d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#Loai_bo_dau_phay_trong_Excel_bang_VBA\" >Lo\u1ea1i b\u1ecf d\u1ea5u ph\u1ea9y trong Excel b\u1eb1ng VBA<\/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:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#Ham_bo_dau_cach_trong_Excel\" >H\u00e0m b\u1ecf d\u1ea5u c\u00e1ch trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#Loai_bo_khoang_trang_bang_ham_Trim\" >Lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng b\u1eb1ng h\u00e0m Trim<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#Su_dung_cua_so_Find_Replace\" >S\u1eed d\u1ee5ng c\u1eeda s\u1ed5 Find &amp; Replace<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_bo_dau_cham_trong_excel_sieu_don_gian\"><\/span><span style=\"color: #000000;\"><b> C\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong excel si\u00eau \u0111\u01a1n gi\u1ea3n<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">\u0110a ph\u1ea7n nh\u1eefng d\u00e3y s\u1ed1 trong Excel s\u1ebd c\u00f3 nh\u1eefng d\u1ea5u ch\u1ea5m ng\u0103n c\u00e1ch gi\u1eefa h\u00e0ng \u0111\u01a1n v\u1ecb, h\u00e0ng ch\u1ee5c, h\u00e0ng tr\u0103m \u0111\u1ec3 l\u00e0m gi\u1ea3m kh\u1ea3 n\u0103ng sai s\u00f3t khi nh\u1eadp li\u1ec7u. Tuy nhi\u00ean, trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p nh\u1eefng d\u1ea5u ch\u1ea5m n\u00e0y c\u0169ng g\u00e2y n\u00ean nhi\u1ec1u phi\u1ec1n to\u00e1i cho ng\u01b0\u1eddi d\u00f9ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Ch\u1eb3ng h\u1ea1n khi b\u1ea1n s\u1eed d\u1ee5ng d\u1eef li\u1ec7u s\u1ed1 \u0111\u1ec3 t\u00ednh to\u00e1n, b\u1ea1n c\u1ea7n x\u00f3a d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1 tr\u00ean Excel \u0111i \u0111\u1ec3 vi\u1ec7c t\u00ednh to\u00e1n ch\u00ednh x\u00e1c h\u01a1n. C\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong Excel v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n b\u1ea1n ch\u1ec9 c\u1ea7n l\u00e0m theo c\u00e1c c\u00e1ch sau<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dung_cong_cu_Find_and_Replace\"><\/span><strong><span style=\"color: #000000;\">D\u00f9ng c\u00f4ng c\u1ee5\u00a0 Find and Replace\u00a0<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">C\u00e1ch b\u1ecf d\u1ea5u ch\u1ea5m trong Excel b\u1eb1ng c\u00f4ng c\u1ee5 Find and Replace v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 1: B\u00f4i \u0111en v\u00f9ng c\u1ea7n x\u00f3a d\u1ea5u ch\u1ea5m trong d\u00e3y s\u1ed1.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 2: Trong b\u1ea3ng t\u00ednh Excel, m\u1edf c\u1eeda s\u1ed5 Find amp, Replace b\u1eb1ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl H. Nh\u1ea5n \u0111\u1ed3ng th\u1eddi c\u1ea3 hai ph\u00edm Ctrl v\u00e0 H.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_13332\" aria-describedby=\"caption-attachment-13332\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13332 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel-1.png\" alt=\"D\u00f9ng c\u00f4ng c\u1ee5\u00a0 Find and Replace\u00a0\" width=\"600\" height=\"214\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel-1-400x143.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13332\" class=\"wp-caption-text\">D\u00f9ng c\u00f4ng c\u1ee5\u00a0 Find and Replace<\/figcaption><\/figure>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 3: Trong c\u1eeda s\u1ed5 Find &amp; Replace, \u1edf m\u1ee5c Find What b\u1ea1n ti\u1ebfn h\u00e0nh nh\u1eadp d\u1ea5u ch\u1ea5m, \u0111\u1ec3 tr\u1ed1ng m\u1ee5c Replace with. Sau \u0111\u00f3 ti\u1ebfp t\u1ee5c nh\u1ea5n n\u00fat Replace All \u0111\u1ec3 x\u00f3a to\u00e0n b\u1ed9 d\u1ea5u ch\u1ea5m trong v\u00f9ng \u0111\u00e3 b\u00f4i \u0111en trong m\u1ed9t l\u1ea7n thao t\u00e1c. Ho\u1eb7c nh\u1ea5n Replace \u0111\u1ec3 x\u00f3a l\u1ea7n l\u01b0\u1ee3t t\u1eebng d\u1ea5u ch\u1ea5m.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Ch\u1ec9 v\u1edbi c\u00e1c b\u01b0\u1edbc tr\u00ean b\u1ea1n \u0111\u00e3 d\u1ec5 d\u00e0ng x\u00f3a \u0111\u01b0\u1ee3c d\u1ea5u ch\u1ea5m tr\u00ean b\u1ea3ng t\u00ednh Excel.<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00e1ch x\u00f3a kho\u1ea3ng tr\u1eafng c\u1ee9ng \u0111\u1ea7u trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/aBaHOxV5pqM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Xoa_dau_cham_bang_ham_Substitute\"><\/span><strong><span style=\"color: #000000;\">X\u00f3a d\u1ea5u ch\u1ea5m b\u1eb1ng h\u00e0m Substitute<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">H\u00e0m Substitute c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng x\u00f3a b\u1ecf d\u1ea5u ch\u1ea5m trong b\u1ea3ng t\u00ednh Excel. H\u00e0m Substitute th\u01b0\u1eddng c\u00f3 c\u1ea5u tr\u00fac nh\u01b0 sau: SUBSTITUTE (text, old_text, new_text, ). \u0110\u1ed1i v\u1edbi c\u00e1ch n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 1: T\u1ea1i \u00f4 c\u1ea7n ghi d\u00e3y s\u1ed1 b\u1ecf d\u1ea5u ch\u1ea5m nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 h\u00ecnh 1.2 b\u00ean d\u01b0\u1edbi.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 2: Sau khi nh\u1eadp xong c\u00f4ng th\u1ee9c nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u00e3y s\u1ed1 kh\u00f4ng c\u00f3 d\u1ea5u ch\u1ea5m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 3: \u0110\u1ec3 x\u00f3a ti\u1ebfp d\u00e3y s\u1ed1 \u1edf c\u00e1c \u00f4 b\u00ean d\u01b0\u1edbi b\u1ea1n th\u1ef1c hi\u1ec7n click chu\u1ed9t v\u00e0o \u00f4 k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean r\u1ed3i k\u00e9o xu\u1ed1ng.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_bo_dau_phay_truoc_so_trong_Excel\"><\/span><span style=\"color: #000000;\"><b> C\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 trong Excel\u00a0<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Su_dung_lenh_Paster_As_Values\"><\/span><strong><span style=\"color: #000000;\">S\u1eed d\u1ee5ng l\u1ec7nh Paster As Values<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 1: Trong b\u1ea3ng t\u00ednh Excel, b\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf d\u1ea5u ph\u1ea9y. Sau \u0111\u00f3 ti\u1ebfn h\u00e0nh sao ch\u00e9p b\u1eb1ng t\u1ed5 h\u1ee3p ph\u00edm \u201cCtrl+C\u201d\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 2: Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 d\u00e3y s\u1ed1 kh\u00f4ng c\u00f3 d\u1ea5u ph\u1ea9y, trong m\u1ee5c \u201cPaste Options\u201d \u1ea5n ch\u1ecdn \u201c123 Value\u201d. Nh\u01b0 v\u1eady, c\u00e1c d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00f3a m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 3: \u0110\u1ec3 ki\u1ec3m tra l\u1ea1i d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00f3a ch\u01b0a b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n chu\u1ed9t v\u00e0o \u00f4 d\u1eef li\u1ec7u ch\u1ee9a d\u00e3y s\u1ed1 \u0111\u00f3, xem tr\u01b0\u1edbc d\u00e3y s\u1ed1 c\u00f2n d\u1ea5u ph\u1ea9y kh\u00f4ng.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Xoa_dau_phay_truoc_so_bang_%E2%80%9CText_to_Columns%E2%80%9D\"><\/span><strong><span style=\"color: #000000;\">X\u00f3a d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 b\u1eb1ng \u201cText to Columns\u201d<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 1: M\u1edf file Excel, sau \u0111\u00f3 b\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n x\u00f3a d\u1ea5u ph\u1ea9y.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_13337\" aria-describedby=\"caption-attachment-13337\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13337 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel-2.jpg\" alt=\"C\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 trong Excel\u00a0\" width=\"600\" height=\"373\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel-2-400x249.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13337\" class=\"wp-caption-text\">C\u00e1ch b\u1ecf d\u1ea5u ph\u1ea9y tr\u01b0\u1edbc s\u1ed1 trong Excel<\/figcaption><\/figure>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 2: Tr\u00ean thanh c\u00f4ng c\u1ee5 ti\u1ebfn h\u00e0nh ch\u1ecdn Data. Sau \u0111\u00f3 ch\u1ecdn Text to Column.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 3: Trong b\u1ea3ng hi\u1ec3n th\u1ecb Convert Text to Columns Wizard, ti\u1ebfn h\u00e0nh t\u00edch v\u00e0o \u00f4 Delimited.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Sau khi ho\u00e0n th\u00e0nh c\u00e1c b\u01b0\u1edbc tr\u00ean, d\u1ea5u ph\u1ea9y \u0111\u00e3 \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf ho\u00e0n to\u00e0n.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Loai_bo_dau_phay_trong_Excel_bang_VBA\"><\/span><strong><span style=\"color: #000000;\">Lo\u1ea1i b\u1ecf d\u1ea5u ph\u1ea9y trong Excel b\u1eb1ng VBA<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 1: S\u1eed d\u1ee5ng ph\u00edm t\u1eaft \u201cAlt +F11\u201d \u0111\u1ec3 m\u1edf ch\u01b0\u01a1ng tr\u00ecnh VBA.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 2: Ti\u1ebfn h\u00e0nh ch\u1ecdn Insert, sau \u0111\u00f3 ti\u1ebfn h\u00e0nh ch\u1ecdn Module. Ti\u1ebfp t\u1ee5c ti\u1ebfn h\u00e0nh Copy \u0111o\u1ea1n code d\u01b0\u1edbi \u0111\u00e2y v\u00e0o Module Window.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Sub remove_Apostrophe()<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Dim rng As Range<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Dim WorkRng As Range<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">On Error Resume Next<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">xTitleId = \u201cHoc Excel Online\u201d<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Set WorkRng = Application.Selection<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Set WorkRng = Application.InputBox(\u201cRange\u201d, xTitleId, WorkRng.Address, Type:=8)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Set WorkRng = WorkRng.SpecialCells(xlCellTypeConstants, xlNumbers)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">For Each rng In WorkRng<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">If Not rng.HasFormula Then<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">rng.Formula = rng.Value<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">End If<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Next<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">End Sub<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 3: Ti\u1ebfn h\u00e0nh nh\u1ea5n F5 r\u1ed3i ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n b\u1ecf d\u1ea5u nh\u00e1y.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 4: Cu\u1ed1i c\u00f9ng nh\u1ea5n Ok l\u00e0 \u0111\u00e3 k\u1ebft th\u00fac qu\u00e1 tr\u00ecnh lo\u1ea1i b\u1ecf d\u1ea5u ph\u1ea9y b\u1eb1ng VBA.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_bo_dau_cach_trong_Excel\"><\/span><span style=\"color: #000000;\"><b> H\u00e0m b\u1ecf d\u1ea5u c\u00e1ch trong Excel<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Loai_bo_khoang_trang_bang_ham_Trim\"><\/span><strong><span style=\"color: #000000;\">Lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng b\u1eb1ng h\u00e0m Trim<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">H\u00e0m Trim l\u00e0 h\u00e0m chuy\u00ean d\u00f9ng trong Excel nh\u1eb1m m\u1ee5c \u0111\u00edch x\u00f3a nh\u1eefng kho\u1ea3ng tr\u1eafng d\u01b0 th\u1eeba trong b\u1ea3ng t\u00ednh. Ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n theo nh\u1eefng b\u01b0\u1edbc sau b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u00f9ng th\u00e0nh c\u00f4ng h\u00e0m Trim \u0111\u1ec3 b\u1ecf d\u1ea5u c\u00e1ch:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 1: Tr\u00ean trang t\u00ednh ch\u00e8n th\u00eam m\u1ed9t c\u1ed9t ph\u1ee5 v\u00e0o cu\u1ed1i b\u1ea3ng d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 2: Trong \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t ph\u1ee5 v\u1eeba ch\u00e8n, nh\u1eadp c\u00f4ng th\u1ee9c: =TRIM(\u00f4 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n x\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 3: Sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c \u00f4 t\u00ednh c\u00f2n l\u1ea1i trong c\u1ed9t \u0111\u1ec3 lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 d\u1ea5u c\u00e1ch.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">\u00a0B\u01b0\u1edbc 4: Tha\u0443 th\u1ebf \u1d04\u1ed9t g\u1ed1\u1d04 b\u1eb1ng \u1d04\u1ed9t ph\u1ee5. Ch\u1ecdn t\u1ea5t \u1d04\u1ea3 \u00f4 t\u00ednh trong \u1d04\u1ed9t ph\u1ee5, sau \u0111\u00f3 sao ch\u00e9p ch\u00fang v\u00e0o clipboard b\u1eb1ng c\u00e1ch nh\u1ea5n Ctrl + C. Ti\u1ebfp \u0111\u1ebfn, ch\u1ecdn \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean \u1d04\u1ee7a \u1d04\u1ed9t g\u1ed1\u1d04, nh\u1ea5n Shift + F10. Sau \u0111\u00f3 nh\u1ea5n ph\u00edm V.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 5: Cu\u1ed1i c\u00f9ng ch\u00fang ta ch\u1ec9 c\u1ea7n x\u00f3a c\u1ed9t ph\u1ee5 l\u00e0 ho\u00e0n th\u00e0nh qu\u00e1 tr\u00ecnh b\u1ecf d\u1ea5u c\u00e1ch trong Excel.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_13344\" aria-describedby=\"caption-attachment-13344\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13344 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel-3.jpg\" alt=\"H\u00e0m b\u1ecf d\u1ea5u c\u00e1ch trong Excel\" width=\"600\" height=\"337\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel-3-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13344\" class=\"wp-caption-text\">H\u00e0m b\u1ecf d\u1ea5u c\u00e1ch trong Excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Su_dung_cua_so_Find_Replace\"><\/span><strong><span style=\"color: #000000;\">S\u1eed d\u1ee5ng c\u1eeda s\u1ed5 Find &amp; Replace<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">C\u00e1ch n\u00e0y th\u1ef1c hi\u1ec7n \u0111\u01a1n gi\u1ea3n h\u01a1n nh\u01b0ng ch\u1ec9 x\u00f3a \u0111\u01b0\u1ee3c d\u1ea5u c\u00e1ch gi\u1eefa c\u00e1c t\u1eeb, kho\u1ea3ng tr\u1eafng \u0111\u1ea7u v\u00e0 cu\u1ed1i t\u1eeb v\u1eabn kh\u00f4ng \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 1: Ch\u1ecdn m\u1ed9t ho\u1eb7\u1d04 nhi\u1ec1u \u1d04\u1ed9t \u1d04h\u1ee9a d\u1eef li\u1ec7u \u1d04\u1ea7n \u0445\u00f3a d\u1ea5u \u1d04\u00e1\u1d04h sau \u0111\u00f3 b\u00f4i \u0111en v\u00f9ng \u0111\u00f3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 2: Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl F \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Find &amp; Replace.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 3: Nh\u1ea5n ph\u00edm \u1d04\u00e1\u1d04h hai l\u1ea7n trong \u00f4 Find What \u1d20\u00e0 m\u1ed9t l\u1ea7n trong \u00f4 Repla\u1d04e With.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">B\u01b0\u1edbc 4: Nh\u1ea5n n\u00fat Replace All, sau \u0111\u00f3 nh\u1ea5n Ok l\u00e0 b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh qu\u00e1 tr\u00ecnh b\u1ecf d\u1ea5u c\u00e1ch trong Excel.<\/span><\/li>\n<\/ul>\n<p><strong>XEM TH\u00caM:\u00a0<\/strong><\/p>\n<ul>\n<li><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/unhide-trong-excel\/\"><strong>C\u00e1ch th\u1ef1c hi\u1ec7n unhide trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/strong><\/a><\/span><\/li>\n<li><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/\"><strong>H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p<\/strong><\/a><\/span><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-find-trong-excel-don-gian-nhat\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m FIND trong Excel &#8211; T\u1eeb A \u0111\u1ebfn Z c\u00e1ch s\u1eed d\u1ee5ng \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-replace-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m replace trong excel\u00a0t\u1eeb A \u0111\u1ebfn Z<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-doi-dau-phay-thanh-dau-cham-trong-excel\/\" target=\"_blank\" rel=\"noopener\">3 C\u00e1ch \u0111\u1ed5i d\u1ea5u ph\u1ea9y th\u00e0nh d\u1ea5u ch\u1ea5m trong Excel ti\u1ec7n l\u1ee3i<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cai-dat-dau-cham-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e0i \u0111\u1eb7t d\u1ea5u ch\u1ea5m trong excel trong gi\u00e2y l\u00e1t v\u1edbi m\u1eb9o sau<\/a><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><span style=\"color: #000000;\">Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, d\u1ea5u c\u00e1ch s\u1ebd g\u00e2y b\u1ea5t ti\u1ec7n cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u0169ng l\u00e0m cho b\u1ea3ng t\u00ednh tr\u1edf n\u00ean m\u1ea5t th\u1ea9m m\u1ef9 v\u00e0 thi\u1ebfu chuy\u00ean nghi\u1ec7p h\u01a1n. Ch\u00ednh v\u00ec th\u1ebf, m\u1ed7i sinh vi\u00ean hay nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng \u0111\u1ec1u ph\u1ea3i bi\u1ebft c\u00e1ch lo\u1ea1i b\u1ecf d\u1ea5u c\u00e1ch trong Excel. Hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y, vi\u1ec7c lo\u1ea1i b\u1ecf d\u1ea5u c\u00e1ch trong Excel s\u1ebd tr\u1edf n\u00ean d\u1ec5 d\u00e0ng cho m\u1ed7i c\u00e1 nh\u00e2n.<\/span> <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ecf d\u1ea5u c\u00e1ch trong Excel ra sao? Tr\u00ean th\u1ef1c t\u1ebf, Kho\u1ea3ng tr\u1eafng trong Excel c\u00f3 th\u1ec3 khi\u1ebfn vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n tr\u1edf n\u00ean ph\u1ee9c t\u1ea1p, l\u00e0m cho trang t\u00ednh c\u1ee7a b\u1ea1n m\u1ea5t th\u1ea9m m\u1ef9. Ch\u00ednh v\u00ec \u0111i\u1ec1u \u0111\u00f3, b\u1ea1n c\u1ea7n \u201cb\u1ecf t\u00fai\u201d ngay nh\u1eefng b\u00ed k\u00edp b\u1ecf d\u1ea5u c\u00e1ch trong Excel. B\u00e0i &hellip;<\/p>\n","protected":false},"author":3,"featured_media":13331,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-13329","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh<\/title>\n<meta name=\"description\" content=\"B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh v\u1edbi c\u00e1c thao t\u00e1c \u0111\u01a1n gi\u1ea3n. Theo d\u00f5i ngay trong b\u00e0i vi\u1ebft sau nh\u00e9!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh\" \/>\n<meta property=\"og:description\" content=\"B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh v\u1edbi c\u00e1c thao t\u00e1c \u0111\u01a1n gi\u1ea3n. Theo d\u00f5i ngay trong b\u00e0i vi\u1ebft sau nh\u00e9!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-30T15:17:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-07T09:59:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"337\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch b\u1ecf d\u1ea5u c\u00e1ch trong Excel ph\u01b0\u01a1ng ph\u00e1p si\u00eau nhanh\",\"datePublished\":\"2022-11-30T15:17:41+00:00\",\"dateModified\":\"2022-12-07T09:59:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/\"},\"wordCount\":2106,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel.png\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/\",\"name\":\"B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel.png\",\"datePublished\":\"2022-11-30T15:17:41+00:00\",\"dateModified\":\"2022-12-07T09:59:25+00:00\",\"description\":\"B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh v\u1edbi c\u00e1c thao t\u00e1c \u0111\u01a1n gi\u1ea3n. Theo d\u00f5i ngay trong b\u00e0i vi\u1ebft sau nh\u00e9!\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel.png\",\"width\":600,\"height\":337,\"caption\":\"B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch b\u1ecf d\u1ea5u c\u00e1ch trong Excel ph\u01b0\u01a1ng ph\u00e1p si\u00eau nhanh\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh","description":"B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh v\u1edbi c\u00e1c thao t\u00e1c \u0111\u01a1n gi\u1ea3n. Theo d\u00f5i ngay trong b\u00e0i vi\u1ebft sau nh\u00e9!","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:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh","og_description":"B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh v\u1edbi c\u00e1c thao t\u00e1c \u0111\u01a1n gi\u1ea3n. Theo d\u00f5i ngay trong b\u00e0i vi\u1ebft sau nh\u00e9!","og_url":"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-30T15:17:41+00:00","article_modified_time":"2022-12-07T09:59:25+00:00","og_image":[{"width":600,"height":337,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel.png","type":"image\/png"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"6 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch b\u1ecf d\u1ea5u c\u00e1ch trong Excel ph\u01b0\u01a1ng ph\u00e1p si\u00eau nhanh","datePublished":"2022-11-30T15:17:41+00:00","dateModified":"2022-12-07T09:59:25+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/"},"wordCount":2106,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel.png","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/","name":"B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel.png","datePublished":"2022-11-30T15:17:41+00:00","dateModified":"2022-12-07T09:59:25+00:00","description":"B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh v\u1edbi c\u00e1c thao t\u00e1c \u0111\u01a1n gi\u1ea3n. Theo d\u00f5i ngay trong b\u00e0i vi\u1ebft sau nh\u00e9!","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Bo-dau-cach-trong-Excel.png","width":600,"height":337,"caption":"B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch b\u1ecf d\u1ea5u c\u00e1ch trong Excel ph\u01b0\u01a1ng ph\u00e1p si\u00eau nhanh"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=13329"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13329\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/13331"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=13329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=13329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=13329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}