Hi,

Presuming your capitalized words are in A1, this should work:

=PROPER(LEFT(A1,FIND(", ",A1)-1))&RIGHT(A1,4)
HTH,

SamuelT