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," "))