{"id":23929,"date":"2021-05-05T11:16:38","date_gmt":"2021-05-05T04:16:38","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=23929"},"modified":"2021-05-05T11:16:38","modified_gmt":"2021-05-05T04:16:38","slug":"ham-viet-hoa-chu-cai-dau-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-viet-hoa-chu-cai-dau-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel H\u00e0m Proper"},"content":{"rendered":"

H\u00e0m Proper<\/strong> \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m v\u0103n b\u1ea3n trong Excel. H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/strong> n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong chu\u1ed7i v\u0103n b\u1ea3n, ch\u1eb3ng h\u1ea1n nh\u01b0 Ben Computer. Trong ph\u00e2n t\u00edch t\u00e0i ch\u00ednh, h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean Proper<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i ch\u1eef c\u00e1i vi\u1ebft hoa sang ch\u1eef th\u01b0\u1eddng.<\/p>\n

H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/strong><\/h2>\n

H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/strong> hay h\u00e0m Proper c\u00f3 s\u1eb5n trong c\u00e1c phi\u00ean b\u1ea3n Excel cho Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 cho Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP v\u00e0 Excel 2000.<\/p>\n

\"H\u00e0m
H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/figcaption><\/figure>\n

H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/strong>, h\u00e0m Proper \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0m h\u00e0m v\u0103n b\u1ea3n trong Excel. H\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel. Thay v\u00ec ph\u1ea3i thao t\u00e1c b\u1eb1ng tay, nh\u1ea5n v\u00e0 gi\u1eef ph\u00edm Shift + ch\u1eef c\u00e1i \u0111\u1ec3 vi\u1ebft hoa hay s\u1eed d\u1ee5ng ph\u00edm Caps Lock, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Proper \u0111\u1ec3 thao t\u00e1c, v\u1eeba \u0111\u01a1n gi\u1ea3n v\u1eeba ti\u1ebft ki\u1ec7m th\u1eddi gian.<\/p>\n

C\u00fa ph\u00e1p h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/strong><\/h2>\n

C\u00fa ph\u00e1p h\u00e0m Proper, h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=PROPER(Text)<\/strong><\/p>\n

Trong \u0111\u00f3 h\u00e0m ch\u1ec9 s\u1eed d\u1ee5ng m\u1ed9t tham s\u1ed1 duy nh\u1ea5t:<\/p>\n

Text<\/strong>\u00a0l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c. Tham s\u1ed1 n\u00e0y \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p, c\u00f4ng th\u1ee9c h\u00e0m tr\u1ea3 v\u1ec1 v\u0103n b\u1ea3n ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9a v\u0103n b\u1ea3n m\u00e0 ch\u00fang ta mu\u1ed1n vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u.<\/p>\n

M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Proper trong Excel<\/strong><\/h2>\n

\u2013 H\u00e0m Proper ch\u1ec9 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong chu\u1ed7i v\u0103n b\u1ea3n, c\u00e1c k\u00fd t\u1ef1 c\u00f2n l\u1ea1i \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean. V\u00ed d\u1ee5 c\u00f4ng th\u1ee9c h\u00e0m = Proper (ben computer), k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng Ben Computer.<\/p>\n

\u2013 H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/strong> n\u00e0y kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng v\u1edbi c\u00e1c k\u00fd t\u1ef1 s\u1ed1, c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t v\u00e0 d\u1ea5u ch\u1ea5m c\u00e2u.<\/p>\n

\u2013 N\u1ebfu ch\u00fang ta s\u1eed d\u1ee5ng tham chi\u1ebfu \u0111\u1ebfn \u00f4 tr\u1ed1ng, h\u00e0m Proper s\u1ebd tr\u1ea3 v\u1ec1 k\u00fd t\u1ef1 tr\u1ed1ng.<\/p>\n

\u2013 H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong Excel, h\u00e0m Proper lu\u00f4n lu\u00f4n chuy\u1ec3n \u0111\u1ed5i \u201cs\u201d th\u00e0nh \u201cS\u201d.<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Proper trong Excel<\/strong><\/h2>\n

V\u00ed d\u1ee5 1<\/strong><\/h3>\n

Cho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y, tuy nhi\u00ean danh s\u00e1ch t\u00ean, ch\u1eef c\u00e1i kh\u00f4ng \u0111\u1ed3ng \u0111\u1ec1u, m\u1ed9t s\u1ed1 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u, m\u1ed9t s\u1ed1 kh\u00f4ng.<\/p>\n

\"1
\nTrong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m Propper \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong chu\u1ed7i v\u0103n b\u1ea3n. C\u00f4ng th\u1ee9c h\u00e0m Excel c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=PROPER(A2&\u201d \u201c&B2)<\/strong><\/p>\n

\"2<\/p>\n

Trong c\u00f4ng th\u1ee9c tr\u00ean, ch\u00fang ta s\u1eed d\u1ee5ng to\u00e1n t\u1eed & \u0111\u1ec3 th\u00eam v\u0103n b\u1ea3n v\u00e0o c\u00e1c \u00f4 trong c\u1ed9t A v\u00e0 B. H\u00e0m Proper vi\u1ebft hoa c\u00e1c ch\u1eef c\u00e1i \u0111\u1ea7u.<\/p>\n

V\u00ed d\u1ee5 2<\/strong><\/h3>\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 b\u1ed9 d\u1eef li\u1ec7u, trong \u0111\u00f3 m\u1ed9t s\u1ed1 \u0111\u1ecba ch\u1ec9 kh\u00f4ng \u0111\u01b0\u1ee3c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean.<\/p>\n

\u0110\u1ec3 nh\u1ea5t qu\u00e1n c\u00e1c \u0111\u1ecba ch\u1ec9 n\u00e0y, vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u, ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m Proper d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=PROPER(A2)<\/strong><\/p>\n

\"3<\/p>\n

H\u00e0m Upper trong Excel<\/strong><\/h2>\n

H\u00e0m Upper trong Excel<\/strong> l\u00e0 h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n ch\u1eef th\u01b0\u1eddng th\u00e0nh ch\u1eef hoa. C\u00fa ph\u00e1p h\u00e0m Upper c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=Upper (text)<\/strong><\/p>\n

Trong \u0111\u00f3:<\/p>\n

\u2013 Tham s\u1ed1\u00a0Text<\/strong>\u00a0l\u00e0 b\u1eaft bu\u1ed9c, l\u00e0 \u00f4 ch\u1ee9a t\u1eeb, v\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n sang ch\u1eef in hoa.<\/p>\n

S\u1eed d\u1ee5ng Unikey Toolkit vi\u1ebft hoa ch\u1eef c\u00e1i trong b\u1ea3ng t\u00ednh Excel<\/strong><\/h2>\n

V\u1edbi c\u00e1ch n\u00e0y, b\u01b0\u1edbc \u0111\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 b\u00f4i \u0111en to\u00e0n b\u1ed9 ch\u1eef c\u1ea7n vi\u1ebft hoa r\u1ed3i nh\u1ea5n\u00a0Ctrl + C<\/strong>\u00a0\u0111\u1ec3 sao ch\u00e9p.<\/p>\n

Ti\u1ebfp theo k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Unikey, ch\u1ecdn\u00a0C\u00f4ng c\u1ee5\u2026(CS+F6).<\/strong>\u00a0Tr\u00ean m\u00e0n h\u00ecnh s\u1ebd hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Unikey Toolkit, t\u1ea1i \u0111\u00e2y t\u00ecm v\u00e0 \u0111\u00e1nh t\u00edch ch\u1ecdn t\u00f9y ch\u1ecdn\u00a0Sang ch\u1eef hoa<\/strong>\u00a0r\u1ed3i click ch\u1ecdn\u00a0Chuy\u1ec3n m\u00e3.<\/strong><\/p>\n

Tr\u00ean b\u1ea3ng t\u00ednh, \u0111\u1eb7t con tr\u1ecf chu\u1ed9t \u1edf v\u1ecb tr\u00ed \u0111\u1eb7t t\u00ean m\u1edbi r\u1ed3i nh\u1ea5n\u00a0Ctrl + V<\/strong>\u00a0l\u00e0 xong.<\/p>\n

B\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Proper<\/strong>, h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel<\/strong>. Ngo\u00e0i ra n\u1ebfu c\u00f2n th\u1eafc m\u1eafc ho\u1eb7c c\u00e2u h\u1ecfi n\u00e0o c\u1ea7n gi\u1ea3i \u0111\u00e1p th\u00eam, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 \u0111\u1ec3 l\u1ea1i \u00fd ki\u1ebfn c\u1ee7a m\u00ecnh trong ph\u1ea7n b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft.<\/p>\n

B\u00ean c\u1ea1nh \u0111\u00f3 b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam h\u00e0m Countif<\/a> v\u00e0 h\u00e0m Len trong Excel<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

H\u00e0m Proper \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m v\u0103n b\u1ea3n trong Excel. H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong chu\u1ed7i v\u0103n b\u1ea3n, ch\u1eb3ng h\u1ea1n nh\u01b0 Ben Computer. Trong ph\u00e2n t\u00edch t\u00e0i ch\u00ednh, h\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean Proper \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng […]<\/p>\n","protected":false},"author":39,"featured_media":23931,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-23929","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/23929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=23929"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/23929\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/23931"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=23929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=23929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=23929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}