Skip to main content

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

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)

    )

)

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)

    )

)

Awesome! It is working now. Thanks @kuovonne ! 🙏

Reply


Terms & Conditions