join text

[RKS]

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]

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

 

[simmo13]

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]

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).

 

[Gord Dibben]

After joining, copy the cell and paste special>value 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

 

[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]

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.

 

[David McRitchie]

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