Forum Discussion

Sogbouma's avatar
Sogbouma
Copper Contributor
Feb 20, 2022
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...
excel
  • Jihad Al-Jarady's avatar
    Jihad Al-Jarady
    Feb 20, 2022

    Hi Sogbouma 

    use this formula

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

     

     

     

Jihad Al-Jarady's avatar
Jihad Al-Jarady
MCT
Feb 20, 2022

Hi Sogbouma 

use this formula

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

 

 

 

  • Sogbouma's avatar
    Sogbouma
    Copper Contributor
    Feb 21, 2022

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

Resources