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.

Units

289 Transactions

0 Transactions

76 Transactions

1,066 Transactions

0 Transactions

402 Transactions

505 Transactions

406 Transactions

720 Transactions

0 Transactions Many thanks

<colgroup><col></colgroup><tbody>
</tbody>

 

[steve the fish]

Try:

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

 

[Bazzza67]

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

Cheers!