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

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

Mike is right, but you might try to overcome this

presume yr data is in column A, then in col B insert:

=IF(find("regex";A1);"regex";"NO regex")

then apply auto-filter, filter on #ARG!, select both columns, CTRL+G,
click on Special, select Visible only

then delete

You have a response at your other post.

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

--

Dave Peterson