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)
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
Post a Comment