Asked by Maria Amavizca on Apr 26, 2024
Verified
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)
Formula
An expression telling the computer or calculator how to mathematically process numbers or symbols.
- Learn the use of various Excel functions for text manipulation.
Verified Answer
KM
Katelynn McCaffreyApr 28, 2024
Final Answer :
B
Explanation :
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)
=RIGHT(A24, 2)
Learning Objectives
- Learn the use of various Excel functions for text manipulation.