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

Formulas don't allow this kind of character by character formatting.

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

--

Dave Peterson

On Apr 12, 1:41*pm, 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

RKS,

I don't think that it's possible to have different formatting within a
cell - I may well be wrong, but I've not seen it done before.

Alex

If the cell contains text -- not a formula and not a real number, you can select
different characters in the cell (in the formulabar) and change the formatting
(bold/font/font color/etc).



wrote:

On Apr 12, 1:41 pm, 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

RKS,

I don't think that it's possible to have different formatting within a
cell - I may well be wrong, but I've not seen it done before.

Alex

--

Dave Peterson

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

Hi Dave, thanks for reply. I know its difficult. u can think about may be its
possible.
may be its possible thru micro. think again please.
RKS


"Dave Peterson" wrote:

If the cell contains text -- not a formula and not a real number, you can select
different characters in the cell (in the formulabar) and change the formatting
(bold/font/font color/etc).



wrote:

On Apr 12, 1:41 pm, 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

RKS,

I don't think that it's possible to have different formatting within a
cell - I may well be wrong, but I've not seen it done before.

Alex

--

Dave Peterson

It's possible to use a macro to change the format of characters in a cell that
contain text. Try recording a macro when you do it.

But if the cell contains a formula, then it's not possible.



RKS wrote:

Hi Dave, thanks for reply. I know its difficult. u can think about may be its
possible.
may be its possible thru micro. think again please.
RKS

"Dave Peterson" wrote:

If the cell contains text -- not a formula and not a real number, you can select
different characters in the cell (in the formulabar) and change the formatting
(bold/font/font color/etc).



wrote:

On Apr 12, 1:41 pm, 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

RKS,

I don't think that it's possible to have different formatting within a
cell - I may well be wrong, but I've not seen it done before.

Alex

--

Dave Peterson


--

Dave Peterson

You can't have a formula in the cell, so that means if you
need to combine cells you will need to do the concatenation
in the macro, or use copy, then edit, paste special, values.

The macro in the following will capitalize and bold the surname
as in a phone book with names like Jones, Danny

This should get you started if you have worked with macros before
Surnames, Special formatting for LASTNAME, firstname
http://www.mvps.org/dmcritchie/excel/surname.htm

If not then also see
Getting started with macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Dave Peterson" wrote in message ...
It's possible to use a macro to change the format of characters in a cell that
contain text. Try recording a macro when you do it.

But if the cell contains a formula, then it's not possible.



RKS wrote:

Hi Dave, thanks for reply. I know its difficult. u can think about may be its
possible.
may be its possible thru micro. think again please.
RKS

"Dave Peterson" wrote:

If the cell contains text -- not a formula and not a real number, you can select
different characters in the cell (in the formulabar) and change the formatting
(bold/font/font color/etc).



wrote:

On Apr 12, 1:41 pm, 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

RKS,

I don't think that it's possible to have different formatting within a
cell - I may well be wrong, but I've not seen it done before.

Alex

--

Dave Peterson


--

Dave Peterson