View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carpe Diem Carpe Diem is offline
external usenet poster
 
Posts: 28
Default Find more than a word in a table

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