Text Format
 

How can I format diffrent font size and color for only text "Sample"
while using formula =concatenate(c2,"Sample",c3).

Text Format
 

copy the cell containing the formula and paste/special/value somewhere else
Then format the resulting text string.
--
Gary''s Student
gsnu200709


" wrote:

How can I format diffrent font size and color for only text "Sample"
while using formula =concatenate(c2,"Sample",c3).

Text Format
 

You cannot do this in a formula.


Gord Dibben MS Excel MVP

On 9 Mar 2007 10:25:34 -0800, wrote:

How can I format diffrent font size and color for only text "Sample"
while using formula =concatenate(c2,"Sample",c3).