{"id":85,"date":"2023-11-17T06:46:31","date_gmt":"2023-11-17T06:46:31","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/"},"modified":"2023-12-25T10:24:27","modified_gmt":"2023-12-25T10:24:27","slug":"concatenar-celdas-con-una-coma","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/","title":{"rendered":"\u00bfc\u00f3mo concatenar celdas con coma?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-634973537\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>En Excel, existen varios m\u00e9todos que puede utilizar para concatenar celdas utilizando una coma entre valores. En este tutorial, veremos todos estos m\u00e9todos.<\/p>\n<h2 class=\"wp-block-heading\"> Funci\u00f3n TEXTJOIN para combinar celdas con un car\u00e1cter com\u00fan<\/h2>\n<p> En el siguiente ejemplo, tiene valores num\u00e9ricos en el rango de A1 a A5 y necesita combinar todos estos valores en la celda B1. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66008\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"almacenamiento celular\" width=\"449\" height=\"283\"><\/figure>\n<\/div>\n<p> Puede utilizar los siguientes pasos:<\/p>\n<ol type=\"1\">\n<li> Primero, escriba TEXTJOIN en la celda B1.<\/li>\n<li> Despu\u00e9s de eso, para el argumento delimitador, agregue una coma (\u201c,\u201d). Esto tambi\u00e9n incluye un espacio despu\u00e9s de la coma.<\/li>\n<li> Luego ingrese VERDADERO para ignorar_empty.<\/li>\n<li> Ahora seleccione el rango A1:A5 desde donde necesita combinar los valores.<\/li>\n<li> Al final, ingrese el par\u00e9ntesis de cierre y luego presione Entrar. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66009\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formule-textjoin.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula de uni\u00f3n de texto\" width=\"626\" height=\"280\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXTJOIN(\", \",TRUE,A1:A5)<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Utilice la funci\u00f3n CONCAT para concatenar valores con una coma<\/h2>\n<p> Tambi\u00e9n puedes utilizar la funci\u00f3n CONCAT para esto. Pero necesitas agregar una columna auxiliar con comas al lado de los valores reales. En el siguiente ejemplo, agregamos comas en la columna B (B1:B5). <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66010\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-concat-pour-combiner-les-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"concat-para-combinar-celdas\" width=\"479\" height=\"305\"><\/figure>\n<\/div>\n<p> Ahora la f\u00f3rmula es bastante simple. Simplemente ingrese la funci\u00f3n CONCAT en la celda C1 y consulte todo el rango (A1:B5). Cuando presionas Enter, obtendr\u00e1s todos los valores en la celda C1, seguidos de una coma. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66011\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-formules-concat1.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula concat\" width=\"651\" height=\"289\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CONCAT(A1:B5)<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Usando el m\u00e9todo de concatenaci\u00f3n simple<\/h2>\n<p> Y tambi\u00e9n puedes usar el m\u00e9todo de concatenaci\u00f3n simple donde puedes hacer referencia a cada celda y con cada referencia de celda puedes agregar una coma. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66012\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-methode-de-concatenation-simple.png\" sizes=\"auto, \" srcset=\"\" alt=\"m\u00e9todo de concatenaci\u00f3n simple\" width=\"682\" height=\"312\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1&amp;\", \"&amp;A2&amp;\", \"&amp;A3&amp;\", \"&amp;A4&amp;\", \"&amp;A5<\/code><\/pre>\n<p> De todos los m\u00e9todos que hemos utilizado, cada m\u00e9todo tiene su ventaja. Pero me gusta usar TEXTJOIN porque me brinda m\u00e1s flexibilidad para combinar valores en una sola celda sin agregar una nueva columna auxiliar. <\/p>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/9-valeurs-de-concatenation-avec-des-virgules.xlsx\" rel=\"nofollow\">Descargar<\/a><\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/nueva-linea-en-la-celda\/\">Agregar una nueva l\u00ednea a una celda en Excel (salto de l\u00ednea)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ceros-a-la-izquierda\/\">Agregue ceros a la izquierda en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/concatenar-un-rango-de-celdas\/\">Concatenar (combinar) un rango de celdas en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/concatenar-un-salto-de-linea\/\">Concatenar con salto de l\u00ednea en Excel<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, existen varios m\u00e9todos que puede utilizar para concatenar celdas utilizando una coma entre valores. En este tutorial, veremos todos estos m\u00e9todos. Funci\u00f3n TEXTJOIN para combinar celdas con un car\u00e1cter com\u00fan En el siguiente ejemplo, tiene valores num\u00e9ricos en el rango de A1 a A5 y necesita combinar todos estos valores en la celda [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-85","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo concatenar celdas con coma?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo concatenar celdas con coma?\" \/>\n<meta property=\"og:description\" content=\"En Excel, existen varios m\u00e9todos que puede utilizar para concatenar celdas utilizando una coma entre valores. En este tutorial, veremos todos estos m\u00e9todos. Funci\u00f3n TEXTJOIN para combinar celdas con un car\u00e1cter com\u00fan En el siguiente ejemplo, tiene valores num\u00e9ricos en el rango de A1 a A5 y necesita combinar todos estos valores en la celda [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/\",\"name\":\"\u00bfc\u00f3mo concatenar celdas con coma?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png\",\"datePublished\":\"2023-11-17T06:46:31+00:00\",\"dateModified\":\"2023-12-25T10:24:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo concatenar celdas con coma?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo concatenar celdas con coma?","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:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo concatenar celdas con coma?","og_description":"En Excel, existen varios m\u00e9todos que puede utilizar para concatenar celdas utilizando una coma entre valores. En este tutorial, veremos todos estos m\u00e9todos. Funci\u00f3n TEXTJOIN para combinar celdas con un car\u00e1cter com\u00fan En el siguiente ejemplo, tiene valores num\u00e9ricos en el rango de A1 a A5 y necesita combinar todos estos valores en la celda [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:27+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/","url":"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/","name":"\u00bfc\u00f3mo concatenar celdas con coma?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png","datePublished":"2023-11-17T06:46:31+00:00","dateModified":"2023-12-25T10:24:27+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-de-cellules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/concatenar-celdas-con-una-coma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo concatenar celdas con coma?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/85","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=85"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/85\/revisions"}],"predecessor-version":[{"id":927,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/85\/revisions\/927"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=85"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}