View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smaruzzi smaruzzi is offline
external usenet poster
 
Posts: 55
Default Creating a text string by reading content in multiple cells

I have a column where each cell contains a single letter. I need to
consolidate all these letters and form a single string of text in a separate
cell. In other words, a function equivalent to sum() for characters is what
i'm looking for. Concatenate() works only with 34 cells, and creating a "sum"
of different Concatenate() doesn't seem to work fine.

Any smart way to solve my problem?

Thanks, Stefano