View Single Post
  #5   Report Post  
Dave O
 
Posts: n/a
Default

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.