Combine UPPER function with another formula

mdan5678 

Decades ago I learned to locate missing parentheses by counting a formula from left to right, starting at zero, adding one for each left (or "opening") parenthesis, subtracting 1 each time I came to a right (or "closing") parenthesis....Usually that helps. In your case, you need a closing parenthesis at the very end.

Another trick that can work--if the formula gets really long--is to build the levels of nesting one by one, so you very consciously are adding an enclosing set of parentheses one pair at a time, for each new "outer" function.

HOWEVER, even when it works, that formula is not going to deliver the combined names all in caps. And the combination, when it works, isn't going to be what you want.

So let's start with the concatenation itself, where you're going to want to add a space between the two cells being concatenated. =CONCAT(B10," ",C10)

Without the space, you'll get johnsmith instead of john smith

Then, decide what you want:

=UPPER(CONCAT(B10," ",C10)) will yield JOHN SMITH

=PROPER(CONCAT(B10," ",C10)) will yield John Smith

You were adding an extra layer in your formula to begin with, in that UPPER and PROPER each do their own thing with a text string, and they don't really work together. The one that's on the 'outside' of the nesting levels "wins"

As a P.S., that "_xlfn." in your posted formula suggests that you may need to use CONCATENATE instead of CONCAT. You may be working with an older version of Excel, so if those suggested solutions don't work either, substitute CONCATENATE for CONCAT. 

And also consider updating your software if that's the case.