I want bold underline specified formula value in a paragraph. need vba

[vengatvj]

Hi,

I have attached a sample file. Please review it from (A15 TO A160 CELLs). I have so many paragraph in this excel in Tamil language. I wrote paragraph including with this function like below


="this is example paragraph "&Sheet2!A1&" and other text"

I want bold and underline only "&Sheet2!A11&" this type of formula. i have so many "&sheet2!xx&" formula in sheet 1. I want bold all

Simply I want display value in bold and underline. Kindly help me in any way.

Can i display values in original format? for example: in sheet 2 A1 Cel has a text "WELCOME"
Can i display "WELCOME" text in Sheet a1 cell without change its original format?

[JBeaucaire]

You cannot have a FORMULA in a cell and have "partial" formatting of text. You can have one or the other.