I have an extremely basic understanding of excel so please cater your answers accordingly! I need to subtract one cell from another, and then add one to the result, however the I need the formula to ignore the first three characters in the cell (both numbers and letters).
For Example -
A1 Contains - X2X1234 B1 Contains - X7X1256
I want cell C1 to contain contain 23. [(1256-1234)+1]
The cells will always be in the format of letter number letter, and then the four numbers I actually care about. X1XYYYY
Thanks for the help!