One idea...

You could identify which type of record is which in another column, then
filter all the data on that column. For example, if your data begins in A2
with a heading in A1, in the first empty column, enter any heading in row 1
and the following in row 2:

=IF(LEN(TRIM(A2)) = LEN(A2) - 5,"5","7")

Copy this down through all rows of data, then filter all data by this column.

Hope this helps,

Hutch

"steev_jd" wrote:


Hi,

I have a list where some entries are preceded by 5 spaces, others by 7
spaces.

When I try to custom filter this list to only display those that begin
after 5 spaces by filtering to;

'Does not begin with ¦ <7 spaces*'

It doesn't display any entries from the list. When I go back to the
filter it has automatically udated it to;

'Does not contain ¦ *'

I need to keep the list in order so I cannot sort it. Any ideas??

Thanks in advance,
Steve


--
steev_jd
------------------------------------------------------------------------
steev_jd's Profile: http://www.excelforum.com/member.php...o&userid=33107
View this thread: http://www.excelforum.com/showthread...hreadid=569919