PakAccountants.com

RIGHT

Fetch specified number of characters starting from the right side of mentioned text string

Syntax of Excel Right formula:
=RIGHT(text,[num_chars])

In words:
=Starting from right(of this text, fetch these many number of characters)

Examples of Excel Right Formula

=RIGHT(“other world of our own”,3) will return own
=RIGHT(“A.B.C.D.”,3) will give .D. as dot is considered character.