Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,751
- Office Version
- 365
- Platform
- Windows
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 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | OrigValue | ChangeValue | Diff | ||
2 | Fiesta 1.6 MK 7 (2008-2013) | Fiesta 1.6 MK 7 B299 (2008-2013) | B299 | ||
3 | Fiesta 1.6 MK 7 (2008-2013) | Fiesta 1.6 MK 8 (2008-2013) | 8 | ||
Sheet1 |