Excel, how to put a named range list into one cell [duplicate]





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0
















This question already has an answer here:




  • Convert a column into a comma separated list

    13 answers




How do I put my named range of a list of values into one cell?



i've tried going into a cell and naming the range like so =namedrange



sample data in my named range:



+---+----------+

|   |    A     |

+---+----------+

| 1 | 'stack', |

| 2 | 'over',  |

| 3 | 'flow',  |

+---+----------+


=OFFSET(Nodes!$B$2,0,0,COUNTA(Nodes!$B:$B),1)



expected output, i would like a formula to do this:



enter image description here






microsoft-excel







share|improve this question















marked as duplicate by Scott Craner, fixer1234, Pimp Juice IT, music2myear, Kenneth L Feb 13 at 2:02


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.



















  • Hi Scott, do you have a textjoin function?

    – excelguy
    Feb 5 at 15:24











  • Go on Stack overflow and look at the answers for the TEXTJOIN tag. It is in there multiple times.

    – Scott Craner
    Feb 5 at 15:37


















0
















This question already has an answer here:




  • Convert a column into a comma separated list

    13 answers




How do I put my named range of a list of values into one cell?



i've tried going into a cell and naming the range like so =namedrange



sample data in my named range:



+---+----------+

|   |    A     |

+---+----------+

| 1 | 'stack', |

| 2 | 'over',  |

| 3 | 'flow',  |

+---+----------+


=OFFSET(Nodes!$B$2,0,0,COUNTA(Nodes!$B:$B),1)



expected output, i would like a formula to do this:



enter image description here






microsoft-excel







share|improve this question















marked as duplicate by Scott Craner, fixer1234, Pimp Juice IT, music2myear, Kenneth L Feb 13 at 2:02


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.



















  • Hi Scott, do you have a textjoin function?

    – excelguy
    Feb 5 at 15:24











  • Go on Stack overflow and look at the answers for the TEXTJOIN tag. It is in there multiple times.

    – Scott Craner
    Feb 5 at 15:37














0












0








0









This question already has an answer here:




  • Convert a column into a comma separated list

    13 answers




How do I put my named range of a list of values into one cell?



i've tried going into a cell and naming the range like so =namedrange



sample data in my named range:



+---+----------+

|   |    A     |

+---+----------+

| 1 | 'stack', |

| 2 | 'over',  |

| 3 | 'flow',  |

+---+----------+


=OFFSET(Nodes!$B$2,0,0,COUNTA(Nodes!$B:$B),1)



expected output, i would like a formula to do this:



enter image description here






microsoft-excel







share|improve this question

















This question already has an answer here:




  • Convert a column into a comma separated list

    13 answers




How do I put my named range of a list of values into one cell?



i've tried going into a cell and naming the range like so =namedrange



sample data in my named range:



+---+----------+

|   |    A     |

+---+----------+

| 1 | 'stack', |

| 2 | 'over',  |

| 3 | 'flow',  |

+---+----------+


=OFFSET(Nodes!$B$2,0,0,COUNTA(Nodes!$B:$B),1)



expected output, i would like a formula to do this:



enter image description here





This question already has an answer here:




  • Convert a column into a comma separated list

    13 answers







microsoft-excel




microsoft-excel






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Feb 5 at 15:19







excelguy

















asked Feb 5 at 15:06









excelguyexcelguy

758




758




marked as duplicate by Scott Craner, fixer1234, Pimp Juice IT, music2myear, Kenneth L Feb 13 at 2:02


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.









marked as duplicate by Scott Craner, fixer1234, Pimp Juice IT, music2myear, Kenneth L Feb 13 at 2:02


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.















  • Hi Scott, do you have a textjoin function?

    – excelguy
    Feb 5 at 15:24











  • Go on Stack overflow and look at the answers for the TEXTJOIN tag. It is in there multiple times.

    – Scott Craner
    Feb 5 at 15:37



















  • Hi Scott, do you have a textjoin function?

    – excelguy
    Feb 5 at 15:24











  • Go on Stack overflow and look at the answers for the TEXTJOIN tag. It is in there multiple times.

    – Scott Craner
    Feb 5 at 15:37

















