Question: how to extract data from right in excel?
Answer: Summary. ... 
Extract text from the right of a string.
One or more characters.
=RIGHT (text, [num_chars])
text - The text from which to extract characters on the right. ... 
Use the RIGHT function when you want to extract characters starting at the right side of text.