{"id":12998,"date":"2023-11-20T20:31:36","date_gmt":"2023-11-20T20:31:36","guid":{"rendered":"https:\/\/windowsreport.com\/es\/?p=12998"},"modified":"2025-09-27T13:34:06","modified_gmt":"2025-09-27T10:34:06","slug":"como-separar-nombres-y-apellidos-excel","status":"publish","type":"post","link":"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/","title":{"rendered":"C\u00f3mo Separar Nombres y Apellidos en Excel [2023]"},"content":{"rendered":"\n<p>Saber c\u00f3mo separar nombres y apellidos en Excel es una tarea sencilla, pero importante a la hora de agilizar el proceso de introducci\u00f3n de datos.<\/p>\n\n\n\n<p>Esto puede ser \u00fatil para la gesti\u00f3n de datos de clientes, empleados, o cualquier lista que incluya nombres completos. A continuaci\u00f3n, te mostramos c\u00f3mo puedes hacerlo de manera sencilla y efectiva.<\/p>\n\n\n<p>[wr_toc]<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfC\u00f3mo Separar Nombres y Apellidos en Excel?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. Preparaci\u00f3n de tus Datos:<\/h3>\n\n\n\n<p>Antes de empezar, aseg\u00farate de que todos los nombres y apellidos que deseas separar est\u00e9n en una sola columna. Por ejemplo, si tienes una lista de nombres completos en la columna A, aseg\u00farate de que cada fila contenga un solo nombre completo (por ejemplo, Juan P\u00e9rez).<img decoding=\"async\" width=\"405\" height=\"733\" class=\"wp-image-13001\" style=\"width: 350px\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-1-verificar-data.png\" alt=\"cambiar-nombre-y-apellido-excel\" srcset=\"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-1-verificar-data.png 405w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-1-verificar-data-166x300.png 166w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-1-verificar-data-116x210.png 116w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-1-verificar-data-66x120.png 66w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-1-verificar-data-77x140.png 77w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-1-verificar-data-35x64.png 35w\" sizes=\"(max-width: 405px) 100vw, 405px\" \/><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2.Usar la Funci\u00f3n &#8216;Texto en Columnas&#8217;<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Selecciona la columna que contiene los nombres completos.<img decoding=\"async\" width=\"867\" height=\"646\" class=\"wp-image-13002\" style=\"width: 750px\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/sites\/5\/2023\/11\/seleccionar-data-excel.png\" alt=\"como-cambiar-nombre-y-apellido-excel\" srcset=\"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/seleccionar-data-excel.png 867w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/seleccionar-data-excel-300x224.png 300w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/seleccionar-data-excel-768x572.png 768w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/seleccionar-data-excel-282x210.png 282w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/seleccionar-data-excel-120x89.png 120w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/seleccionar-data-excel-140x104.png 140w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/seleccionar-data-excel-64x48.png 64w\" sizes=\"(max-width: 867px) 100vw, 867px\" \/><\/li>\n\n\n\n<li>Ve a la pesta\u00f1a <strong>Datos <\/strong>en la barra de opciones de Excel.<br><br><\/li>\n\n\n\n<li>Haz clic en Texto en Columnas. Se abrir\u00e1 un asistente de conversi\u00f3n.<img decoding=\"async\" width=\"974\" height=\"886\" class=\"wp-image-13003\" style=\"width: 750px\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/sites\/5\/2023\/11\/Seleccionar-data-paso-2.png\" alt=\"como-cambiar-nombre-apellido-excel\" srcset=\"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/Seleccionar-data-paso-2.png 974w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/Seleccionar-data-paso-2-300x273.png 300w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/Seleccionar-data-paso-2-768x699.png 768w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/Seleccionar-data-paso-2-231x210.png 231w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/Seleccionar-data-paso-2-120x109.png 120w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/Seleccionar-data-paso-2-140x127.png 140w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/Seleccionar-data-paso-2-64x58.png 64w\" sizes=\"(max-width: 974px) 100vw, 974px\" \/><\/li>\n\n\n\n<li>Elige <strong>Delimitado <\/strong>y haz clic en <em>Siguiente<\/em>.<br><br><\/li>\n\n\n\n<li>En el paso 2 del asistente, marca la casilla <strong>Espacio como delimitador<\/strong>. Esto indicar\u00e1 a Excel que separe los nombres y apellidos bas\u00e1ndose en el espacio entre ellos.<img decoding=\"async\" width=\"989\" height=\"900\" class=\"wp-image-13005\" style=\"width: 750px\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-3-como-cambiar-nombre-apellido-excel.png\" alt=\"como-cambiar-nombre-apellido-excel\" srcset=\"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-3-como-cambiar-nombre-apellido-excel.png 989w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-3-como-cambiar-nombre-apellido-excel-300x273.png 300w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-3-como-cambiar-nombre-apellido-excel-768x699.png 768w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-3-como-cambiar-nombre-apellido-excel-231x210.png 231w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-3-como-cambiar-nombre-apellido-excel-120x109.png 120w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-3-como-cambiar-nombre-apellido-excel-140x127.png 140w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/paso-3-como-cambiar-nombre-apellido-excel-64x58.png 64w\" sizes=\"(max-width: 989px) 100vw, 989px\" \/><\/li>\n\n\n\n<li>Haz clic en <strong>Siguiente <\/strong>y luego en <em>Finalizar<\/em>.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">3. Ajustar Datos Separados<\/h3>\n\n\n\n<p>Despu\u00e9s de completar los pasos anteriores, encontrar\u00e1s que los nombres y apellidos han sido separados en dos columnas diferentes. Puede ser necesario ajustar manualmente algunos datos, especialmente si algunos nombres tienen m\u00e1s de dos palabras (por ejemplo, nombres compuestos o apellidos dobles).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4. Uso de F\u00f3rmulas para Casos Complejos<\/h3>\n\n\n\n<p>En casos donde los nombres o apellidos son m\u00e1s complejos (por ejemplo, Mar\u00eda del Carmen Torres), podr\u00edas necesitar usar f\u00f3rmulas para ajustar los datos correctamente. Una f\u00f3rmula com\u00fan para esto es la funci\u00f3n <strong>IZQUIERDA<\/strong> o <strong>DERECHA <\/strong>combinada con <strong>ENCONTRAR <\/strong>o <strong>LARGO <\/strong>para especificar d\u00f3nde realizar el corte en el texto.<img decoding=\"async\" width=\"1280\" height=\"720\" class=\"wp-image-13006\" style=\"width: 750px\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/sites\/5\/2023\/11\/maxresdefault.jpg\" alt=\"formulas-excel-izq-derecha\" srcset=\"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/maxresdefault.jpg 1280w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/maxresdefault-300x169.jpg 300w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/maxresdefault-1024x576.jpg 1024w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/maxresdefault-768x432.jpg 768w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/maxresdefault-330x186.jpg 330w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/maxresdefault-120x68.jpg 120w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/maxresdefault-140x79.jpg 140w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/maxresdefault-64x36.jpg 64w, https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/maxresdefault-1200x675.jpg 1200w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">En conclusi\u00f3n<\/h3>\n\n\n\n<p>Separar nombres y apellidos en Excel es un proceso sencillo que puede ahorrar mucho tiempo en la gesti\u00f3n de datos. Siguiendo estos pasos, puedes asegurarte de que tus listas est\u00e9n organizadas de manera m\u00e1s efectiva y que tus datos sean m\u00e1s accesibles y f\u00e1ciles de manejar.<\/p>\n\n\n\n<p>Si\u00e9ntete libre de dejarnos tu opini\u00f3n y comentarios debajo. Sigue leyendo nuestras <a href=\"https:\/\/windowsreport.com\/name-error-excel\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">gu\u00edas especializadas y de calidad sobre Excel<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Saber c\u00f3mo separar nombres y apellidos en Excel es una tarea sencilla, pero importante a la hora de agilizar el proceso de introducci\u00f3n de datos. Esto puede ser \u00fatil para la gesti\u00f3n de datos de clientes, empleados, o cualquier lista que incluya nombres completos. A continuaci\u00f3n, te mostramos c\u00f3mo puedes hacerlo de manera sencilla y [&hellip;]<\/p>\n","protected":false},"author":2266,"featured_media":13008,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_enabled_clarity":"","footnotes":""},"categories":[44],"tags":[1910,1721,1789],"work":[1784,1785,1786],"class_list":["post-12998","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-resolucion-de-problemas","tag-excel","tag-windows-10","tag-windows-11","work-exclude-first-cta","work-exclude-last-cta","work-exclude-mid-cta"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.0 (Yoast SEO v28.0) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>C\u00f3mo Separar Nombres y Apellidos en Excel [2023]<\/title>\n<meta name=\"description\" content=\"Aprende c\u00f3mo separar nombres y apellidos en Microsoft Excel de forma r\u00e1pida y eficiente. Sigue leyendo para mejorar la gesti\u00f3n de tus datos.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00f3mo Separar Nombres y Apellidos en Excel [2023]\" \/>\n<meta property=\"og:description\" content=\"Aprende c\u00f3mo separar nombres y apellidos en Microsoft Excel de forma r\u00e1pida y eficiente. Sigue leyendo para mejorar la gesti\u00f3n de tus datos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"WindowsReport ES (Spanish)\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-20T20:31:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-27T10:34:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/como-cambiar-nombre-apellido-excel-.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Italo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Italo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/como-separar-nombres-y-apellidos-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/como-separar-nombres-y-apellidos-excel\\\/\"},\"author\":{\"name\":\"Italo\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/#\\\/schema\\\/person\\\/80b05ab767d55143dfa5519b6c3c2079\"},\"headline\":\"C\u00f3mo Separar Nombres y Apellidos en Excel [2023]\",\"datePublished\":\"2023-11-20T20:31:36+00:00\",\"dateModified\":\"2025-09-27T10:34:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/como-separar-nombres-y-apellidos-excel\\\/\"},\"wordCount\":407,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/como-separar-nombres-y-apellidos-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2023\\\/11\\\/como-cambiar-nombre-apellido-excel-.png\",\"keywords\":[\"Excel\",\"Windows 10\",\"Windows 11\"],\"articleSection\":[\"Resoluci\u00f3n de problemas\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/windowsreport.com\\\/es\\\/como-separar-nombres-y-apellidos-excel\\\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/como-separar-nombres-y-apellidos-excel\\\/\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/como-separar-nombres-y-apellidos-excel\\\/\",\"name\":\"C\u00f3mo Separar Nombres y Apellidos en Excel [2023]\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/como-separar-nombres-y-apellidos-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/como-separar-nombres-y-apellidos-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2023\\\/11\\\/como-cambiar-nombre-apellido-excel-.png\",\"datePublished\":\"2023-11-20T20:31:36+00:00\",\"dateModified\":\"2025-09-27T10:34:06+00:00\",\"description\":\"Aprende c\u00f3mo separar nombres y apellidos en Microsoft Excel de forma r\u00e1pida y eficiente. Sigue leyendo para mejorar la gesti\u00f3n de tus datos.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/como-separar-nombres-y-apellidos-excel\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/windowsreport.com\\\/es\\\/como-separar-nombres-y-apellidos-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/como-separar-nombres-y-apellidos-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2023\\\/11\\\/como-cambiar-nombre-apellido-excel-.png\",\"contentUrl\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2023\\\/11\\\/como-cambiar-nombre-apellido-excel-.png\",\"width\":1920,\"height\":1280,\"caption\":\"como-cambiar-nombre-apellido-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/como-separar-nombres-y-apellidos-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"P\u00e1gina de inicio\",\"item\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resoluci\u00f3n de problemas\",\"item\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/category\\\/resolucion-de-problemas\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00f3mo Separar Nombres y Apellidos en Excel [2023]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/#website\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/\",\"name\":\"WindowsReport - ES\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/#organization\",\"name\":\"WindowsReport - ES\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2024\\\/01\\\/wr-logo-default.png\",\"contentUrl\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2024\\\/01\\\/wr-logo-default.png\",\"width\":214,\"height\":35,\"caption\":\"WindowsReport - ES\"},\"image\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/#\\\/schema\\\/person\\\/80b05ab767d55143dfa5519b6c3c2079\",\"name\":\"Italo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2023\\\/06\\\/IMG_20230610_024323-1.jpg\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2023\\\/06\\\/IMG_20230610_024323-1.jpg\",\"contentUrl\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2023\\\/06\\\/IMG_20230610_024323-1.jpg\",\"caption\":\"Italo\"},\"url\":\"https:\\\/\\\/windowsreport.com\\\/es\\\/author\\\/italoarellano\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00f3mo Separar Nombres y Apellidos en Excel [2023]","description":"Aprende c\u00f3mo separar nombres y apellidos en Microsoft Excel de forma r\u00e1pida y eficiente. Sigue leyendo para mejorar la gesti\u00f3n de tus datos.","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:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/","og_locale":"es_ES","og_type":"article","og_title":"C\u00f3mo Separar Nombres y Apellidos en Excel [2023]","og_description":"Aprende c\u00f3mo separar nombres y apellidos en Microsoft Excel de forma r\u00e1pida y eficiente. Sigue leyendo para mejorar la gesti\u00f3n de tus datos.","og_url":"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/","og_site_name":"WindowsReport ES (Spanish)","article_published_time":"2023-11-20T20:31:36+00:00","article_modified_time":"2025-09-27T10:34:06+00:00","og_image":[{"width":1920,"height":1280,"url":"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/como-cambiar-nombre-apellido-excel-.png","type":"image\/png"}],"author":"Italo","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Italo","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/#article","isPartOf":{"@id":"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/"},"author":{"name":"Italo","@id":"https:\/\/windowsreport.com\/es\/#\/schema\/person\/80b05ab767d55143dfa5519b6c3c2079"},"headline":"C\u00f3mo Separar Nombres y Apellidos en Excel [2023]","datePublished":"2023-11-20T20:31:36+00:00","dateModified":"2025-09-27T10:34:06+00:00","mainEntityOfPage":{"@id":"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/"},"wordCount":407,"commentCount":0,"publisher":{"@id":"https:\/\/windowsreport.com\/es\/#organization"},"image":{"@id":"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/como-cambiar-nombre-apellido-excel-.png","keywords":["Excel","Windows 10","Windows 11"],"articleSection":["Resoluci\u00f3n de problemas"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/windowsreport.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/","url":"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/","name":"C\u00f3mo Separar Nombres y Apellidos en Excel [2023]","isPartOf":{"@id":"https:\/\/windowsreport.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/#primaryimage"},"image":{"@id":"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/como-cambiar-nombre-apellido-excel-.png","datePublished":"2023-11-20T20:31:36+00:00","dateModified":"2025-09-27T10:34:06+00:00","description":"Aprende c\u00f3mo separar nombres y apellidos en Microsoft Excel de forma r\u00e1pida y eficiente. Sigue leyendo para mejorar la gesti\u00f3n de tus datos.","breadcrumb":{"@id":"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/#primaryimage","url":"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/como-cambiar-nombre-apellido-excel-.png","contentUrl":"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/11\/como-cambiar-nombre-apellido-excel-.png","width":1920,"height":1280,"caption":"como-cambiar-nombre-apellido-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/windowsreport.com\/es\/como-separar-nombres-y-apellidos-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"P\u00e1gina de inicio","item":"https:\/\/windowsreport.com\/es\/"},{"@type":"ListItem","position":2,"name":"Resoluci\u00f3n de problemas","item":"https:\/\/windowsreport.com\/es\/category\/resolucion-de-problemas\/"},{"@type":"ListItem","position":3,"name":"C\u00f3mo Separar Nombres y Apellidos en Excel [2023]"}]},{"@type":"WebSite","@id":"https:\/\/windowsreport.com\/es\/#website","url":"https:\/\/windowsreport.com\/es\/","name":"WindowsReport - ES","description":"","publisher":{"@id":"https:\/\/windowsreport.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/windowsreport.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/windowsreport.com\/es\/#organization","name":"WindowsReport - ES","url":"https:\/\/windowsreport.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/windowsreport.com\/es\/#\/schema\/logo\/image\/","url":"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2024\/01\/wr-logo-default.png","contentUrl":"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2024\/01\/wr-logo-default.png","width":214,"height":35,"caption":"WindowsReport - ES"},"image":{"@id":"https:\/\/windowsreport.com\/es\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/windowsreport.com\/es\/#\/schema\/person\/80b05ab767d55143dfa5519b6c3c2079","name":"Italo","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/06\/IMG_20230610_024323-1.jpg","url":"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/06\/IMG_20230610_024323-1.jpg","contentUrl":"https:\/\/windowsreport.com\/es\/wp-content\/uploads\/sites\/5\/2023\/06\/IMG_20230610_024323-1.jpg","caption":"Italo"},"url":"https:\/\/windowsreport.com\/es\/author\/italoarellano\/"}]}},"_links":{"self":[{"href":"https:\/\/windowsreport.com\/es\/wp-json\/wp\/v2\/posts\/12998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/windowsreport.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/windowsreport.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/windowsreport.com\/es\/wp-json\/wp\/v2\/users\/2266"}],"replies":[{"embeddable":true,"href":"https:\/\/windowsreport.com\/es\/wp-json\/wp\/v2\/comments?post=12998"}],"version-history":[{"count":5,"href":"https:\/\/windowsreport.com\/es\/wp-json\/wp\/v2\/posts\/12998\/revisions"}],"predecessor-version":[{"id":13597,"href":"https:\/\/windowsreport.com\/es\/wp-json\/wp\/v2\/posts\/12998\/revisions\/13597"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/windowsreport.com\/es\/wp-json\/wp\/v2\/media\/13008"}],"wp:attachment":[{"href":"https:\/\/windowsreport.com\/es\/wp-json\/wp\/v2\/media?parent=12998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/windowsreport.com\/es\/wp-json\/wp\/v2\/categories?post=12998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/windowsreport.com\/es\/wp-json\/wp\/v2\/tags?post=12998"},{"taxonomy":"work","embeddable":true,"href":"https:\/\/windowsreport.com\/es\/wp-json\/wp\/v2\/work?post=12998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}