Manolocs
Active Member
- Joined
- Mar 28, 2008
- Messages
- 340
Hello, I want to concatenate all words with a space in the same row but some rows has more than 30 columns
How can I make simple this formula maybe with function?
=CONCATENATE(A1," ",B1," ",C1," "......... until there is text in the cell?
Thanks in advance
How can I make simple this formula maybe with function?
=CONCATENATE(A1," ",B1," ",C1," "......... until there is text in the cell?
Thanks in advance
