Converting text into usuable number

[dbogey]

I am pulling out information from a cell using =RIGHT(C2,4). It gives me 6-2 in the cell, which is what I want. Now I want to sum the cell but can't figure out how to do it. I have tried converting it but it doesn't work, I tried pulling out each digit, but that didn't work. I am sure this is simple for all of you, but any help would be appreciated.

Ideally, I would like a formula that could convert cell A1 into a result in one cell.

Thanks for the help,
Steveconverting text example.xlsx

[slx]

Will the numbers always be in the same position? 3rd from the right and last?

[Draconi]

Here is what you can do based on your spreadsheet:

1) Fix the formula of B1 to "=Right(A1,3)"
2) Fix the formula of E1 to "=Left(B1,1)"
3) In G1 type: "=value(E1)+value(F1)"

[FDibbins]

Try this, assuming that your data will not always be in the format/layout as in your sample...
=--MID(A1,SEARCH(CHAR(160),A1,1)+1,FIND("-",A1,1)-FIND(CHAR(160),A1,1)-1)+MID(A1,FIND("-",A1,1),99)

If the format will always be as per your sample, then use this...
=MID(A1,5,1)-RIGHT(A1,1)

edit: @ draconi, OP asked..."Ideally, I would like a formula that could convert cell A1 into a result in one cell."

[newdoverman]

Using your calculated value in B1

Please Login or Register  to view this content.

If you want to use the value in A1 directly:

Please Login or Register  to view this content.

[martindwilson]

6-2 is that 4 or 8?

[dbogey]

Thanks very much. FDibbins 1st option looks like it works, thank you.

Newdoverman's 2nd option works, except is always adds.

[newdoverman]

If you want to subtract:

Please Login or Register  to view this content.