how to put avalaible value to designated cell

Question

I'm having some trouble here.
I have an excel test.
The instruction is to adding a final value with an available value, and it should using trim(instruction unclear but it just said "TRIM" on the sheet test.

The data is look like these.
Btw, what is the function in excel to fill the final score but skip the blank(Actually if it with trim)?

Answer 1

If you really, really must use Trim(), you might opt for following solution:

=TRIM(A1&B1)

It means that you are using both cells "A1" and "B1" as strings, you concatenate them and trim it, so, in case either one of them contains only space characters, those get chopped off.

Answer 2

Seems pretty easier. MAX() may work for you.

=MAX(C2:D2)

For Microsoft 365 user can use BYROW() for array approach.

=BYROW(C2:D16,LAMBDA(x,MAX(x)))