View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Finding a string within a cell value

Heather,

The "InStr" Function does what you want.
It returns a Variant (Long) specifying the position of the first occurrence
of one string within another.

Jim Cone
San Francisco, USA


"peacelittleone"
<peacelittleone.1tawim_1123261540.0021@excelforu m-nospam.com
wrote in message
news:peacelittleone.1tawim_1123261540.0021@excelfo rum-nospam.com...
Say I have a string = "abc".
Say I have a cell value = "123 abc 456 def"
In VB how do I findout if the cell value contains my string?
Right now I am trying this: (which of course doesn't work)
Set Found = Find(c.Value, req.Value, 1)
Where c is my string and req is the cell value I want to look in.
TIA!!!!
Heather.--
peacelittleone