SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-3189041%22%20slang%3D%22en-US%22%3EHow%20to%20change%20case%20of%20first%20word%20in%20a%20cell%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3189041%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3CBR%20%2F%3EHow%20do%20I%20change%20the%20case%20of%20only%20the%20first%20name%20in%20a%20cell%20in%20Excel%20without%20affecting%20other%20names%3F%26nbsp%3B%3CBR%20%2F%3EFor%20example%2C%20I%20have%3C%2FP%3E%3CP%3E%3CSTRONG%3EJohn%20Jacobs%20Doe%3C%2FSTRONG%3E%26nbsp%3Bin%20a%20cell%2C%20and%20I%20want%20to%20change%20only%20JOHN%20to%20UPPERCASE%2C%20how%20do%20I%20do%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3189041%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3189065%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20case%20of%20first%20word%20in%20a%20cell%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3189065%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1312629%22%20target%3D%22_blank%22%3E%40Sogbouma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Euse%20this%20formula%3C%2FP%3E%3CP%3E%3DUPPER(LEFT(A1%2C(FIND(%22%20%22%2CA1%2C1)-1)))%26amp%3B%22%20%22%26amp%3B(RIGHT(A1%2CLEN(A1)-FIND(%22%20%22%2CA1%2C1)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3189066%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20case%20of%20first%20word%20in%20a%20cell%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3189066%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1312629%22%20target%3D%22_blank%22%3E%40Sogbouma%3C%2FA%3E%26nbsp%3BIf%20you%20want%20%22John%22%20to%20be%20replaced%20by%20%22JOHN%22%20in%20the%20same%20cell%2C%20you'll%20need%20VBA%2C%20I%20guess.%20Not%20my%20kind%20of%20thing.%20If%20you%20can%20add%20a%20column%20to%20hold%20the%20new%20name%2C%20try%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-02-20%20at%2007.44.20.png%22%20style%3D%22width%3A%20607px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349737i10BAC6C50DA3638C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-02-20%20at%2007.44.20.png%22%20alt%3D%22Screenshot%202022-02-20%20at%2007.44.20.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EOn%20a%20modern%20Excel%20version%20you%20could%20use%20the%20LET%20function%20to%20make%20it%20more%20compact.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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 (Occasional 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