Actually, Gary, that does work for me, except that when I make updates to
Columns A1 or B1 the changes don't update in C1.

I was unable to get the coding to register, however.


"Gary''s Student" wrote:

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.