Text Format

Thread view:

Thread rating:

achatta@yahoo.com - 09 Mar 2007 18:25 GMT

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

Gary''s Student - 09 Mar 2007 19:06 GMT

copy the cell containing the formula and paste/special/value somewhere else
Then format the resulting text string.

Signature

Gary''s Student
gsnu200709

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

Gord Dibben - 09 Mar 2007 19:50 GMT

You cannot do this in a formula.

Gord Dibben MS Excel MVP

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