How to get Right characters from cells in Excel | How to use RIGHT formula (function) in Excel

RIGHT

Use of RIGHT Formula / Function IN Excel:

RIGHT Formula/Function helps to return right characters in particular
cell in to another cell.
It begin at right position.

Syntax/Formula of RIGHT Function in Excel

The syntax of RIGHT formula in Microsoft Excel is below


=RIGHT(text,[num-chars])

Example of RIGHT Function in Excel

Step 1: First type ADVANCEDMSEXCEL.BLOGSPOT.COM in cell B4 as per shown in below image

Step 2: Type formula in cell =RIGHT(B4,12) in cell B6 and press enter.

RIGHT FUNCTION