I looked everywhere but could not find a solution to this.

I have a column that contains numbers and text. Some cells contain just numbers, some just text and some a combination. There is no pattern. Is there a way to remove just the text?

Here's an example:

5,000
4,000cc
none
4k credit
0