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 cell C1 = "Hello Folks"
How do I do it?
Your question seems easy at first glance!
But it's difficult to even with the VBA!Anyway, there are some fairly good solutions here.
Thanks Haytam. Additional question.
If I have: A1 = "Hello" and B1 = "Folks" and I want C1 to be:
HelloFolks
(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.
