ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will do as you wish...........

Vaya con Dios,
Chuck, CABGx3



"Wayne Knazek" wrote:

Problem . . . File is imported. Only certain lines are needed. The data is
these 3 coluimns, 6 rows, repeated numerous times. (Column B is various text)

A B C
1 TE | |0.055
2 LE | |0.094
3 X | |.559
4 Y | |0.749
5 Z | |0.987
6 L | |0.296

What I need to do is show only this . . . (No X, Y or Z)

A B C
1 TE | |0.055
2 LE | |0.094
3 L | |0.296

Preferably . . . even better would be if all I got was this . . .

A B C
1 0.055
2 0.094
3 0.296

So I need to delete (or filter out, but a filter has already been run) all
rows with X, Y or Z in the 1st column.