Excel RIGHT Function can extract a number of characters from a cell starting from the last character. If you check above example word “Brown” has 5 characters starting from the first character from the right side.
In the below example, we have extracted 6 characters using right function. If you know, how many characters you need to extract from the string, you can simply extract them by using a number.
Now, if you look at the below example, where we have to extract the last name from the cell, but we are not confirmed about the number characters in the last name. So, we are using LEN Function and FIND Function to get the name.
Let me show you, how we have done this. First of all, we have used the LEN Function to get the length of that entire text string, then we used the FIND Function to get the position number of space between first and last name. And, in the end, we have used both the figures to get the last name.
To learn more about Excel RIGHT Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.