Forum Discussion

Miguel Pantoja Viquez's avatar
Miguel Pantoja Viquez
Copper Contributor
Jan 18, 2018

CONCATENATE Formatting

Hello   I am trying to concatenate text while being able to keep some of it bolded, underlined, etc.   e.g.   Cell A1 = "Hello" Cell B1 = "Folks"   And I want to have as output in c...
BI & Data Analytics
tips and tricks
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jan 18, 2018

Your question seems easy at first glance!
But it's difficult to even with the VBA!

 

Anyway, there are some fairly good solutions here.

  • Miguel Pantoja Viquez's avatar
    Miguel Pantoja Viquez
    Copper Contributor
    Jan 18, 2018

    Thanks Haytam.  Additional question.

     

    If I have: A1 = "Hello" and B1 = "Folks" and I want C1 to be:
    Hello

    Folks

     

    (concatenate but add a manual 'line break'), is that possible?

    • Haytham Amairah's avatar
      Haytham Amairah
      Silver Contributor
      Jan 18, 2018

      Put this formula in cell C1:

       

      =A1&CHAR(10)&B1

      Keep cell C1 selected, then go to Home >> Alignment and click on Wrap Text button.

       

Resources