RIGHT  

This function extracts a specified amount of characters from the right-hand side of a string.

This function extracts a specified amount of characters from the right-hand side of the input string'. To use this function the format needs to be

RIGHT(input, number)

So a simple example would be

=RIGHT("EXAMPLE",4) would give MPLE

If the input is less than the number then the whole string will be returned

=RIGHT("EXA",4) would give EXA

Any text containing spaces needs to be contained within "".