Picking out data from a list

[stockgoblin42]

Hi,

I have a list of data and I need to trim it down to only the lines I need.

So, I only need the lines that contain a 0 or 5 in the 4th digit of column B
I'd like the rest of the data to be removed.

How can I do this?

ex)

....................v................

20111025 133700 1241.03 1241.03 1239.1 1239.1 1
20111025 133800 1239.74 1239.74 1233.14 1233.14 1
20111025 133900 1233.31 1237.06 1233.31 1236.93 1
20111025 134000 1237.2 1237.35 1237.14 1237.14 1
20111025 134100 1238.23 1239.8 1238.23 1239.74 1
20111025 134200 1239.23 1239.91 1239.23 1239.36 1
20111025 134300 1239.06 1240.97 1238.77 1240.97 1
20111025 134400 1240.74 1240.79 1240.33 1240.79 1
20111025 134500 1240.18 1240.18 1238.81 1239.86 1
20111025 134600 1239.62 1239.62 1238.51 1238.94 1
20111025 134700 1238.78 1243.41 1238.78 1243.41 1
...
.....................^............

I would like it to be trimmed down to:

20111025 134000 1237.2 1237.35 1237.14 1237.14 1
20111025 134500 1240.18 1240.18 1238.81 1239.86 1


Any help is appreciated.

[jeffreybrown]

With a helper column use...=MID(B1,4,1)

and then filter for only 0 and 5 and then delete the rest.