Help with an Excel formula

Copper Contributor
I'm not sure if what I need is possible.
When I add the value of two cells (ie a1 = 3 & a2 =9 giving a total of 12) I want to be able to take the second digit, (in this example it would be the '2') and display it in another cell. I tried just subtracting 10 from the total but then this wouldn't work correctly if the total was 20 or greater.
Is there any way this can be achieved?
Thanks in advance for any help!
1 Reply

@CSlane29 Although this community is for Ms Access your question has a very easy answer

Assuming you perform this addition in C1 cell then to get "2" ...eg. in Cell D1 it would be :

=MID(C1;2;1)