I have a long list of items some of which have rows ending with a *
I wanted to use auto-filter to isolate these particular rows but when I use Custom in auto-filter and choose 'contains' and in the right hand box insert a * then OK, all the rows show up, presumably because * means 'represents any series of characters'.
Is there a way round this?
johnni
I wanted to use auto-filter to isolate these particular rows but when I use Custom in auto-filter and choose 'contains' and in the right hand box insert a * then OK, all the rows show up, presumably because * means 'represents any series of characters'.
Is there a way round this?
johnni