Just a thought. Are you trying to say that if there is a common word in all
the lines, you need to know that word?
Example
I let you go
Let me in
Who let the dogs out
To let
and you need the value in your first column to be '*let*'?
I'd say caramba! if that's the case
And Excel_Lover, you need to add in error condition, otherwise it will
error out when there is no 'cell' in the text. Check Noorain's solution
where he suggested using IFERROR along with the SEARCH function.
Regards,
Sam Mathai Chacko
On Tue, Feb 7, 2012 at 11:15 AM, Excel_Lover <idforex...@gmail.com> wrote:
> =IF(FIND("cell",E13),"cell","")
>
>
> On Tue, Feb 7, 2012 at 8:38 AM, Mohammed Muneer <mmun...@ccc.com.qa>wrote:
>
>> ** **
>>
>> *****del****** cell *
>>
>> *bel cell del*
>>
>> *cell bel del*
>>
>> *cell ell llec*
>>
>> *blood consist of red cell and white cell*
>>
>> *simos is a cell*
>>
>> *max cell*
>>
>> *sony cell*
>>
>> *a cell is a source of energy for some electronic devices and stands as
>> a two way power.*
>>
>> ** **
>>
>> Above mentioned lines are having the word “cell” in common, Ok I want to
>> extract the same in the cell beside (the highlighted).****
>>
>> For example, we are at first line *****del****** cell *and if I can do
>> this to extract the word *cell.*
>>
>> * *
>>
>> cell****
>>
>> ****del**** cell****
>>
>> cell****
>>
>> bel cell ****del********
>>
>> cell****
>>
>> cell bel ****del********
>>
>> cell****
>>
>> cell ell llec****
>>
>> cell****
>>
>> blood consist of red cell and white cell****
>>
>> cell****
>>
>> simos is a cell****
>>
>> cell****
>>
>> max cell****
>>
>> cell****
>>
>> sony cell****
>>
>> cell****
>>
>> a cell is a source of energy for some electronic devices and stands as a
>> two way power.****
>>
>> ** **
>>
>> ** **
>>
>> Regards,****
>>
>> Muneer,****
>>
>> CC...****
>>
>> ** **
>>
>> ** **
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ------------------------------------------------------------------------------------------------------
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
