Concantenate which keeps bold of some parts.

[Andersn]

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.

 

[Andersn]

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.

 

[Becky]

The short answer is that it's not possible without a workaround. There are some good solutions here that might be worth a try:

https://answers.microsoft.com/en-us...function/8ad6fdf2-ea71-42eb-8ce4-03fb1c5ff306

 

[Andersn]

I thought you could do anything Becky!
Thanks, I'll try the link you provided.

 

[Andersn]

The short answer is that it's not possible without a workaround. There are some good solutions here that might be worth a try:

https://answers.microsoft.com/en-us...function/8ad6fdf2-ea71-42eb-8ce4-03fb1c5ff306

I found this.
https://www.extendoffice.com/documents/excel/3858-excel-concatenate-and-bold.html
Unfortunately I do not now how to code. Can this be modified to do what I need?

 

[Andersn]

I found the answer and it works!

1. concantenate column A and B into column P
=CONCATENATE(A1, ", ", B1, ".")
2. Copy column C to column Q (to make it adjacent to the new P)
3. Use
https://www.extendoffice.com/documents/excel/3858-excel-concatenate-and-bold.html
to concantenate "P" with "Q"

Done!!!