Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a word from text out of a cell
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a word from text out of a cell
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a word from text out of a cell
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a word from text out of a cell
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a word from text out of a cell
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 - |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a word from text out of a cell
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 - |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a word from text out of a cell
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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a word from text out of a cell
Here is the list I have so far. There will probably be a few more, which I
could add later. Also, I shortened some of the word searches. raw make to order line priority pail label sales ahead scc deploy Thanks again for your help. This is saving me a ton of time. -- Baltimore Ravens "Pete_UK" wrote: 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. Thanks in advance. -- Baltimore Ravens- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a word from text out of a cell
So, imagine that you put this list somewhere on the sheet, eg in
Z1:Z8. Then in S2 try this array* formula: =IF(ISNUMBER(SEARCH(Z1:Z8,R2)),Z1:Z8,"") *As this is an array formula, then once you have typed it in, or subsequently edit it, you must commit it using CTRL-SHIFT-ENTER (CSE) rather than the usual ENTER. If you do this correctly, then Excel will wrap curly braces { } around the formula when viewed in the formula bar - you must not type these yourself. I'm not exactly certain that it will work - give examples of what happens if it does not. Hope this helps. Pete On Jan 31, 4:56*pm, Ravens Fan wrote: Here is the list I have so far. There will probably be a few more, which I could add later. Also, I shortened some of the word searches. raw make to order line priority pail label sales ahead scc deploy Thanks again for your help. This is saving me a ton of time. -- Baltimore Ravens "Pete_UK" wrote: 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. Thanks in advance. -- Baltimore Ravens- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a word from text out of a cell
I setup the list in column "Z". in column "V" I put the array:
{if(isnumber(search($z$2:$z$9,r2)),$z$1:$z$9,"")} The list is in this order: raw make to order line priority pail label sales ahead scc deploy It returns a 0 when it sees the word raw, but, does nothing when any of the other words show up (the cell is blank). -- Baltimore Ravens "Pete_UK" wrote: So, imagine that you put this list somewhere on the sheet, eg in Z1:Z8. Then in S2 try this array* formula: =IF(ISNUMBER(SEARCH(Z1:Z8,R2)),Z1:Z8,"") *As this is an array formula, then once you have typed it in, or subsequently edit it, you must commit it using CTRL-SHIFT-ENTER (CSE) rather than the usual ENTER. If you do this correctly, then Excel will wrap curly braces { } around the formula when viewed in the formula bar - you must not type these yourself. I'm not exactly certain that it will work - give examples of what happens if it does not. Hope this helps. Pete On Jan 31, 4:56 pm, Ravens Fan wrote: Here is the list I have so far. There will probably be a few more, which I could add later. Also, I shortened some of the word searches. raw make to order line priority pail label sales ahead scc deploy Thanks again for your help. This is saving me a ton of time. -- Baltimore Ravens "Pete_UK" wrote: 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. Thanks in advance. -- Baltimore Ravens- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a word from text out of a cell
I did say that I didn't think it would work !! It's a bit late here,
but I'll have another look at it tomorrow. Pete On Jan 31, 6:09*pm, Ravens Fan wrote: I setup the list in column "Z". in column "V" I put the array: {if(isnumber(search($z$2:$z$9,r2)),$z$1:$z$9,"")} The list is in this order: raw make to order line priority pail label sales ahead scc deploy It returns a 0 when it sees the word raw, but, does nothing when any of the other words show up (the cell is blank). -- Baltimore Ravens "Pete_UK" wrote: So, imagine that you put this list somewhere on the sheet, eg in Z1:Z8. Then in S2 try this array* formula: =IF(ISNUMBER(SEARCH(Z1:Z8,R2)),Z1:Z8,"") *As this is an array formula, then once you have typed it in, or subsequently edit it, you must commit it using CTRL-SHIFT-ENTER (CSE) rather than the usual ENTER. If you do this correctly, then Excel will wrap curly braces { } around the formula when viewed in the formula bar - you must not type these yourself. I'm not exactly certain that it will work - give examples of what happens if it does not. Hope this helps. Pete On Jan 31, 4:56 pm, Ravens Fan wrote: Here is the list I have so far. There will probably be a few more, which I could add later. Also, I shortened some of the word searches. raw make to order line priority pail label sales ahead scc deploy Thanks again for your help. This is saving me a ton of time. -- Baltimore Ravens "Pete_UK" wrote: 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. Thanks in advance. -- Baltimore Ravens- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a word from text out of a cell
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP IF Cell Contains a Word within Text | Excel Discussion (Misc queries) | |||
word match in string text in cell, color format cell | Excel Discussion (Misc queries) | |||
formula for pulling only numbers but not text from another cell | Excel Worksheet Functions | |||
Pulling text from a cell | Excel Worksheet Functions | |||
Omit the first word from a cell contain text | Excel Worksheet Functions |