Extract number value from a cell

[Bazzza67]

Hi Boardmembers

I wonder if someone can please assist me.

I have a column, for which I would like to extract the number value, that may be one-five characters, into a new column and ignore the
"transactions" part.

[TABLE="width: 155"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: left"]Units[/TD]
[/TR]
[TR]
[TD="align: left"]289 Transactions[/TD]
[/TR]
[TR]
[TD="align: left"]0 Transactions[/TD]
[/TR]
[TR]
[TD="align: left"]76 Transactions[/TD]
[/TR]
[TR]
[TD="align: left"]1,066 Transactions[/TD]
[/TR]
[TR]
[TD="align: left"]0 Transactions[/TD]
[/TR]
[TR]
[TD="align: left"]402 Transactions[/TD]
[/TR]
[TR]
[TD="align: left"]505 Transactions[/TD]
[/TR]
[TR]
[TD="align: left"]406 Transactions[/TD]
[/TR]
[TR]
[TD="align: left"]720 Transactions[/TD]
[/TR]
[TR]
[TD="align: left"]0 Transactions

Many thanks[/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

Try:

=0+LEFT(A1,FIND(" ",A1&" ")-1)

 

[Bazzza67]

Excellent, thank you "Steve the fish"...works brilliantly!

Cheers!