Count the numer of digits in an alphanumerc string

[HangMan]

How can I count the number of numbers in an alphanumeric 'string'. My cell could be formatted as either a number or as text, depending on which would provide a solution?

For example if a cell contains AC34723D6H78, there would be 8 numbers, in KT12.456 there would be 5 numbers an so on. I've tried playing around with LEN and various other things, but no no avail.

I would like to be able to do two things, firstly, display the number of 'numbers' in an adjacent cell and secondly apply a conditional format to highlight cells that contain more than or less than a specified number of numbers within the 'string' if that is possible?

Many thanks

[rcm]

Try this macro (button)

The highlightcolor is the in B1 , so is the minimum number of digits to be highlighted

[dredwolf]

assuming your data starts in A1 going down, try this :

Please Login or Register  to view this content.

Drag down

Hope this helps

Edit-

for CF try it this way:
(for >6 say)

Please Login or Register  to view this content.