{"id":52637,"date":"2025-03-12T14:00:00","date_gmt":"2025-03-12T13:00:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=52637"},"modified":"2025-06-03T20:44:35","modified_gmt":"2025-06-03T18:44:35","slug":"fonction-propre-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-formulas\/proper-function-google-sheets\/","title":{"rendered":"Utilisation de la fonction PROPER pour mettre en majuscule la premi\u00e8re lettre de chaque mot dans Google Sheets"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ theme_builder_area=”post_content” _builder_version=”4.27.2″ _module_preset=”default”][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content”][et_pb_column _builder_version=”4.27.2″ _module_preset=”default” type=”4_4″ theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″]
\n

Note:<\/strong> This post was originally published in our community forum.<\/p>\n<\/blockquote>\n

Ever found yourself needing to clean up a list of names, titles, or any other text in Google Sheets, ensuring each word starts with a capital letter? Whether you\u2019re preparing a presentation, organizing data, or just trying to make your sheets look neater, I\u2019ve got a neat trick for you.<\/p>\n

Google Sheets offers a powerful function called\u00a0<\/span>PROPER<\/code><\/strong>\u00a0<\/span>that can do exactly this. However, when you have a long list, editing each cell individually is not practical. That\u2019s where the\u00a0ARRAYFORMULA<\/b><\/span><\/span><\/span>\u00a0function comes in, allowing us to apply the\u00a0<\/span>PROPER<\/code><\/strong>\u00a0<\/span>function to a range of cells all at once!<\/p>\n

Let\u2019s create an example scenario where this formula can be applied in Google Sheets.<\/p>\n

Imagine you have a list of product names in your sheet that are not consistently formatted. Some names are all lowercase, some are all uppercase, and others are a mix of both. You want to standardize the formatting so that each word in the product names starts with a capital letter, and the rest of the letters are lowercase. Here\u2019s how you can do it:<\/p>\n

Original Data<\/strong><\/p>\n

Column A<\/p>\n

apple iPhone<\/p>\n

SAMSUNG galaxy S21<\/p>\n

google Pixel<\/p>\n

Step 1: Select the cell where you want the output to start. In this case, let\u2019s say you want to place the formatted names in Column B, starting at B2.<\/p>\n

Step 2: In cell B2, enter the formula to capitalize the first letter of each word across your range of product names in Column A (assuming your list starts at A2 and ends at A4):<\/p>\n

=ArrayFormula(PROPER(A2:A4))<\/code><\/p>\n

Step 3: Press Enter. The formula will automatically apply the `PROPER` function to each cell in the range A2:A4, and the results will be displayed in the corresponding cells in Column B.<\/p>\n

Result<\/strong><\/p>\n\n\n\n\n\n\n
ColumnA<\/td>\nColumn B<\/td>\n<\/tr>\n
apple iPhone<\/td>\nApple Iphone<\/td>\n<\/tr>\n
SAMSUNG galaxy S21<\/td>\nSamsung Galaxy S21<\/td>\n<\/tr>\n
google Pixel<\/td>\nGoogle Pixel<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Explanation:<\/span><\/p>\n

    \n
  • The formula\u00a0=ArrayFormula(PROPER(A2:A4))<\/code><\/strong>\u00a0takes each value in the range A2:A4, applies the\u00a0PROPER<\/code><\/strong>\u00a0function to capitalize the first letter of each word, and outputs the results into Column B, maintaining the row alignment.<\/li>\n
  • \n

    This process standardizes the formatting of each product name, making your data look cleaner and more professional.<\/p>\n<\/li>\n<\/ul>\n

    Note: This example assumes your original data is in Column A and that you want the formatted output in Column B. Adjust the cell references in the formula as needed based on where your data is located and where you want the results to appear.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"

    Note: This post was originally published in our community forum. Ever found yourself needing to clean up a list of names, titles, or any other text in Google Sheets, ensuring each word starts with a capital letter? Whether you\u2019re preparing a presentation, organizing data, or just trying to make your sheets look neater, I\u2019ve got […]<\/p>\n","protected":false},"author":46,"featured_media":44470,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[28],"class_list":["post-52637","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/52637","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/46"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=52637"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/52637\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/44470"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=52637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=52637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=52637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}