SOLVED

How to change case of first word in a cell in Excel

Copper Contributor

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?

5 Replies
best response confirmed by Sogbouma (Copper Contributor)
Solution

Hi @Sogbouma 

use this formula

=UPPER(LEFT(A1,(FIND(" ",A1,1)-1)))&" "&(RIGHT(A1,LEN(A1)-FIND(" ",A1,1)))

 

 

 

@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:

Screenshot 2022-02-20 at 07.44.20.png

On a modern Excel version you could use the LET function to make it more compact.

Hello @Jihad Al-Jarady ,
The formula worked perfectly. Thanks a million. I really appreciate the help.
 

Hello @Riny_van_Eekelen,
Your suggestion worked beautifully. Thank you very much for the assistance.
I am glad it helps you
1 best response

Accepted Solutions
best response confirmed by Sogbouma (Copper Contributor)
Solution

Hi @Sogbouma 

use this formula

=UPPER(LEFT(A1,(FIND(" ",A1,1)-1)))&" "&(RIGHT(A1,LEN(A1)-FIND(" ",A1,1)))

 

 

 

View solution in original post