I have the following in column A :

A
1
2
3 4
3 4 5
3
4
5
1 3


How do I find out if the number 1 is found in Column A. Column A
contains either a single entry or multiple entries separated by
"ALT+Enter" (Chr(10)).

I don't care if it is there more than once, only if it is there at
all.

Any suggestions?

TIA

Heather.


--
peacelittleone


------------------------------------------------------------------------
peacelittleone's Profile: http://www.excelforum.com/member.php...o&userid=20937
View this thread: http://www.excelforum.com/showthread...hreadid=383726