How to make Text in a Merged Cell of different Font(s) & Font Size Programmatically?

How to make Text in a Merged Cell of different Font(s) & Font Size Programmatically?

Dear Forum,

I have a particular Form which is basically a Blank Template and which is going to be used with Dynamic Names and then further for Printing.

The names are going to be selected from a Drop-Down and that is concatenated in the Template TEXT..

TO make it look more Authentic I want to haev this Text in a Different Font and Larger Font Size than the remaining text..

Ex:-

Cell B6 =

Received with thanks from MR. SACHIN RAMESH TENDULKAR a return of income and/or return of fringe benefits in Form No. ITR … for assessment year 2009-10, having the following particulars.

AS you can see the reamaining text is of normal Times New Roman Font and regular Font Size.

This TExt is Pulled from a DropDown connected to a List Names in the cell U1.

U1= MR. SACHIN RAMESH TENDULKAR

="Received with thanks from"& MR. SACHIN RAMESH TENDULKAR &"a return of income and/or return of fringe benefits in Form No. ITR … for assessment year 2009-10, having the following particulars."

So ,how DO i manage this difference in Font(s) and FOnt Size in a single cell which is Merged.

Warm Regards
e4excel