Copy C1 and paste/special/value back onto C1.

Then you can format parts of the resultant string.
--
Gary''s Student - gsnu200851


"Scott" wrote:

I have three columns. A1 contains person's first name. B1 contains person's
last name. C1 is a formula that combines A1 and B1, so therefore it would be
Last Name, First Name.

Now my question is, when combining the first two cells, is there a way to
have Last Name a different font than First Name? And a different size?

Thanks.