Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find a word in a sentence | Excel Worksheet Functions | |||
Link a cell to a word in a sentence | Excel Discussion (Misc queries) | |||
how to keep a word of same sentence starting w a capital next lin | Excel Worksheet Functions | |||
separate a Capital starting word from a sentence | Excel Worksheet Functions | |||
How do I highlight a word or sentence within Excel? | Excel Discussion (Misc queries) |