Removing first two digits in Excel if the character length is greater than certain number

You're not using the parenthesis properly. Also since you strictly want to have 10 characters, you don't need to calculated the length in the RIGHT formula.. It needs to be like this:

=IF(LEN(D2)>10,RIGHT(D2, LEN(D2)-2),D2)

=IF( LEN(B2)>10, RIGHT(B2, LEN(B2)-2) ,B2 )

RIGHT(A1,10)

It will automatically get the 10 characters at the end and remove the rest.