Share this article:

What it does: The RIGHT() Function removes a string from the right side of a given piece of text according to parameters you set.

Plain English: The RIGHT() Function is for removing the right part of a string.

Imagine we have a list of sales data, including the date on which the sales were made. Each date is formatted like 01/20/2015. If that date is in cell A2, the formula RIGHT(A2,4) would yield “2015” and we just removed the year from our date. We can then apply the formula to the rest of our data

Arguments: RIGHT(text,no. of characters)

  • Text – The text you want to pull a string from
  • No. of characters – How many characters do you want to remove from the right?
Please remember that we may receive commissions when you click our links and make purchases