
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 10, 2022 06:46 AM
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
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 10, 2022 07:59 AM
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)
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 10, 2022 07:59 AM
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)
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 10, 2022 08:36 AM
Awesome! It is working now. Thanks @kuovonne ! :pray:
