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
|