Mar 29 2023 01:09 PM
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.
Mar 29 2023 01:34 PM
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.
Mar 29 2023 01:39 PM
A very slight variation on what my friend @Hans Vogelaar has written for you.
=UPPER(LEFT(A2,FIND(",",A2)))&PROPER(RIGHT(A2,LEN(A2)-FIND(",",A2)))
works as shown here
Mar 29 2023 01:43 PM
In general, however, I would avoid putting first and last names into the same cell. Why? Doing that limits flexibility. Keeping them separate allows you to assemble such things as alphabetical listings sorted by last name AND also create name labels for various purposes with first name first.
Mar 29 2023 03:56 PM
Thank you so much!@Hans Vogelaar