{"id":1557,"date":"2023-11-17T06:46:31","date_gmt":"2023-11-17T06:46:31","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/"},"modified":"2023-12-10T06:21:52","modified_gmt":"2023-12-10T06:21:52","slug":"concatenare-le-celle-con-una-virgola","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/","title":{"rendered":"Come concatenare le celle con una virgola?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-1717153594\"><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>In Excel esistono diversi metodi che \u00e8 possibile utilizzare per concatenare le celle utilizzando una virgola tra i valori. In questo tutorial, esamineremo tutti questi metodi.<\/p><h2 class=\"wp-block-heading\"> Funzione TEXTJOIN per combinare celle con un carattere comune<\/h2><p> Nell&#8217;esempio seguente, hai valori numerici nell&#8217;intervallo da A1 a A5 e devi combinare tutti questi valori nella cella B1. <\/p><div class=\"wp-block-image\"><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=\"stoccaggio delle cellule\" width=\"449\" height=\"283\"><\/figure><\/div><p> \u00c8 possibile utilizzare i seguenti passaggi:<\/p><ol type=\"1\"><li> Innanzitutto, digita TEXTJOIN nella cella B1.<\/li><li> Successivamente, per l&#8217;argomento delimitatore, aggiungere una virgola (\u201c, \u201c). Ci\u00f2 include anche uno spazio dopo la virgola.<\/li><li> Quindi inserisci TRUE per ignore_empty.<\/li><li> Ora seleziona l&#8217;intervallo A1: A5 da cui devi combinare i valori.<\/li><li> Alla fine, inserisci la parentesi di chiusura, quindi premi Invio. <\/li><\/ol><div class=\"wp-block-image\"><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=\"textjoin-formula\" width=\"626\" height=\"280\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXTJOIN(\", \",TRUE,A1:A5)<\/code><\/pre><h2 class=\"wp-block-heading\"> Utilizza la funzione CONCAT per concatenare i valori con una virgola<\/h2><p> Anche a questo scopo \u00e8 possibile utilizzare la funzione CONCAT. Ma devi aggiungere una colonna helper con virgole accanto ai valori effettivi. Nell&#8217;esempio seguente abbiamo aggiunto virgole nella colonna B (B1:B5). <\/p><div class=\"wp-block-image\"><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-per-combinare-celle\" width=\"479\" height=\"305\"><\/figure><\/div><p> Ora la formula \u00e8 piuttosto semplice. Basta inserire la funzione CONCAT nella cella C1 e fare riferimento all&#8217;intero intervallo (A1:B5). Quando premi Invio, otterrai tutti i valori nella cella C1, seguiti da una virgola. <\/p><div class=\"wp-block-image\"><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=\"formula concatenata\" width=\"651\" height=\"289\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CONCAT(A1:B5)<\/code><\/pre><h2 class=\"wp-block-heading\"> Utilizzando il metodo di concatenazione semplice<\/h2><p> E puoi anche utilizzare il semplice metodo di concatenazione in cui puoi fare riferimento a ciascuna cella e con ogni riferimento di cella puoi aggiungere una virgola. <\/p><div class=\"wp-block-image\"><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=\"metodo di concatenazione semplice\" width=\"682\" height=\"312\"><\/figure><\/div><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><p> Di tutti i metodi che abbiamo utilizzato, ogni metodo ha il suo vantaggio. Ma mi piace usare TEXTJOIN perch\u00e9 mi d\u00e0 maggiore flessibilit\u00e0 nel combinare valori in una singola cella senza aggiungere una nuova colonna helper. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Ottieni il file Excel<\/h2> <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\">Scaricamento<\/a><\/div><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\/it\/formule\/\">Elenco delle formule di Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Formule correlate <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/it\/nuova-riga-nella-cella\/\">Aggiungi una nuova riga a una cella in Excel (interruzione di riga)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/zeri-iniziali\/\">Aggiungi zeri iniziali in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/concatenare-un-intervallo-di-celle\/\">Concatena (combina) un intervallo di celle in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/concatenare-uninterruzione-di-riga\/\">Concatena con interruzione di riga in Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","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-1557","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>Come concatenare (combinare) le celle con una virgola?<\/title>\n<meta name=\"description\" content=\"In questo tutorial imparerai diversi modi per concatenare (combinare) le celle con una virgola nelle formule di Excel\" \/>\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\/it\/concatenare-le-celle-con-una-virgola\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Come concatenare (combinare) le celle con una virgola?\" \/>\n<meta property=\"og:description\" content=\"In questo tutorial imparerai diversi modi per concatenare (combinare) le celle con una virgola nelle formule di Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:21:52+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=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/\",\"name\":\"Come concatenare (combinare) le celle con una virgola?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/#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-10T06:21:52+00:00\",\"description\":\"In questo tutorial imparerai diversi modi per concatenare (combinare) le celle con una virgola nelle formule di Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/#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\/it\/concatenare-le-celle-con-una-virgola\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come concatenare le celle con una virgola?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"name\":\"Excel Advisor\",\"description\":\"Tips, Tricks, and Time-Saving Hacks\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Come concatenare (combinare) le celle con una virgola?","description":"In questo tutorial imparerai diversi modi per concatenare (combinare) le celle con una virgola nelle formule di Excel","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\/it\/concatenare-le-celle-con-una-virgola\/","og_locale":"it_IT","og_type":"article","og_title":"Come concatenare (combinare) le celle con una virgola?","og_description":"In questo tutorial imparerai diversi modi per concatenare (combinare) le celle con una virgola nelle formule di Excel","og_url":"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:21:52+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":{"Tempo di lettura stimato":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/","url":"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/","name":"Come concatenare (combinare) le celle con una virgola?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/#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-10T06:21:52+00:00","description":"In questo tutorial imparerai diversi modi per concatenare (combinare) le celle con una virgola nelle formule di Excel","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/concatenare-le-celle-con-una-virgola\/#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\/it\/concatenare-le-celle-con-una-virgola\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come concatenare le celle con una virgola?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/it\/#website","url":"https:\/\/exceladvisor.org\/it\/","name":"Excel Advisor","description":"Tips, Tricks, and Time-Saving Hacks","publisher":{"@id":"https:\/\/exceladvisor.org\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/it\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1557","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/comments?post=1557"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1557\/revisions"}],"predecessor-version":[{"id":2385,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1557\/revisions\/2385"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=1557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}