Extract Text using RIGHT

Pull the last characters from a code or label.

You will learn to

• Use RIGHT with a character count

How it works

RIGHT(text, num_chars) returns characters from the end of a string. =RIGHT(A2,4) returns "0815" from "NE-2024-0815".

When the part you want has a variable length, pair RIGHT with LEN and FIND: =RIGHT(A2,LEN(A2)-FIND("-",A2)) returns everything after the first hyphen.

=RIGHT(A2,4)