{"id":9755,"date":"2023-06-02T13:01:15","date_gmt":"2023-06-02T11:01:15","guid":{"rendered":"https:\/\/sosexcel.com\/exceltippek\/?p=9755"},"modified":"2025-06-29T00:20:03","modified_gmt":"2025-06-28T22:20:03","slug":"csere-automatikusan","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/","title":{"rendered":"\u21d4 Csere automatikusan"},"content":{"rendered":"\n<p>&nbsp;<\/p>\n\n\n\n<p>A CSERE funkci\u00f3val t\u00f6bb helyzetet is megoldhatsz az adott pillanatban. Viszont mindig megt\u00f6rt\u00e9nik a csere automatikusan a HELYETTE f\u00fcggv\u00e9nnyel.<\/p>\n\n\n\n<p>Ha m\u00e9g&nbsp;nem ismered: a&nbsp;Keres\u00e9s \u00e9s kijel\u00f6l\u00e9s men\u00fcben tal\u00e1lod&nbsp;a men\u00fcszalag legv\u00e9g\u00e9n, vagy a&nbsp;<strong>Ctrl H&nbsp;<\/strong>kombin\u00e1ci\u00f3val h\u00edvhat\u00f3 el\u0151. Itt \u00edrtam r\u00e9szletesen a <a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/kereses-es-csere-az-excelben\/\" data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/kereses-es-csere-az-excelben\/\" target=\"_blank\">Windows &#8211; Mac &#8211; Google CSERE k\u00fcl\u00f6nbs\u00e9gekr\u0151l<\/a><a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/kereses-es-csere-az-excelben\/\" target=\"_blank\">.<\/a><\/p>\n\n\n\n<p>Az ablakban add meg, hogy mit mire cser\u00e9ln\u00e9l &#8211; t\u00f6rl\u00e9s eset\u00e9n a m\u00e1sodik dobozt hagyd \u00fcresesen:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/csere.png\" alt=\"Csere gyorsan a Ctrl H kombin\u00e1ci\u00f3val. Viszont mindig megt\u00f6rt\u00e9nik a csere automatikusan a HELYETTE f\u00fcggv\u00e9nnyel.\"\/><\/figure>\n\n\n\n<p><strong>N\u00e9h\u00e1ny p\u00e9lda, hogy mire haszn\u00e1lhatod:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u00c9szreveszel egy helyes\u00edr\u00e1si hib\u00e1t:<\/strong>\u00a0a\u00a0t\u00e1bl\u00e1zatban v\u00e9gig k\u00fcl\u00f6n \u00edrtad a tizedesjegy sz\u00f3t, pedig egybe kellett volna. A Csere funkci\u00f3ban\u00a0megadod, hogy a \u201ctizedes jegy\u201d sz\u00f3p\u00e1rt cser\u00e9lje le \u201ctizedesjegy\u201d karakterekre.<\/li>\n\n\n\n<li><strong>Megv\u00e1ltozott egy adat<\/strong>, pl az \u00e9rt\u00e9kes\u00edt\u0151kn\u00e9l Istv\u00e1n \u00fcgyfeleit J\u00f3zsi vette \u00e1t, \u00e9s nem akarod egyes\u00e9vel \u00e1t\u00edrni a neveket. Vagy a piros term\u00e9kek helyett m\u00e1r csak k\u00e9k lesz kaphat\u00f3.<\/li>\n\n\n\n<li>Az adatokn\u00e1l\u00a0<strong>pont szerepel a tizedesvessz\u00f6 helyett<\/strong>, \u00e9s emiatt sz\u00f6vegk\u00e9nt \u00e9rtelmezi az\u00a0Excel.\u00a0<\/li>\n\n\n\n<li>Kit\u00f6r\u00f6ln\u00e9d a k\u00f6t\u0151jeleket<\/li>\n<\/ul>\n\n\n\n<p>A csere funkci\u00f3 azonban statikus, azaz az \u00e9ppen a t\u00e1bl\u00e1zatban szerepl\u0151 adatokra v\u00e9gzi el a cser\u00e9t. Ha automatiz\u00e1lni szeretn\u00e9l, akkor:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Haszn\u00e1lj &#8216;<a data-type=\"URL\" data-id=\"https:\/\/www.youtube.com\/watch?v=SB7xCRkDZac&amp;list=PL8rv8Gx6e17Ep147JvAmkcaEf9wpI7VG-\" href=\"https:\/\/www.youtube.com\/watch?v=SB7xCRkDZac&amp;list=PL8rv8Gx6e17Ep147JvAmkcaEf9wpI7VG-\" target=\"_blank\" rel=\"noreferrer noopener\">T\u00e1bl\u00e1zat form\u00e1tumot<\/a>&#8216; \u00e9s a HELYETTE f\u00fcggv\u00e9nyt<\/li>\n\n\n\n<li>Ismerkedj meg a <a data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/power-query\/\" href=\"https:\/\/exceltitok.hu\/power-query\/\" target=\"_blank\" rel=\"noreferrer noopener\">Power Queryvel<\/a><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">CSERE automatikusan a HELYETTE f\u00fcggv\u00e9nnyel?<\/h2>\n\n\n\n<p>Jobb lenne, ha \u00faj adatokn\u00e1l is automatikusan megt\u00f6rt\u00e9nne a csere?&nbsp;Erre is van megold\u00e1s: a&nbsp;HELYETTE&nbsp;(SUBSTITUTE) f\u00fcggv\u00e9ny!<\/p>\n\n\n\n<p>A fenti esetekre p\u00e9lda:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>=HELYETTE(A2;&#8221;tizedes jegy&#8221;;&#8221;tizedesjegy&#8221;)<\/li>\n\n\n\n<li>=HELYETTE(A2;&#8221;Istv\u00e1n&#8221;;&#8221;J\u00f3zsi&#8221;)<\/li>\n\n\n\n<li>=HELYETTE(A2;&#8221;.&#8221;;&#8221;,&#8221;)<\/li>\n\n\n\n<li>=HELYETTE(A2;&#8221;-&#8222;;&#8221;&#8221;)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/10\/csere-helyette-excel.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"810\" height=\"450\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/10\/csere-helyette-excel.png\" alt=\"Az Excelben haszn\u00e1lhatod a CSERE funkci\u00f3t \u00e9s a HELYETTE f\u00fcggv\u00e9nyt, ha valamit valamire cser\u00e9ln\u00e9l.\" class=\"wp-image-9794\" style=\"width:758px;height:421px\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/10\/csere-helyette-excel.png 810w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/10\/csere-helyette-excel-300x167.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/10\/csere-helyette-excel-768x427.png 768w\" sizes=\"(max-width: 810px) 100vw, 810px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u00c9rdekes cser\u00e9k<\/h2>\n\n\n\n<p>L\u00e9tezik <strong>CSERE f\u00fcggv\u00e9ny <\/strong>is, azzal viszont konkr\u00e9t karaktereket (pl az els\u0151 3 karaktert, vagy a 4-8. karatert tudod cser\u00e9lni (t\u00f6r\u00f6lni, \u00e9s helyette \u00faj karaktereket be\u00edrni).<\/p>\n\n\n\n<p>P\u00e9ld\u00e1ul a 4. karaktert\u0151l 3-t cser\u00e9lve =CSERE(A2;4;3;&#8221;aa-fg&#8221;)<br>ami az 123456789 sz\u00e1msorb\u00f3l 123aa-fg789 eredm\u00e9nyt ad.<\/p>\n\n\n\n<p>Speci\u00e1lis eset, ha <strong>hiba\u00e9rt\u00e9ket<\/strong> (pl. #HIV, #Z\u00c9R\u00d3OSZT\u00d3, #HI\u00c1NYZIK) akarsz cser\u00e9lni. Erre a <a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/hahiba-csereld-le-a-hianyzik-erteket\/\" data-type=\"URL\" data-id=\"https:\/\/sosexcel.com\/exceltippek\/hahiba-csereld-le-a-hianyzik-erteket\/\" target=\"_blank\">HAHIBA f\u00fcggv\u00e9ny a megold\u00e1s<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Tanulj vel\u00fcnk!<\/h2>\n\n\n\n<p>Profit\u00e1lj a t\u00f6bb mint 10 \u00e9ves oktat\u00f3i tapasztalatunkb\u00f3l &#8211;<strong>, \u00e9s sp\u00f3rold meg a ker\u00fcl\u0151utakat, bossz\u00fas\u00e1gokat!<\/strong><\/p>\n\n\n\n<p><img decoding=\"async\" alt=\"\ud83d\udccc\" src=\"https:\/\/fonts.gstatic.com\/s\/e\/notoemoji\/15.0\/1f4cc\/32.png\">&nbsp;<strong>Gyere a VIP Klubba, \u00e9s tanuljunk egy\u00fctt!<\/strong><\/p>\n\n\n\n<p>Ha sokat \u00e9s j\u00f3l haszn\u00e1lod az&nbsp;Excel, csak n\u00e9ha elakadsz a munk\u00e1ddal: a VILL\u00c1MGYORS \u00fatbaigaz\u00edt\u00e1s mindenn\u00e9l t\u00f6bbet \u00e9rhet.&nbsp;<\/p>\n\n\n\n<p>Ez\u00e9rt hoztam l\u00e9tra a VIP&nbsp;Excel&nbsp;Klubot, ahol korl\u00e1tlanul k\u00e9rdezhetsz, ott \u00e1ll m\u00f6g\u00f6tted egy szak\u00e9rt\u0151i csapat:&nbsp;<a href=\"https:\/\/exceltitok.hu\/vip-klub\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/vip-klub\/<\/a><\/p>\n\n\n\n<p><img decoding=\"async\" alt=\"\ud83d\udccc\" src=\"https:\/\/fonts.gstatic.com\/s\/e\/notoemoji\/15.0\/1f4cc\/32.png\">&nbsp;<strong>Csoportos tanfolyamok kezd\u0151t\u0151l halad\u00f3ig<\/strong><\/p>\n\n\n\n<p>Itt az \u00f3r\u00e1kon \u00e9l\u0151ben van lehet\u0151s\u00e9ged megk\u00e9rdezni, amit nem \u00e9rtesz az Excellel kapcsolatban. Az alkalmak sor\u00e1n sok&nbsp;hasznos tr\u00fckk\u00f6t tanulhatsz &#8211; \u00e9s&nbsp;<strong>r\u00f6gt\u00f6n be is gyakorolhatod&nbsp;<\/strong>(az \u00f3r\u00e1n \u00e9s&nbsp;rengeteg extra h\u00e1zi feladattal).<\/p>\n\n\n\n<p>Jelentkezz a&nbsp;k\u00f6vetkez\u0151&nbsp;tanfolyamra:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><figure><img decoding=\"async\" height=\"16\" width=\"16\" src=\"https:\/\/static.xx.fbcdn.net\/images\/emoji.php\/v9\/ted\/1.5\/16\/1f49a.png\" alt=\"\ud83d\udc9a\"><\/figure>\u00a0Ha m\u00e9g csak bar\u00e1tkozn\u00e1l az Excellel: 5 alkalmas Kezd\u0151t\u0151l a stabil felhaszn\u00e1l\u00f3ig tanfolyam, ahol magabiztosan elsaj\u00e1t\u00edthatod az Excel alap funkci\u00f3it:\u00a0<a href=\"https:\/\/exceltitok.hu\/stabil-excel\/?fbclid=IwAR0WEOYvpRoapNTPqGRi7j8enan_c6wPxJQM909PokL7bS7Zb_gia9muYWQ\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/stabil-excel\/<\/a><\/li>\n\n\n\n<li><figure><img decoding=\"async\" height=\"16\" width=\"16\" src=\"https:\/\/static.xx.fbcdn.net\/images\/emoji.php\/v9\/ted\/1.5\/16\/1f49a.png\" alt=\"\ud83d\udc9a\"><\/figure>\u00a0Ha szeretn\u00e9d a halad\u00f3\u00a0funkci\u00f3kat is megtanulni: 9 alkalmas kezd\u0151t\u0151l a halad\u00f3ig tanfolyam:<a href=\"https:\/\/exceltitok.hu\/kezdo-halado\/?fbclid=IwAR1yAxQSxNappSBeFwWzdok5Rnzdpg-zGGblax2ad8-y9-mq2Y0X_PwvOZM\" target=\"_blank\" rel=\"noreferrer noopener\">\u00a0https:\/\/exceltitok.hu\/kezdo-halado<\/a>\/<\/li>\n<\/ul>\n\n\n\n<p><img decoding=\"async\" src=\"https:\/\/fonts.gstatic.com\/s\/e\/notoemoji\/15.0\/1f4cc\/32.png\" alt=\"\ud83d\udccc\">&nbsp;<strong>Excel Kezd\u0151 &amp; Halad\u00f3 Tank\u00f6nyv<\/strong><\/p>\n\n\n\n<p>Ha szorgalmas vagy \u00e9s szeretsz \u00f6n\u00e1ll\u00f3an tanulni, szeretn\u00e9l hasznos tippeket, billenty\u0171kombin\u00e1ci\u00f3kat \u00e9s f\u00fcggv\u00e9nyeket tanulni, akkor rendeld meg az <a href=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel Kezd\u0151 &amp; Halad\u00f3 tank\u00f6nyv\u00fcnket<\/a>.<\/p>\n\n\n\n<p>A gyakorl\u00e1shoz aj\u00e1nlom a kimondottan kezd\u0151knek k\u00e9sz\u00fclt feladatsorokat, az <a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/excel-nagyagyu\/\" data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/excel-nagyagyu\/\" target=\"_blank\">Excel Kezd\u0151 Tanul\u00f3csomagban <\/a>kedvez\u0151bben jutsz hozz\u00e1 a Tank\u00f6nyvh\u00f6z \u00e9s a feladatokhoz. <\/p>\n\n\n\n<p>N\u00e9zd meg \u00e1tfog\u00f3,\u00a0<strong>9 alkalmas kezd\u0151t\u0151l halad\u00f3ig<\/strong>\u00a0<a href=\"https:\/\/exceltitok.hu\/kezdo-halado\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel tanfolyamainkat<\/a>\u00a0\u2013 alap esetben Windowsra, \u00e9s van\u00a0<a href=\"https:\/\/exceltitok.hu\/mac-excel-tanfolyam\/\" target=\"_blank\" rel=\"noreferrer noopener\">Macintosh Excel tanfolyam<\/a>\u00a0\u00e9s\u00a0<a href=\"https:\/\/exceltitok.hu\/google-tablazatok\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google T\u00e1bl\u00e1zatok tanfolyam<\/a>\u00a0is.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; A CSERE funkci\u00f3val t\u00f6bb helyzetet is megoldhatsz az adott pillanatban. Viszont mindig megt\u00f6rt\u00e9nik a csere automatikusan a HELYETTE f\u00fcggv\u00e9nnyel. Ha m\u00e9g&nbsp;nem ismered: a&nbsp;Keres\u00e9s \u00e9s kijel\u00f6l\u00e9s men\u00fcben tal\u00e1lod&nbsp;a men\u00fcszalag legv\u00e9g\u00e9n, vagy a&nbsp;Ctrl H&nbsp;kombin\u00e1ci\u00f3val h\u00edvhat\u00f3 el\u0151. Itt \u00edrtam r\u00e9szletesen a Windows &#8211; Mac &#8211; Google CSERE k\u00fcl\u00f6nbs\u00e9gekr\u0151l. Az ablakban add meg, hogy mit mire cser\u00e9ln\u00e9l &#8211; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":9794,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-9755","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u21d4 Csere automatikusan - ExcelTitok<\/title>\n<meta name=\"description\" content=\"A CSERE funkci\u00f3val t\u00f6bb helyzetet is megoldhatsz adott pillanatban. Viszont mindig megt\u00f6rt\u00e9nik a csere automatikusan a HELYETTE f\u00fcggv\u00e9nnyel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u21d4 Csere automatikusan - ExcelTitok\" \/>\n<meta property=\"og:description\" content=\"A CSERE funkci\u00f3val t\u00f6bb helyzetet is megoldhatsz adott pillanatban. Viszont mindig megt\u00f6rt\u00e9nik a csere automatikusan a HELYETTE f\u00fcggv\u00e9nnyel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-02T11:01:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-28T22:20:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/10\/csere-helyette-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"810\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/csere-automatikusan\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/csere-automatikusan\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"\u21d4 Csere automatikusan\",\"datePublished\":\"2023-06-02T11:01:15+00:00\",\"dateModified\":\"2025-06-28T22:20:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/csere-automatikusan\\\/\"},\"wordCount\":708,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/csere-automatikusan\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/csere-helyette-excel.png\",\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/csere-automatikusan\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/csere-automatikusan\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/csere-automatikusan\\\/\",\"name\":\"\u21d4 Csere automatikusan - ExcelTitok\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/csere-automatikusan\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/csere-automatikusan\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/csere-helyette-excel.png\",\"datePublished\":\"2023-06-02T11:01:15+00:00\",\"dateModified\":\"2025-06-28T22:20:03+00:00\",\"description\":\"A CSERE funkci\u00f3val t\u00f6bb helyzetet is megoldhatsz adott pillanatban. Viszont mindig megt\u00f6rt\u00e9nik a csere automatikusan a HELYETTE f\u00fcggv\u00e9nnyel.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/csere-automatikusan\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/csere-automatikusan\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/csere-automatikusan\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/csere-helyette-excel.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/csere-helyette-excel.png\",\"width\":810,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/csere-automatikusan\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u21d4 Csere automatikusan\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"description\":\"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!\",\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"width\":600,\"height\":133,\"caption\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"caption\":\"Bernadett\"},\"description\":\"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.\",\"sameAs\":[\"http:\\\/\\\/exceltitok.hu\\\/\",\"https:\\\/\\\/www.facebook.com\\\/bernadett.koros\"],\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/author\\\/sos-excel\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u21d4 Csere automatikusan - ExcelTitok","description":"A CSERE funkci\u00f3val t\u00f6bb helyzetet is megoldhatsz adott pillanatban. Viszont mindig megt\u00f6rt\u00e9nik a csere automatikusan a HELYETTE f\u00fcggv\u00e9nnyel.","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:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/","og_locale":"hu_HU","og_type":"article","og_title":"\u21d4 Csere automatikusan - ExcelTitok","og_description":"A CSERE funkci\u00f3val t\u00f6bb helyzetet is megoldhatsz adott pillanatban. Viszont mindig megt\u00f6rt\u00e9nik a csere automatikusan a HELYETTE f\u00fcggv\u00e9nnyel.","og_url":"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2023-06-02T11:01:15+00:00","article_modified_time":"2025-06-28T22:20:03+00:00","og_image":[{"width":810,"height":450,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/10\/csere-helyette-excel.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"5 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"\u21d4 Csere automatikusan","datePublished":"2023-06-02T11:01:15+00:00","dateModified":"2025-06-28T22:20:03+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/"},"wordCount":708,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/10\/csere-helyette-excel.png","articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/","url":"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/","name":"\u21d4 Csere automatikusan - ExcelTitok","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/10\/csere-helyette-excel.png","datePublished":"2023-06-02T11:01:15+00:00","dateModified":"2025-06-28T22:20:03+00:00","description":"A CSERE funkci\u00f3val t\u00f6bb helyzetet is megoldhatsz adott pillanatban. Viszont mindig megt\u00f6rt\u00e9nik a csere automatikusan a HELYETTE f\u00fcggv\u00e9nnyel.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/10\/csere-helyette-excel.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/10\/csere-helyette-excel.png","width":810,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/csere-automatikusan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"\u21d4 Csere automatikusan"}]},{"@type":"WebSite","@id":"https:\/\/sosexcel.com\/exceltippek\/#website","url":"https:\/\/sosexcel.com\/exceltippek\/","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!","publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/sosexcel.com\/exceltippek\/#organization","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","url":"https:\/\/sosexcel.com\/exceltippek\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","width":600,"height":133,"caption":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","caption":"Bernadett"},"description":"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.","sameAs":["http:\/\/exceltitok.hu\/","https:\/\/www.facebook.com\/bernadett.koros"],"url":"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9755","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=9755"}],"version-history":[{"count":9,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9755\/revisions"}],"predecessor-version":[{"id":9961,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9755\/revisions\/9961"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/9794"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=9755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=9755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=9755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}