Checking if a number appears within a cell

Giganews Newsgroups
Subject: Checking if a number appears within a cell
Posted by:  moonrabbit (moonrabbit.27aflb_1146754204.366@excelforum-nospam.com)
Date: Thu, 4 May 2006

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?action=getinfo&userid=34119
View this thread:http://www.excelforum.com/showthread.php?threadid=538898

Replies