CSlane29Copper ContributorSep 03, 2019Help with an Excel formulaI'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') a...Show More
tsgiannisIron ContributorSep 03, 2019CSlane29 Although this community is for Ms Access your question has a very easy answerAssuming you perform this addition in C1 cell then to get "2" ...eg. in Cell D1 it would be :=MID(C1;2;1)
