Ask Question
6 October, 07:12

What is the correct syntax to take the first five characters from the cell and place to its right in cell A3?

+3
Answers (1)
  1. 6 October, 08:22
    0
    In cell A3 we type

    =Right (A2,5)

    Explanation:

    The Right function in the Microsoft excel is placing the character or the string into the right position. Following are the syntax to using the right function in the excel sheet

    =Right (cell name, num _of_character)

    cell name-In this we have to specify the cell name num_of_character - In this we have to specify the number of character we want the right of the cell name.

    From the given question We have putting the string in the cell A2 and we have used the function in the cell A3 i. e

    =Right (A2,5)
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “What is the correct syntax to take the first five characters from the cell and place to its right in cell A3? ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers