Help

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

Topic Labels: Formulas
Solved
Jump to Solution
1862 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Soly
7 - App Architect
7 - App Architect

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

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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)
    )
)

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

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 ! :pray: