Search for word in cell

[seacrest]

I want to find and certain word in a certain cell.This word will most likely be in a sentence.Can this be done without using vba

 

[Ivan F Moala]

On 2002-10-05 04:30, seacrest wrote:
I want to find and certain word in a certain cell.This word will most likely be in a sentence.Can this be done without using vba

Have you looked @ Find or Search
Have a look @ Online help for these Functions

 

[seacrest]

Thanks Ivan but i need this to be built into my spreadsheet can you return a word from a sentence on a given cell.?With or without vba

 

[Aladin Akyurek]

On 2002-10-05 04:51, seacrest wrote:
Thanks Ivan but i need this to be built into my spreadsheet can you return a word from a sentence on a given cell.?With or without vba

Care to give some examples of sentences and the words that must be returned?

 

[seacrest]

The cow jumped over the moon (Need to return cow)

 

[Sir Vili]

Hi seacrest.

In cell B1 give cow. In C1 give formula =LEN(B1).

In A2 Your sentence: 'The cow jumped over the moon .

In B2 formula:

=IF(ISERROR((TEXT(MID(SUBSTITUTE(A2," "," "),SEARCH(B1,SUBSTITUTE(A2," "," ")),C1),255))),"Not found";(TEXT(MID(SUBSTITUTE(A2," "," "),SEARCH(B1,SUBSTITUTE(A2," "," ")),C1),255)))

There is sure more simple answers, but this is mine.

Regards Sir Vili.

 

[seacrest]

Thanks Sir Villi that worked well however there was a bad character after "Not Found"
It works great thanks again

 

[Aladin Akyurek]

On 2002-10-05 05:36, seacrest wrote:
The cow jumped over the moon (Need to return cow)

Let A2 house the sentence and D2 the word "cow".

In B2 enter:

=IF(ISNUMBER(SEARCH(D2,A2)),D2,"Not Found")

 

[Candy Samsung]

	A</SPAN>	B</SPAN>
1</SPAN>	Site-Id(SH.Name2)</SPAN>
2</SPAN>	IN03XC115</SPAN>	Here's where I need my formula to search for A2 in the next tab called 'Sprint MMBS Inbox'</SPAN>
3</SPAN>	NY33HO062</SPAN>
4</SPAN>	NY33HO062</SPAN>
5</SPAN>	NY33HO062</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>

 

[Candy Samsung]

Can you gentlemen help me, too?