Feb 19 2022 10:15 PM
Hello All,
How do I change the case of only the first name in a cell in Excel without affecting other names?
For example, I have
John Jacobs Doe in a cell, and I want to change only JOHN to UPPERCASE, how do I do it?
Feb 19 2022 10:48 PM
SolutionHi @Sogbouma
use this formula
=UPPER(LEFT(A1,(FIND(" ",A1,1)-1)))&" "&(RIGHT(A1,LEN(A1)-FIND(" ",A1,1)))
Feb 19 2022 10:49 PM
@Sogbouma If you want "John" to be replaced by "JOHN" in the same cell, you'll need VBA, I guess. Not my kind of thing. If you can add a column to hold the new name, try this:
On a modern Excel version you could use the LET function to make it more compact.
Feb 20 2022 08:13 PM
Hello @Jihad Al-Jarady ,
The formula worked perfectly. Thanks a million. I really appreciate the help.
Feb 20 2022 08:26 PM
Feb 20 2022 09:38 PM
Feb 19 2022 10:48 PM
SolutionHi @Sogbouma
use this formula
=UPPER(LEFT(A1,(FIND(" ",A1,1)-1)))&" "&(RIGHT(A1,LEN(A1)-FIND(" ",A1,1)))