Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 14th 11, 12:50 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
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

  #2   Report Post  
Old July 14th 11, 02:33 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find a word in a sentence Chicago2Paris Excel Worksheet Functions 10 October 29th 09 06:29 PM
Link a cell to a word in a sentence Brenelder Excel Discussion (Misc queries) 1 March 14th 08 08:36 PM
how to keep a word of same sentence starting w a capital next lin dottie Excel Worksheet Functions 1 September 20th 07 05:32 PM
separate a Capital starting word from a sentence Rasoul Khoshravan Excel Worksheet Functions 3 October 25th 06 06:31 PM
How do I highlight a word or sentence within Excel? cands Excel Discussion (Misc queries) 1 October 11th 05 10:58 PM


All times are GMT +1. The time now is 10:45 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017