this comment section apparently also does not support rich text formatting, the part of string i want bold are
Mr. Dev Bahadur Karki. (from the B10 cell)

Mr. Dev Bahadur Karki (from the B21 Cell) and,

Dhapasi-4(Sabik), Tokha Municipality-6(Present); Kathmandu. (from the D11 cell)

Can i bold a part of result within the cell containing various formula and text with other texts with in the same cell in regular size?


for example. my cell contains following formula (I have kept it on italic so as to distinguish it as a formula and part of formula to be displayed bold in the bold letter).
="The team has read the guidelines provided by the company for preparing the "&" report and we have visited the site to undergo assignment for client "&B10&". The property owner is "&B21&" for which the client has submitted legal documents of the property that is proposed to be"&" used. The location of the property is at "&D11&". The team has assessed the property. "&"The team also tried to incorporate as many details as possible. Additional information required by"&" the company has been provided in ANNEXURE-1 as per the format and some of the information has been provided here under."

The result should be like following.

The team has read the guidelines provided by the company for preparing the valuation report and we have visited the site to undergo assignment for client Mr. Dev Bahadur Karki. The property owner is Mr. Dev Bahadur Karki for which the client has submitted legal documents of the property that is proposed to be used. The location of the property is at Dhapasi-4(Sabik), Tokha Municipality-6(Present); Kathmandu. The team has assessed the property. The team also tried to incorporate as many details as possible. Additional information required by the Bank has been provided in ANNEXURE-1 as per the format and some of the information has been provided here under.

Oh boy, so many clicks for a so basic feature...