Respuesta :

Answer:

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)

Answer:

=LEFT(A2,5)

Explanation: