Concantenate which keeps bold of some parts.


Joined
Sep 8, 2018
Messages
9
Reaction score
4
I wish to concantenate 3 columns in Excel 2007.
=CONCATENATE(A1, " ", B1, " ", D1)
does it for me.

But the text in column A and B are both formatted as bold - which I want to keep that way. However, the result of the above formula removes the bold.
How can I modify the formula so that A1 and B1 remain bold, while D1 does not?

Could I also add underline to A1 and B1?

Thank you.
 
Ad

Advertisements

Joined
Sep 8, 2018
Messages
9
Reaction score
4
I thought you could do anything Becky! :thumb:
Thanks, I'll try the link you provided.
 
Joined
Sep 8, 2018
Messages
9
Reaction score
4
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top