Hi,

I have following formula that needs to be modified.

=IF(ISERROR(SEARCH("BOFA",V98)),"0",MID(V98,SEARCH ("- ",V98)+1,99)+0)

Seconf search criteria which is "- " can be either "- " or "for". How can i
incorporate the second criteria as "for"?

Thanks,
Dinesh