Formula To Return Numerals Left Or Right Of A "-" Sign

[glerwell]

Hi

I working with some statistics and have some data like so:

Excel Workbook
	L
6	5-0
7	5-0
8	5-0
9	4-1
OVERALL OVER-UNDER

What I want is two formulas, one that will return the numerical to the left of the "-" and the other to return what is to the left of the "-" sign.

I know of LEFT and RIGHT but sometimes the data will be adouble number so they could look like this:

10-6 or 18-11

Many thanks

 

[Expiry]

this will return what's left of the "-" in cell C7:

=LEFT(C7,FIND("-",C7)-1)

This will return what's right

=RIGHT(C7,LEN(C7)-FIND("-",C7))

 

[tigeravatar]

glerwell,

You could use text-to-columns with the hyphen as the delimiter. If you need the formula though, you can use the following:

For the left:
=LEFT(A1,FIND("-",A1)-1)
For the right:
=MID(A1,FIND("-",A1)+1,LEN(A1))

Hope that helps,
~tigeravatar

 

[VoG]

Try like this

Excel Workbook
	L	M	N
6	5-0	5	0
7	5-0	5	0
8	5-0	5	0
9	4-1	4	1
Sheet1

 

[glerwell]

Thanks guys!