How to find find last letter of S,pore car plate no using modulus operation???

Something to do with %26#039;a mod n%26#039; but Excel can%26#039;t do it. Please help(URGENT!) !!|||That%26#039;s impossible..|||You have to state the whole problem, or something close to it.