google-sheets

Can't convert cell values to uppercase using UPPER function

I am trying convert cell values to upper using a formula. I have a google sheet with this format:

ID Name
1 usa
2 Canada

To make this, in the next cell I am putting this:

=CONCATENATE("case "; B2; " = "; UPPER(TRIM(A2)); ";")

My expected result is this: case USA = 1;

But I am getting always case usa = 1;

Why are this ignoring my UPPER function?

Solution

  • Apply upper() to B2 instead of A2, like this:

    ="case " & upper(B2) & " = " & A2 & ";"