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

Use the LEFT function to return characters starting from the left side of a cell. The formula =LEFT(A2,5) takes the first five characters from A2; enter it in A3 to place the result there. The RIGHT function would return the last five characters instead.

AI-written and checked against the verified answer.