I need two excel formulas. I need a formula for column B that will give me what I have in column A without the last two digits. The next formula in column C will give me the last to digits from column A. Can you provide this formulas?
Column A Column B Column C
Have Want 1 Want 2
Ukraine UP Ukraine UP
United Arab Emirates AE United Arab Emirates AE