formula that would pick out the number values within a cell

i have a large spreadsheet including a lot of client details, the name of the client and the client code which is anywhere between 5 and 10 numbers are included within one cell is there a formula that would pick out the number values of the cell.. with out cut and pasting them.. I have tried =right(.. but it picks up on too many numbers for some of them..

any help would be fantastic.. cheers

Thanks for changing your title. Can you give a few examples of the entries so we can see if there's a pattern etc

VBA Noob