How to return characters from the end of a text in Excel | Right Function Explained With Example
The RIGHT Function is categorized under Excel TEXT functions.
The function will return a specified number of characters from the end of a given text string.
In data cleaning and data prepration, the RIGHT function can be useful if we wish to extract characters
from the right side of a text string. Generally, it is used by combining it with other functions such
as VALUE, SUM, COUNT, DATE, DAY, etc.
Formula
=RIGHT(text,[num_chars])
The RIGHT function uses the following arguments:
Text (required argument) – This is the original text string.
Num_chars (optional argument) – Specifies the number of characters to be returned from the end of the given text. It is the number of characters to be extracted starting on the right side of the text. If we omit the argument, the default value of 1 is taken.
Excel Playlist:- • What is MS Excel | Introduction To Ex...
SQL Playlist:- • Introduction to SQL | SQL For Beginne...
Google Data Studio playlist:- • Introduction to Looker|Introduction t...
__________________________________________________________________________________________________
You can follow us on the below social media handles:-
Blog: - https://thedatamillennials.blogspot.com/
Facebook:- / the-data-millennials-596575371027542
Instagram: - / the_data_millennials
LinkedIn: - / data-millennials-6b5a031b3
Twitter: - / datamillennials