{"id":3643,"date":"2016-07-12T18:46:58","date_gmt":"2016-07-12T16:46:58","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=3643"},"modified":"2021-07-12T11:59:10","modified_gmt":"2021-07-12T09:59:10","slug":"vezetek-es-keresztnev","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/","title":{"rendered":"Hogyan szedd sz\u00e9t a neveket vezet\u00e9k \u00e9s keresztn\u00e9v oszlopba?"},"content":{"rendered":"

Biztos okozott m\u00e1r bossz\u00fas\u00e1got, hogy egy list\u00e1ban egy cell\u00e1ban szerepeltek a\u00a0nevek, Neked viszont k\u00fcl\u00f6n kellett a vezet\u00e9k \u00e9s keresztn\u00e9v.<\/p>\n

Ezent\u00fal haszn\u00e1ld a Adatok men\u00fc\u00a0Sz\u00f6vegb\u0151l oszlopok<\/strong> funkci\u00f3t, \u00e9s p\u00e1r pillanat alatt elk\u00e9sz\u00fclsz a feladattal.<\/p>\n

Jel\u00f6ld ki azt az adatoszlopot, amelyet sz\u00e9t akarsz v\u00e1lasztani!\u00a0Ha nincs list\u00e1d, akkor haszn\u00e1ld ezt az Excel f\u00e1jlt<\/a>.<\/p>\n

Majd kattints\u00a0a men\u00fcsor Adatok f\u00fcl\u00e9n, \u00e9s azon a Sz\u00f6vegb\u0151l oszlopok gombra!<\/p>\n

A vezet\u00e9k \u00e9s keresztn\u00e9v hat\u00e1r\u00e1n<\/h3>\n

A Var\u00e1zsl\u00f3 megjelenik a k\u00e9perny\u0151n.<\/p>\n

\"Vezet\u00e9k<\/a>Itt v\u00e1laszd a tagolt sz\u00e9less\u00e9get, mivel a vezet\u00e9k- \u00e9s keresztn\u00e9v k\u00f6z\u00f6tt egy\u00a0sz\u00f3k\u00f6z szerepel.<\/strong><\/p>\n

A k\u00f6vetkez\u0151 l\u00e9p\u00e9sben meg is kell adnod, mint az elv\u00e1laszt\u00e1s\u00e1ra szolg\u00e1l\u00f3 speci\u00e1lis elv\u00e1laszt\u00f3jelet.<\/p>\n

Ez egy\u00e9bk\u00e9nt lehet m\u00e9g vessz\u0151, pontosvessz\u0151, tabul\u00e1tor, vagy tetsz\u0151leges karakter is lehet.<\/p>\n

Az ablak alj\u00e1n r\u00f6gt\u00f6n megjelenik a minta.<\/strong><\/p>\n

Ha ez megfelel \u00e9s az eredeti adatokra tov\u00e1bb m\u00e1r nincs sz\u00fcks\u00e9ged, akkor kattints a Befejez\u00e9s gombra.<\/p>\n

Hov\u00e1 ker\u00fclj\u00f6n a vezet\u00e9k \u00e9s keresztn\u00e9v<\/h3>\n

Ha azonban \u00faj helyet akarsz megadni az adatoknak, akkor a 3. l\u00e9p\u00e9sben a Rendeltet\u00e9si hely mez\u0151ben add meg a kezd\u0151 cella<\/strong>\u00a0hivatkoz\u00e1s\u00e1t<\/strong>.<\/p>\n

\"Add<\/a>A Befejez\u00e9s gombra kattintva (vagy Enter<\/a>) n\u00e9ha akkor is felugrik egy figyelmeztet\u0151 ablak, hogy a cell\u00e1k adatot tartalmaznak, ha teljesen \u00fcres oszlopok\u00a0vannak.<\/p>\n

Ilyenkor mindig ellen\u0151rizd, hogy nem t\u00f6r\u00f6lt\u00e9l-e ki fontos adatot, \u00e9s ha kell, gyorsan l\u00e9pj vissza a Ctrl Z-vel.<\/p>\n

Mivel 2-n\u00e9l t\u00f6bb n\u00e9vb\u0151l is \u00e1llhat egy ember neve, s\u0151t, n\u00e9ha (f\u0151leg adatb\u00e1zis exportn\u00e1l) extra karakterek is szerepelhetnek a v\u00e9g\u00e9n, jobb, ha b\u0151s\u00e9gesen hagysz helyet az \u00faj adatoknak.<\/p>\n

Ellen\u0151rizd a nevek sz\u00e9tv\u00e1laszt\u00e1s\u00e1t!<\/h3>\n

A 3 vagy t\u00f6bb vezet\u00e9k \u00e9s keresztn\u00e9vb\u0151l \u00e1ll\u00f3 eseteket t\u00e9telesen n\u00e9zd \u00e1t<\/strong>.\u00a0A sz\u0171r\u0151 seg\u00edts\u00e9g\u00e9vel<\/a> k\u00f6nnyen kikeresheted \u0151ket, a t\u00f6bbszint\u0171 rendez\u00e9ssel<\/a> pedig becsoportos\u00edthatod \u0151ket. S\u0151t, adott esetben az el\u0151tagokra (ifj., dr.) is gondolnod kell, vagy el\u0151fordulhat, hogy k\u00fclf\u00f6ldi (azaz ford\u00edtott) nevek is szerepelnek az adatb\u00e1zisodban.<\/p>\n

Ha szeretn\u00e9d lev\u00e9lben megsz\u00f3l\u00edt\u00e1sk\u00e9nt haszn\u00e1lni a keresztnevet<\/strong>, akkor a „Kov\u00e1cs J\u00e1nosn\u00e9” \u00e9s t\u00e1rsai eset\u00e9ben m\u00e9rlegeld, hogy hogyan teszed.<\/p>\n

Egy\u00e9b megold\u00e1sok a keresztn\u00e9v kinyer\u00e9s\u00e9re<\/b><\/h2>\n

Term\u00e9szetesen\u00a0a nevek sz\u00e9tv\u00e1laszt\u00e1s\u00e1ra\u00a0haszn\u00e1lhatsz f\u00fcggv\u00e9nyes megold\u00e1st is (SZ\u00d6VEG.KERES, JOBB, BAL, …). Ennek el\u0151nye – f\u0151leg, ha T\u00e1bl\u00e1zat form\u00e1tumot<\/span><\/a> haszn\u00e1lsz -, hogy az \u00faj adatokra is sz\u00e1mol.<\/p>\n

A 2013-as verzi\u00f3t\u00f3l pedig a Vill\u00e1mkit\u00f6lt\u00e9s<\/a><\/span> funkci\u00f3t. Ez nagyon gyors, viszont ugyan\u00fagy statikus (a pillanatnyi adatokra v\u00e9gzi el az \u00e1talak\u00edt\u00e1st), mint a Sz\u00f6vegb\u0151l oszlopok funkci\u00f3.<\/p>\n

A Power Query eszk\u00f6zzel<\/span><\/a> egy m\u00e9g magasabb szinten automatiz\u00e1lhatod az adattiszt\u00edt\u00e1st, adat\u00e1talak\u00edt\u00e1st (\u00e9s elemz\u00e9st). Ez a 2016-os verzi\u00f3t\u00f3l r\u00e9sze az Excelnek, a 2013-ashoz k\u00fcl\u00f6n let\u00f6lthet\u0151.<\/p>\n

Hasznos volt a bejegyz\u00e9s?<\/h2>\n

Oszd meg, hogy m\u00e1sok is tudjanak r\u00f3la!<\/p>\n

J\u00f3l j\u00f6nne m\u00e9g t\u00f6bb Excel tipp, \u00e9s probl\u00e9ma eset\u00e9n a gyors seg\u00edts\u00e9g? Csatlakozz a Titkos Klubunk<\/a><\/span>ba, ahol nemcsak a k\u00e9rd\u00e9seidet tudod feltenni, hanem sz\u00e1mtalan hasznos tippet is kapsz. Ha szem\u00e9lyre szabott seg\u00edts\u00e9get szeretn\u00e9l, gyere egy\u00e9ni Excel tanfolyamra<\/span><\/a>!<\/p>\n

M\u00e9g t\u00f6bb hasznos tipp:<\/span><\/strong><\/p>\n

7 hasznos Excel tr\u00fckk, amivel id\u0151t nyerhetsz<\/span><\/a><\/p>\n

Gyorsabb k\u00e9pletez\u00e9s: itt is haszn\u00e1lj billenty\u0171zetet!<\/a><\/span><\/p>\n\n","protected":false},"excerpt":{"rendered":"

Biztos okozott m\u00e1r bossz\u00fas\u00e1got, hogy egy list\u00e1ban egy cell\u00e1ban szerepeltek a\u00a0nevek, Neked viszont k\u00fcl\u00f6n kellett a vezet\u00e9k \u00e9s keresztn\u00e9v. Ezent\u00fal haszn\u00e1ld a Adatok men\u00fc\u00a0Sz\u00f6vegb\u0151l oszlopok funkci\u00f3t, \u00e9s p\u00e1r pillanat alatt elk\u00e9sz\u00fclsz a feladattal.<\/p>\n","protected":false},"author":1,"featured_media":3646,"comment_status":"open","ping_status":"open","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":"default","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":[69,78,34],"class_list":["post-3643","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-adatkezeles","tag-gyakorlo-feladat","tag-szovegek"],"yoast_head":"\nHogyan szedd sz\u00e9t a neveket vezet\u00e9k \u00e9s keresztn\u00e9v oszlopba? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"K\u00fcl\u00f6n oszlopban kell a vezet\u00e9k \u00e9s keresztn\u00e9v? Az Excel remek funkci\u00f3t k\u00e9sz\u00edtett a nevek sz\u00e9tv\u00e1laszt\u00e1s\u00e1ra.\" \/>\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\/vezetek-es-keresztnev\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hogyan szedd sz\u00e9t a neveket vezet\u00e9k \u00e9s keresztn\u00e9v oszlopba? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"K\u00fcl\u00f6n oszlopban kell a vezet\u00e9k \u00e9s keresztn\u00e9v? Az Excel remek funkci\u00f3t k\u00e9sz\u00edtett a nevek sz\u00e9tv\u00e1laszt\u00e1s\u00e1ra.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/\" \/>\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=\"2016-07-12T16:46:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-12T09:59:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/nevek.png\" \/>\n\t<meta property=\"og:image:width\" content=\"629\" \/>\n\t<meta property=\"og:image:height\" content=\"205\" \/>\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=\"3 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/vezetek-es-keresztnev\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/vezetek-es-keresztnev\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Hogyan szedd sz\u00e9t a neveket vezet\u00e9k \u00e9s keresztn\u00e9v oszlopba?\",\"datePublished\":\"2016-07-12T16:46:58+00:00\",\"dateModified\":\"2021-07-12T09:59:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/vezetek-es-keresztnev\\\/\"},\"wordCount\":673,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/vezetek-es-keresztnev\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/nevek.png\",\"keywords\":[\"adatkezel\u00e9s\",\"gyakorl\u00f3 feladat\",\"sz\u00f6vegek\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/vezetek-es-keresztnev\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/vezetek-es-keresztnev\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/vezetek-es-keresztnev\\\/\",\"name\":\"Hogyan szedd sz\u00e9t a neveket vezet\u00e9k \u00e9s keresztn\u00e9v oszlopba? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/vezetek-es-keresztnev\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/vezetek-es-keresztnev\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/nevek.png\",\"datePublished\":\"2016-07-12T16:46:58+00:00\",\"dateModified\":\"2021-07-12T09:59:10+00:00\",\"description\":\"K\u00fcl\u00f6n oszlopban kell a vezet\u00e9k \u00e9s keresztn\u00e9v? Az Excel remek funkci\u00f3t k\u00e9sz\u00edtett a nevek sz\u00e9tv\u00e1laszt\u00e1s\u00e1ra.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/vezetek-es-keresztnev\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/vezetek-es-keresztnev\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/vezetek-es-keresztnev\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/nevek.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/nevek.png\",\"width\":629,\"height\":205},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/vezetek-es-keresztnev\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hogyan szedd sz\u00e9t a neveket vezet\u00e9k \u00e9s keresztn\u00e9v oszlopba?\"}]},{\"@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":"Hogyan szedd sz\u00e9t a neveket vezet\u00e9k \u00e9s keresztn\u00e9v oszlopba? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"K\u00fcl\u00f6n oszlopban kell a vezet\u00e9k \u00e9s keresztn\u00e9v? Az Excel remek funkci\u00f3t k\u00e9sz\u00edtett a nevek sz\u00e9tv\u00e1laszt\u00e1s\u00e1ra.","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\/vezetek-es-keresztnev\/","og_locale":"hu_HU","og_type":"article","og_title":"Hogyan szedd sz\u00e9t a neveket vezet\u00e9k \u00e9s keresztn\u00e9v oszlopba? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"K\u00fcl\u00f6n oszlopban kell a vezet\u00e9k \u00e9s keresztn\u00e9v? Az Excel remek funkci\u00f3t k\u00e9sz\u00edtett a nevek sz\u00e9tv\u00e1laszt\u00e1s\u00e1ra.","og_url":"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2016-07-12T16:46:58+00:00","article_modified_time":"2021-07-12T09:59:10+00:00","og_image":[{"width":629,"height":205,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/nevek.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"3 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Hogyan szedd sz\u00e9t a neveket vezet\u00e9k \u00e9s keresztn\u00e9v oszlopba?","datePublished":"2016-07-12T16:46:58+00:00","dateModified":"2021-07-12T09:59:10+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/"},"wordCount":673,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/nevek.png","keywords":["adatkezel\u00e9s","gyakorl\u00f3 feladat","sz\u00f6vegek"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/","url":"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/","name":"Hogyan szedd sz\u00e9t a neveket vezet\u00e9k \u00e9s keresztn\u00e9v oszlopba? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/nevek.png","datePublished":"2016-07-12T16:46:58+00:00","dateModified":"2021-07-12T09:59:10+00:00","description":"K\u00fcl\u00f6n oszlopban kell a vezet\u00e9k \u00e9s keresztn\u00e9v? Az Excel remek funkci\u00f3t k\u00e9sz\u00edtett a nevek sz\u00e9tv\u00e1laszt\u00e1s\u00e1ra.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/nevek.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/nevek.png","width":629,"height":205},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Hogyan szedd sz\u00e9t a neveket vezet\u00e9k \u00e9s keresztn\u00e9v oszlopba?"}]},{"@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\/3643","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=3643"}],"version-history":[{"count":16,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/3643\/revisions"}],"predecessor-version":[{"id":9200,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/3643\/revisions\/9200"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/3646"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=3643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=3643"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=3643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}