i'm trying to search for certain word(s) (i.e. "reply??" or "remind") in a cell with a sentence in it, and place a specific text on a different cell depending on the word it finds. If J3 text is "remind him to call", i'd like A3 to show "remind" in blue. If J3 text is "left message, waiting for reply??", i'd like A3 to show "reply??" in red.
Currently this is the function i'm using and only works for one word.
Any thoughts and help to solve this will be greatly appreciated.
Find words within cell & put text and color in adjacent cell
you'll see that I've used a Data Validation drop down in J3. This is just as a safeguard to ensure that spelling, punctuation, spaces etc. are exactly as per the formula because any differences between the two, however minor, will not allow the formula to work.
I've used Conditional Formatting to colour the font as per your post.
hey guys , i am trying to copy some text and paste in to another column but i dont know how to use formula plz advise. thx
task 1,,,,this is what i have info in my cells in rows..
1..aqua di gio 3.4fl.oz eau de toilett for men .
2..aqua di gio 1.7fl.oz eau de perfume for men .
3..aqua di gio 1.0fl.oz eau de cologne for men.
from above cells i would like to take sizes such as 3.4 fl.oz , 1.7 fl.oz,1.0 fl.oz and paste those sizes to next column ....( sheet contains about 15 diffrent sizes ( text) which i need to find and copy paste to another column )
1..aqua di gio 3.4 fl.oz eau de toilette for men .
2..aqua di gio 1.7 fl.oz eau de perfume for men .
3..aqua di gio 1.0 fl.oz eau de cologne for men.
from above cells i want to find and paste diffrent text in to another cell..
....eau de toilette......if found then in next column = EDT ....eau de perfume.....if found then in next column = EDP ....eau de cologne.....if found then in next column = EDC
meaning ...if 'eau de perfume' then i want to paste EDP in next column ..and so on ..( sheet contains about 12 diffrent types(text) which i need to find from more then thousand products in cell and copy paste diffrent text for them in next column )....