{"id":13343,"date":"2023-04-21T10:06:31","date_gmt":"2023-04-21T10:06:31","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=13343"},"modified":"2023-04-21T23:10:23","modified_gmt":"2023-04-21T23:10:23","slug":"las-funciones-derecha-izquierda-y-extrae-en-excel","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/","title":{"rendered":"LAS FUNCIONES DERECHA IZQUIERDA Y EXTRAE EN EXCEL"},"content":{"rendered":"<p>Las funciones <em><strong>DERECHA, IZQUIERDA <\/strong><\/em>y\u00a0<em><strong>EXTRAE<\/strong><\/em> son funciones de texto en Excel que se utilizan para extraer una parte espec\u00edfica de un texto o cadena de caracteres en una celda determinada.<\/p>\n<p>La funci\u00f3n <em><strong>DERECHA <\/strong><\/em>extrae los caracteres del lado derecho del texto, mientras que la funci\u00f3n <em><strong>IZQUIERDA<\/strong><\/em> extrae los caracteres del lado izquierdo del texto. La funci\u00f3n<em><strong> EXTRAE<\/strong><\/em>, extrae una cantidad determinada de caracteres a partir de una posici\u00f3n espec\u00edfica dentro del texto.<\/p><div id=\"excel-3556313168\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<h6>Veamos cada una de ellas:<\/h6>\n<h6>Funci\u00f3n DERECHA:<\/h6>\n<p>Esta funci\u00f3n nos permite extraer una cierta cantidad de caracteres desde el lado derecho de un texto en una celda.<\/p>\n<hr \/>\n<h6 style=\"text-align: center;\">La sintaxis de la funci\u00f3n DERECHA es:<\/h6>\n<p style=\"text-align: center;\"><strong>=DERECHA(texto, [n\u00fam_de_caracteres])<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13345\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/der.png\" alt=\"funci\u00f3n derecha\" width=\"582\" height=\"262\" \/><\/p>\n<ul>\n<li><strong>Texto (obligatorio):<\/strong> La cadena de texto que contiene los caracteres que deseamos extraer.<\/li>\n<li><strong>N\u00fam_de_caracteres (opcional):<\/strong> El n\u00famero de caracteres que deseamos extraer.<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">Si no se especifica el n\u00famero de caracteres, entonces la funci\u00f3n devolver\u00e1 solamente el \u00faltimo car\u00e1cter de la cadena de texto. Si, por el contrario, el n\u00famero de caracteres especificado excede la longitud de la cadena de texto, entonces se devolver\u00e1 el texto completo.<\/p>\n<h6>Funci\u00f3n IZQUIERDA:<\/h6>\n<p>Esta funci\u00f3n es similar a la funci\u00f3n DERECHA, pero extrae caracteres desde el lado izquierdo de un texto en una celda.<\/p>\n<hr \/>\n<h6 style=\"text-align: center;\">La sintaxis de la funci\u00f3n IZQUIERDA es:<\/h6>\n<p style=\"text-align: center;\"><strong>=IZQUIERDA(texto, [n\u00fam_de_caracteres])<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13344\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/izq.png\" alt=\"funci\u00f3n izquierda\" width=\"589\" height=\"265\" \/><\/p>\n<hr \/>\n<ul>\n<li><strong>Texto (obligatorio):<\/strong> La cadena de texto de la cual se obtendr\u00e1n los caracteres de la izquierda.<\/li>\n<li><strong>N\u00fam_de_caracteres (opcional):<\/strong> La cantidad de caracteres que ser\u00e1n extra\u00eddos de la cadena de texto.<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">Si omitimos el segundo argumento, la funci\u00f3n IZQUIERDA asumir\u00e1 que solamente deseamos el primer car\u00e1cter de la izquierda de la cadena de texto.<\/p>\n<h6>Funci\u00f3n EXTRAE:<\/h6>\n<p>Esta funci\u00f3n nos permite extraer una cantidad espec\u00edfica de caracteres desde una posici\u00f3n determinada en un texto en una celda.<\/p>\n<hr \/>\n<h6 style=\"text-align: center;\">La sintaxis de la funci\u00f3n EXTRAE es:<\/h6>\n<p style=\"text-align: center;\"><strong>=EXTRAE((texto, posici\u00f3n_inicial, n\u00fam_de_caracteres)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13346\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/extrae.png\" alt=\"funci\u00f3n extrae\" width=\"576\" height=\"289\" \/><\/p>\n<ul>\n<li><strong>texto (obligatorio):<\/strong> Cadena de texto que tiene los caracteres que deseamos extraer.<\/li>\n<li><strong>posici\u00f3n_inicial (obligatorio):<\/strong> Posici\u00f3n del primer caracter.<\/li>\n<li><strong>n\u00fam_de_caracteres (obligatorio):<\/strong> N\u00famero de caracteres a extraer a partir de la posici\u00f3n inicial.<\/li>\n<\/ul>\n<h6>EJEMPLO DE LAS FUNCIONES DERECHA, IZQUIERDA Y EXTRAE EN EXCEL<\/h6>\n<p><iframe loading=\"lazy\" title=\"13- Funciones DERECHA, IZQUIERDA y EXTRAE\" src=\"https:\/\/player.vimeo.com\/video\/417785586?h=ff3446c5f3&amp;dnt=1&amp;app_id=122963\" width=\"960\" height=\"540\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<p>Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\"><strong>Facebook<\/strong><\/a><\/span> e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\"><strong>Instagram<\/strong><\/a><\/span>.<\/p>\n<p>D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/p>\n<p>Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\"><strong>Curso de Excel Online<\/strong><\/a><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Las funciones DERECHA, IZQUIERDA y\u00a0EXTRAE &#8230; <a title=\"LAS FUNCIONES DERECHA IZQUIERDA Y EXTRAE EN EXCEL\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/\" aria-label=\"Leer m\u00e1s sobre LAS FUNCIONES DERECHA IZQUIERDA Y EXTRAE EN EXCEL\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":13353,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[328,549,556,570],"tags":[625,626,575,624],"class_list":["post-13343","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-intermedio","category-funciones-especiales","category-texto","tag-derecha","tag-extraer","tag-funciones","tag-izquierda","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>LAS FUNCIONES DERECHA IZQUIERDA Y EXTRAE EN EXCEL<\/title>\n<meta name=\"description\" content=\"Las funciones DERECHA, IZQUIERDA y EXTRAE en Excel se utilizan para extraer una parte espec\u00edfica de un texto o cadena de caracteres.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"LAS FUNCIONES DERECHA IZQUIERDA Y EXTRAE EN EXCEL\" \/>\n<meta property=\"og:description\" content=\"Las funciones DERECHA, IZQUIERDA y EXTRAE en Excel se utilizan para extraer una parte espec\u00edfica de un texto o cadena de caracteres.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-21T10:06:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-21T23:10:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LAS-FUNCIONES-DERECHA-IZQUIERDA-Y-EXTRAE-EN-EXCEL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"LAS FUNCIONES DERECHA IZQUIERDA Y EXTRAE EN EXCEL\",\"datePublished\":\"2023-04-21T10:06:31+00:00\",\"dateModified\":\"2023-04-21T23:10:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/\"},\"wordCount\":446,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LAS-FUNCIONES-DERECHA-IZQUIERDA-Y-EXTRAE-EN-EXCEL.png\",\"keywords\":[\"derecha\",\"extraer\",\"funciones\",\"izquierda\"],\"articleSection\":[\"Excel\",\"Excel Intermedio\",\"Funciones Especiales\",\"Texto\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/\",\"url\":\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/\",\"name\":\"LAS FUNCIONES DERECHA IZQUIERDA Y EXTRAE EN EXCEL\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LAS-FUNCIONES-DERECHA-IZQUIERDA-Y-EXTRAE-EN-EXCEL.png\",\"datePublished\":\"2023-04-21T10:06:31+00:00\",\"dateModified\":\"2023-04-21T23:10:23+00:00\",\"description\":\"Las funciones DERECHA, IZQUIERDA y EXTRAE en Excel se utilizan para extraer una parte espec\u00edfica de un texto o cadena de caracteres.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LAS-FUNCIONES-DERECHA-IZQUIERDA-Y-EXTRAE-EN-EXCEL.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LAS-FUNCIONES-DERECHA-IZQUIERDA-Y-EXTRAE-EN-EXCEL.png\",\"width\":1280,\"height\":720,\"caption\":\"LAS FUNCIONES DERECHA, IZQUIERDA Y EXTRAE EN EXCEL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LAS FUNCIONES DERECHA IZQUIERDA Y EXTRAE EN EXCEL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"LAS FUNCIONES DERECHA IZQUIERDA Y EXTRAE EN EXCEL","description":"Las funciones DERECHA, IZQUIERDA y EXTRAE en Excel se utilizan para extraer una parte espec\u00edfica de un texto o cadena de caracteres.","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:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"LAS FUNCIONES DERECHA IZQUIERDA Y EXTRAE EN EXCEL","og_description":"Las funciones DERECHA, IZQUIERDA y EXTRAE en Excel se utilizan para extraer una parte espec\u00edfica de un texto o cadena de caracteres.","og_url":"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2023-04-21T10:06:31+00:00","article_modified_time":"2023-04-21T23:10:23+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LAS-FUNCIONES-DERECHA-IZQUIERDA-Y-EXTRAE-EN-EXCEL.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"LAS FUNCIONES DERECHA IZQUIERDA Y EXTRAE EN EXCEL","datePublished":"2023-04-21T10:06:31+00:00","dateModified":"2023-04-21T23:10:23+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/"},"wordCount":446,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LAS-FUNCIONES-DERECHA-IZQUIERDA-Y-EXTRAE-EN-EXCEL.png","keywords":["derecha","extraer","funciones","izquierda"],"articleSection":["Excel","Excel Intermedio","Funciones Especiales","Texto"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/","url":"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/","name":"LAS FUNCIONES DERECHA IZQUIERDA Y EXTRAE EN EXCEL","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LAS-FUNCIONES-DERECHA-IZQUIERDA-Y-EXTRAE-EN-EXCEL.png","datePublished":"2023-04-21T10:06:31+00:00","dateModified":"2023-04-21T23:10:23+00:00","description":"Las funciones DERECHA, IZQUIERDA y EXTRAE en Excel se utilizan para extraer una parte espec\u00edfica de un texto o cadena de caracteres.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LAS-FUNCIONES-DERECHA-IZQUIERDA-Y-EXTRAE-EN-EXCEL.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/04\/LAS-FUNCIONES-DERECHA-IZQUIERDA-Y-EXTRAE-EN-EXCEL.png","width":1280,"height":720,"caption":"LAS FUNCIONES DERECHA, IZQUIERDA Y EXTRAE EN EXCEL"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/las-funciones-derecha-izquierda-y-extrae-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"LAS FUNCIONES DERECHA IZQUIERDA Y EXTRAE EN EXCEL"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=13343"}],"version-history":[{"count":6,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13343\/revisions"}],"predecessor-version":[{"id":13361,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13343\/revisions\/13361"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/13353"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=13343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=13343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=13343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}