Scott,

No that isn't possible with concatenated text but you could do this. assume
you have concatenated with this

=B1&" "&A1

I.e you have a space between the names. Right click your sheet tab, view
code and paste the code below in. Select Column C and run the code and it
converts the formula to a text string and highlights the last name

Sub HighLight()
For Each c In Selection
c.Value = c.Value
Strt = InStr(c, " ") + 1
With c.Characters(Start:=Strt, Length:=Len(c)).Font
.Size = 12
.ColorIndex = 3
End With
Next
End Sub

Mike

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