Extract Number Before Hyphen Mark (-)

[muhammad susanto]

hello all..

i need someone could help me out to extract number only left position before hyphen mark
check this table below :
note : my number is in decimal format (in indonesian language)
<!-- Please do not remove this header -->

<tbody>
[TD="bgcolor: #FFFFFF"] data [/TD]
[TD="bgcolor: #FFFFFF"] target [/TD]

[TD="bgcolor: #FFFFFF"] 31,75-35 [/TD]
[TD="bgcolor: #FFFFFF, align: right"] 31,75 [/TD]

[TD="bgcolor: #FFFFFF"] 35,1-38,25 [/TD]
[TD="bgcolor: #FFFFFF, align: right"] 35,1 [/TD]

[TD="bgcolor: #FFFFFF"] 38,35-41,5 [/TD]
[TD="bgcolor: #FFFFFF, align: right"] 38,35 [/TD]

[TD="bgcolor: #FFFFFF"] 41,6-44,75 [/TD]
[TD="bgcolor: #FFFFFF, align: right"] [/TD]

[TD="bgcolor: #FFFFFF"] 44,85-48 [/TD]
[TD="bgcolor: #FFFFFF, align: right"] [/TD]

[TD="bgcolor: #FFFFFF"] 48,1-51,25 [/TD]
[TD="bgcolor: #FFFFFF, align: right"] [/TD]

[TD="bgcolor: #FFFFFF"] 51,35-54,5 [/TD]
[TD="bgcolor: #FFFFFF, align: right"] [/TD]

[TD="bgcolor: #FFFFFF"] 54,6-57,75 [/TD]
[TD="bgcolor: #FFFFFF, align: right"] [/TD]

[TD="bgcolor: #FFFFFF"] 57,85-61 [/TD]
[TD="bgcolor: #FFFFFF, align: right"] [/TD]

</tbody>

thanks...

m.susanto

 

[Tetra201]

Try this formula:

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

 

[muhammad susanto]

Try this formula:

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

you are great, many thanks....

 

[Tetra201]

You are most welcome.