I have a document that I just need to extract specific information in and
build into a new document. Is there a way that I can extract than information
on a continous level. The info starts with the same first 3 letters but has
different endings? Any ideas??

=IF(LEFT(A1,3="XXX"),"Extract","Don't extract")

Replace cell reference with the appropriate cell reference and the three
characters with the appropriate characters. Then filter on the "Extract"
values and copy those filtered records where you want.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Paula" wrote:

I have a document that I just need to extract specific information in and
build into a new document. Is there a way that I can extract than information
on a continous level. The info starts with the same first 3 letters but has
different endings? Any ideas??