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...
SallyH -
It looks like this is similar to your need; with a little modification of course https://www.extendoffice.com/documents/excel/824-excel-flip-first-last-name.html.
=UPPER(REPLACE(MID(B2&", "&B2,FIND(",",B2)+2,LEN(B2)),FIND(",",MID(B2&", "&B2,FIND(",",B2)+2,LEN(B2))),1," "))
ChrisMendoza, mathetes , Abiola1 Thanks so much for the fast responses!! I had this formula: MID(B1&" "&B1,FIND(", ",B1)+1,LEN(B1))), which worked great for changing the names, but I couldn't figure out where to put the UPPER function. I kept wanting to show it as UPPER(B1). I finally found it online before I checked my messages here!
UPPER(MID(B1&" "&B1,FIND(", ",B1)+1,LEN(B1))).
- Absolutely... All Text Case Functions such as PROPER, LOWER and UPPER are always outside the formula i.e UPPER(CONCAT(A1," ",B1))
