Back to guides
Google Sheets Formulas

How to Use RIGHT Function in Google Sheets

In this article, you will learn the RIGHT formula and how to use it in Google Sheets.

What is the RIGHT function 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. 

How to use the RIGHT formula in Google Sheets

  • Type “=RIGHT” or go to “Insert”“Function” “TEXT”“RIGHT”

  • Select a text by cell reference or manual input for “string

  • Define how many letters the formula pull out from the begging of the text string by entering value at “number_of_characters

How to insert the RIGHT function 
How to insert the RIGHT function in Google Sheets

The generic syntax is as follows:

=RIGHT(string, [number_of_characters])

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.

How to insert the RIGHT function 
How to use the RIGHT function in Google Sheets with examples

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.

Why spend hours creating spreadsheets, when we have already done the work for you?
100+ financial spreadsheet templates, all free and ready for you now.
Free Spreadsheet Templates

How do you use LEFT function in Google Sheets?

It’s very similar to the RIGHT function. Check this article to learn how to use the LEFT function in Google Sheets.

How do I align right in Google Sheets?

Read this article: How to Align Text in Google Sheets to learn how to align text in Google Sheets.

The world's top businesses trust LiveFlow to automate their financial reporting
We turn Quickbooks Online data into a live FP&A dashboard in Sheets FAST!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below