Remove non-numbers

[Thom7890]

Hello, I'm looking for an equation that populates as in the example spreadsheet.
Basically, I have a column where a material number is and then below it is its location code.
Sometimes the number has a repeated location code.
I'd like to return in a new column just the material number - even where it has a location code.

e.g.
123 - material #
B45 - location
B45 - location

Would like to return:
123
123
123

[JohnTopley]

in C2

=IF(N($B2),$B2,$C1)

copy down