View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vargasjc Vargasjc is offline
external usenet poster
 
Posts: 3
Default How do I convert a text array to a concatenated text cell? Excel.

I'm trying to concatenate different cell values into one single cell in a
dynamic table. Usually one could use =concatenate(), or do something like
=A1&" ,"&A2 and so on. What I want to try to do is concatenate an array of
values into a single cell. For example, =concatenate(B1:B5), but in this case
the result is an array equivalent to {=B1:B5}, which I find most disturbing.
Is there any way to do this I need to do?