returning only a number?

[zeeero]

Is there a way to return only the number from a cell, that contains text also!
whitout the "=RIGHT(A1;X)"?

Something like:
The contet of a cell is "100 Birdies" and returns only the number: "100"?

Anyone?

[Rutgers_Excels]

you can use this as long as the value is always the first number. If it was to say "Birdies 100" it wouldn't work....

=VALUE(LEFT(A1,FIND(" ",A1)))

[zeeero]

Thanks alot!