View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default Find in a sentence diferent word

On Jul 14, 6:50*am, Carpe Diem wrote:
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


See your OTHER post in misc. Do not multi post