Maybe you can use a helper column.

And put a formula like:
=isnumber(a2)
in B2
Then drag down

And then apply data|Filter|autofilter to column B.

Show the Trues and delete those visible rows.

Christmas May wrote:

To all,

If you enter "965-0001" in cell A1, "2" in cell A2, "=A1+1" into cell B1 and
"=A2+1" into cell B2, "#VALUE!" in cell B1 and "3" in cell B2.

I'd like to run a macro to remove all of the cells in a long list that are
simply a number like cell A2 above, while retaining the cells that have data
like cell A1 above. However, I'm unsure how to determine the difference.

Sincerely,

Christmas May

--

Dave Peterson