In this article, you will learn the RIGHT formula and how to use it in Google Sheets.
The RIGHT formula is a simple one. The RIGHT enables you to extract a specified number of letters from the end of a specified value such as text, date and number.
The generic syntax is as follows:
Look at the examples in the picture below. The top table shows how the RIGHT function works and the second one shows how you can use the formula to clean up a data set.
As you can see at the upper table, you can pull out characters from a text, a number and a date. This function is beneficial especially when you have a list of items with a specific number of code or words with a specific number of letters, and you want to extract them as independent values.
It’s very similar to the RIGHT function. Check this article to learn how to use the LEFT function in Google Sheets.
Read this article to learn how to align text in Google Sheets.
Learn how to do this step-by-step in the video below 👇