Forum Discussion

Андрийчук Виктор's avatar
Андрийчук Виктор
Copper Contributor
Jan 23, 2018

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,...
concatenate
excel
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jan 23, 2018

Hi

 

Use CONCAT() or TEXTJOIN().

 

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Jan 27, 2018

    You could use a helper column:

    C1: =B1

    C2: =C1&B2 and copy down.

     

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Jan 27, 2018

    Then you are not a Office 365 subscriber or you haven't updated your subscription.

    Both functions were added a few month ago to Office 365/Excel Online.

     

Resources