# concatenate and bold in libreoffice [closed]

I want to concatenate and BOLD a part of the formula. For example: =CONCATENATE(a1, a2) where a1 = Parag and a2 = Agarwal. I want to BOLD only a1 i.e. Parag.

Result should be like this - Parag Agarwal

How is it possible?

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2016-02-18 17:26:32.882641

1

No, for the result of the formula it's impossible. You can format the various fragments of the text string, but not the result of calculations.

( 2012-11-12 15:06:13 +0200 )edit

Sort by » oldest newest most voted

Well, yes... and no.

You can achive a partial concatenation of two cells by using HTML. For example, concatenating A1 and B2 would be:

=CONCATENATE("<b>"; A1; "</b>: ";B1; "<br/>")


And then, copy and paste this column in a plain text file saving it as .html. After that, open it in your web browser and copy and paste again to Calc.

Not exactly a Calc solution, but it works.

more

hmmm. the same is with excel. i do not understand that if there is a formula available for UPPERCASE then why there is no formula for BOLD.

more

Probably because UPPERCASE() is a string manipulation function, while bold is a style.