I don't know if this can be done? But, here it goes.

I have a cell that has a line of text in it. I need to be able to search the
text string and look for certain words and copy the word into another cell.

Example:

Cell "R2": runs 1/11, raw material issue

I need to look at that cell and find the words raw material and copy "raw
material" into another cell.

I'll also be looking for other words in the cells to differientate reasoning
for issues.

Words like:

Pail issue, Art Work, etc.

I don't nessarily need to copy the words if that's an issue. I could code
the different words with numbers. So if I'm looking for the words "raw
material", I could code it as equal to "1". If this makes it easier.

Thanks in advance.
--
Baltimore Ravens

So, you have the following in cell R2:

runs 1/11, raw material issue

and you want the words "raw material" to appear in , say, S2 because
they are present in R2 ?? If so, try this in S2:

=IF(ISNUMBER(SEARCH("raw material",R2)),"raw material","")

Not sure about the rest of your question, but hope this helps.

Pete

On Jan 31, 1:40*pm, Ravens Fan
wrote:
I don't know if this can be done? But, here it goes.

I have a cell that has a line of text in it. I need to be able to search the
text string and look for certain words and copy the word into another cell..

Example:

Cell "R2": * * * runs 1/11, raw material issue

I need to look at that cell and find the words raw material and copy "raw
material" into another cell.

I'll also be looking for other words in the cells to differientate reasoning
for issues.

Words like:

Pail issue, Art Work, etc.

I don't nessarily need to copy the words if that's an issue. I could code
the different words with numbers. So if I'm looking for the words "raw
material", I could code it as equal to "1". If this makes it easier.

Thanks in advance.
--
Baltimore Ravens

Yes it worked great.

The second part is:

"R2" could also say:

runs 1/11, raw material issue

or

Art Work not delivered.


So, what I'm trying to do is look for the different scenerios and capturing
words.

In this example, R2 could say anyone of the three examples. So, I am looking
in the cell and searching for different scenerios, "raw material", "pail
issue" or "Art Work" and copy what it finds into "S2"

Pail issue, delivery 1/31

or



--
Baltimore Ravens


"Pete_UK" wrote:

So, you have the following in cell R2:

runs 1/11, raw material issue

and you want the words "raw material" to appear in , say, S2 because
they are present in R2 ?? If so, try this in S2:

=IF(ISNUMBER(SEARCH("raw material",R2)),"raw material","")

Not sure about the rest of your question, but hope this helps.

Pete

On Jan 31, 1:40 pm, Ravens Fan
wrote:
I don't know if this can be done? But, here it goes.

I have a cell that has a line of text in it. I need to be able to search the
text string and look for certain words and copy the word into another cell..

Example:

Cell "R2": runs 1/11, raw material issue

I need to look at that cell and find the words raw material and copy "raw
material" into another cell.

I'll also be looking for other words in the cells to differientate reasoning
for issues.

Words like:

Pail issue, Art Work, etc.

I don't nessarily need to copy the words if that's an issue. I could code
the different words with numbers. So if I'm looking for the words "raw
material", I could code it as equal to "1". If this makes it easier.

Thanks in advance.
--
Baltimore Ravens

Glad it worked for you.

If you want to look for three items of text, then you can just combine
three IFs as follows:

