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

	A​	B​
1​	Count​	Total​
2​	1-2​	3​
3​	10-3​	13​
4​	11-12​	23​

<tbody>
</tbody>

 

[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