Return blank for cells with non-number characters?

[Crispy131]

I have one field where some cells contain only numbers while others contain a mix of numbers/letters/special characters.

I want a formula that will return all the values with numbers only and return a blank for all the cells that contain other characters not just numbers.

Anyone know how I can do this? Any help is much appreciated!

Thanks

[binuacs · Accepted solution]

@Crispy131 One way of doing this with the regex_match function

[Crispy131]

Amazing this did the trick, thank you!