Hi,
I have a long column of data, some cells have numbers in the cells some with text.
I want to get the numbers out. Any ideas on a formula for this?

Thanks

Simon