{"id":1812,"date":"2020-11-08T16:23:36","date_gmt":"2020-11-08T09:23:36","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1812"},"modified":"2020-11-08T16:23:38","modified_gmt":"2020-11-08T09:23:38","slug":"cach-bo-dau-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/cach-bo-dau-trong-excel\/","title":{"rendered":"C\u00e1ch B\u1ecf D\u1ea5u Trong Excel: Chuy\u1ec3n Ch\u1eef C\u00f3 D\u1ea5u Th\u00e0nh Kh\u00f4ng D\u1ea5u"},"content":{"rendered":"\t\t
Nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n b\u1ecf d\u1ea5u trong Excel \u0111\u1ec3 chuy\u1ec3n ch\u1eef c\u00f3 d\u1ea5u th\u00e0nh kh\u00f4ng d\u1ea5u ph\u1ee5c v\u1ee5 y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c, v\u00ed d\u1ee5 x\u00f3a d\u1ea5u ti\u1ebfng Vi\u1ec7t c\u1ee7a t\u1eeb kh\u00f3a khi b\u1ea1n ph\u00e2n t\u00edch SEO, ho\u1eb7c l\u1eadp email t\u1eeb danh s\u00e1ch h\u1ecd v\u00e0 t\u00ean,…<\/span><\/p> \u00a0<\/span><\/p> B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch b\u1ecf d\u1ea5u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t v\u1edbi c\u00f4ng c\u1ee5 Unikey.<\/span><\/p> \u00a0<\/span><\/p> \u0110\u1ec3 b\u1ecf d\u1ea5u ti\u1ebfng Vi\u1ec7t trong Excel, tr\u01b0\u1edbc h\u1ebft b\u1ea1n c\u1ea7n c\u00e0i \u0111\u1eb7t Unikey gi\u00fap g\u00f5 \u0111\u01b0\u1ee3c ch\u1eef ti\u1ebfng Vi\u1ec7t tr\u00ean m\u00e1y t\u00ednh.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t M\u1ed7i lo\u1ea1i font ch\u1eef thu\u1ed9c b\u1ea3ng m\u00e3 nh\u1ea5t \u0111\u1ecbnh. M\u1ed7i b\u1ea3ng m\u00e3 l\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a b\u1ed9 g\u00f5, t\u1eadp h\u1ee3p nhi\u1ec1u ki\u1ec3u font ch\u1eef kh\u00e1c nhau c\u00f9ng 1 thu\u1ed9c t\u00ednh.<\/span><\/p> \u00a0<\/span><\/p> N\u1ebfu b\u1ea1n ch\u1ecdn b\u1ea3ng m\u00e3 kh\u00f4ng t\u01b0\u01a1ng th\u00edch v\u1edbi font trong ph\u1ea7n m\u1ec1m g\u00f5 ti\u1ebfng Vi\u1ec7t th\u00ec b\u1ea1n s\u1ebd kh\u00f4ng g\u00f5 \u0111\u01b0\u1ee3c ch\u1eef ti\u1ebfng Vi\u1ec7t c\u00f3 d\u1ea5u<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u00a0<\/span><\/p> UniKey Toolkit cung c\u1ea5p c\u00f4ng c\u1ee5 chuy\u1ec3n \u0111\u1ed5i b\u1ea3ng m\u00e3, chuy\u1ec3n t\u1eeb ch\u1eef th\u01b0\u1eddng sang ch\u1eef hoa v\u00e0 ng\u01b0\u1ee3c l\u1ea1i, lo\u1ea1i b\u1ecf d\u1ea5u ti\u1ebfng Vi\u1ec7t…<\/span><\/p> \u00a0<\/span><\/p> Unikey c\u00f3 r\u1ea5t nhi\u1ec1u b\u1ea3ng m\u00e3 nh\u01b0: ABC, Unicode, VNI Windows,… trong \u0111\u00f3, Unicode l\u00e0 b\u1ea3ng m\u00e3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u1ea3i nh\u1ea5t v\u00e0 l\u00e0 b\u1ea3ng m\u00e3 chu\u1ea9n qu\u1ed1c t\u1ebf – m\u1ecdi ph\u1ea7n m\u1ec1m g\u00f5 ti\u1ebfng Vi\u1ec7t tr\u00ean m\u00e1y t\u00ednh \u0111\u1ec1u h\u1ed7 tr\u1ee3 b\u1ea3ng m\u00e3 Unicode.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u00a0<\/span><\/p> M\u1ed9t s\u1ed1 lo\u1ea1i font ch\u1eef ph\u1ed5 bi\u1ebfn \u1edf Vi\u1ec7t Nam:<\/span><\/p> Arial, Times New Roman, Verdana, nh\u00f3m font UTM<\/span>: b\u1ea3ng m\u00e3 Unicode<\/span><\/p><\/li> C\u00e1c font ch\u1eef b\u1eaft \u0111\u1ea7u b\u1edfi “.Vn” ho\u1eb7c “.VN” nh\u01b0<\/span> .VnTimes, .VnTimesH<\/span>: b\u1ea3ng m\u00e3 TCVN3 (ABC)<\/span><\/p><\/li> C\u00e1c font ch\u1eef b\u1eaft \u0111\u1ea7u b\u1edfi VNI nh\u01b0 <\/span>VNI-Times, VNI-Helve, VniHelvetica<\/span>: b\u1ea3ng m\u00e3 VNI Windows<\/span><\/p><\/li> C\u00e1c font ch\u1eef b\u1eaft \u0111\u1ea7u b\u1edfi “Vn” nh\u01b0 <\/span>VnArial, VnTimes New Roman<\/span>: b\u1ea3ng m\u00e3 Vietware X<\/span><\/p><\/li><\/ul> \u00a0<\/p> …<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t C\u00e1ch b\u1ecf d\u1ea5u trong Excel:<\/span><\/p> B\u01b0\u1edbc 1:<\/span> Ch\u1ecdn c\u00e1c \u00f4 c\u1ea7n lo\u1ea1i b\u1ecf d\u1ea5u trong Excel, th\u1ef1c hi\u1ec7n copy b\u1eb1ng ph\u00edm t\u1eaft Ctrl + C.<\/span><\/p><\/li> B\u01b0\u1edbc 2:<\/span> \u0110\u1ea3m b\u1ea3o Unikey \u0111ang ch\u1ea1y, m\u1edf C\u00f4ng c\u1ee5 (Unikey toolkit) b\u1eb1ng ph\u00edm t\u1eaft Ctrl + Shift + F6 ho\u1eb7c b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Unikey thanh Taskbar c\u1ee7a Windows >> ch\u1ecdn C\u00f4ng c\u1ee5.<\/span><\/p><\/li> B\u01b0\u1edbc 3: <\/span>Trong h\u1ed9p tho\u1ea1i Unikey Toolkit: ch\u1ecdn b\u1ea3ng m\u00e3 \u0111\u00edch gi\u1ed1ng ngu\u1ed3n (l\u00e0 b\u1ea3ng m\u00e3 c\u1ee7a font ch\u1eef \u0111ang s\u1eed d\u1ee5ng), ch\u1ecdn Lo\u1ea1i b\u1ecf d\u1ea5u v\u00e0 \u1ea5n Chuy\u1ec3n m\u00e3.<\/span><\/p><\/li> B\u01b0\u1edbc 4: <\/span>Sau khi \u1ea5n Chuy\u1ec3n m\u00e3, th\u00f4ng b\u00e1o th\u00e0nh c\u00f4ng hi\u1ec7n ra, \u0111\u00f3ng th\u00f4ng b\u00e1o v\u00e0 d\u00e1n k\u1ebft qu\u1ea3 v\u00e0o Excel \u0111\u1ec3 thu \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u \u0111\u00e3 b\u1ecf d\u1ea5u ti\u1ebfng Vi\u1ec7t.<\/span><\/p><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u00a0<\/p> V\u00ed d\u1ee5 c\u00e1ch b\u1ecf d\u1ea5u ti\u1ebfng Vi\u1ec7t trong Excel: Chuy\u1ec3n n\u1ed9i dung trong v\u00f9ng A3:A6 c\u00f3 font l\u00e0 Calibri, thu\u1ed9c b\u1ea3ng m\u00e3 Unicode th\u00e0nh ti\u1ebfng Vi\u1ec7t kh\u00f4ng d\u1ea5u:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u00a0<\/span><\/p> Sau khi copy v\u00f9ng d\u1eef li\u1ec7u A3:A6, m\u1edf c\u00f4ng c\u1ee5 c\u1ee7a Unikey b\u1eb1ng c\u00e1ch b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Unikey \u1edf thanh Taskbar d\u01b0\u1edbi c\u00f9ng ph\u00eda b\u00ean ph\u1ea3i m\u00e0n h\u00ecnh (thanh bi\u1ec3u th\u1ecb c\u00e1c ph\u1ea7n m\u1ec1m \u0111nag ch\u1ea1y trong Windows) v\u00e0 ch\u1ecdn C\u00f4ng c\u1ee5…[CS+F6]:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + F6 \u0111\u1ec3 m\u1edf Unikey Toolkit n\u00e0y.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t Thao t\u00e1c v\u1edbi Unikey Toolkit \u0111\u1ec3 b\u1ecf d\u1ea5u trong Excel:<\/span><\/p> – Do font ch\u1eef \u0111ang s\u1eed d\u1ee5ng l\u00e0 Calibri n\u00ean trong h\u1ed9p tho\u1ea1i Unikey Toolkit: ph\u1ea7n ngu\u1ed3n c\u1ee7a b\u1ea3ng m\u00e3 t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb l\u00e0 Unicode.<\/span><\/p> – N\u1ebfu mu\u1ed1n lo\u1ea1i b\u1ecf d\u1ea5u m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n Unicode m\u00e0 kh\u00f4ng chuy\u1ec3n m\u00e3 th\u00ec ph\u1ea3i ch\u1ecdn b\u1ea3ng m\u00e3 ngu\u1ed3n v\u00e0 b\u1ea3ng m\u00e3 \u0111\u00edch \u0111\u1ec1u l\u00e0 Unicode.<\/span><\/p> – Ch\u1ecdn Lo\u1ea1i b\u1ecf d\u1ea5u v\u00e0 \u1ea5<\/span>n chuy\u1ec3n m\u00e3.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u00a0<\/span><\/p> H\u1ed9p tho\u1ea1i th\u00f4ng b\u00e1o chuy\u1ec3n \u0111\u1ed5i th\u00e0nh c\u00f4ng xu\u1ea5t hi\u1ec7n, ch\u1ecdn OK. N\u1ebfu b\u1ea1n ch\u01b0a thao t\u00e1c h\u1ee3p l\u00fd nh\u01b0 h\u01b0\u1edbng d\u1eabn \u1edf tr\u00ean, h\u1ed9p tho\u1ea1i kh\u00e1c \u201cCannot read clipboard\u201d hi\u1ec7n ra th\u00f4ng b\u00e1o l\u1ed7i.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u00a0<\/span><\/p> Cu\u1ed1i c\u00f9ng, di chuy\u1ec3n \u0111\u1ebfn c\u1ed9t k\u1ebft qu\u1ea3 b\u1ecf d\u1ea5u trong Excel (\u00f4 B3), b\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl + V ho\u1eb7c b\u1ea5m chu\u1ed9t ph\u1ea3i >> ch\u1ecdn Paste \u0111\u1ec3 d\u00e1n k\u1ebft qu\u1ea3 chuy\u1ec3n ch\u1eef c\u00f3 d\u1ea5u th\u00e0nh kh\u00f4ng d\u1ea5u:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t1, Ki\u1ebfn Th\u1ee9c V\u1ec1 Font Ch\u1eef V\u00e0 B\u1ea3ng M\u00e3 Unikey \u0110\u1ec3 \u00c1p D\u1ee5ng B\u1ecf D\u1ea5u Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
2, C\u00e1ch Chuy\u1ec3n Ch\u1eef C\u00f3 D\u1ea5u Th\u00e0nh Kh\u00f4ng D\u1ea5u Trong Excel S\u1eed D\u1ee5ng Unikey<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t