Create a formula that uses RIGHT() and LEFT() simultaneously

[Soly]

Hi!

I created a field that concatenates the last name and full name in a table.
I am trying to write a function that takes the 2 letters first letter of the first name and 2 last letters of the last name.
But it only returns the 2 first letters of the first name.
Here is the formula
CONCATENATE(
UPPER(
LEFT(
{Full Name},2),
RIGHT(
{Full Name},2)
))

How can we make it happen ?
Thank you

[kuovonne · Accepted solution]

Your problem is because you are nesting UPPER() inside the CONCATENATE(). UPPER() takes only one parameter, but you are sending it two, so it ignores the second one. Flip-flop these two functions:

UPPER(
    CONCATENATE(
        LEFT({Full Name},2),
        RIGHT({Full Name},2)
    )
)

[Soly]

Awesome! It is working now. Thanks @kuovonne ! :pray: