How to use Right Function in Excel

Right function helps in extracting content from text in an Excel Cell. There can be many use cases where we have to work with Text values in Excel. For example there may be a need to extract, Last name from full name, extract company name from email, extract zip code from address etc. In such examples Right function is helpful. In this article we will discuss how to use Right function in Excel with the help of an example.

John has customer spend data for his company. He is looking forward to create updated Phone column. The new Phone column should have last 12 characters of the Phone, which will be without the country code. For example for Phone number “80-790-163-1507” we will have new Phone number as “790-163-1507”.

Extract 12 character from Right

• Step 1: The first parameter of Right function is “text”. “text” is the cell which contains Text value, from which we will extract letters from the Right. For this example it is Phone i.e. cell H5. So we will be entering the same.

                  =RIGHT(H5, )

• Step 2: The second parameter is how many characters we are looking to extract from the cell. Currently the requirement is to extract twelve values from the cell, so we will add 12 in the syntax. After putting the value, press enter to get the results.

                  =RIGHT(H5,12)

• Step 3: Copy the cell I5 and paste the formulas to rest of the cells in the column. This will generate updated Phone column for whole table.

To get top certifications in Microsoft Excel and build your resume visit here. Also, you can read books listed here to build strong knowledge around Microsoft Excel.

Please visit our video tutorial to go through the example as well:

Share your feedbacks if you like the article. Like and share for more such content.