Forum Discussion
How to change case of first word in a cell in Excel
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?
Hi Sogbouma
use this formula
=UPPER(LEFT(A1,(FIND(" ",A1,1)-1)))&" "&(RIGHT(A1,LEN(A1)-FIND(" ",A1,1)))
5 Replies
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.
- Hello Riny_van_Eekelen,
Your suggestion worked beautifully. Thank you very much for the assistance.
Hi Sogbouma
use this formula
=UPPER(LEFT(A1,(FIND(" ",A1,1)-1)))&" "&(RIGHT(A1,LEN(A1)-FIND(" ",A1,1)))
Hello Jihad Al-Jarady ,
The formula worked perfectly. Thanks a million. I really appreciate the help.
- I am glad it helps you
