Delete a cell value if not "like"

[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

 

[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

 

[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

 

[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