Forum Discussion
Combine UPPER function with another formula
I've looked online, and I'm only seeing instructions on how to capitalize names by using the UPPER function by itself. Is there any way to combine this function with another formula? I'm wanting to c...
Of course, you can wrap LOWER, UPPER or PROPER text case functions around CONCATENATE, TEXTJOIN, LEFT, RIGHT and other text functions.
For example, PROPER(LEFT(K2,FIND(" ",K2)-1) will extract all the leftmost Name from the Full Name and delivered in Proper case.
See the attached picture
For example, PROPER(LEFT(K2,FIND(" ",K2)-1) will extract all the leftmost Name from the Full Name and delivered in Proper case.
See the attached picture
