Sum values seperated by a hyphen

[FryGirl]

How can I sum these values that are separated by a hyphen other than using =LEFT(A2,FIND("-",A2)-1)+MID(A2,FIND("-",A2)+1,2)

There will always only be one hyphen and the two values will never be over two digits on each side of the hyphen.

Data Range
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

Count​

[/TD]
[TD]

Total​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

1-2​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

10-3​

[/TD]
[TD]

13​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

11-12​

[/TD]
[TD]

23​

[/TD]
[/TR]
</tbody>[/TABLE]

 

[bosco_yip]

Try,

In B2, copied down

=IMREAL(A2&"i")-IMAGINARY(A2&"i")

Regards
Bosco

 

[Yongle]

@bosco_yip very nice

 

[Yongle]

@FryGirl
A less erudite option
- Insert a column to the right of column A
- Select data in column A
- Data Tab \ Text-To-Columns \ use hyphen as Other Delimiter
- Sum the 2 columns normally in column C with:
=A2+B2

 

[FryGirl]

Thanks Bosco and Yongle.
@bosco, that works great