{"id":15127,"date":"2023-07-27T15:25:11","date_gmt":"2023-07-27T08:25:11","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=15127"},"modified":"2023-08-09T16:09:10","modified_gmt":"2023-08-09T09:09:10","slug":"cach-viet-hoa-chu-cai-dau-trong-google-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-viet-hoa-chu-cai-dau-trong-google-sheets\/","title":{"rendered":"How to capitalize first letter in Google Sheets"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Job <strong>vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong Google Sheets<\/strong> is very important if you want your document to look professional and attractive to viewers. In this article, you will learn how to capitalize the first letter using the PROPER and UPPER functions in Google Sheets. This formula is very useful if you need consistent formatting across a data set.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 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\">Table of contents<\/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:\/\/gcloudvn.com\/en\/kienthuc\/cach-viet-hoa-chu-cai-dau-trong-google-sheets\/#Cach_su_dung_ham_PROPER_de_viet_hoa_chu_cai_dau_trong_Google_Sheets\" >How to use the PROPER function to capitalize the first letter in Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-viet-hoa-chu-cai-dau-trong-google-sheets\/#Cach_su_dung_ham_UPPER_ket_hop_cac_ham_de_viet_hoa_chu_cai_dau_trong_Google_Sheets\" >How to use the UPPER function to combine functions to capitalize the first letter in Google Sheets<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-viet-hoa-chu-cai-dau-trong-google-sheets\/#Ket_hop_ham_UPPER_va_LEN\" >Combining UPPER and LEN . functions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-viet-hoa-chu-cai-dau-trong-google-sheets\/#Ket_hop_ham_UPPER_%E2%80%93_LOWER_%E2%80%93_Repace\" >Combine the function UPPER - LOWER - Repace<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-viet-hoa-chu-cai-dau-trong-google-sheets\/#Cach_su_dung_ham_UPPER_ket_hop_cac_ham_de_viet_hoa_chu_cai_dau_o_doan_van_ban_trong_Google_Sheets\" >How to use the UPPER function in combination with functions to capitalize the first letter of text in Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-viet-hoa-chu-cai-dau-trong-google-sheets\/#Lam_cach_nao_de_ban_viet_hoa_chu_cai_dau_tien_trong_Google_Sheets_ma_khong_can_cong_thuc\" >How do you capitalize the first letter in Google Sheets without a formula?<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_PROPER_de_viet_hoa_chu_cai_dau_trong_Google_Sheets\"><\/span><b>How to use the PROPER function to capitalize the first letter in Google Sheets<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Step 1: Enter <\/span><b>\u201c=PROPER(\u201d<\/b><span style=\"font-weight: 400;\"> or in <\/span><b>\u201cInsert\u201d \u2192 \u201cFunction\u201d \u2192 \u201cText\u201d \u2192 \u201cPROPER\u201d<\/b><span style=\"font-weight: 400;\">.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Step 2: Enter the text value by cell reference or enter it manually.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Step 3: Press the . key <\/span><b>\u201cEnter\u201d<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">The general syntax for the function is as follows: <\/span><b>=PROPER(text_to_capitalize)<\/b><span style=\"font-weight: 400;\">\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Text_to_capitalize<\/b><span style=\"font-weight: 400;\">: This is the text string to which you make changes.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">You can see the example below. Regardless of the case of all letters in a selected text string, the PROPER formula makes the first letter uppercase and the rest lowercase. The last example shows how to manually enter the text value, \u201cABC\u201d.<\/span><\/p>\n<p style=\"text-align: justify;\"><b><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-15131 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/viet_hoa_google_sheets_1.jpg\" alt=\"How to capitalize the first letter in Google Sheets 1\" width=\"407\" height=\"361\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/viet_hoa_google_sheets_1.jpg 407w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/viet_hoa_google_sheets_1-14x12.jpg 14w\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" \/><\/b><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_UPPER_ket_hop_cac_ham_de_viet_hoa_chu_cai_dau_trong_Google_Sheets\"><\/span><b>How to use the UPPER function to combine functions to capitalize the first letter in Google Sheets<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ket_hop_ham_UPPER_va_LEN\"><\/span><b>Combining UPPER and LEN . functions<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">General Formula <\/span><b>=UPPER(LEFT((text_to_capitalize),1))&amp;RIGHT((text_to_capitalize),LEN((text_to_capitalize))-1)<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Note:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Jaw <\/span><b>LEFT<\/b><span style=\"font-weight: 400;\"> with reference 1 will return the first character in the sentence.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Jaw <\/span><b>RIGHT<\/b><span style=\"font-weight: 400;\"> will return the remaining characters after that.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Jaw <\/span><b>UPPER<\/b><span style=\"font-weight: 400;\"> will then convert the first character to uppercase.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Jaw <\/span><b>WOOL<\/b><span style=\"font-weight: 400;\"> counts all characters in a cell, and then returns the string length, including the space character.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Text_to_capitalize<\/b><span style=\"font-weight: 400;\">: This is the text string to which you make changes.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">You can see the example below, of all the letters in a selected text string, the UPPER formula will make the first letter uppercase and the rest lowercase.<\/span><\/p>\n<p style=\"text-align: justify;\"><b><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-15130 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/viet_hoa_google_sheets_2.jpg\" alt=\"How to capitalize the first letter in Google Sheets 2\" width=\"602\" height=\"259\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/viet_hoa_google_sheets_2.jpg 602w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/viet_hoa_google_sheets_2-18x8.jpg 18w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/b><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ket_hop_ham_UPPER_%E2%80%93_LOWER_%E2%80%93_Repace\"><\/span><b>Combine the function UPPER - LOWER - Repace<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">General Formula <\/span><b>=REPLACE(LOWER(text_to_capitalize),1,1,UPPER(LEFT(text_to_capitalize,1)))<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-15129 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/viet_hoa_google_sheets_3.jpg\" alt=\"How to capitalize the first letter in Google Sheets 3\" width=\"601\" height=\"256\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/viet_hoa_google_sheets_3.jpg 601w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/viet_hoa_google_sheets_3-18x8.jpg 18w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/>Note:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Jaw <\/span><b>REPLACE<\/b><span style=\"font-weight: 400;\"> to replace letters by reference.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Jaw <\/span><b>LEFT <\/b><span style=\"font-weight: 400;\">will return the remaining characters by reference.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Jaw <\/span><b>UPPER<\/b><span style=\"font-weight: 400;\"> will then convert the first character to uppercase.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Jaw <\/span><b>LOWER<\/b><span style=\"font-weight: 400;\"> will then convert the characters by reference to lowercase.\u00a0<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_UPPER_ket_hop_cac_ham_de_viet_hoa_chu_cai_dau_o_doan_van_ban_trong_Google_Sheets\"><\/span><b>How to use the UPPER function in combination with functions to capitalize the first letter of text in Google Sheets<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Another scenario where you might want to capitalize the first letter in Google Sheets is the case of a complete paragraph of text. If you&#039;re working with paragraphs that include period-separated sentences, you only need the first word in each sentence to be capitalized.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">In essence, there is no direct function that can do this task for you. However, you can use a combination of different functions to perform this task and convert entire sentences in the text.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">General Formula <\/span><b>=JOIN(\u201c. \u201c, ARRAYFORMULA(REPLACE(TRIM(SPLIT((text_to_capitalize), \u201c.\u201d)), 1, 1, UPPER(LEFT(TRIM(SPLIT((text_to_capitalize), \u201c.\u201d)),1)) )))<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Note:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The first thing you need to do is separate sentences based on periods. The SPLIT function does this based on the condition you set, in this case the &quot;.&quot;.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Jaw <\/span><b>TRIM<\/b><span style=\"font-weight: 400;\"> is applied to each sentence and removes any extra spaces.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Jaw <\/span><b>LEFT<\/b><span style=\"font-weight: 400;\"> will return the first character from each sentence.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Jaw <\/span><b>UPPER<\/b><span style=\"font-weight: 400;\"> will then convert the first character to uppercase.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Jaw <\/span><b>REPLACE<\/b><span style=\"font-weight: 400;\"> will replace the first characters with its uppercase version.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Sentences have been split, so the function . is needed <\/span><b>ARRAYFORMULA<\/b><span style=\"font-weight: 400;\"> to work again.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Then you need to combine all the sentences with the function <\/span><b>JOIN<\/b><span style=\"font-weight: 400;\">, separate them with a dot.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Text_to_capitalize<\/b><span style=\"font-weight: 400;\">: This is the text string to which you make changes.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-15128 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/viet_hoa_google_sheets_4.jpg\" alt=\"How to capitalize the first letter in Google Sheets 4\" width=\"800\" height=\"214\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/viet_hoa_google_sheets_4.jpg 800w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/viet_hoa_google_sheets_4-768x205.jpg 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/viet_hoa_google_sheets_4-18x5.jpg 18w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/b><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Lam_cach_nao_de_ban_viet_hoa_chu_cai_dau_tien_trong_Google_Sheets_ma_khong_can_cong_thuc\"><\/span><b>How do you capitalize the first letter in Google Sheets without a formula?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Unfortunately, if you&#039;re not using a formula function, you&#039;ll need to manually capitalize lowercase letters. If you&#039;re having trouble with case formatting inconsistencies in your dataset, you should review your settings for importing or exporting data from third-party apps from Google Sheets.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Capitalize the first letter in Google Sheets<\/strong> You can use many different functions, depending on the specific case, you will have the right way to do it. For more detailed information about<\/span><b> Google Sheets <\/b><span style=\"font-weight: 400;\">or<\/span><a href=\"https:\/\/gcloudvn.com\/en\/google-workspace\/\"><b> GG Workspace<\/b><\/a><span style=\"font-weight: 400;\"> or need technical support, you can contact Gimasys \u2013 Premier Partner of Google in Vietnam with the following information:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Hotline: 0974 417 099 (HCM) | 0987 682 505 (HN)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Email: gcp@gimasys.com<\/span><\/li>\n<\/ul>\n<p style=\"text-align: right;\"><b>Source: Gimasys<\/b><\/p>","protected":false},"excerpt":{"rendered":"<p>Vi\u1ec7c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong Google Sheets l\u00e0 r\u1ea5t quan tr\u1ecdng n\u1ebfu b\u1ea1n mu\u1ed1n t\u00e0i li\u1ec7u c\u1ee7a m\u00ecnh tr\u00f4ng th\u1eadt chuy\u00ean nghi\u1ec7p v\u00e0 cu\u1ed1n h\u00fat ng\u01b0\u1eddi xem. Trong b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch vi\u1ebft&hellip;<\/p>","protected":false},"author":2,"featured_media":15132,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,134],"tags":[],"class_list":["post-15127","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","category-google-workspace","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/15127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=15127"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/15127\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/15132"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=15127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=15127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=15127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}