W webmax Member Oct 23, 2014 #1 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 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 Member Oct 23, 2014 #2 webmax said: 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 Click to expand... 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
webmax said: 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 Click to expand... 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