Forum Discussion

Copper Contributor

Jan 15, 2023

Solved

How to capitalize a specific word in a set of words?

Can someone explain to me or give me a trick on how to capitalize (or change to upper case) only a specific words in a particular constant position in an excel column? I have a column list containin...

excel

Formulas and Functions

Riny_van_Eekelen
Jan 15, 2023
Kcryptonian Perhaps something like this?
=UPPER(LEFT(A1,FIND(" ",A1)-1))&RIGHT(A1,LEN(A1)-FIND(" ",A1)+1)
or
=UPPER(TEXTBEFORE(A1," "))&" "&TEXTAFTER(A1," ")
...... depending on which Excel version you have. And there are probably a dozen more ways to do this.

Harun24HR

Bronze Contributor

Jan 15, 2023

Kcryptonian You may try-

=UPPER(TEXTBEFORE(A2:A5," "))& " " & TEXTAFTER(A2:A5," ")

Kcryptonian

Copper Contributor

Jan 15, 2023

Thanks Harun, but the formular doesn't work on Excel 2010.