View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amylou Amylou is offline
external usenet poster
 
Posts: 11
Default Conditional Formula

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!