# Re: Create a formula that uses RIGHT() and LEFT() simultaneously

Solved
1272 0
cancel
Showing results for
Did you mean:
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
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)
)
)
``````
2 Replies 2
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)
)
)
``````
7 - App Architect

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