Forum Discussion

Susanna Hughes's avatar
Susanna Hughes
Copper Contributor
May 25, 2017

Help for CONCATENATE function

Hi - I am using the CONCATENATE funcation to combine several cells into one.  I would like a hard return (Alt+Shift) after each cells data.  Is this possible?     I knowt hat I can edit the formula...
Formulas & Functions
Need Help
Susanna Hughes's avatar
Susanna Hughes
Copper Contributor
May 25, 2017
Detlef_Lewin wrote:

Hi

 

=TEXTJOIN(CHAR(10),TRUE,G1641:G1648)

 

Thanks, but that formula returns #NAME?

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
May 25, 2017

That means you are not an Office 365 subscriber. TEXTJOIN() is only available for subscribers or in Excel Online.

 

  • Susanna Hughes's avatar
    Susanna Hughes
    Copper Contributor
    May 25, 2017
    I'm on 365 for Business, shouldn't that work the same way?

    Thanks for the reply.
    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      May 25, 2017

      Only if and when your admins roll out the updates.

      • Susanna Hughes's avatar
        Susanna Hughes
        Copper Contributor
        May 25, 2017
        Thanks. I just figured that out. I appreciate your help. :)