After joining, copy the cell and paste specialvalue to get rid of the formula.

You can then format sections as you like by selecting parts in the formula bar.


Gord Dibben MS Excel MVP

On Sat, 12 Apr 2008 05:41:00 -0700, RKS wrote:

Hi all,
I can join 3 column like (A1-Name, B1- Middle Name and C1 is Surname) in
column D thru CONCATENATE(a1,b1,c1) aqnd result display in Column D1.

It is possible that in D1 Surname is Bold or italic and rest of normal.
please tell me how is possible.
RKS