Google Sheets: How to Extract Text with the RIGHT Function

Use natural language to write 'right function' with AI

Capgo

— 1 min read
Google Sheets: How to Extract Text with the RIGHT Function

The RIGHT Formula in Google Sheets

The RIGHT formula in Google Sheets extracts a specified number of characters from the right side of a text string.

To use the RIGHT formula, you need to enter the following syntax into a cell:

=RIGHT(text, num_chars)
  • "text" is the text string from which you want to extract characters.
  • "num_chars" is the number of characters you want to extract from the right side of the text string.

For example, if you have the text string "Hello World" in cell A1 and you want to extract the last 5 characters, you would enter the formula =RIGHT(A1, 5) in another cell. This would return "World" as the result.

Now you can use simple words to process data. It's at CapGo AI Sheet. For Google Sheet formula '=RIGHT(A1, 4):

You can write a simple instruction "Extract the last 4 characters from the text in #A."

In 1 second, all your data is processed!

Try it now at CapGo.AI

Read more