Forum Discussion
Solved
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 UPPER...
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:
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.
