There are a few useful functions in Google Sheets that you can use to return substrings from a specific string.
One such function is the right function. Using this formula allows you to take a string and return a specific substring from the right of your original string.
In this tutorial, I will show you how to use the RIGHT function in Google Sheets.
Table of Contents
RIGHT Syntax
The RIGHT function will take a string and return a substring from the right of your original string according to the number of characters that you specify in the formula.
The syntax of the RIGHT function is:
=RIGHT(string, [number_of_characters])
- string – the string that will be taken to return a specific substring from the right
- number_of_characters – this is an optional argument and will be set to 1 by default. Here you specify the number of characters from the right of the string that you want to return
Using the RIGHT Function
Using the RIGHT function is very simple.
Here are the steps:
- For the first argument of the function, put in the cell reference that contains your string (or you can put your string directly in the function)
- For the second argument of the function, put a number that represents how many characters from the right of your string you want returned
Here are a few examples:
Let’s break down each formula used in the example so you can understand what each one is doing:
- =RIGHT(A2) – by default if you leave the number_of_characters parameter out of your function, it will be set to 1. So this returns a single letter all the way at the right of the original string
- =RIGHT(A3,2) – this takes the string in A3 and returns 2 characters starting from the right
- =RIGHT(A4,3) – this takes the string in A4 and returns 3 characters starting from the right
- =RIGHT(A5,4) – this takes the string in A5 and returns 4 characters starting from the right
Closing Thoughts
Hopefully by now after you have read through this entire tutorial, you have a good understanding of how to use this function.
I have only covered the basics of how to use it here, but RIGHT is a useful formula that can be combined with other formulas to do more advanced things.
More Google Sheets Tutorials:
How to Use the LEN Function
How to Use the SUBSTITUTE Function