EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources TEXT and String Functions in Excel RIGHT Excel Function
 

RIGHT Excel Function

Jeevan A Y
Article byJeevan A Y
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated May 30, 2023

RIGHT Function in Excel

 

 

RIGHT Function in Excel

Right function in Excel, which is used to extract the cell values starting from the extreme right. We can also select the number of characters we must extract from the selected cell. This is quite helpful in extracting some portion of the text. For example, if a cell contains FIRST and we want to use the Right function here considering 3 characters to be extracted, we will get RST starting from the right as output.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

RIGHT Formula in Excel:

Below is the RIGHT Formula in Excel.

RIGHT Formula in Excel

Explanation of RIGHT Function in Excel:

A RIGHT Formula in Excel has two parameters: i.e., text and num_chars.

  • Text: From the text that you want to extract specified characters.
  • The number of characters you want to extract from the given text. [num_chars]: This is an optional parameter. If you do not provide any numbers by default, it will give you only one character.

Usually, a RIGHT function in Excel is used alongside other text functions like SEARCH, REPLACE, LEN, FIND, LEFT, etc…

How to Use RIGHT Function in Excel?

RIGHT Function in Excel is very simple and easy to use. A RIGHT function can be used as a worksheet function and a VBA function. Let us understand the working of the RIGHT function in Excel by some RIGHT Formula examples.

You can download this RIGHT Function Excel Template here – RIGHT Function Excel Template

Example #1

Look at the below data that contains invoice numbers. You need to extract the last 4 digits of all the invoice numbers using the RIGHT function in Excel.

RIGHT Example 1-1

We can extract the last 4 digits of the above text using the RIGHT function in Excel. 

RIGHT Function Example 1-2

So the result will be :

RIGHT Example 1-3

Example #2

Assume you have serial numbers from A1 to A10 and must extract 6 characters from the right.

RIGHT Example 2-1

A RIGHT function will return the last 6 digits from the right end of the text.

RIGHT Function Example 2-2

Result is :

RIGHT Example 2-3

Example #3

Below are the names of the employees, and you need to extract the Last Name separately.

RIGHT Example 3-1

In the above example, we cannot just apply RIGHT with specified numbers because the last name of every employee is different. Here we need to use LEN & FIND function to determine the number of characters from the given text. For the first employee, the last 4 characters are 5, but for the second one, it is 11 (including space, i.e., Robert Adam), and for the third one, it is 12 (including space, i.e., J. Johnston).

RIGHT Function Example 3-2

So the result will be :

RIGHT Example 3-3

RIGHT Example 3-4

Part 1: This part determines the desired text that you want to extract from the characters.

Part 2: LEN function will give you the total number of characters in the list. We will see the detailed article on LEN in the upcoming articles.

RIGHT Example 3-5

Result is :

RIGHT Example 3-6

Part 3: The FIND function determines from which number space begins, i.e., The End of the first name. We will see the detailed article on FIND in the upcoming articles.

RIGHT Example 3-7

Result is :

RIGHT Example 3-8

Len gives 10 characters and Finds 5 for the first employee. That means LEN – FIND (10 – 5) = 5 characters from the right side.

RIGHT Example 3-9

The result will be Smith.

RIGHT Example 3-10

Len gives 16 characters, and Find gives 5 characters for the first employee. That means LEN – FIND (16 – 5) = 11 characters from the right side.

RIGHT Example 3-11

The result will be Robert Adam.

RIGHT Example 3-12

Len gives 17 characters, and Find gives 5 characters for the first employee. That means LEN – FIND (17 – 5) = 12 characters from the right side.

RIGHT Example 3-13

The result will be J. Johnston.

RIGHT Example 3-14

NOTE: Space is also considered as one character.

Example #4

Let us consider the same example from the above. Name the employees, and you need to extract the Last Name separately. i.e., only ADAM, not ROBORT ADAM.

RIGHT Example 4-1

This is done using LEN, FIND, and SUBSTITUTE formulas alongside the RIGHT function in Excel.

The first SUBSTITUTE function will replace the space (““) with “#,” and then LEN, a function, will deduct the space character number from the SUBSTITUTE function to get only the last name characters.

RIGHT Function Example 4-2

So the result will be :

RIGHT Example 4-3

Example #5

From the below table, extract the last number until you find a space.

RIGHT Example 5-1

This is a bit of complex data, but we can still extract the last characters using the RIGHT Function in Excel and the FIND function.

RIGHT Function Example 5-2

So the result will be :

RIGHT Example 5-3

RIGHT Example 5-4

Part 1: This part determines the desired text that you want to extract from the characters.

Part 2: LEN function will give you the total number of characters in the list.

Part 3: The FIND function determines from which number “@” begins.

Example #6

Below are the errors find out while you are working on the web-based software. You need to extract the substring after the last occurrence of the delimiter.

RIGHT Example 6-1

This can be done by combining LEN, SEARCH & SUBSTITUTE, and the RIGHT function in Excel.

RIGHT Function Example 6-2

  • The first step is to calculate the total length of the string using the LEN function: LEN(A2)
  • The second step is to calculate the length of the string without delimiters by using the SUBSTITUTE function that replaces all occurrences of a colon with nothing: LEN(SUBSTITUTE(A2, “:”,”))
  • Lastly, we subtract the length of the original string without delimiters from the total string length: LEN(A2)-LEN(SUBSTITUTE(A2, “:”,”))

So the result would be:

RIGHT Example 6-3

Example #7

RIGHT Function in Excel does not work with Dates. Since the RIGHT function is a text function, it can extract numbers too, but it does not work with dates. Assume you have a date in cell A1 “22-Oct-18.”

RIGHT Example 7-1

Then we’ll try to extract the year with the formula.

RIGHT Function Example 7-2

The result would be 3395.

RIGHT Example 7-3

In Excel, ideology 3395 means 2018 if the format is in Dates. So RIGHT function in Excel will not recognize it as a date but, as usual, as a number only.

VBA RIGHT Function

In VBA, also we can use the RIGHT function. Below is a simple illustration of the VBA right function.

RIGHT Function Example 7-4

If you run the above code, it will give you the below result.

RIGHT Function Example 7-5

Things to Remember

  • Number formatting is not part of a string and will not be extracted or counted.
  • Right Function in Excel is designed to extract the characters from the right side of a specified text.
  • If the user does not specify the last parameter, it will take 1 by default.
  • Num_chars must be greater than or equal to zero. If it is a negative number, it will throw the error as #VALUE.
  • A RIGHT function will not give accurate results regarding date formatting.
  • In the case of complex data sets, you need to use other text functions like LEN, SEARCH, FIND, and SUBSTITUTE to get the Num_chars parameter.

Recommended Articles

This has been a guide to the RIGHT Function in Excel. Here we discuss the RIGHT Formula in Excel and How to use the RIGHT Function in Excel, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles –

  1. CHOOSE Function in Excel
  2. FV Function in Excel
  3. LEFT Formula in Excel
  4. RIGHT Formula in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download RIGHT Function Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download RIGHT Function Excel Template

EDUCBA

डाउनलोड RIGHT Function Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW