{"id":5762,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/velka2\/"},"modified":"2021-02-26T10:01:58","modified_gmt":"2021-02-26T10:01:58","slug":"proper","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/proper\/","title":{"rendered":"VELK\u00c12"},"content":{"rendered":"

Funkce PROPER (ve slovensk\u00e9 verzi Excelu jako VELK\u00c12) je u\u017eite\u010dn\u00e1 pro pr\u00e1ci s textem v programu Microsoft Excel a Google Sheets. Umo\u017e\u0148uje form\u00e1tov\u00e1n\u00ed textov\u00fdch \u0159et\u011bzc\u016f tak, \u017ee prvn\u00ed p\u00edsmeno ka\u017ed\u00e9ho slova je velk\u00e9 a zbyl\u00e1 p\u00edsmena jsou mal\u00e1. Tato funkce je u\u017eite\u010dn\u00e1 v situac\u00edch, kdy je pot\u0159eba zjednotit form\u00e1t n\u00e1zv\u016f \u010di adres.<\/p>\n

Syntaxe a p\u0159\u00edklady<\/h2>\n

Syntaxe funkce PROPER je n\u00e1sledovn\u00e1:<\/p>\n

=PROPER(text)<\/code><\/pre>\n
Argument text<\/em> znamen\u00e1 textov\u00fd \u0159et\u011bzec, kter\u00fd chcete zm\u011bnit, aby ka\u017ed\u00e9 slovo za\u010d\u00ednalo velk\u00fdm p\u00edsmenem.<\/p>\n
Nap\u0159\u00edklad, pokud m\u00e1te data v bu\u0148ce A1 ve tvaru:<\/p>\n
jan nov\u00e1k<\/code><\/pre>\n
a pou\u017eijete na n\u011b funkci PROPER:<\/p>\n
=PROPER(A1)<\/code><\/pre>\n
v\u00fdsledek v bu\u0148ce, kde je vzorec um\u00edst\u011bn, bude:<\/p>\n
Jan Nov\u00e1k<\/code><\/pre>\n
Pou\u017eit\u00ed ve skute\u010dn\u00fdch situac\u00edch<\/h2>\n
1. \u00daprava jmen kontakt\u016f pro marketingov\u00e9 \u00fa\u010dely:<\/p>\n
    \n
  • Pokud m\u00e1te seznam kontakt\u016f ve sloupci A a jm\u00e9na jsou zaps\u00e1na mal\u00fdmi p\u00edsmeny, m\u016f\u017eete funkci PROPER pou\u017e\u00edt k tomu, aby ka\u017ed\u00e9 jm\u00e9no za\u010d\u00ednalo velk\u00fdm p\u00edsmenem, co\u017e dod\u00e1 va\u0161\u00ed emailov\u00e9 kampani profesion\u00e1ln\u011bj\u0161\u00ed vzhled.<\/li>\n
  • N\u00ed\u017ee je uk\u00e1zka, jak by mohla funkce b\u00fdt aplikov\u00e1na:<\/li>\n<\/ul>\n\n\n\n\n\n
    P\u016fvodn\u00ed<\/th>\nUpraven\u00fd<\/th>\n<\/tr>\n
    jan nov\u00e1k<\/td>\n=PROPER(A2)<\/td>\n<\/tr>\n
    eva hrub\u00e1<\/td>\n=PROPER(A3)<\/td>\n<\/tr>\n
    tom\u00e1\u0161 svoboda<\/td>\n=PROPER(A4)<\/td>\n<\/tr>\n<\/table>\n
    2. \u00daprava adres v seznamu:<\/p>\n
      \n
    • Funkce PROPER je tak\u00e9 vhodn\u00e1 pro \u00fapravu form\u00e1tu adres. P\u0159i importu dat, nap\u0159\u00edklad adres, mohou b\u00fdt \u010d\u00e1sti jako n\u00e1zvy ulic nebo m\u011bst nekonzistentn\u011b zaps\u00e1ny. Pou\u017eit\u00ed funkce PROPER zajist\u00ed, \u017ee ka\u017ed\u00e9 slovo bude za\u010d\u00ednat velk\u00fdm p\u00edsmenem, co\u017e je \u010dasto po\u017eadovan\u00fd zp\u016fsob z\u00e1pisu.<\/li>\n<\/ul>\n
      P\u016fvodn\u00ed: pern\u0161t\u00fdnsk\u00e1 ulice 5 Po \u00faprav\u011b: =PROPER(A2) V\u00fdsledek: Pern\u0161t\u00fdnsk\u00e1 Ulice 5<\/code><\/pre>\n
      Tato jednoduch\u00e1 funkce (VELK\u00c12 v Excelu a PROPER v Google Sheets) v\u00fdrazn\u011b zlep\u0161uje \u010ditelnost a estetickou prezentaci dat, co\u017e je obzvl\u00e1\u0161t\u011b cenn\u00e9 p\u0159i p\u0159\u00edprav\u011b report\u016f nebo prezentac\u00ed pro klienty a veden\u00ed spole\u010dnosti.<\/p>\n","protected":false},"excerpt":{"rendered":"
      P\u0159evede prvn\u00ed p\u00edsmeno ka\u017ed\u00e9ho slova textov\u00e9 hodnoty na\u00a0velk\u00e9<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[286],"tags":[],"class_list":["post-5762","post","type-post","status-publish","format-standard","hentry","category-textove"],"acf":[],"yoast_head":"\nFunkce PROPER (VELK\u00c12) v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije PROPER (VELK\u00c12) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/cs\/proper\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce PROPER (VELK\u00c12) v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije PROPER (VELK\u00c12) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/proper\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T10:01:58+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce PROPER (VELK\u00c12) v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/proper\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/proper\/\",\"name\":\"Funkce PROPER (VELK\u00c12) v Excelu: jak funguje, primjeri kori\u0161tenja formule\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:44+00:00\",\"dateModified\":\"2021-02-26T10:01:58+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije PROPER (VELK\u00c12) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/proper\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/proper\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/proper\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Textov\u00e9\",\"item\":\"https:\/\/functiontranslator.com\/cs\/textove\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VELK\u00c12\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/cs\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkce PROPER (VELK\u00c12) v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije PROPER (VELK\u00c12) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/cs\/proper\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce PROPER (VELK\u00c12) v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije PROPER (VELK\u00c12) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/proper\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T10:01:58+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce PROPER (VELK\u00c12) v Excelu: jak funguje, primjeri kori\u0161tenja formule","twitter_misc":{"Napsal(a)":"glavadmin","Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/cs\/proper\/","url":"https:\/\/functiontranslator.com\/cs\/proper\/","name":"Funkce PROPER (VELK\u00c12) v Excelu: jak funguje, primjeri kori\u0161tenja formule","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:44+00:00","dateModified":"2021-02-26T10:01:58+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije PROPER (VELK\u00c12) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/proper\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/proper\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/proper\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Textov\u00e9","item":"https:\/\/functiontranslator.com\/cs\/textove\/"},{"@type":"ListItem","position":3,"name":"VELK\u00c12"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/cs\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/comments?post=5762"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5762\/revisions"}],"predecessor-version":[{"id":30900,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5762\/revisions\/30900"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}