Thank you bman, it worked perfectly and as long as there are no spelling
errors, abreviations etc it is going to save me hours every month!
I LOVE EXCEL!!!!!

"bman" wrote:

Presuming col E has your product text data,

In col A, corresponding row, put
=IF(ISNUMBER(SEARCH("acid free",($E1))),"Y", "N")

In Col B
=IF(ISNUMBER(SEARCH("lightfast",($E1))),"Y", "N")

In Col C
=IF(ISNUMBER(SEARCH("USA",($E1))),"USA",IF(ISNUMBE R(SEARCH("import",($E1))),"Imported","No"))

Then copy each Col down for as many rows as you have data. This should work
for Capital letters as well as lower case in the data.

This is presuming your data (Col E")is consistent and clean, e.g. no
extraneous spaces, spelling errors or something like "not imported" is used
which would give the opposite result you intended.

Hope this helps.

"Amylou" wrote:

What I have is a spread sheet of information from a vendor about several
different products. One specific column holds a single cell with what is
usually a paragraph of information about the product represented in that row.
What I need to get out of each €œparagraph€� are specific key bits of
information and having to go through each paragraph for a minimum of key
points just seems to take forever.

What I would like to do is set up a few extra columns.
For example:

A(acid free) B(lightfast) C(made in USA or Imported)

€¦have these columns look through the €œparagraph€� and return either a €œY€� or
€œN€� for A & B and either €œUSA€� or €�I€� for column C.

Any help would be greatly appreciated!