Desktop

Ask something
Discussion Locked

Multiple Concatenation

0 helpful
3 replies

by medhavee

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I find it difficult to concatenate text strings in more than 30 cells as Excel doesn't permit the same. Is there any way by which I can concatenate the contents of multiple cells more than 30 cells?
Please advise.

3 replies

by opatzg9

Make a number of 30 concatenates and then concatenate them into another cell.

by medhavee

My requirement is to concatenate texts in all the cells of a single column at once. However, I may try this suggestion.

This discussion is closed to new replies.