Thread: Help With Searching For Strings In Part Numbers
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
  
Posts: 6
Default Help With Searching For Strings In Part Numbers
On 6/21/2011 at 9:43:09 AM Claus Busch wrote:

=IF(COUNT(SEARCH({"1K0PR";"1K0SI";"1K0VA";"1K0VR"} ,A1))0,"X","")

Works great! Thanks.
--
tb
Reply With QuoteReply With Quote