=IF(ISNUMBER(SEARCH("raw material",R2)),"raw
material",IF(ISNUMBER(SEARCH("pail issue",R2)),"pail
issue",IF(ISNUMBER(SEARCH("art work",R2)),"art work","")))

If you have more than 3 items then this approach will become more
unwieldly, so you would probably be better using MATCH.

Hope this helps.

Pete

On Jan 31, 2:23*pm, Ravens Fan
wrote:
Yes it worked great.

The second part is:

"R2" could also say:

runs 1/11, raw material issue

or

Art Work not delivered.

So, what I'm trying to do is look for the different scenerios and capturing
words.

In this example, R2 could say anyone of the three examples. So, I am looking
in the cell and searching for different scenerios, "raw material", "pail
issue" or "Art Work" and copy what it finds into "S2"

Pail issue, delivery 1/31

or

--
Baltimore Ravens



"Pete_UK" wrote:
So, you have the following in cell R2:

runs 1/11, raw material issue

and you want the words "raw material" to appear in , say, S2 because
they are present in R2 ?? *If so, try this in S2:

=IF(ISNUMBER(SEARCH("raw material",R2)),"raw material","")

Not sure about the rest of your question, but hope this helps.

Pete

On Jan 31, 1:40 pm, Ravens Fan
wrote:
I don't know if this can be done? But, here it goes.

I have a cell that has a line of text in it. I need to be able to search the
text string and look for certain words and copy the word into another cell..

Example:

Cell "R2": * * * runs 1/11, raw material issue

I need to look at that cell and find the words raw material and copy "raw
material" into another cell.

I'll also be looking for other words in the cells to differientate reasoning
for issues.

Words like:

Pail issue, Art Work, etc.

I don't nessarily need to copy the words if that's an issue. I could code
the different words with numbers. So if I'm looking for the words "raw
material", I could code it as equal to "1". If this makes it easier.

Thanks in advance.
--
Baltimore Ravens- Hide quoted text -

- Show quoted text -

Yea, I do have a lot of different scenarios with words. There is no easy way
around it either.

I thought there might be a way to have a list of words and if it finds any
of them, it would return that particular word.

I'm looking at the "match" command in the help section and it's not a lot of
help.
--
Baltimore Ravens


"Pete_UK" wrote:

Glad it worked for you.

If you want to look for three items of text, then you can just combine
three IFs as follows:

=IF(ISNUMBER(SEARCH("raw material",R2)),"raw
material",IF(ISNUMBER(SEARCH("pail issue",R2)),"pail
issue",IF(ISNUMBER(SEARCH("art work",R2)),"art work","")))

If you have more than 3 items then this approach will become more
unwieldly, so you would probably be better using MATCH.

Hope this helps.

Pete

On Jan 31, 2:23 pm, Ravens Fan
wrote:
Yes it worked great.

The second part is:

"R2" could also say:

runs 1/11, raw material issue

or

Art Work not delivered.

So, what I'm trying to do is look for the different scenerios and capturing
words.

In this example, R2 could say anyone of the three examples. So, I am looking
in the cell and searching for different scenerios, "raw material", "pail
issue" or "Art Work" and copy what it finds into "S2"

Pail issue, delivery 1/31

or

--
Baltimore Ravens



"Pete_UK" wrote:
So, you have the following in cell R2:

runs 1/11, raw material issue

and you want the words "raw material" to appear in , say, S2 because
they are present in R2 ?? If so, try this in S2:

=IF(ISNUMBER(SEARCH("raw material",R2)),"raw material","")

Not sure about the rest of your question, but hope this helps.

Pete

On Jan 31, 1:40 pm, Ravens Fan
wrote:
I don't know if this can be done? But, here it goes.

I have a cell that has a line of text in it. I need to be able to search the
text string and look for certain words and copy the word into another cell..

Example:

Cell "R2": runs 1/11, raw material issue

I need to look at that cell and find the words raw material and copy "raw
material" into another cell.

I'll also be looking for other words in the cells to differientate reasoning
for issues.

Words like:

Pail issue, Art Work, etc.

I don't nessarily need to copy the words if that's an issue. I could code
the different words with numbers. So if I'm looking for the words "raw
material", I could code it as equal to "1". If this makes it easier.

Thanks in advance.
--
Baltimore Ravens- Hide quoted text -

- Show quoted text -

Well, post the list of words you are interested in here, then I can
get some idea of the size of the problem. Maybe a SUMIF array formula
might be better.

Pete

On Jan 31, 3:25*pm, Ravens Fan
wrote:
Yea, I do have *a lot of different scenarios with words. There is no easy way
around it either.

I thought there might be a way to have a list of words and if it finds any
of them, it would return that particular word.

I'm looking at the "match" command in the help section and it's not a lot of
help.
--
Baltimore Ravens



"Pete_UK" wrote:
Glad it worked for you.

If you want to look for three items of text, then you can just combine
three IFs as follows:

=IF(ISNUMBER(SEARCH("raw material",R2)),"raw
material",IF(ISNUMBER(SEARCH("pail issue",R2)),"pail
issue",IF(ISNUMBER(SEARCH("art work",R2)),"art work","")))

If you have more than 3 items then this approach will become more
unwieldly, so you would probably be better using MATCH.

Hope this helps.

Pete

On Jan 31, 2:23 pm, Ravens Fan
wrote:
Yes it worked great.

The second part is:

"R2" could also say:

runs 1/11, raw material issue

or

Art Work not delivered.

So, what I'm trying to do is look for the different scenerios and capturing
words.

In this example, R2 could say anyone of the three examples. So, I am looking
in the cell and searching for different scenerios, "raw material", "pail
issue" or "Art Work" and copy what it finds into "S2"

Pail issue, delivery 1/31

or

--
Baltimore Ravens

"Pete_UK" wrote:
So, you have the following in cell R2:

runs 1/11, raw material issue

and you want the words "raw material" to appear in , say, S2 because
they are present in R2 ?? *If so, try this in S2:

=IF(ISNUMBER(SEARCH("raw material",R2)),"raw material","")

Not sure about the rest of your question, but hope this helps.

Pete

On Jan 31, 1:40 pm, Ravens Fan
wrote:
I don't know if this can be done? But, here it goes.

I have a cell that has a line of text in it. I need to be able to search the
text string and look for certain words and copy the word into another cell..

Example:

Cell "R2": * * * runs 1/11, raw material issue

I need to look at that cell and find the words raw material and copy "raw
material" into another cell.

I'll also be looking for other words in the cells to differientate reasoning
for issues.

Words like:

Pail issue, Art Work, etc.

I don't nessarily need to copy the words if that's an issue. I could code
the different words with numbers. So if I'm looking for the words "raw
material", I could code it as equal to "1". If this makes it easier.

Hi,

You don't need to extract it, just look if it there

=IF(ISERROR(SEARCH("raw material",R2)),"","Raw material")

Mike

"Ravens Fan" wrote:

I don't know if this can be done? But, here it goes.

I have a cell that has a line of text in it. I need to be able to search the
text string and look for certain words and copy the word into another cell.

Example:

Cell "R2": runs 1/11, raw material issue

I need to look at that cell and find the words raw material and copy "raw
material" into another cell.

I'll also be looking for other words in the cells to differientate reasoning
for issues.

Words like:

Pail issue, Art Work, etc.

I don't nessarily need to copy the words if that's an issue. I could code
the different words with numbers. So if I'm looking for the words "raw
material", I could code it as equal to "1". If this makes it easier.

Thanks in advance.
--
Baltimore Ravens

On Thu, 31 Jan 2008 05:40:01 -0800, Ravens Fan
wrote:

I don't know if this can be done? But, here it goes.

I have a cell that has a line of text in it. I need to be able to search the
text string and look for certain words and copy the word into another cell.

Example:

Cell "R2": runs 1/11, raw material issue

I need to look at that cell and find the words raw material and copy "raw
material" into another cell.

I'll also be looking for other words in the cells to differientate reasoning
for issues.

Words like:

Pail issue, Art Work, etc.

I don't nessarily need to copy the words if that's an issue. I could code
the different words with numbers. So if I'm looking for the words "raw
material", I could code it as equal to "1". If this makes it easier.

Thanks in advance.

Here's one method that will return the desired phrase if it is present in the
source text.

This assumes the source text is less than 256 characters long. If it is
longer, we can certainly rewrite the routine to handle it.

Download and install Longre's free (and easily distributable by embedding in
the workbook) morefunc.xll add-in from:

http://xcell05.free.fr/morefunc/english/index.htm

Set up your list of Phrases to search for in a column (which I NAME'd Phrase).

Then use this formula (with your test sentence in A1):

=REGEX.MID(A1,MCONCAT(Phrases,"|"),,FALSE)
--ron