For anyone who is not familiar with these two functions, they are very simple in concept and easy to pick up.
Pro-tip: I explain LEFT and RIGHT (+other text functions) in much more in-depth right here
They do exactly what they sound like they do:
They return a substring of characters from the left or right side of our original text string.
Both require one argument: ‘text’.
This is the text or cell reference to apply the function to.
There is also an optional argument: ‘num_chars’. This is the number of characters from the left or right that we want the function to return. (If we omit this argument, the functions return the first character from the left or right.)
The formal syntax for each is as follows:
Imagine how this can help us solve our ‘fifa world cup’ problem.
First, we should be aware of something…
… Since the first four letters of our string need to be all capital letters, we want to isolate this part of the original string.
Then we’re going to apply the ‘UPPER’ function to it.
We can isolate those four letters by using ‘LEFT’.
‘=LEFT(“fifa world cup”, 4)’
This gets us the substring result of ‘fifa’.
Since we know this we can enclose the above formula within the ‘UPPER’ function to get ‘FIFA’:
‘=UPPER(LEFT(“fifa world cup”, 4))’
In the following figure, we have used the cell reference ‘B2’ in the ‘UPPER’ function (cell ‘D2’).
This is the same as ‘=LEFT(A2,4)’ since that is the formula in cell ‘B2’ resulting in ‘fifa’.
Since the substring ‘world cup’ is 9 characters in length (including the space), our formula will be:
‘=RIGHT(“fifa world cup”, 9)’
In much the same way, the ‘LEFT’ function parsed ‘fifa’ for us, our ‘RIGHT’ function parses out ‘world cup’.
Then like we did with ‘fifa’ we need to enclose our ‘RIGHT’ formula within the ‘PROPER’ function.
Putting it all together requires a bit more finesse.
Join our two substrings by using the ‘&’ and an extra space between them.
I know this is starting to get a bit advanced.
My point is to introduce you to the further possibilities. It takes some practice.
But, these advanced techniques are worth learning to get the most out of your letter case functions.