Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

Topic Labels: Formulas
Solved
Jump to Solution
429 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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: