Hi all

I have a column which contains multiples of several different text
entries. These entries vary , but involve the single words 'New' ,
'Used' , 'Sold' , 'Open' , Closed' and so on.

I want to run a command on the column to keep all the cells with the
word 'New' and replace all others , irrespective of present content ,
with the word 'Used'. Is this possible?

I've been playing with this for some time now and find no luck. It's the
implementation of a 'Not Equal to' command I'm having trouble with.


Grateful for any help.



Best Wishes


Colin