{"id":4812,"date":"2025-11-17T13:40:34","date_gmt":"2025-11-17T06:40:34","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-bo-dau-tieng-viet-trong-file-excel-cuc-don-gian-de-hieu\/"},"modified":"2025-11-17T13:40:34","modified_gmt":"2025-11-17T06:40:34","slug":"cach-bo-dau-tieng-viet-trong-file-excel-cuc-don-gian-de-hieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-bo-dau-tieng-viet-trong-file-excel-cuc-don-gian-de-hieu\/","title":{"rendered":"C\u00e1ch b\u1ecf d\u1ea5u ti\u1ebfng Vi\u1ec7t trong file Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u"},"content":{"rendered":"<div class=\"content_article\" id=\"clicklinka\">\n<div id=\"bxindexknh\">\u00a0<\/div>\n<p>Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u ti\u1ebfng Vi\u1ec7t, \u0111\u1eb7c bi\u1ec7t l\u00e0 h\u1ecd t\u00ean ho\u1eb7c danh s\u00e1ch d\u00e0i, vi\u1ec7c chuy\u1ec3n v\u0103n b\u1ea3n c\u00f3 d\u1ea5u sang kh\u00f4ng d\u1ea5u gi\u00fap l\u1ecdc v\u00e0 x\u1eed l\u00fd nhanh h\u01a1n. B\u00e0i vi\u1ebft n\u00e0y t\u1ed5ng h\u1ee3p c\u00e1c c\u00e1ch b\u1ecf d\u1ea5u trong Excel v\u00e0 Google Sheet b\u1eb1ng Unikey, EVKey, VBA c\u0169ng nh\u01b0 c\u00f4ng th\u1ee9c t\u1ef1 \u0111\u1ed9ng \u0111\u1ec3 b\u1ea1n \u00e1p d\u1ee5ng linh ho\u1ea1t t\u00f9y nhu c\u1ea7u.<\/p>\n<p><em><img decoding=\"async\" alt=\"C\u00e1ch b\u1ecf d\u1ea5u ti\u1ebfng Vi\u1ec7t trong file Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel\">C\u00e1ch b\u1ecf d\u1ea5u ti\u1ebfng Vi\u1ec7t trong file Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/em><\/p>\n<div class=\"titletab\" id=\"titletab1\">\n<h2>1. S\u1eed d\u1ee5ng Unikey<\/h2>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Tr\u01b0\u1edbc khi chuy\u1ec3n m\u00e3, h\u00e3y ki\u1ec3m tra ki\u1ec3u font \u0111ang d\u00f9ng trong file Excel \u0111\u1ec3 ch\u1ecdn \u0111\u00fang b\u1ea3ng m\u00e3 t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<ul>\n<li><strong>Nh\u00f3m Unicode:<\/strong> Times New Roman, Calibri, Arial\u2026<\/li>\n<li><strong>Nh\u00f3m TCVN3 (ABC):<\/strong> c\u00e1c font c\u00f3 ti\u1ec1n t\u1ed1 .Vn nh\u01b0 .VnTimeH, .VnTimes\u2026<\/li>\n<li><strong>Nh\u00f3m VNI Windows:<\/strong> t\u00ean font b\u1eaft \u0111\u1ea7u b\u1eb1ng VNI, v\u00ed d\u1ee5 VNI-Times\u2026<\/li>\n<\/ul>\n<p>\u1ede v\u00ed d\u1ee5 n\u00e0y, b\u1ea3ng t\u00ednh s\u1eed d\u1ee5ng font Calibri n\u00ean thu\u1ed9c h\u1ec7 <strong>Unicode<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u mu\u1ed1n b\u1ecf d\u1ea5u v\u00e0 sao ch\u00e9p b\u1eb1ng <strong>Ctrl + C<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong>Unikey <\/strong>tr\u00ean thanh taskbar v\u00e0 ch\u1ecdn <strong>C\u00f4ng c\u1ee5\u2026 (Ctrl+Shift+F6)<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i chuy\u1ec3n m\u00e3.<\/p>\n<p><em><img decoding=\"async\" alt=\"Ki\u1ec3m tra font ch\u1eef v\u00e0 sao ch\u00e9p d\u1eef li\u1ec7u\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-1.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-1\">Ki\u1ec3m tra font ch\u1eef v\u00e0 sao ch\u00e9p d\u1eef li\u1ec7u khi b\u1ecf d\u1ea5u b\u1eb1ng Unikey<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Khi c\u1eeda s\u1ed5 Unikey Toolkit xu\u1ea5t hi\u1ec7n, h\u00e3y ch\u1ecdn \u0111\u00fang <strong>Ngu\u1ed3n <\/strong>v\u00e0 <strong>\u0110\u00edch <\/strong>tr\u00f9ng v\u1edbi b\u1ea3ng m\u00e3 c\u1ee7a font \u0111ang d\u00f9ng. \u0110\u00e1nh d\u1ea5u v\u00e0o m\u1ee5c <strong>Lo\u1ea1i b\u1ecf d\u1ea5u<\/strong>, sau \u0111\u00f3 b\u1ea5m <strong>Chuy\u1ec3n m\u00e3<\/strong>.<\/p>\n<p><em><img decoding=\"async\" alt=\"Ch\u1ecdn Lo\u1ea1i b\u1ecf d\u1ea5u trong Unikey Toolkit\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-2.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-2\">Thi\u1ebft l\u1eadp b\u1ea3ng m\u00e3 v\u00e0 ch\u1ecdn Lo\u1ea1i b\u1ecf d\u1ea5u trong Unikey Toolkit<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 5: <\/strong>Unikey s\u1ebd th\u00f4ng b\u00e1o qu\u00e1 tr\u00ecnh x\u1eed l\u00fd \u0111\u00e3 ho\u00e0n t\u1ea5t. Nh\u1ea5n <strong>OK <\/strong>\u0111\u1ec3 \u0111\u00f3ng th\u00f4ng b\u00e1o.<\/p>\n<p><strong>B\u01b0\u1edbc 6:<\/strong> Quay l\u1ea1i Excel, d\u00e1n ph\u1ea7n n\u1ed9i dung \u0111\u00e3 chuy\u1ec3n \u0111\u1ed5i b\u1eb1ng <strong>Ctrl + V<\/strong> v\u00e0o v\u00f9ng tr\u1ed1ng ho\u1eb7c ghi \u0111\u00e8 l\u00ean d\u1eef li\u1ec7u ban \u0111\u1ea7u. V\u0103n b\u1ea3n kh\u00f4ng d\u1ea5u s\u1ebd hi\u1ec3n th\u1ecb ngay l\u1eadp t\u1ee9c.<\/p>\n<p><em><img decoding=\"async\" alt=\"D\u00e1n n\u1ed9i dung \u0111\u00e3 chuy\u1ec3n m\u00e3 v\u00e0o Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-3.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-3\">D\u00e1n n\u1ed9i dung \u0111\u00e3 chuy\u1ec3n m\u00e3 v\u00e0o Excel \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3 kh\u00f4ng d\u1ea5u<\/em><\/p>\n<div class=\"infobox\"><strong>Xem th\u00eam: <\/strong>C\u00e1c thao t\u00e1c c\u01a1 b\u1ea3n trong Excel \u0111\u01a1n gi\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi<\/div>\n<div class=\"titletab\" id=\"titletab2\">\n<h2>2. S\u1eed d\u1ee5ng VBA trong Excel<\/h2>\n<\/div>\n<p>Excel kh\u00f4ng t\u00edch h\u1ee3p s\u1eb5n h\u00e0m chuy\u1ec3n ti\u1ebfng Vi\u1ec7t c\u00f3 d\u1ea5u sang kh\u00f4ng d\u1ea5u, n\u00ean b\u1ea1n c\u1ea7n t\u1ea1o m\u1ed9t h\u00e0m t\u00f9y ch\u1ec9nh b\u1eb1ng VBA. Khi th\u00eam m\u00e3 v\u00e0o VBA, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m n\u00e0y nh\u01b0 b\u1ea5t k\u1ef3 h\u00e0m Excel n\u00e0o kh\u00e1c \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf b\u1ea3ng t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n x\u1eed l\u00fd. Nh\u1ea5n <strong>Alt + F11<\/strong> \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 l\u1eadp tr\u00ecnh VBA, sau \u0111\u00f3 ch\u1ecdn <strong>Insert <\/strong>v\u00e0 ti\u1ebfp t\u1ee5c ch\u1ecdn <strong>Module <\/strong>\u0111\u1ec3 t\u1ea1o m\u1ed9t module m\u1edbi.<\/p>\n<p><em>M\u1edf c\u1eeda s\u1ed5 VBA v\u00e0 t\u1ea1o Module m\u1edbi trong Excel<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Sao ch\u00e9p \u0111o\u1ea1n m\u00e3 VBA d\u01b0\u1edbi \u0111\u00e2y v\u00e0 d\u00e1n v\u00e0o module v\u1eeba t\u1ea1o b\u1eb1ng t\u1ed5 h\u1ee3p Ctrl + V:<\/p>\n<p><strong>C\u00e2u l\u1ec7nh b\u1eb1ng Ti\u1ebfng Vi\u1ec7t<\/strong><\/p>\n<div class=\"prompt-container\">\n<div class=\"prompt-header\"><span class=\"prompt-title\">Prompt<\/span><\/p>\n<div class=\"tooltip-wrapper\" data-tooltip=\"Sao ch\u00e9p m\u00e3\">\n<div class=\"copy-button\" data-copy-target=\"#prompt-block-1\" role=\"button\">\u00a0<\/div>\n<\/div>\n<\/div>\n<div class=\"prompt-text\">\n<pre id=\"prompt-block-1\">Function ConvertToUnSign(ByVal s As String) As String Dim i As Long, code As Long Dim ch As String, out As String If LenB(s) = 0 Then ConvertToUnSign = \"\": Exit Function For i = 1 To Len(s) ch = Mid$(s, i, 1) code = AscW(ch) Select Case code Case 273: out = out &amp; \"d\" Case 272: out = out &amp; \"D\" Case 224,225,226,227,259,7841,7843,7845,7847,7849,7851,7853,7855,7857,7859,7861,7863: out = out &amp; \"a\" Case 192,193,194,195,258,7840,7842,7844,7846,7848,7850,7852,7854,7856,7858,7860,7862: out = out &amp; \"A\" Case 232,233,234,7865,7867,7869,7871,7873,7875,7877,7879: out = out &amp; \"e\" Case 200,201,202,7864,7866,7868,7870,7872,7874,7876,7878: out = out &amp; \"E\" Case 236,237,297,7881,7883: out = out &amp; \"i\" Case 204,205,296,7880,7882: out = out &amp; \"I\" Case 242,243,244,245,417,7885,7887,7889,7891,7893,7895,7897,7899,7901,7903,7905,7907: out = out &amp; \"o\" Case 210,211,212,213,416,7884,7886,7888,7890,7892,7894,7896,7898,7900,7902,7904,7906: out = out &amp; \"O\" Case 249,250,361,432,7909,7911,7913,7915,7917,7919,7921: out = out &amp; \"u\" Case 217,218,360,431,7908,7910,7912,7914,7916,7918,7920: out = out &amp; \"U\" Case 253,7923,7925,7927,7929: out = out &amp; \"y\" Case 221,7922,7924,7926,7928: out = out &amp; \"Y\" Case Else: out = out &amp; ch End Select Next i ConvertToUnSign = out\nEnd Function<\/pre>\n<\/div>\n<\/div>\n<p>\u00a0 \u00a0 ConvertToUnSign = out<br \/>End Function<\/p>\n<p><em><img decoding=\"async\" alt=\"D\u00e1n m\u00e3 VBA v\u00e0o Module\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-5.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-5\">D\u00e1n m\u00e3 VBA v\u00e0o Module \u0111\u1ec3 t\u1ea1o h\u00e0m ConvertToUnSign<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Tr\u1edf l\u1ea1i Excel v\u00e0 v\u00e0o File \u2192 Options. Khi c\u1eeda s\u1ed5 Excel Options hi\u1ec7n ra, ch\u1ecdn Trust Center, r\u1ed3i nh\u1ea5n Trust Center Settings\u2026.<\/p>\n<p><em><img decoding=\"async\" alt=\"Truy c\u1eadp m\u1ee5c Trust Center\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-6.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-6\">M\u1edf Excel Options v\u00e0 truy c\u1eadp m\u1ee5c Trust Center<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Trong c\u1eeda s\u1ed5 Trust Center, m\u1edf m\u1ee5c <strong>Macro Settings<\/strong> v\u00e0 k\u00edch ho\u1ea1t hai t\u00f9y ch\u1ecdn:<\/p>\n<ul>\n<li><strong>Enable all macros<\/strong> (kh\u00f4ng \u0111\u01b0\u1ee3c khuy\u1ebfn kh\u00edch v\u00ec c\u00f3 th\u1ec3 ch\u1ea1y m\u00e3 \u0111\u1ed9c h\u1ea1i).<\/li>\n<li><strong>Trust access to the VBA project object model<\/strong>.<\/li>\n<\/ul>\n<p>Nh\u1ea5n <strong>OK <\/strong>\u0111\u1ec3 l\u01b0u thay \u0111\u1ed5i v\u00e0 \u0111\u00f3ng h\u1ed9p tho\u1ea1i.<\/p>\n<p><em><img decoding=\"async\" alt=\"B\u1eadt Macro Settings v\u00e0 c\u1ea5p quy\u1ec1n truy c\u1eadp\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-7.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-7\">B\u1eadt Macro Settings v\u00e0 c\u1ea5p quy\u1ec1n truy c\u1eadp VBA project object model<\/em><\/p>\n<p>Sau b\u01b0\u1edbc n\u00e0y, h\u00e0m VBA t\u00f9y ch\u1ec9nh \u0111\u00e3 s\u1eb5n s\u00e0ng \u0111\u1ec3 s\u1eed d\u1ee5ng trong Excel.<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> Quay l\u1ea1i b\u1ea3ng t\u00ednh. T\u1ea1i \u00f4 C2, nh\u1eadp c\u00f4ng th\u1ee9c: =ConvertToUnSign(B2)<\/p>\n<p><em><img decoding=\"async\" alt=\"S\u1eed d\u1ee5ng h\u00e0m ConvertToUnSign\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-8.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-8\">S\u1eed d\u1ee5ng h\u00e0m ConvertToUnSign \u0111\u1ec3 chuy\u1ec3n v\u0103n b\u1ea3n ti\u1ebfng Vi\u1ec7t th\u00e0nh kh\u00f4ng d\u1ea5u<\/em><\/p>\n<p>Excel s\u1ebd tr\u1ea3 v\u1ec1 phi\u00ean b\u1ea3n kh\u00f4ng d\u1ea5u c\u1ee7a gi\u00e1 tr\u1ecb trong \u00f4 B2. B\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i \u0111\u1ec3 x\u1eed l\u00fd to\u00e0n b\u1ed9 danh s\u00e1ch.<\/p>\n<p>Khi ho\u00e0n t\u1ea5t, b\u1ea1n s\u1ebd c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u ti\u1ebfng Vi\u1ec7t \u0111\u01b0\u1ee3c chuy\u1ec3n v\u1ec1 d\u1ea1ng kh\u00f4ng d\u1ea5u m\u1ed9t c\u00e1ch \u0111\u1ed3ng b\u1ed9.<\/p>\n<p><em><img decoding=\"async\" alt=\"K\u1ebft qu\u1ea3 sau khi \u00e1p d\u1ee5ng h\u00e0m ConvertToUnSign\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-9.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-9\">K\u1ebft qu\u1ea3 danh s\u00e1ch h\u1ecd t\u00ean \u0111\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n sang d\u1ea1ng kh\u00f4ng d\u1ea5u b\u1eb1ng VBA<\/em><\/p>\n<div class=\"titletab\" id=\"titletab3\">\n<h2>3. S\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m EVkey<\/h2>\n<\/div>\n<p>Ngo\u00e0i Unikey, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng EVKey \u0111\u1ec3 chuy\u1ec3n v\u0103n b\u1ea3n ti\u1ebfng Vi\u1ec7t v\u1ec1 d\u1ea1ng kh\u00f4ng d\u1ea5u trong Excel. Tr\u01b0\u1edbc h\u1ebft h\u00e3y t\u1ea3i ph\u1ea7n m\u1ec1m t\u1ea1i trang ch\u1ee7: <a href=\"https:\/\/evkeyvn.com\/\" target=\"_blank\" rel=\"noopener\">https:\/\/evkeyvn.com\/<\/a><\/p>\n<p>Khi c\u00e0i \u0111\u1eb7t xong, b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel v\u00e0 sao ch\u00e9p ph\u1ea7n n\u1ed9i dung c\u1ea7n x\u1eed l\u00fd b\u1eb1ng Ctrl + C.<\/p>\n<p><em><img decoding=\"async\" alt=\"Sao ch\u00e9p n\u1ed9i dung c\u1ea7n b\u1ecf d\u1ea5u\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-10.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-10\">Sao ch\u00e9p n\u1ed9i dung c\u1ea7n b\u1ecf d\u1ea5u trong Excel<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5p chu\u1ed9t v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng EVKey tr\u00ean thanh t\u00e1c v\u1ee5, sau \u0111\u00f3 ch\u1ecdn m\u1ee5c Chuy\u1ec3n m\u00e3 trong menu xu\u1ea5t hi\u1ec7n.<\/p>\n<p><em><img decoding=\"async\" alt=\"M\u1edf menu EVKey tr\u00ean thanh taskbar\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-11.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-11\">M\u1edf menu EVKey tr\u00ean thanh taskbar v\u00e0 ch\u1ecdn Chuy\u1ec3n m\u00e3<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong><\/p>\n<ul>\n<li>Trong c\u1eeda s\u1ed5 chuy\u1ec3n m\u00e3, \u0111\u00e1nh d\u1ea5u v\u00e0o t\u00f9y ch\u1ecdn Lo\u1ea1i b\u1ecf d\u1ea5u trong ph\u1ea7n L\u1ef1a ch\u1ecdn.<\/li>\n<li>T\u1ea1i m\u1ee5c \u201cChuy\u1ec3n m\u00e3 cho\u201d ch\u1ecdn Clipboard.\u00a0<\/li>\n<li>Cu\u1ed1i c\u00f9ng b\u1ea5m Chuy\u1ec3n m\u00e3 \u0111\u1ec3 EVKey x\u1eed l\u00fd n\u1ed9i dung \u0111\u00e3 sao ch\u00e9p.<\/li>\n<\/ul>\n<p><em><img decoding=\"async\" alt=\"Ch\u1ecdn Lo\u1ea1i b\u1ecf d\u1ea5u v\u00e0 ch\u1ecdn Clipboard trong c\u1eeda s\u1ed5\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-12.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-12\">Thi\u1ebft l\u1eadp Lo\u1ea1i b\u1ecf d\u1ea5u v\u00e0 ch\u1ecdn Clipboard trong c\u1eeda s\u1ed5 chuy\u1ec3n m\u00e3<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Khi ph\u1ea7n m\u1ec1m th\u00f4ng b\u00e1o chuy\u1ec3n m\u00e3 ho\u00e0n t\u1ea5t, nh\u1ea5n OK \u0111\u1ec3 \u0111\u00f3ng c\u1eeda s\u1ed5.<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> Tr\u1edf l\u1ea1i Excel v\u00e0 d\u00f9ng Ctrl + V \u0111\u1ec3 d\u00e1n v\u0103n b\u1ea3n \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1ecf d\u1ea5u v\u00e0o b\u1ea3ng t\u00ednh. D\u1eef li\u1ec7u kh\u00f4ng d\u1ea5u s\u1ebd xu\u1ea5t hi\u1ec7n \u0111\u00fang nh\u01b0 mong mu\u1ed1n.<\/p>\n<p><em><img decoding=\"async\" alt=\"D\u00e1n k\u1ebft qu\u1ea3 \u0111\u00e3 b\u1ecf d\u1ea5u tr\u1edf l\u1ea1i Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-13.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-13\">D\u00e1n k\u1ebft qu\u1ea3 \u0111\u00e3 b\u1ecf d\u1ea5u tr\u1edf l\u1ea1i Excel b\u1eb1ng Ctrl+V<\/em><\/p>\n<div class=\"titletab\" id=\"titletab4\">\n<h2>4. C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p<\/h2>\n<\/div>\n<div class=\"titletab\" id=\"titletab4_1\">\n<h3>4.1. Ngo\u00e0i VBA, c\u00f3 c\u00f4ng th\u1ee9c h\u00e0m b\u1ecf d\u1ea5u n\u00e0o kh\u00e1c kh\u00f4ng?<\/h3>\n<\/div>\n<p>Ngo\u00e0i gi\u1ea3i ph\u00e1p d\u00f9ng VBA, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1eed lo\u1ea1i b\u1ecf d\u1ea5u b\u1eb1ng c\u00e1c h\u00e0m SUBSTITUTE ho\u1eb7c REPLACE trong Excel. Tuy nhi\u00ean, hai h\u00e0m n\u00e0y kh\u00f4ng ph\u1ea3i l\u1ef1a ch\u1ecdn t\u1ed1i \u01b0u v\u00ec m\u1ed7i l\u1ea7n ch\u1ec9 x\u1eed l\u00fd \u0111\u01b0\u1ee3c m\u1ed9t k\u00fd t\u1ef1 c\u00f3 d\u1ea5u, g\u00e2y m\u1ea5t th\u1eddi gian n\u1ebfu v\u0103n b\u1ea3n d\u00e0i. V\u00ec l\u00fd do \u0111\u00f3, c\u00e1ch l\u00e0m n\u00e0y kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i.<\/p>\n<p>N\u1ebfu b\u1ea1n v\u1eabn mu\u1ed1n thao t\u00e1c th\u1eed, v\u00ed d\u1ee5 minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 h\u00ecnh dung:<\/p>\n<h4>4.1.1. H\u00e0m SUBSTITUTE<\/h4>\n<p><strong>C\u00fa ph\u00e1p:<\/strong> =SUBSTITUTE(text, old_text, new_text, [instance_num])<\/p>\n<p><strong>Gi\u1ea3i th\u00edch c\u00e1c \u0111\u1ed1i s\u1ed1:<\/strong><\/p>\n<ul>\n<li><strong>text:<\/strong> \u00d4 ch\u1ee9a n\u1ed9i dung c\u1ea7n thay \u0111\u1ed5i.<\/li>\n<li><strong>old_text:<\/strong> K\u00fd t\u1ef1 c\u00f3 d\u1ea5u m\u00e0 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf.<\/li>\n<li><strong>new_text: <\/strong>K\u00fd t\u1ef1 thay th\u1ebf.<\/li>\n<li><strong>instance_num:<\/strong> Th\u1ee9 t\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a old_text. N\u1ebfu b\u1ecf tr\u1ed1ng, Excel s\u1ebd thay to\u00e0n b\u1ed9 old_text trong chu\u1ed7i.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5 thao t\u00e1c<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>T\u1ea1i \u00f4 B2, nh\u1eadp c\u00f4ng th\u1ee9c: =SUBSTITUTE(A2, &#8220;\u00ea&#8221;, &#8220;e&#8221;) r\u1ed3i nh\u1ea5n <strong>Enter<\/strong>.<\/p>\n<p><em><img decoding=\"async\" alt=\"Nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m SUBSTITUTE\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-14.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-14\">Nh\u1eadp c\u00f4ng th\u1ee9c SUBSTITUTE \u0111\u1ec3 thay k\u00fd t\u1ef1 c\u00f3 d\u1ea5u b\u1eb1ng k\u00fd t\u1ef1 kh\u00f4ng d\u1ea5u<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 m\u1edbi, ch\u1eb3ng h\u1ea1n: <strong>Ng\u1ecdc Lien<\/strong>. Ngh\u0129a l\u00e0 ch\u1eef <strong>\u00ea<\/strong> trong n\u1ed9i dung g\u1ed1c \u0111\u00e3 \u0111\u01b0\u1ee3c thay b\u1eb1ng <strong>e<\/strong>.<\/p>\n<p><em><img decoding=\"async\" alt=\"K\u1ebft qu\u1ea3 sau khi s\u1eed d\u1ee5ng h\u00e0m SUBSTITUTE\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-15.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-15\">K\u1ebft qu\u1ea3 thay th\u1ebf k\u00fd t\u1ef1 trong v\u00ed d\u1ee5 h\u00e0m SUBSTITUTE<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> V\u1edbi c\u00e1c d\u00f2ng kh\u00e1c, b\u1ea1n ti\u1ebfp t\u1ee5c sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0 ch\u1ec9nh l\u1ea1i k\u00fd t\u1ef1 c\u1ea7n thay th\u1ebf t\u00f9y theo t\u1eebng tr\u01b0\u1eddng h\u1ee3p.<\/p>\n<p><em><img decoding=\"async\" alt=\"Sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-16.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-16\">\u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c SUBSTITUTE cho c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i<\/em><\/p>\n<h4>4.1.2. H\u00e0m REPLACE<\/h4>\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng <strong>REPLACE <\/strong>\u0111\u1ec3 \u0111\u1ed5i m\u1ed9t k\u00fd t\u1ef1 c\u00f3 d\u1ea5u sang k\u00fd t\u1ef1 kh\u00f4ng d\u1ea5u, d\u00f9 c\u00e1ch n\u00e0y ch\u1ec9 ph\u00f9 h\u1ee3p cho nh\u1eefng tr\u01b0\u1eddng h\u1ee3p \u0111\u01a1n l\u1ebb.<\/p>\n<p><strong>C\u00fa ph\u00e1p:<\/strong> REPLACE(old_text, start_num, num_chars, new_text)<\/p>\n<p><strong>\u00dd ngh\u0129a c\u00e1c tham s\u1ed1:<\/strong><\/p>\n<ul>\n<li><strong>old_text:<\/strong> \u00d4 ch\u1ee9a n\u1ed9i dung b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda.<\/li>\n<li><strong>start_num:<\/strong> V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u thay th\u1ebf trong chu\u1ed7i k\u00fd t\u1ef1.<\/li>\n<li><strong>num_chars:<\/strong> S\u1ed1 k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n thay.<\/li>\n<li><strong>new_text:<\/strong> K\u00fd t\u1ef1 ho\u1eb7c \u0111o\u1ea1n k\u00fd t\u1ef1 m\u1edbi d\u00f9ng \u0111\u1ec3 thay th\u1ebf.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5 thao t\u00e1c<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n \u0111\u1ed5i m\u1ed9t k\u00fd t\u1ef1 c\u00f3 d\u1ea5u trong \u00f4 A2, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 B2: =REPLACE(A2, 3, 2, &#8220;a\u201d), sau \u0111\u00f3 nh\u1ea5n <strong>Enter<\/strong>.<\/p>\n<p><em><img decoding=\"async\" alt=\"Nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m REPLACE\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-17.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-17\">Nh\u1eadp c\u00f4ng th\u1ee9c REPLACE \u0111\u1ec3 thay k\u00fd t\u1ef1 t\u1ea1i v\u1ecb tr\u00ed x\u00e1c \u0111\u1ecbnh<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 v\u00ed d\u1ee5 nh\u01b0 <strong>Hoang Ha<\/strong>, t\u1ee9c l\u00e0 k\u00fd t\u1ef1 t\u1ea1i v\u1ecb tr\u00ed th\u1ee9 3 trong chu\u1ed7i \u0111\u00e3 \u0111\u01b0\u1ee3c thay b\u1eb1ng ch\u1eef \u201ca\u201d.<\/p>\n<p><em><img decoding=\"async\" alt=\"K\u1ebft qu\u1ea3 lo\u1ea1i b\u1ecf d\u1ea5u sau khi s\u1eed d\u1ee5ng h\u00e0m REPLACE\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-18.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-18\">K\u1ebft qu\u1ea3 lo\u1ea1i b\u1ecf d\u1ea5u trong v\u00ed d\u1ee5 h\u00e0m REPLACE<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> V\u1edbi c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i, b\u1ea1n ch\u1ec9 c\u1ea7n \u0111i\u1ec1u ch\u1ec9nh v\u1ecb tr\u00ed v\u00e0 s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n thay sao cho \u0111\u00fang v\u1edbi t\u1eebng tr\u01b0\u1eddng h\u1ee3p.<\/p>\n<div class=\"titletab\" id=\"titletab4_2\">\n<h3>4.2. Tr\u00ean Google Sheet th\u00ec b\u1ecf d\u1ea5u nh\u01b0 th\u1ebf n\u00e0o?<\/h3>\n<\/div>\n<p>B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t h\u00e0m t\u00f9y ch\u1ec9nh \u0111\u1ec3 chuy\u1ec3n ch\u1eef c\u00f3 d\u1ea5u sang kh\u00f4ng d\u1ea5u nhanh v\u00e0 ch\u00ednh x\u00e1c.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf Google Sheet \u2192 Ti\u1ec7n \u00edch \u2192 Apps Script.<\/p>\n<p><em><img decoding=\"async\" alt=\"Ch\u1ecdn Apps Script trong menu Ti\u1ec7n \u00edch\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-19.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-19\">Ch\u1ecdn Apps Script trong menu Ti\u1ec7n \u00edch c\u1ee7a Google Sheet<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> X\u00f3a to\u00e0n b\u1ed9 m\u00e3 m\u1eb7c \u0111\u1ecbnh trong file M\u00e3.gs.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> D\u00e1n \u0111o\u1ea1n m\u00e3 sau:<\/p>\n<div class=\"prompt-text\">\n<pre id=\"prompt-block-2\">function UNSIGN(text) { if (!text) return \"\"; var normalized = text.normalize('NFD'); var noAccents = normalized.replace(\/[u0300-u036f]\/g, ''); noAccents = noAccents.replace(\/\u0111\/g, 'd').replace(\/\u0110\/g, 'D'); return noAccents; \/\/ gi\u1eef nguy\u00ean hoa \u2013 th\u01b0\u1eddng\n}<\/pre>\n<\/div>\n<p><em><img decoding=\"async\" alt=\"D\u00e1n \u0111o\u1ea1n m\u00e3 UNSIGN v\u00e0o file M\u00e3.gs\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-20.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-20\">D\u00e1n \u0111o\u1ea1n m\u00e3 UNSIGN v\u00e0o file M\u00e3.gs trong Apps Script<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 4: <\/strong>Nh\u1ea5n Ctrl + S \u0111\u1ec3 l\u01b0u m\u00e3 v\u00e0 quay l\u1ea1i Google Sheet.<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> T\u1ea1i \u00f4 mu\u1ed1n xu\u1ea5t ch\u1eef kh\u00f4ng d\u1ea5u, nh\u1eadp: =UNSIGN(A2)<\/p>\n<p>Trong \u0111\u00f3 <strong>A2 <\/strong>l\u00e0 \u00f4 ch\u1ee9a v\u0103n b\u1ea3n c\u00f3 d\u1ea5u.<\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong><\/p>\n<ul>\n<li><strong>A2:<\/strong> \u0110I\u1ec6N M\u00c1Y CH\u1ee2 L\u1edaN<\/li>\n<li><strong>C\u00f4ng th\u1ee9c:<\/strong> =UNSIGN(A2)<\/li>\n<li><strong>K\u1ebft qu\u1ea3:<\/strong> DIEN MAY CHO LON<\/li>\n<\/ul>\n<p><em><img decoding=\"async\" alt=\"K\u1ebft qu\u1ea3 sau khi s\u1eed d\u1ee5ng h\u00e0m UNSIGN\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-bo-dau-tieng-viet-trong-excel-21.jpg\" title=\"cach-bo-dau-tieng-viet-trong-excel-21\">Nh\u1eadp c\u00f4ng th\u1ee9c =UNSIGN(A2) \u0111\u1ec3 chuy\u1ec3n v\u0103n b\u1ea3n sang kh\u00f4ng d\u1ea5u<\/em><\/p>\n<p>Qua c\u00e1c c\u00e1ch b\u1ecf d\u1ea5u b\u1eb1ng Unikey, EVKey, VBA v\u00e0 Google Sheet, b\u1ea1n c\u00f3 th\u1ec3 linh ho\u1ea1t x\u1eed l\u00fd d\u1eef li\u1ec7u ti\u1ebfng Vi\u1ec7t d\u1ec5 d\u00e0ng h\u01a1n trong c\u00f4ng vi\u1ec7c. \u0110\u1ec3 kh\u00e1m ph\u00e1 th\u00eam nhi\u1ec1u th\u1ee7 thu\u1eadt hay, \u0111\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y &#8211; N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn.<\/p>\n<p>N\u1ebfu \u0111ang t\u00ecm \u0111i\u1ec7n tho\u1ea1i ho\u1eb7c m\u00e1y t\u00ednh b\u1ea3ng \u0111\u1ec3 h\u1ed7 tr\u1ee3 c\u00f4ng vi\u1ec7c, b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam c\u00e1c l\u1ef1a ch\u1ecdn ph\u00f9 h\u1ee3p t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y &#8211; N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u ti\u1ebfng Vi\u1ec7t, \u0111\u1eb7c bi\u1ec7t l\u00e0 h\u1ecd t\u00ean ho\u1eb7c danh s\u00e1ch d\u00e0i, vi\u1ec7c chuy\u1ec3n v\u0103n b\u1ea3n c\u00f3 d\u1ea5u sang kh\u00f4ng d\u1ea5u gi\u00fap l\u1ecdc v\u00e0 x\u1eed l\u00fd nhanh h\u01a1n. B\u00e0i vi\u1ebft n\u00e0y t\u1ed5ng h\u1ee3p c\u00e1c c\u00e1ch b\u1ecf d\u1ea5u trong Excel v\u00e0 Google Sheet b\u1eb1ng Unikey, EVKey, VBA c\u0169ng nh\u01b0 c\u00f4ng [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4813,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4812","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19334.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4812","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=4812"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4812\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4813"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4812"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4812"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}