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?
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.
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.
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.
Probably because UPPERCASE() is a string manipulation function, while bold is a style.