View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carpe Diem Carpe Diem is offline
external usenet poster
 
Posts: 28
Default Find in a sentence diferent word

Hi,

I need to find in a table in one column and X rows more then one
word.

Example:

A1 = mercedes_xpto_iol_mrec_jun
A2 = mercedes_xpto_af_mrec_jun
A3= mercedes_xpto_mf_mrec_jun



I need to see if there is the word "IOL" or the word "AF" or "MF" in
each cell, but only one could be there.

In A1 IOL
In A2 AF
In A3 MF

Thank you