ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Find in a sentence diferent word (https://www.excelbanter.com/excel-worksheet-functions/270863-find-sentence-diferent-word.html)

Carpe Diem

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

Don Guillett[_2_]

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


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com