Check if a cell contains 5 numeric charaters

[pgrad]

Hi All,

I have used this solution to extract some numeric data from my original data source http://www.mrexcel.com/forum/showthread.php?t=105555

I now need to do a check to return something like a 'yes' or a 'no', '1' or '0' if a cell contains a string of 5 numeric values.

I have Googled and searched these forums but must be phrasing my question incorrectly as I'm sure this can be done.

Any help much appreciated!

Thanks
Paul

 

[pgrad]

Hi All,

I was being daft.

=LEN(A1)

I can then filter on the number 5.

Apologies.
Paul