Which Excel function returns characters from the end of a text string?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Prepare for the Digital Information Technology Exam. Utilize engaging flashcards and diverse multiple-choice questions. Each question offers hints and explanations to enhance your understanding. Get exam-ready now!

Multiple Choice

Which Excel function returns characters from the end of a text string?

Explanation:
Pulling characters from the end of a text string is done with the RIGHT function. It takes the text and the number of characters to return from the right side. For example, RIGHT("Excel", 3) returns "cel", and RIGHT(A1, 2) returns the last two characters of whatever text is in A1. If you omit the second argument, it returns just the final character. This is in contrast to LEFT, which grabs from the start, and MID, which can pull characters from the middle. LEN returns the total length of the string, not a substring.

Pulling characters from the end of a text string is done with the RIGHT function. It takes the text and the number of characters to return from the right side. For example, RIGHT("Excel", 3) returns "cel", and RIGHT(A1, 2) returns the last two characters of whatever text is in A1. If you omit the second argument, it returns just the final character. This is in contrast to LEFT, which grabs from the start, and MID, which can pull characters from the middle. LEN returns the total length of the string, not a substring.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy