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.
A very slight variation on what my friend HansVogelaar has written for you.
=UPPER(LEFT(A2,FIND(",",A2)))&PROPER(RIGHT(A2,LEN(A2)-FIND(",",A2)))
works as shown here
- Thank you so much!