Hi Scott, do you have a textjoin function?

– excelguy
Feb 5 at 15:24





Hi Scott, do you have a textjoin function?

– excelguy
Feb 5 at 15:24













Go on Stack overflow and look at the answers for the TEXTJOIN tag. It is in there multiple times.

– Scott Craner
Feb 5 at 15:37





Go on Stack overflow and look at the answers for the TEXTJOIN tag. It is in there multiple times.

– Scott Craner
Feb 5 at 15:37










1 Answer
1






active

oldest

votes


















0














Lets do 2 cases. Say the Named Range is A1 through A3. Without Named Ranges we can use:



=TEXTJOIN(CHAR(10),TRUE,A1:A3)


enter image description here



With Named Ranges:



=TEXTJOIN(CHAR(10),TRUE,Stooges)


gives the same result.



To use the comma as a separator, replace the 10 with 44






share|improve this answer
























  • what is textjoin i dont seem to have that formula. I guess i dont have that excel version.

    – excelguy
    Feb 5 at 15:16













  • may be worth noting TEXTJOIN is not available in 2013 or earlier. not sure when it was brought in. I think @ScottCraner has VBA code to produce TEXTJOIN results.

    – Forward Ed
    Feb 5 at 15:17




















1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









0














Lets do 2 cases. Say the Named Range is A1 through A3. Without Named Ranges we can use:



=TEXTJOIN(CHAR(10),TRUE,A1:A3)


enter image description here



With Named Ranges:



=TEXTJOIN(CHAR(10),TRUE,Stooges)


gives the same result.



To use the comma as a separator, replace the 10 with 44






share|improve this answer
























  • what is textjoin i dont seem to have that formula. I guess i dont have that excel version.

    – excelguy
    Feb 5 at 15:16













  • may be worth noting TEXTJOIN is not available in 2013 or earlier. not sure when it was brought in. I think @ScottCraner has VBA code to produce TEXTJOIN results.

    – Forward Ed
    Feb 5 at 15:17


















0














Lets do 2 cases. Say the Named Range is A1 through A3. Without Named Ranges we can use:



=TEXTJOIN(CHAR(10),TRUE,A1:A3)


enter image description here



With Named Ranges:



=TEXTJOIN(CHAR(10),TRUE,Stooges)


gives the same result.



To use the comma as a separator, replace the 10 with 44






share|improve this answer
























  • what is textjoin i dont seem to have that formula. I guess i dont have that excel version.

    – excelguy
    Feb 5 at 15:16













  • may be worth noting TEXTJOIN is not available in 2013 or earlier. not sure when it was brought in. I think @ScottCraner has VBA code to produce TEXTJOIN results.

    – Forward Ed
    Feb 5 at 15:17
















0












0








0







Lets do 2 cases. Say the Named Range is A1 through A3. Without Named Ranges we can use:



=TEXTJOIN(CHAR(10),TRUE,A1:A3)


enter image description here



With Named Ranges:



=TEXTJOIN(CHAR(10),TRUE,Stooges)


gives the same result.



To use the comma as a separator, replace the 10 with 44






share|improve this answer













Lets do 2 cases. Say the Named Range is A1 through A3. Without Named Ranges we can use:



=TEXTJOIN(CHAR(10),TRUE,A1:A3)


enter image description here



With Named Ranges:



=TEXTJOIN(CHAR(10),TRUE,Stooges)


gives the same result.



To use the comma as a separator, replace the 10 with 44







share|improve this answer












share|improve this answer



share|improve this answer










answered Feb 5 at 15:13









Gary's StudentGary's Student

14.2k31834




