Thread: Find
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BenjieLop
 
Posts: n/a
Default Find

Wrote:
I am trying to find a cell containing the letters I know, is there a
function that allows wildcard characters.

For ex:

I want to find "HIJ" or "HI" or "HIJKL"

in Cells containing string of letters: "ABCDEFGHIJKLMNOPQRS"

Thanks,

J9

Try this ...

=NOT(ISERROR(SEARCH("xxxxxx",A1)))

where xxxxxx = text that you want to search and
A1 = cell is where the string to be searched is in.

Hope this is what you are looking for ... regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=515007

Reply With QuoteReply With Quote