Just realized that trailing spaces would throw off the formula I gave you in
my previous reply. Use this formula instead:

=IF(LEN(TRIM(LEFT(A2,7))) = 2,"5","7")

Regards,

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