Formula to Caluclate difference separated by Hyphen in Single Cell

[petes]

All - Need Some help on Formula to calculate the difference for the figures appearing in single separated by Hyphen

In Column A of Excel I have values like:

413.0-413.1 in A1
414.00-414.07 in A2
414.10-414.12 in A4

I need a formula in Column B that will display the Result as:

2 in B1 for A1
8 in B2 for A2
3 in B3 for A4

Actullay, the Result is the difference in figures between the hyphen (-) and adding 1 to it. Since it is in the single cell, i am not able to think of any formula

Any Thoughts?? Thanks!!

 

[barry houdini]

Did you try my suggestion, it doesn't depend on the hyphen symbol.......

 

[petes]

wow!! Thanks a lot barry.... itz working