Here's one way to use Excel: with LAST, first in cell A1, use this
formula in another cell:
=UPPER(MID(A1,1,FIND(",",A1,1)))&MID(A1,FIND(",",A 1,1)+1,LEN(A1))
This formula converts anything before the comma to upper case, and
everything after the comma as it originally appears.
|