Bold the Formula Cells

[webmax]

Hi
I have a two cells A1 & A2

A1 Cell contains Mr.
A2 Cell Contains Name ie John

When i put the formula in A3 Cell concatenate A1 & A2 Cell in it is coming as Mr.John.

I the Result to Come as Mr. John in tha John should bold in word.

Any one help on this.

regard
Shahul

 

[udprocks]

Hi
I have a two cells A1 & A2

A1 Cell contains Mr.
A2 Cell Contains Name ie John

When i put the formula in A3 Cell concatenate A1 & A2 Cell in it is coming as Mr.John.

I the Result to Come as Mr. John in tha John should bold in word.

Any one help on this.

regard
Shahul

Hi Shahul,

Go through it , i think it will helps u...

http://www.mrexcel.com/forum/excel-questions/352267-concatenate-bold-excel-2007-a.html