{"id":12523,"date":"2022-11-02T19:18:39","date_gmt":"2022-11-02T19:18:39","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=12523"},"modified":"2022-11-02T19:22:46","modified_gmt":"2022-11-02T19:22:46","slug":"dividir-texto-en-columnas","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/","title":{"rendered":"DIVIDIR TEXTO EN COLUMNAS"},"content":{"rendered":"<p>El comando Texto en columnas es de gran utilidad para esas ocasiones en las que tenemos una serie de datos y necesitamos dividir ese texto en columnas.<\/p>\n<p>Antes de empezar, debemos aclarar, que es muy importante que las cadenas de texto contengan una separaci\u00f3n con un s\u00edmbolo o un car\u00e1cter delimitador, el cual nos permita identificar cada una de las partes por las cuales haremos la divisi\u00f3n. De lo contrario Excel no podr\u00e1 realizar la operaci\u00f3n.<\/p><div id=\"excel-1637099399\" 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<p>Algunos ejemplos de caracteres delimitadores son: la coma, el punto y coma, el tabulador, el espacio en blanco o cualquier otro s\u00edmbolo o letra que nos permita distinguir visualmente la separaci\u00f3n dentro de la cadena de texto.<\/p>\n<p>El comando <em><strong>Texto en columnas<\/strong><\/em> se encuentra en la ficha <em><strong>Herramientas de datos<\/strong><\/em>, dentro de la pesta\u00f1a <strong><em>Datos<\/em><\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12524 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/texto-en-columnas.png\" alt=\"dividir texto en columnas\" width=\"1076\" height=\"152\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/texto-en-columnas.png 1076w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/texto-en-columnas-1000x141.png 1000w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/texto-en-columnas-768x108.png 768w\" sizes=\"auto, (max-width: 1076px) 100vw, 1076px\" \/><\/p>\n<h6><\/h6>\n<h6 style=\"text-align: center;\">PASOS PARA DIVIDIR UN TEXTO EN COLUMNAS<\/h6>\n<p>1. Seleccionamos la <a href=\"https:\/\/excelfull.com\/excel\/seleccionar-celdas-y-rangos\/\">celda o rango<\/a>\u00a0que contiene el texto que queremos dividir (sin los encabezados) y en la pesta\u00f1a <em><strong>Datos<\/strong> s<\/em>eleccionamos la opci\u00f3n <em><strong>Texto en columnas<\/strong><\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12525\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/dividir-texto.png\" alt=\"\" width=\"286\" height=\"227\" \/><\/p>\n<p><span style=\"font-size: 16px;\">2. Al pulsar el comando <em><strong>Texto en columnas<\/strong><\/em> se mostrar\u00e1 el primer paso del asistente. En el Asistente para convertir texto en columnas, seleccionamos la opci\u00f3n <em><strong>Delimitados, <\/strong><\/em>ya que existe un car\u00e1cter que delimita la separaci\u00f3n de cada palabra que deseamos colocar en diferentes columnas. Una vez hecha esta selecci\u00f3n pulsamos el bot\u00f3n <em><strong>Siguiente<\/strong><\/em>.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12526\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/delimitado.png\" alt=\"\" width=\"509\" height=\"214\" \/><\/p>\n<p>3. Seleccionamos los <em><strong>Delimitadores<\/strong><\/em> para los datos, (el car\u00e1cter por el cual necesitamos hacer la divisi\u00f3n, por ejemplo, Coma y Espacio). Aqui, podemos ver como quedaran las columnas en la ventana <em><strong>Vista previa de datos<\/strong><\/em>. Pulsamos el bot\u00f3n <em><strong>Siguiente<\/strong><\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12527\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/separadores.png\" alt=\"\" width=\"500\" height=\"416\" \/><\/p>\n<p>4. Seleccionamos la celda <em><strong>Destino<\/strong><\/em>, de manera que comience en la celda donde queremos que aparezcan los datos divididos en la hoja de c\u00e1lculo.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12529 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/destino-1.png\" alt=\"\" width=\"873\" height=\"431\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/destino-1.png 873w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/destino-1-768x379.png 768w\" sizes=\"auto, (max-width: 873px) 100vw, 873px\" \/><\/p>\n<p>5. Al pulsar el bot\u00f3n <em><strong>Finalizar<\/strong><\/em>, el texto del rango seleccionado se dividir\u00e1 en varias columnas, colocando una sola palabra en cada una de ellas como se observa en la siguiente imagen. Solo resta escribir los nuevos encabezados de las columnas.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12530 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/texto-dividido.png\" alt=\"dividir texto en columnas\" width=\"524\" height=\"205\" \/><\/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>El comando Texto en columnas &#8230; <a title=\"DIVIDIR TEXTO EN COLUMNAS\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/\" aria-label=\"Leer m\u00e1s sobre DIVIDIR TEXTO EN COLUMNAS\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":12532,"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,346,486],"tags":[496,347,518,517],"class_list":["post-12523","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-basico","category-operaciones-basicas","tag-columnas","tag-excel-basico","tag-separar-nombre-y-apellido-en-excel","tag-separar-texto","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>DIVIDIR TEXTO EN COLUMNAS - EXCELFULL.COM<\/title>\n<meta name=\"description\" content=\"Este comando es de gran utilidad para esas ocasiones en las que tenemos una serie de datos y necesitamos dividir ese texto en columnas.\" \/>\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\/dividir-texto-en-columnas\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DIVIDIR TEXTO EN COLUMNAS - EXCELFULL.COM\" \/>\n<meta property=\"og:description\" content=\"Este comando es de gran utilidad para esas ocasiones en las que tenemos una serie de datos y necesitamos dividir ese texto en columnas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/\" \/>\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=\"2022-11-02T19:18:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-02T19:22:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/DIVIDIR-TEXTO-EN-COLUMNAS.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\/dividir-texto-en-columnas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"DIVIDIR TEXTO EN COLUMNAS\",\"datePublished\":\"2022-11-02T19:18:39+00:00\",\"dateModified\":\"2022-11-02T19:22:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/\"},\"wordCount\":381,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/DIVIDIR-TEXTO-EN-COLUMNAS.png\",\"keywords\":[\"columnas\",\"excel b\u00e1sico\",\"separar nombre y apellido en excel\",\"separar texto\"],\"articleSection\":[\"Excel\",\"Excel B\u00e1sico\",\"Operaciones B\u00e1sicas\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/\",\"url\":\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/\",\"name\":\"DIVIDIR TEXTO EN COLUMNAS - EXCELFULL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/DIVIDIR-TEXTO-EN-COLUMNAS.png\",\"datePublished\":\"2022-11-02T19:18:39+00:00\",\"dateModified\":\"2022-11-02T19:22:46+00:00\",\"description\":\"Este comando es de gran utilidad para esas ocasiones en las que tenemos una serie de datos y necesitamos dividir ese texto en columnas.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/DIVIDIR-TEXTO-EN-COLUMNAS.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/DIVIDIR-TEXTO-EN-COLUMNAS.png\",\"width\":1280,\"height\":720,\"caption\":\"DIVIDIR TEXTO EN COLUMNAS\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#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\":\"DIVIDIR TEXTO EN COLUMNAS\"}]},{\"@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":"DIVIDIR TEXTO EN COLUMNAS - EXCELFULL.COM","description":"Este comando es de gran utilidad para esas ocasiones en las que tenemos una serie de datos y necesitamos dividir ese texto en columnas.","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\/dividir-texto-en-columnas\/","og_locale":"es_ES","og_type":"article","og_title":"DIVIDIR TEXTO EN COLUMNAS - EXCELFULL.COM","og_description":"Este comando es de gran utilidad para esas ocasiones en las que tenemos una serie de datos y necesitamos dividir ese texto en columnas.","og_url":"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2022-11-02T19:18:39+00:00","article_modified_time":"2022-11-02T19:22:46+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/DIVIDIR-TEXTO-EN-COLUMNAS.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\/dividir-texto-en-columnas\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"DIVIDIR TEXTO EN COLUMNAS","datePublished":"2022-11-02T19:18:39+00:00","dateModified":"2022-11-02T19:22:46+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/"},"wordCount":381,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/DIVIDIR-TEXTO-EN-COLUMNAS.png","keywords":["columnas","excel b\u00e1sico","separar nombre y apellido en excel","separar texto"],"articleSection":["Excel","Excel B\u00e1sico","Operaciones B\u00e1sicas"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/","url":"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/","name":"DIVIDIR TEXTO EN COLUMNAS - EXCELFULL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/DIVIDIR-TEXTO-EN-COLUMNAS.png","datePublished":"2022-11-02T19:18:39+00:00","dateModified":"2022-11-02T19:22:46+00:00","description":"Este comando es de gran utilidad para esas ocasiones en las que tenemos una serie de datos y necesitamos dividir ese texto en columnas.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/DIVIDIR-TEXTO-EN-COLUMNAS.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/11\/DIVIDIR-TEXTO-EN-COLUMNAS.png","width":1280,"height":720,"caption":"DIVIDIR TEXTO EN COLUMNAS"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/dividir-texto-en-columnas\/#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":"DIVIDIR TEXTO EN COLUMNAS"}]},{"@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\/12523","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=12523"}],"version-history":[{"count":4,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12523\/revisions"}],"predecessor-version":[{"id":12536,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12523\/revisions\/12536"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/12532"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=12523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=12523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=12523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}