Hi,

I have a column of cells that contain data that looks like this...

VI 06 08 09 10 11 12 13 17 18 21 22 24 31 41 56 67 72 73 74 75

I would like the cell next to it to tell me if a number between 1 and 7
(inclusive) appears within this cell. I know how to check for the
appearance of a string, but not a numeric value that falls within a
specified range.

Any help would be much appreciated

moonrabbit


--
moonrabbit
------------------------------------------------------------------------
moonrabbit's Profile: http://www.excelforum.com/member.php...o&userid=34119
View this thread: http://www.excelforum.com/showthread...hreadid=538898