162k views
4 votes
What is the correct syntax to take the first five characters from the cell and place to its right in cell A3?

2 Answers

5 votes

Answer:

=LEFT(A2,5)

Step-by-step explanation:

User Yodit
by
4.8k points
5 votes

Answer:

In cell A3 we type

=Right(A2,5)

Step-by-step 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)

User Kruger
by
5.0k points