14.2k31834













  • what is textjoin i dont seem to have that formula. I guess i dont have that excel version.

    – excelguy
    Feb 5 at 15:16













  • may be worth noting TEXTJOIN is not available in 2013 or earlier. not sure when it was brought in. I think @ScottCraner has VBA code to produce TEXTJOIN results.

    – Forward Ed
    Feb 5 at 15:17





















  • what is textjoin i dont seem to have that formula. I guess i dont have that excel version.

    – excelguy
    Feb 5 at 15:16













  • may be worth noting TEXTJOIN is not available in 2013 or earlier. not sure when it was brought in. I think @ScottCraner has VBA code to produce TEXTJOIN results.

    – Forward Ed
    Feb 5 at 15:17



















what is textjoin i dont seem to have that formula. I guess i dont have that excel version.

– excelguy
Feb 5 at 15:16







what is textjoin i dont seem to have that formula. I guess i dont have that excel version.

– excelguy
Feb 5 at 15:16















may be worth noting TEXTJOIN is not available in 2013 or earlier. not sure when it was brought in. I think @ScottCraner has VBA code to produce TEXTJOIN results.

– Forward Ed
Feb 5 at 15:17







may be worth noting TEXTJOIN is not available in 2013 or earlier. not sure when it was brought in. I think @ScottCraner has VBA code to produce TEXTJOIN results.

– Forward Ed
Feb 5 at 15:17





-

Popular posts from this blog

Plaza Victoria

Image
Plaza Victoria Plaza Victoria en 2017 Otros nombres Plaza de La Victoria Localización El Almendral, Valparaíso, Chile Vías adyacentes Chacabuco, Molina, Plaza Victoria y Edwards Creación 1841 Metro Bellavista Ubicación 33°02′46″S 71°37′11″O  /  -33.04624167, -71.61980833 Coordenadas: 33°02′46″S 71°37′11″O  /  -33.04624167, -71.61980833 [editar datos en Wikidata] La Plaza Victoria , también llamada Plaza de la Victoria , [ 1 ] ​ es una plaza ubicada en el sector El Almendral del plan de la ciudad de Valparaíso, Chile, de importancia patrimonial, que incluye valiosas estatuas y especies vegetales. [ 2 ] ​ La plaza se creó como tal en la primera mitad del siglo XIX, tomando previamente los nombres de Plaza Nueva y Plaza de Orrego . Si bien desde sus inicios tuvo relevancia histórica, no fue sino a partir de fines de los años 1860 cuando comenzó a cobrar mayor importancia y se convirtió en uno de los principales centros sociales de l
Read more

In PowerPoint, is there a keyboard shortcut for bulleted / numbered list?

Image
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 2 OneNote has two useful keyboard shortcuts for bulleted and numbered lists, namely Ctrl + . and Ctrl + - . Is there something similar for PowerPoint where the work with lists is also very common? Haven't found anything here: Use keyboard shortcuts in PowerPoint. keyboard-shortcuts microsoft-powerpoint share | improve this question edited Aug 14 '14 at 14:49 Linger 2,826 10 28 40
Read more

How to put 3 figures in Latex with 2 figures side by side and 1 below these side by side images but in...

Image
1 0 I want to put 3 images in LateX such as 2 figures are side by side horizotally and 3rd figure below these 2 side by side figures but in middle. I have following code: begin{figure}[H] centering begin{minipage}{.5textwidth} centering includegraphics[width=.50linewidth]{Text/Images/Genelec_8010_AP.jpg} captionof{figure}{Genelec 8010 AP} label{fig:Genelec 8010} end{minipage}% begin{minipage}{.5textwidth} centering includegraphics[width=.69linewidth]{Text/Images/Genelec_8020_CPM.jpg} captionof{figure}{Genelec 8020 CPM} label{fig:Genelec 8020} end{minipage}% end{figure} %%Here is my 3rd picture code begin{figure} centering includegraphics[width=5cm]{Text/Images/Genelec_8030_BPM.jpg} caption{Genelec 8030 BPM} label{fig:Genelec 8030} end{figure} I want to ask ho
Read more