{"id":4590,"date":"2018-05-19T20:24:42","date_gmt":"2018-05-20T01:24:42","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=4590"},"modified":"2025-04-02T01:13:04","modified_gmt":"2025-04-02T06:13:04","slug":"extraer-textos","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/","title":{"rendered":"Extraer texto en Excel"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-como-extraer-texto-en-excel-de-forma-automatica\"><span style=\"vertical-align: inherit;\"><span style=\"vertical-align: inherit;\">C\u00f3mo Extraer Texto en Excel de Forma Autom\u00e1tica<\/span><\/span><\/h1>\n\n\n\n<p>Extraer informaci\u00f3n espec\u00edfica de una celda en Excel es una tarea com\u00fan, sobre todo cuando los datos se presentan en un formato estructurado, como correos y contrase\u00f1as separados por un s\u00edmbolo espec\u00edfico. En esta gu\u00eda, aprender\u00e1s a extraer texto en Excel utilizando funciones como <strong>ENCONTRAR<\/strong> y <strong>EXTRAER<\/strong>, para optimizar tu trabajo con grandes vol\u00famenes de datos.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Separar o Extraer textos de una Celda - Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/FdATXPJUzlI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\" style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"h-descargar-material-de-apoyo\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left\">\u00bfListo para poner en pr\u00e1ctica el tutorial? Descarga el \u00abmaterial de apoyo\u00bb y trabaja con el mismo archivo que usamos en el video.<\/p>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-576bb6\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-631202 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/material_de_apoyo\/tutoriales_excel\/extraer_textos.zip\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 48 41.6\"><g><path d=\"M30.777 0a17.252 17.252 0 0 0-15.969 10.734 12.026 12.026 0 1 0-5.2 23.479 2.084 2.084 0 0 0 .413.042 2.051 2.051 0 0 0 .409-4.06 7.924 7.924 0 0 1 1.6-15.686 7.84 7.84 0 0 1 3.231.691l2.2.986.617-2.333a13.132 13.132 0 0 1 25.821 3.372 12.993 12.993 0 0 1-4.169 9.6 2.052 2.052 0 0 0 2.8 3A17.229 17.229 0 0 0 30.779.002\"><\/path><path d=\"M34.188 29.466h-5.18V15.578a1.164 1.164 0 0 0-1.164-1.164h-3.94a1.164 1.164 0 0 0-1.164 1.164v13.888h-5.18a1.164 1.164 0 0 0-.888 1.917l8.314 9.8a1.164 1.164 0 0 0 1.775 0l8.315-9.8a1.164 1.164 0 0 0-.888-1.917\"><\/path><\/g><\/svg><\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<p>\u00bf\ud83d\ude80Quieres llevar tus habilidades en Excel al siguiente nivel y destacar en tu trabajo? Un<strong> <a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos\/curso-excel-avanzado\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso de Excel Avanzad<\/a>o<\/strong> es la clave para optimizar tu productividad, automatizar tareas y manejar datos como un profesional. Aprender\u00e1s desde funciones avanzadas hasta el uso de macros y tablas din\u00e1micas para agilizar tus procesos. \u2705<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfPor qu\u00e9 extraer texto en Excel?<\/h2>\n\n\n\n<p>Cuando trabajas con bases de datos exportadas, es com\u00fan que la informaci\u00f3n venga en una sola celda, separada por un delimitador (por ejemplo, dos puntos \u00ab:\u00bb). Para procesar estos datos de manera eficiente, Excel ofrece funciones que permiten dividir y extraer informaci\u00f3n r\u00e1pidamente.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Paso a Paso: Extraer Texto de una Celda en Excel<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. Encontrar la Posici\u00f3n del Separador<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"c6cfd6\" data-has-transparency=\"true\" style=\"--dominant-color: #c6cfd6;\" decoding=\"async\" width=\"557\" height=\"62\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-46.png\" alt=\"\" class=\"wp-image-24388 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-46.png 557w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-46-300x33.avif 300w\" sizes=\"(max-width: 557px) 100vw, 557px\" \/><\/figure>\n\n\n\n<p>Para extraer datos correctamente, primero necesitamos conocer la ubicaci\u00f3n del separador en la celda. Para esto, usamos la funci\u00f3n <strong>ENCONTRAR<\/strong>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Uso de la funci\u00f3n ENCONTRAR<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>=ENCONTRAR(\":\", A2)<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u00ab:\u00bb<\/strong> es el caracter que queremos localizar.<\/li>\n\n\n\n<li><strong>A2<\/strong> es la celda donde se encuentra el texto.<\/li>\n<\/ul>\n\n\n\n<p>Este f\u00f3rmula devuelve la posici\u00f3n exacta del separador en la celda.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Extraer la Contrase\u00f1a<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"cbcfd7\" data-has-transparency=\"true\" style=\"--dominant-color: #cbcfd7;\" decoding=\"async\" width=\"627\" height=\"64\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-47.png\" alt=\"\" class=\"wp-image-24389 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-47.png 627w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-47-300x31.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-47-600x61.avif 600w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/figure>\n\n\n\n<p>Una vez que conocemos la posici\u00f3n del separador, podemos usar la funci\u00f3n <strong>EXTRAER<\/strong> para obtener el texto despu\u00e9s de los dos puntos.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Uso de la funci\u00f3n EXTRAER<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>=EXTRAER(A2, ENCONTRAR(\":\", A2) + 1, 100)<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>A2<\/strong> es la celda con el texto original.<\/li>\n\n\n\n<li><strong>ENCONTRAR(\u00ab:\u00bb, A2) + 1<\/strong> nos da la posici\u00f3n inicial del texto despu\u00e9s de los dos puntos.<\/li>\n\n\n\n<li><strong>100<\/strong> es el n\u00famero m\u00e1ximo de caracteres que esperamos extraer.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">3. Extraer el Correo Electr\u00f3nico<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"d0d5db\" data-has-transparency=\"true\" style=\"--dominant-color: #d0d5db;\" fetchpriority=\"high\" decoding=\"async\" width=\"774\" height=\"69\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-48.png\" alt=\"\" class=\"wp-image-24390 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-48.png 774w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-48-300x27.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-48-768x68.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-48-600x53.avif 600w\" sizes=\"(max-width: 774px) 100vw, 774px\" \/><\/figure>\n\n\n\n<p>Para obtener el correo antes del separador, tambi\u00e9n utilizamos <strong>EXTRAER<\/strong>, pero limitamos la cantidad de caracteres hasta la posici\u00f3n del separador menos uno.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=EXTRAER(A2, 1, ENCONTRAR(\":\", A2) - 1)<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>1<\/strong> indica que la extracci\u00f3n comienza desde el inicio del texto.<\/li>\n\n\n\n<li><strong>ENCONTRAR(\u00ab:\u00bb, A2) &#8211; 1<\/strong> define la cantidad de caracteres a extraer, excluyendo el separador.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Automatizaci\u00f3n en una Sola F\u00f3rmula<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-dominant-color=\"cfd5dc\" data-has-transparency=\"true\" style=\"--dominant-color: #cfd5dc;\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"54\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-49-1024x54.avif\" alt=\"\" class=\"wp-image-24391 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-49-1024x54.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-49-300x16.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-49-768x40.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-49-600x32.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-49.png 1103w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Si deseas hacer todo en una sola celda sin c\u00e1lculos intermedios, puedes unir ambas funciones:<\/p>\n\n\n\n<p><strong>Para extraer la contrase\u00f1a:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=EXTRAER(A2, ENCONTRAR(\":\", A2) + 1, 100)<\/code><\/pre>\n\n\n\n<p><strong>Para extraer el correo:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=EXTRAER(A2, 1, ENCONTRAR(\":\", A2) - 1)<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Utilizando estas f\u00f3rmulas en Excel, puedes separar r\u00e1pidamente informaci\u00f3n de grandes vol\u00famenes de datos sin necesidad de hacerlo manualmente. Esta t\u00e9cnica es especialmente \u00fatil al trabajar con bases de datos, reportes y cualquier otro conjunto de datos estructurados.<\/p>\n\n\n\n<p>\ud83d\udcbb \u00bfNecesitas licencias originales de Windows y Office al mejor precio? <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\" target=\"_blank\" rel=\"noreferrer noopener\">Keysfan<\/a><\/strong> es la opci\u00f3n ideal para obtener software 100 % genuino a precios accesibles. Con el c\u00f3digo de descuento <strong>DH66<\/strong>, puedes ahorrar a\u00fan m\u00e1s en tus compras. No pierdas la oportunidad de actualizar tu sistema con licencias seguras y econ\u00f3micas.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-preguntas-frecuentes-faq\">Preguntas Frecuentes (FAQ)<\/h3>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-52d1d70d uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-67135745 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfSe puede hacer esto sin funciones en Excel?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, tambi\u00e9n puedes usar \u00abTexto en columnas\u00bb desde la pesta\u00f1a \u00abDatos\u00bb, pero las funciones te permiten mayor automatizaci\u00f3n.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-dba9325b \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfQu\u00e9 pasa si el delimitador cambia?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Solo necesitas reemplazar los <strong>\u00ab:\u00bb<\/strong> en las f\u00f3rmulas por el nuevo separador.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-66c15e86 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfFunciona con cualquier cantidad de caracteres?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, pero si hay datos muy largos, puedes aumentar el valor de caracteres extra\u00eddos (por ejemplo, cambiar <strong>100<\/strong> por un n\u00famero mayor).<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-d171413a \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPuedo extraer texto en Excel cuando hay varios separadores en una celda?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, en ese caso puedes usar la funci\u00f3n <strong>HALLAR<\/strong> o <strong>DIVIDIRTEXTO<\/strong> (en versiones m\u00e1s recientes de Excel) para manejar m\u00faltiples separadores. Tambi\u00e9n puedes combinar funciones como <strong>EXTRAE<\/strong>, <strong>DERECHA<\/strong> o <strong>IZQUIERDA<\/strong> para obtener diferentes fragmentos del texto.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-6ae7facb \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfC\u00f3mo extraer texto en Excel si los datos tienen longitudes variables?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Si la longitud del texto a extraer var\u00eda, puedes usar <strong>LARGO(A2)<\/strong> para calcular la cantidad de caracteres restantes despu\u00e9s del separador y ajustar la f\u00f3rmula en consecuencia.<\/p><\/div><\/div><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n","protected":false},"excerpt":{"rendered":"<p>Aprende a extraer texto en Excel desde una celda usando funciones como ENCONTRAR y EXTRAER. Optimiza tu trabajo con esta gu\u00eda pr\u00e1ctica.<\/p>\n","protected":false},"author":4,"featured_media":4870,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"video","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","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":"","adv-header-id-meta":"","stick-header-meta":"","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":[52],"tags":[225,476,486],"class_list":["post-4590","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-excel","tag-textos","tag-tutorial","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Extraer texto en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende a extraer texto en Excel desde una celda usando funciones como ENCONTRAR y EXTRAER. Optimiza tu trabajo con esta gu\u00eda pr\u00e1ctica.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Extraer texto en Excel: Gu\u00eda pr\u00e1ctica f\u00e1cil\" \/>\n<meta property=\"og:description\" content=\"Aprende a extraer texto en Excel con funciones como ENCONTRAR y EXTRAER. Optimiza tus datos y mejora tu productividad.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-20T01:24:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-02T06:13:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"376\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Extraer texto en Excel con Funciones \u00datiles\" \/>\n<meta name=\"twitter:description\" content=\"Aprende a extraer texto en Excel con funciones \u00fatiles para optimizar tu trabajo y manejar datos de manera eficiente.\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin Hurtado\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/extraer-textos\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/extraer-textos\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"Extraer texto en Excel\",\"datePublished\":\"2018-05-20T01:24:42+00:00\",\"dateModified\":\"2025-04-02T06:13:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/extraer-textos\\\/\"},\"wordCount\":545,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/extraer-textos\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/extraer_textos.jpg\",\"keywords\":[\"Excel\",\"textos\",\"Tutorial\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/extraer-textos\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/extraer-textos\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/extraer-textos\\\/\",\"name\":\"Extraer texto en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/extraer-textos\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/extraer-textos\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/extraer_textos.jpg\",\"datePublished\":\"2018-05-20T01:24:42+00:00\",\"dateModified\":\"2025-04-02T06:13:04+00:00\",\"description\":\"Aprende a extraer texto en Excel desde una celda usando funciones como ENCONTRAR y EXTRAER. Optimiza tu trabajo con esta gu\u00eda pr\u00e1ctica.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/extraer-textos\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/extraer-textos\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/extraer-textos\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/extraer_textos.jpg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/extraer_textos.jpg\",\"width\":500,\"height\":376,\"caption\":\"Extraer Textos en Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/extraer-textos\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extraer texto en Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1781532031\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1781532031\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1781532031\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Extraer texto en Excel - Dostin Hurtado","description":"Aprende a extraer texto en Excel desde una celda usando funciones como ENCONTRAR y EXTRAER. Optimiza tu trabajo con esta gu\u00eda pr\u00e1ctica.","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:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/","og_locale":"es_ES","og_type":"article","og_title":"Extraer texto en Excel: Gu\u00eda pr\u00e1ctica f\u00e1cil","og_description":"Aprende a extraer texto en Excel con funciones como ENCONTRAR y EXTRAER. Optimiza tus datos y mejora tu productividad.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/","og_site_name":"Dostin Hurtado","article_published_time":"2018-05-20T01:24:42+00:00","article_modified_time":"2025-04-02T06:13:04+00:00","og_image":[{"width":500,"height":376,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_title":"Extraer texto en Excel con Funciones \u00datiles","twitter_description":"Aprende a extraer texto en Excel con funciones \u00fatiles para optimizar tu trabajo y manejar datos de manera eficiente.","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"Extraer texto en Excel","datePublished":"2018-05-20T01:24:42+00:00","dateModified":"2025-04-02T06:13:04+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/"},"wordCount":545,"commentCount":3,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg","keywords":["Excel","textos","Tutorial"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/","name":"Extraer texto en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg","datePublished":"2018-05-20T01:24:42+00:00","dateModified":"2025-04-02T06:13:04+00:00","description":"Aprende a extraer texto en Excel desde una celda usando funciones como ENCONTRAR y EXTRAER. Optimiza tu trabajo con esta gu\u00eda pr\u00e1ctica.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg","width":500,"height":376,"caption":"Extraer Textos en Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/extraer-textos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Extraer texto en Excel"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"]},{"@type":"Person","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1781532031","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1781532031","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1781532031","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg",500,376,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos-300x226.jpg",300,226,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg",500,376,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg",500,376,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg",500,376,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg",500,376,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg",500,376,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg",500,376,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg",500,376,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg",500,376,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos-400x376.jpg",400,376,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos.jpg",500,376,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/extraer_textos-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":3,"uagb_excerpt":"Aprende a extraer texto en Excel desde una celda usando funciones como ENCONTRAR y EXTRAER. Optimiza tu trabajo con esta gu\u00eda pr\u00e1ctica.","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4590","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=4590"}],"version-history":[{"count":3,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4590\/revisions"}],"predecessor-version":[{"id":25166,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4590\/revisions\/25166"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/4870"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=4590"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=4590"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=4590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}