Formula to extract amount from a cell

[Obewan]

In Cell E4 I have the following:
$3,510 - $1,080 - $540

I need a formula in cell AM4 which will get the answer of the first amount - i.e. $3,510

This amount may differ in value so could be $900 or $50

Thanks in advance

Seamus

 

[Peter_SSs]

Does this work for you?

=LEFT(E4,FIND(" ",E4))+0

 

[Obewan]

Awesome!! Thanks

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

 

[proficient]

=--TEXTBEFORE(E4," - ")


=ABS(TEXTBEFORE(E4," - "))