{"id":15617,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/yinele\/"},"modified":"2021-02-25T16:34:52","modified_gmt":"2021-02-25T16:34:52","slug":"rept","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/rept\/","title":{"rendered":"Y\u0130NELE"},"content":{"rendered":"

REPT (Y\u0130NELE) Fonksiyonu ile Excel ve Google E-tablolar\u0131nda Yarat\u0131c\u0131 \u00c7\u00f6z\u00fcmler<\/h1>\n

Excel ve Google E-Tablolar, verilerle \u00e7al\u0131\u015f\u0131rken kapsaml\u0131 ve g\u00fc\u00e7l\u00fc ara\u00e7lar sunar. Bu ara\u00e7lar\u0131n sundu\u011fu fonksiyonlardan biri de REPT, T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131 ile Y\u0130NELE fonksiyonudur. Bu fonksiyon, belirtilen bir metni, belirtilen say\u0131da tekrar etmeye yarar. Bu i\u015flevsellik basit g\u00f6r\u00fcnse de, \u00e7e\u015fitli yarat\u0131c\u0131 \u00e7\u00f6z\u00fcmler ve i\u015f ak\u0131\u015f\u0131 optimizasyonlar\u0131 i\u00e7in olduk\u00e7a faydal\u0131d\u0131r.<\/p>\n

REPT Fonksiyonunun S\u00f6zdizimi<\/h2>\n

REPT fonksiyonunun genel s\u00f6z dizimi \u015fu \u015fekildedir:<\/p>\n

=REPT(metin, say\u0131)<\/code><\/pre>\n
    \n
  • metin<\/strong>: Tekrar edilecek olan metindir.<\/li>\n
  • say\u0131<\/strong>: Metnin ka\u00e7 defa tekrar edilece\u011fini belirten say\u0131sal de\u011ferdir.<\/li>\n<\/ul>\n
    \u00d6rne\u011fin, “Merhaba” kelimesini 3 kere tekrar etmek i\u00e7in kullan\u0131lacak form\u00fcl \u015f\u00f6yledir:<\/p>\n
    =REPT(\"Merhaba \", 3)<\/code><\/pre>\n
    Bu form\u00fcl “Merhaba Merhaba Merhaba ” \u015feklinde bir \u00e7\u0131kt\u0131 \u00fcretir.<\/p>\n
    Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
    REPT fonksiyonu, farkl\u0131 senaryolarda i\u015f ak\u0131\u015f\u0131n\u0131z\u0131 kolayla\u015ft\u0131rmak i\u00e7in kullan\u0131labilir. \u0130\u015fte birka\u00e7 \u00f6rnek:<\/p>\n
    \u00d6rnek 1: G\u00f6rsel \u0130zlenim Sa\u011flamak<\/h3>\n
    Bir projede g\u00f6rev tamamlama y\u00fczdesini g\u00f6stermek i\u00e7in REPT fonksiyonunu kullanabilirsiniz. G\u00f6revin tamamlanma durumunu bir \u00e7ubuk grafi\u011fi gibi g\u00f6stermek hem g\u00f6rsel a\u00e7\u0131dan etkileyici olur hem de anla\u015f\u0131lmas\u0131 kolayd\u0131r.<\/p>\n
    =REPT(\"|\", B1) & REPT(\" \", 10-B1) & B1*10 & \"%\"<\/code><\/pre>\n
    Burada, B1 h\u00fccresindeki de\u011fer (\u00f6rne\u011fin, 7), tamamlanan i\u015f y\u00fczdesini g\u00f6sterir ve ona g\u00f6re bir \u00e7ubuk olu\u015fturur. Yan\u0131nda ise y\u00fczde olarak de\u011feri g\u00f6r\u00fcnt\u00fcler.<\/p>\n
    \u00d6rnek 2: Metin Alanlar\u0131n\u0131 D\u00fczenli Tutmak<\/h3>\n
    Raporlar\u0131n\u0131zda veya listelerinizde, t\u00fcm metinleri ayn\u0131 uzunlukta g\u00f6stermek i\u00e7in REPT fonksiyonunu kullanabilirsiniz. Bu, \u00f6zellikle metin bazl\u0131 raporlama yapt\u0131\u011f\u0131n\u0131zda okunabilirli\u011fi art\u0131r\u0131r.<\/p>\n
    =A1 & REPT(\" \", 20-LEN(A1))<\/code><\/pre>\n
    Bu form\u00fcl, A1 h\u00fccresindeki metni al\u0131r ve metnin uzunlu\u011fu 20 karakterden az ise, kalan karakter say\u0131s\u0131 kadar bo\u015fluk ekler. B\u00f6ylece t\u00fcm metinler sabit geni\u015flikte olur.<\/p>\n
    Sonu\u00e7<\/h2>\n
    REPT (Y\u0130NELE) fonksiyonu, Excel ve Google E-Tablolar’da basit ama etkili bir i\u015flevsellik sunar. Yarat\u0131c\u0131 kullan\u0131mlar\u0131yla bir\u00e7ok farkl\u0131 senaryoda i\u015f ak\u0131\u015f\u0131n\u0131z\u0131 kolayla\u015ft\u0131rabilir ve veri g\u00f6rselle\u015ftirme, metin d\u00fczenleme gibi i\u015flemleri optimization edebilirsiniz. Bu fonksiyonun sa\u011flad\u0131\u011f\u0131 avantajlar\u0131 ke\u015ffetmek i\u015f verimlili\u011finizi art\u0131rabilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Metni belirtilen say\u0131da yineler<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[581],"tags":[],"class_list":["post-15617","post","type-post","status-publish","format-standard","hentry","category-metin"],"acf":[],"yoast_head":"\nExcel'de REPT (Y\u0130NELE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da REPT (Y\u0130NELE) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\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\/tr\/rept\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de REPT (Y\u0130NELE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da REPT (Y\u0130NELE) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/rept\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:34:52+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de REPT (Y\u0130NELE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/rept\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/rept\/\",\"name\":\"Excel'de REPT (Y\u0130NELE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:34:52+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da REPT (Y\u0130NELE) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/rept\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/rept\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/rept\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Metin\",\"item\":\"https:\/\/functiontranslator.com\/tr\/metin\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Y\u0130NELE\"}]},{\"@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\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@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\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de REPT (Y\u0130NELE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da REPT (Y\u0130NELE) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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\/tr\/rept\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de REPT (Y\u0130NELE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da REPT (Y\u0130NELE) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/rept\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:34:52+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de REPT (Y\u0130NELE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/rept\/","url":"https:\/\/functiontranslator.com\/tr\/rept\/","name":"Excel'de REPT (Y\u0130NELE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:34:52+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da REPT (Y\u0130NELE) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/rept\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/rept\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/rept\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Metin","item":"https:\/\/functiontranslator.com\/tr\/metin\/"},{"@type":"ListItem","position":3,"name":"Y\u0130NELE"}]},{"@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":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@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\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15617","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15617"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15617\/revisions"}],"predecessor-version":[{"id":26885,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15617\/revisions\/26885"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}