Forum Discussion
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...
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?
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.
Awesome! Thanks a lot!