Loading suggested videos
=RIGHT(cell, number_of_characters) to extract only the characters you want to keep from the end.=RIGHT(A1, 5) keeps the last 5 characters of the value in cell A1)Enter to apply the formula.Result: Excel will return only the specified number of characters from the end of the original text.
Tip: Use this method when the characters you want to keep are fixed in length and located at the end of each entry.
Your feedback helps us improve our content.