CONCATENATE Formatting

[Miguel Pantoja Viquez]

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?

[#2]

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

Anyway, there are some fairly good solutions here.

[#3]

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?

[#4]

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.

[#5]

Awesome!  Thanks a lot!