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

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)