Delete a cell value if not "like"

Posted to microsoft.public.excel.misc

Kryten[_2_] Kryten[_2_] is offline

external usenet poster

Posts: 1

Delete a cell value if not "like"

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel "Move or Copy" and "Delete" sheet functions	dsiama	Excel Worksheet Functions	1	December 28th 07 01:57 PM
"Last Cell" to find last row, but can't delete blank rows	[email protected]	Excel Discussion (Misc queries)	6	January 8th 07 11:50 PM
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!!	[email protected]	Excel Discussion (Misc queries)	3	January 5th 07 02:18 PM
Delete the number "49" from each cell in a column	se12	Excel Worksheet Functions	18	September 5th 06 05:53 PM
Complex if test program possible? If "value" "value", paste "value" in another cell?	jseabold	Excel Discussion (Misc queries)	1	January 30th 06 10:01 PM

All times are GMT +1. The time now is 05:17 PM.

Menu

About Us