Find Phrase in a cell and add it to another cell

cybermatrix

New Member
Joined
Jun 2, 2010
Messages
37
Is there a way to look for certain word(s) in a cell and if it finds any of them, it puts the word I would like to use in another cell?

Example here is a description of a product and if the word moisture or wicks is in the cell I would like it to put the word Moisture Wicking in another cell.


  • 100% polyester
  • essential moisture management piqu wicks away moisture
  • keeps you dry and comfortable
  • open-hem sleeves
  • side vents and one-button placket
  • contrast 3-Stripes embroidered detail on sleeves
  • contrast heat-sealed adidas heat-seal logo on back neck
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Like this?

Excel Workbook
AB
1100% polyester 
2essential moisture management piqu wicks away moistureMoisture Wicking
3keeps you dry and comfortable 
4open-hem sleeves 
5side vents and one-button placket 
6contrast 3-Stripes embroidered detail on sleeves 
7contrast heat-sealed adidas heat-seal logo on back neck 
Sheet1
 
Upvote 0
Something like this
Excel Workbook
AB
1100% polyester 
2essential moisture management piqu wicks away moisturewicks moisture
3keeps you dry and comfortable 
4open-hem sleeves 
5side vents and one-button placket 
6contrast 3-Stripes embroidered detail on sleeves 
7contrast heat-sealed adidas heat-seal logo on back neck 
Sheet2
 
Upvote 0
Close to what I'm looking to accomplish. The column which is holding the descriptions has over 1200 rows and in that column each product has different descriptions so I would want to look for specific words in each cell and place that word in a cell I need to go in.

This is value actually in the column, sorry for any confusion. I format it as html to show on the web page

100% polyester; essential moisture management piqu wicks away moisture; keeps you dry and comfortable; set-in, open-hem sleeves; side vents, rib-knit collar and three-button placket; contrast 3-Stripes piping detail on sleeves; contrast heat-sealed adidas performance logo on back neck;
My thoughts are to put together another sheet with all the possible terms I would like it look for then if that word is found put it in the column I would like it to show.
 
Upvote 0
Trevor, thanks it worked great and I was able to build a large one to do as I needed. Much appreciated. One other question is there a way to make it find the first word value I'm looking and only use it? There are some cells that have 2 or more values and it shows the results such as Easy CareStain Resistant and would like it to just show Easy Care.
 
Upvote 0

Forum statistics

Threads
1,214,653
Messages
6,120,749
Members
448,989
Latest member
mariah3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top