Forum Discussion
How auto concatenate many cells?
Hi.
I have 1000 text cells in Excel. I need to concatenate it into one cell. I try to use =CONCATENATE(B1: B999), but it not works. When I try to use some as =CONCATENATE(B1; B999) - it's work, but, of course, I see a text from b1+b999, and nothing else.
Help me, please, how I can to auto-combine text from all 1000 cells?
Thnx a lot!
4 Replies
Hi
Use CONCAT() or TEXTJOIN().
Sorry, but I don't see "textjoin" command in excel 2016.
You could use a helper column:
C1: =B1
C2: =C1&B2 and copy down.
