Returning Just numeric values in a cell. 1

[Cordury]

I have a column of data with account numbers, most contain a letter or two in them. Now, the number of characters in each account number vary from 8 to 30. The text included in the account numbers are not set at a specific space, i.e the first character or the 7th.

Is there a way/formula that will just return all the actual numbers?

For example:
B192634740307A but I just want to return 192634740307

Thanks,
Cord

 

[SkipVought]

Go to the Personal.xls VBA Project and Give the PROJECT a unique name, instead of VBAProject, like VBAPersonal

Skip,
[sub]
[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large! [/sub]