Adding 2 numbers from a single cell

Assuming your 2 numbers are in A1, separated by a hyphen, then you can do this:

Formula:

=LEFT(A1,SEARCH("-",A1)-1) + RIGHT(A1,LEN(A1)-SEARCH("-",A1))

Hope this helps.

Pete