General discussion

Locked

Multiple Concatenation

By medhavee ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Multiple Concatenation

by opatzg In reply to Multiple Concatenation

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

Collapse -

Multiple Concatenation

by medhavee In reply to Multiple Concatenation

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

Collapse -

Multiple Concatenation

by Cactus Pete In reply to Multiple Concatenation

Define "at once". Can you use a loop?

Back to Desktop Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums