Copying over specific data

R

Ricardo

Let's say that in cell A1:A2, was the following data:

Private Label Canola Cooking Oil 32OZ 9999912345
Private Label Vegetable Cooking Oil 48OZ 9999912456

I wanted to assign attributes to my products; and so in cell
B1, I wanted to do a find, and paste function. If "Canola", "Corn",
"Vegetable" and so forth were found in
any of the product description in A1, then paste that attribute in B1.
Results: B1 should be Canola, and B2 should be Vegetable
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top