Forum Discussion
formula for upper & lower case in same column
I am trying to find a formula to change the last names to uppercase followed by a comma then proper case the first name, in the same column.
Let's say you have a name such as
presti, christine
in A2. Enter the following formula in another cell in row 2:
=UPPER(LEFT(A2,FIND(",",A2)-1))&PROPER(MID(A2,FIND(",",A2),100))
Fill down as far as needed.
Thank you so much!HansVogelaar
