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.
 
Joined
Sep 8, 2018
Messages
9
Reaction score
4
Here's an example. It won't let me upload an excel file, so this is a screenshot .
Essentially, I want A and B column to remain Bold in the concantenated colum.
 

Attachments

  • Screenshot_20181104-160222~01.png
    Screenshot_20181104-160222~01.png
    561.1 KB · Views: 228

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