Delete a cell value if not "like"

K

Kryten

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
 
M

Mike H

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
 
J

Jarek Kujawa

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
 
D

Dave Peterson

You have a response at your other post.
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
Click to expand...
 
Top