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!