Hi,

You can't create a formula that 'deletes' a value in another cell. If you
explain what you are trying to do then I'm sure someone will help.

Mike


"Kryten" wrote:

Hi,

Is there any way, without using VBA, to delete cell values for an
entire column IF the current cell value is NOT LIKE a predefined
value. Ideally the predefined value would be a regex.

Thanks,
Stuart