EXCEL

CODE IS USED TO REMOVE ANY LEFT NO.
if value one
than if value - madhyapradesh
than after formula its becomes :- adhyapradesh

if no. -1 shows the no. of digit remove

=RIGHT(A1,LEN(A1)-1)

Comments