Extracting information

P

Paula

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??
 
D

Dave F

=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
 
Top