Finding Unique Numbers within a list of notes

[ParksideDR]

I am working with journal entries. I am trying to find the unique numbers in a cell that also contains words. I am unable to upload the excel spreadsheet due to it being financials. But I can give examples. Here is are some examples: 2000 carpet clean for makeready. repair planking 1884. 2N205 Cleaned. There are others that do not contain any numbers which is perfectly fine to exclude. How would I be able to identify the total number of unique numbers in a cell range that includes text?

<tbody>
</tbody>

 

[VBA Geek]

hi would you judge this "2N205" as 2205 or would you exclude it?

 

[ParksideDR]

I would judge it as a number. To give you more information they are in reference to doors in an apartment complex. I work with multiple apartments and the naming of units are different. Some will be purely numbers other will include a letter with the number.