Charlie imported data that displays "Albany, NY" in cell A24.What formula can he use to display "NY" in cell D3?
A) =LEFT(A24, 2)
B) =RIGHT(A24, 2)
C) =LOWER(A24)
D) =EXTRACT(A24, 2)

Question

Quizplus · Accepted Answer

Since the state abbreviation "NY" is at the end of the text string in cell A24, we can use the RIGHT function to extract the last two characters of the string. Therefore, the correct formula is: 
=RIGHT(A24, 2)

Charlie Imported Data That Displays "Albany, NY" in Cell A24