Excel: Formula Or Code To tell Me Difference between 2 Cells


I need a Formula Or Code To tell Me Difference between 2 Cells please. The example below shows that the difference in B2 to A2 is B299 and B3 to A3 is 8. With the result in C please. Thanks. N.B the difference could be anywhere in the cell. Excel 2010

ABC
1OrigValueChangeValueDiff
2Fiesta 1.6 MK 7 (2008-2013)Fiesta 1.6 MK 7 B299 (2008-2013)B299
3Fiesta 1.6 MK 7 (2008-2013)Fiesta 1.6 MK 8 (2008-2013)8

Sheet1




This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of July 20, 2017.


For more resources for Microsoft Excel