{"id":11679,"date":"2022-11-20T16:14:30","date_gmt":"2022-11-20T09:14:30","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11679"},"modified":"2025-04-15T10:53:02","modified_gmt":"2025-04-15T03:53:02","slug":"ham-xoa-ky-tu-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/","title":{"rendered":"H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o"},"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;11679&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;6&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 - (6 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o&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 - (6 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng excel, \u0111\u1eb7c bi\u1ec7t m\u1ed9t trong s\u1ed1 tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng <\/span><b>h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel<\/b><span style=\"font-weight: 400;\">. \u0110\u1ed1i v\u1edbi m\u1ed9t s\u1ed1 ng\u01b0\u1eddi, c\u00f4ng vi\u1ec7c n\u00e0y kh\u00e1 kh\u00f3 kh\u0103n khi h\u1ecd ch\u01b0a c\u00f3 trong tay nh\u1eefng thao t\u00e1c \u0111\u1ec3 x\u00f3a k\u00fd t\u1ef1. V\u1eady c\u1ee5 th\u1ec3 <\/span><b>h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 g\u00ec? H\u00e3y c\u00f9ng nhau t\u00ecm hi\u1ec3u trong ph\u1ea7n ph\u00e2n t\u00edch ng\u00e0y sau \u0111\u00e2y.\u00a0<\/span><\/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\/ham-xoa-ky-tu-trong-excel\/#Tim_hieu_ve_excel\" >T\u00ecm hi\u1ec3u v\u1ec1 excel\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#Cac_kieu_du_lieu_trong_excel\" >C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#Cong_thuc_ham_xoa_ky_tu_trong_chuoi_excel\" >C\u00f4ng th\u1ee9c h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong chu\u1ed7i excel\u00a0<\/a><\/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\/ham-xoa-ky-tu-trong-excel\/#Su_dung_to_hop_phim_xoa_ky_tu_trong_excel\" >S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm x\u00f3a k\u00fd t\u1ef1 trong excel\u00a0<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tim_hieu_ve_excel\"><\/span><b>T\u00ecm hi\u1ec3u v\u1ec1 excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 l\u1ebd excel \u0111\u00e3 tr\u1edf l\u00ean qu\u00e1 quen thu\u1ed9c v\u1edbi t\u1ea5t c\u1ea3 ch\u00fang ta. N\u00f3 ph\u1ee5c v\u1ee5 c\u00e1c c\u00f4ng vi\u1ec7c li\u00ean quan t\u1edbi vi\u1ec7c th\u1ed1ng k\u00ea, t\u00ednh to\u00e1n; nh\u1eefng vi\u1ec7c c\u00f3 li\u00ean quan tr\u1ef1c ti\u1ebfp v\u1edbi nh\u1eefng con s\u1ed1. V\u1eady c\u1ee5 th\u1ec3 excel l\u00e0 g\u00ec?\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Excel m\u1ed9t ph\u1ea7n m\u1ec1m b\u1ea3n t\u00ednh gi\u00fap ng\u01b0\u1eddi d\u00f9ng th\u1ed1ng k\u00ea d\u1eef li\u1ec7u; tr\u00ecnh b\u00e0y th\u00f4ng tin d\u01b0\u1edbi d\u1ea1ng c\u00e1c b\u1ea3ng, c\u00e1c c\u1ed9t. H\u1ed7 tr\u1ee3 cho qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n, x\u1eed l\u00fd th\u00f4ng tin nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c h\u01a1n \u0111\u1eb7c bi\u1ec7t v\u1edbi m\u1ed9t l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn. C\u00e1c c\u1ed9t, h\u00e0ng v\u00e0 b\u1ea3ng l\u00e0 \u0111\u1eb7c tr\u01b0ng ch\u00ednh khi nh\u1eafc t\u1edbi excel.\u00a0<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00e1ch t\u00e1ch k\u00fd t\u1ef1 trong Excel, c\u00e1ch l\u1ea5y k\u00fd t\u1ef1 \u1edf gi\u1eefa, tr\u00e1i, ph\u1ea3i trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/YjhViXs0FrU?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<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cac_kieu_du_lieu_trong_excel\"><\/span><b>C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_12316\" aria-describedby=\"caption-attachment-12316\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12316 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-1.jpg\" alt=\"C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong excel\" width=\"600\" height=\"437\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-1-400x291.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12316\" class=\"wp-caption-text\">C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi excel, b\u1ea1n c\u1ea7n t\u00ecm hi\u1ec3u r\u00f5 v\u1ec1 c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong excel. V\u1eady nh\u1eefng ki\u1ec3u d\u1eef li\u1ec7u trong excel bao g\u1ed3m nh\u1eefng lo\u1ea1i n\u00e0o. Ch\u00fang t\u00f4i s\u1ebd mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng th\u00f4ng tin c\u1ea7n thi\u1ebft sau \u0111\u00e2y:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Th\u1ee9 nh\u1ea5t l\u00e0 ki\u1ec3u d\u1eef li\u1ec7u chu\u1ed7i: Ki\u1ec3u d\u1eef li\u1ec7u n\u00e0y; bao g\u1ed3m c\u00e1c d\u1eef li\u1ec7u d\u01b0\u1edbi d\u1ea1ng c\u00e1c t\u1eeb trong b\u1ea3ng ch\u1eef c\u00e1i; bao g\u1ed3m c\u00e1c k\u00fd t\u1ef1 t\u1eeb A \u0111\u1ebfn Z. Ngo\u00e0i ra n\u00f3 c\u0169ng bao g\u1ed3m c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t ho\u1eb7c d\u00e3y s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 9; th\u1eadm ch\u00ed ch\u1ec9 c\u1ea7n 1 k\u00fd t\u1ef1 l\u00e0 \u0111\u1ee7.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Th\u1ee9 hai l\u00e0 ki\u1ec3u d\u1eef li\u1ec7u s\u1ed1: C\u00f3 l\u1ebd b\u1ea1n \u0111\u00e3 \u0111o\u00e1n ra h\u00ecnh th\u1ee9c c\u1ee7a ki\u1ec3u d\u1eef li\u1ec7u n\u00e0y ph\u1ea3i kh\u00f4ng. \u0110\u00fang v\u1eady, n\u00f3 bao g\u1ed3m c\u00e1c d\u1ea1ng d\u1eef li\u1ec7u t\u1eeb 0 \u0111\u1ebfn 9, c\u00e1c s\u1ed1 \u00e2m.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ti\u1ebfp theo l\u00e0 ki\u1ec3u d\u1eef li\u1ec7u th\u1eddi gian: T\u1ea1i ki\u1ec3u d\u1eef li\u1ec7u n\u00e0y, b\u1ea1n h\u00e3y nh\u1eadp v\u00e0o excel ng\u00e0y, th\u00e1ng, n\u0103m v\u00e0 t\u1ea5t nhi\u00ean kh\u00f4ng th\u1ec3 thi\u1ebfu \u0111\u00f3 l\u00e0 gi\u1edd, ph\u00fat v\u00e0 gi\u00e2y.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ki\u1ec3u d\u1eef li\u1ec7u c\u00f4ng th\u1ee9c: Nh\u1eafc \u0111\u1ebfn c\u00f4ng th\u1ee9c b\u1ea1n s\u1ebd ngh\u0129 \u0111\u1ebfn c\u00e1c c\u00f4ng th\u1ee9c to\u00e1n h\u1ecdc ph\u1ea3i kh\u00f4ng \u1ea1. \u0110\u00fang v\u1eady \u1edf ki\u1ec3u d\u1eef li\u1ec7u n\u00e0y b\u1ea1n c\u1ea7n c\u00e1c c\u00f4ng th\u1ee9c to\u00e1n h\u1ecdc ho\u1eb7c c\u00e1c d\u1ea5u s\u1eed d\u1ee5ng trong to\u00e1n nh\u01b0 l\u1edbn, nh\u1ecf, b\u1eb1ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00e0 cu\u1ed1i c\u00f9ng l\u00e0 ki\u1ec3u d\u1eef li\u1ec7u Boolean: \u0110\u00e2y c\u00f3 th\u1ec3 l\u00e0 ki\u1ec3u d\u1eef li\u1ec7u \u00edt ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn nh\u1ea5t. Ki\u1ec3u d\u1eef li\u1ec7u n\u00e0y c\u00f3 d\u1ea1ng true\/false.<a href=\"http:\/\/hoclaptrinhmienphi.teky.vn\/1hhoclaptrinh\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24877\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Banner-Free-Trial.png\" alt=\"H\u1ecdc th\u1eed mi\u1ec5n ph\u00ed\" width=\"600\" height=\"314\" \/><\/a><\/span><\/li>\n<\/ul>\n<p>Xem th\u00eam b\u00e0i vi\u1ebft:<\/p>\n<p><a href=\"https:\/\/teky.edu.vn\/blog\/cach-gach-cheo-o-trong-excel\/\">C\u00e1ch g\u1ea1ch ch\u00e9o \u00f4 trong excel nhanh nh\u1ea5t v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/p>\n<p><a href=\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/\">C\u00e1ch s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng?<\/a><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_xoa_ky_tu_trong_chuoi_excel\"><\/span><b>C\u00f4ng th\u1ee9c h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong chu\u1ed7i excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_12320\" aria-describedby=\"caption-attachment-12320\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12320 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-5.jpg\" alt=\"C\u00f4ng th\u1ee9c h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong chu\u1ed7i excel\u00a0\" width=\"600\" height=\"191\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-5-400x127.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12320\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong chu\u1ed7i excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi l\u00e0m vi\u1ec7c v\u1edbi excel, ch\u1eafc ch\u1eafn s\u1ebd c\u00f3 t\u00ecnh hu\u1ed1ng b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng <\/span><b>h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel. <\/b><span style=\"font-weight: 400;\">V\u1eady c\u1ee5 th\u1ec3 vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u00f3 nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng nhau t\u00ecm hi\u1ec3u ngay sau \u0111\u00e2y.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c k\u00fd t\u1ef1 trong excel b\u1ea1n h\u00e3y l\u00e0m vi\u1ec7c v\u1edbi h\u00e0m left v\u00e0 right. C\u1ee5 th\u1ec3 \u0111\u1ec3 lo\u1ea1i b\u1ecf k\u00fd t\u1ef1 \u0111\u1ea7u th\u00ec b\u1ea1n h\u00e3y l\u00e0m theo nh\u1eefng b\u01b0\u1edbc sau \u0111\u00e2y:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: B\u1ea1n h\u00e3y g\u00f5 c\u00f4ng th\u1ee9c <\/span><b>=RIGHT(A1,LEN(A1)-5) <\/b><span style=\"font-weight: 400;\">v\u00e0o l\u00e0 \u00f4 c\u00f3 k\u00fd hi\u1ec7u l\u00e0 <\/span><b>B1.\u00a0<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: H\u00e3y nh\u1ea5n Enter \u0111\u1ec3 b\u1eaft \u0111\u1ea7u ch\u1ea1y c\u00f4ng th\u1ee9c v\u00e0 sau \u0111\u00f3 h\u00e3y \u0111i\u1ec1n c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 ph\u00eda d\u01b0\u1edbi; t\u01b0\u01a1ng \u1ee9ng theo y\u00eau c\u1ea7u c\u1ee7a b\u1ea1n. Nh\u01b0 v\u1eady b\u1ea1n \u0111\u00e3 x\u00f3a b\u1ecf \u0111\u01b0\u1ee3c 5 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean trong chu\u1ed7i c\u00e1c k\u00fd t\u1ef1.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u00e2y ch\u00ednh l\u00e0<\/span><b> h\u00e0m x\u00f3a k\u00fd t\u1ef1 b\u00ean ph\u1ea3i trong excel;<\/b><span style=\"font-weight: 400;\"> v\u1edbi c\u00f4ng th\u1ee9c n\u00e0y b\u1ea1n \u0111\u00e3 tr\u1ea3 l\u1ea1i chu\u1ed7i k\u00fd t\u1ef1 ph\u00eda b\u00ean ph\u1ea3i tr\u1eeb \u0111i 5 k\u00fd t\u1ef1. N\u1ebfu mu\u1ed1n x\u00f3a nhi\u1ec1u k\u00fd t\u1ef1 h\u01a1n, b\u1ea1n h\u00e3y thay s\u1ed1 5 trong c\u00f4ng th\u1ee9c b\u1eb1ng k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n x\u00f3a. L\u00e0m t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m right; khi b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m left s\u1ebd gi\u00fap b\u1ea1n x\u00f3a b\u1ecf c\u00e1c k\u00fd t\u1ef1 \u1edf cu\u1ed1i c\u1ee7a chu\u1ed7i c\u00e1c k\u00fd t\u1ef1.\u00a0<\/span><\/p>\n<figure id=\"attachment_12318\" aria-describedby=\"caption-attachment-12318\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12318 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-3.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m right trong x\u00f3a k\u00fd t\u1ef1\" width=\"600\" height=\"214\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-3-400x143.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12318\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m right trong x\u00f3a k\u00fd t\u1ef1 excel<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Su_dung_to_hop_phim_xoa_ky_tu_trong_excel\"><\/span><b>S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm x\u00f3a k\u00fd t\u1ef1 trong excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 x\u00f3a k\u00fd t\u1ef1 trong chu\u1ed7i excel; ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng <\/span><b>h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel <\/b><span style=\"font-weight: 400;\">b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf. C\u1ee5 th\u1ec3 t\u00ednh n\u0103ng Find and replace s\u1ebd h\u1ed7 trong b\u1ea1n trong vi\u1ec7c lo\u1ea1i b\u1ecf k\u00fd t\u1ef1 trong chu\u1ed7i excel. V\u1edbi c\u00e1c b\u01b0\u1edbc c\u00e1c b\u1ea3n sau \u0111\u00e2y:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc m\u1ed9t: Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl+F v\u1edbi m\u1ee5c \u0111\u00edch \u0111\u1ec3 m\u1edf <a href=\"https:\/\/vi.wikipedia.org\/wiki\/H%E1%BB%99p_tho%E1%BA%A1i\">h\u1ed9p tho\u1ea1i<\/a><\/span><span style=\"font-weight: 400;\">\u00a0<\/span><b>Find and Replace<\/b><span style=\"font-weight: 400;\">; v\u00e0 sau \u0111\u00f3 h\u00e3y nh\u1ea5n <\/span><b>Replace<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u1ea1i b\u01b0\u1edbc n\u00e0y b\u1ea1n c\u1ea7n nh\u1eadp * v\u00e0o \u00f4 <\/span><b>Find what<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: B\u1ea1n h\u00e3y nh\u1ea5n chu\u1ed9t tr\u00e1i v\u00e0o <\/span><b>Replace all<\/b><span style=\"font-weight: 400;\"> v\u00e0 th\u1eadm ch\u00ed l\u00e0 t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 \u1edf cu\u1ed1i d\u1ea5u hai ch\u1ea5m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: \u0110\u1ec3 x\u00f3a t\u1ea5t c\u1ea3 k\u00fd t\u1ef1 \u1edf cu\u1ed1i d\u1ea5u hai ch\u1ea5m. B\u1ea1n h\u00e3y nh\u1eadp<\/span><b> *:<\/b><span style=\"font-weight: 400;\">\u00a0 v\u00e0o \u00f4 find what, \u0111\u1ed3ng th\u1eddi b\u1ecf tr\u1ed1ng \u00f4 <\/span><b>replace with<\/b><span style=\"font-weight: 400;\"> nh\u00e9.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc cu\u1ed1i: B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n <\/span><b>replace all <\/b><span style=\"font-weight: 400;\">th\u00ec t\u1ea5t c\u1ea3 c\u00e1c k\u00fd t\u1ef1 \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00f3a b\u1ecf, th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng \u1ea1.\u00a0<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12317\" aria-describedby=\"caption-attachment-12317\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12317 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-2.jpg\" alt=\"S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl+F\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-2-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12317\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl+F<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y, vi\u1ec7c x\u00f3a s\u1ed1 trang trong excel c\u1ef1c d\u1ec5 ph\u1ea3i kh\u00f4ng \u1ea1. Ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n, b\u1ea1n \u0111\u00e3 bi\u1ebft v\u1ec1<\/span><b> h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong chu\u1ed7i excel<\/b><span style=\"font-weight: 400;\">. B\u1ea1n c\u0169ng kh\u00f4ng c\u1ea7n ph\u1ea3i m\u1ea5t th\u1eddi gian qu\u00e1 l\u00e2u \u0111\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eefng thao t\u00e1c tr\u00ean. Th\u1eadt ti\u1ec7n \u00edch ph\u1ea3i kh\u00f4ng \u1ea1. <a href=\"https:\/\/khuyenmai.teky.vn\/tangsachlaptrinh\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24876\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Free-Asset.png\" alt=\"T\u1eb7ng s\u00e1ch mi\u1ec5n ph\u00ed\" width=\"600\" height=\"314\" \/><\/a><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u00e0i ph\u00e2n t\u00edch tr\u00ean ch\u00fang t\u00f4i \u0111\u00e3 mang t\u1edbi nh\u1eefng th\u00f4ng tin <\/span><b>h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel<\/b><span style=\"font-weight: 400;\">. Hy v\u1ecdng b\u00e0i bi\u1ebft cung c\u1ea5p cho b\u1ea1n nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n thi\u1ebft h\u1ed7 tr\u1ee3 trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c c\u1ee7a m\u00ecnh v\u1ec1 <\/span><b>h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel.<\/b><span style=\"font-weight: 400;\"> N\u1ebfu c\u00e1c b\u1ea1n c\u00f2n th\u1eafc m\u1eafc v\u1ea5n \u0111\u1ec1 g\u00ec, h\u00e3y li\u00ean h\u1ec7 ngay cho Teky.edu.vn \u0111\u1ec3 \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn v\u00e0 gi\u1ea3i \u0111\u00e1p m\u1ed9t c\u00e1ch nhanh nh\u1ea5t b\u1ea1n nh\u00e9.\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Khi s\u1eed d\u1ee5ng excel, \u0111\u1eb7c bi\u1ec7t m\u1ed9t trong s\u1ed1 tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel. \u0110\u1ed1i v\u1edbi m\u1ed9t s\u1ed1 ng\u01b0\u1eddi, c\u00f4ng vi\u1ec7c n\u00e0y kh\u00e1 kh\u00f3 kh\u0103n khi h\u1ecd ch\u01b0a c\u00f3 trong tay nh\u1eefng thao t\u00e1c \u0111\u1ec3 x\u00f3a k\u00fd t\u1ef1. V\u1eady c\u1ee5 th\u1ec3 h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12319,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11679","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>H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o?<\/title>\n<meta name=\"description\" content=\"\u0110\u1ec3 x\u00f3a k\u00fd t\u1ef1 trong chu\u1ed7i excel; ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel \u00a0b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf.\" \/>\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\/ham-xoa-ky-tu-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o?\" \/>\n<meta property=\"og:description\" content=\"\u0110\u1ec3 x\u00f3a k\u00fd t\u1ef1 trong chu\u1ed7i excel; ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel \u00a0b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-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-20T09:14:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-15T03:53:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-4.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"272\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"7 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\/ham-xoa-ky-tu-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o\",\"datePublished\":\"2022-11-20T09:14:30+00:00\",\"dateModified\":\"2025-04-15T03:53:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/\"},\"wordCount\":1579,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-4.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/\",\"name\":\"H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o?\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-4.jpg\",\"datePublished\":\"2022-11-20T09:14:30+00:00\",\"dateModified\":\"2025-04-15T03:53:02+00:00\",\"description\":\"\u0110\u1ec3 x\u00f3a k\u00fd t\u1ef1 trong chu\u1ed7i excel; ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel \u00a0b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-4.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-4.jpg\",\"width\":600,\"height\":272,\"caption\":\"H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o?\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-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\":\"H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o\"}]},{\"@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":"H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o?","description":"\u0110\u1ec3 x\u00f3a k\u00fd t\u1ef1 trong chu\u1ed7i excel; ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel \u00a0b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf.","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\/ham-xoa-ky-tu-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o?","og_description":"\u0110\u1ec3 x\u00f3a k\u00fd t\u1ef1 trong chu\u1ed7i excel; ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel \u00a0b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf.","og_url":"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-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-20T09:14:30+00:00","article_modified_time":"2025-04-15T03:53:02+00:00","og_image":[{"width":600,"height":272,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-4.jpg","type":"image\/jpeg"}],"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":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o","datePublished":"2022-11-20T09:14:30+00:00","dateModified":"2025-04-15T03:53:02+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/"},"wordCount":1579,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-4.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/","name":"H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o?","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-4.jpg","datePublished":"2022-11-20T09:14:30+00:00","dateModified":"2025-04-15T03:53:02+00:00","description":"\u0110\u1ec3 x\u00f3a k\u00fd t\u1ef1 trong chu\u1ed7i excel; ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel \u00a0b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-4.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-xoa-ky-tu-trong-excel-4.jpg","width":600,"height":272,"caption":"H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o?"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-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":"H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o"}]},{"@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\/11679","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=11679"}],"version-history":[{"count":1,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11679\/revisions"}],"predecessor-version":[{"id":24908,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11679\/revisions\/24908"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12319"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}