Ask Your Question

concatenate and bold in libreoffice [closed]

asked 2012-11-12 10:21:14 +0200

AJParag gravatar image

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 flag offensive 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



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.

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

2 Answers

Sort by » oldest newest most voted

answered 2014-01-23 11:59:02 +0200

vmassuchetto gravatar image

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.

edit flag offensive delete link more

answered 2012-11-14 17:12:43 +0200

AJParag gravatar image

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.

edit flag offensive delete link more


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

oweng gravatar imageoweng ( 2014-01-24 07:33:33 +0200 )edit

Question Tools


Asked: 2012-11-12 10:21:14 +0200

Seen: 2,858 times

Last updated: Jan 23 '14