Add a new column (say column A)

Put 1 in A1 and put 2 in A2
select A1:A2 and drag it down your data using the autofill button on the bottom
right of the selection.

Now you can sort all the data by anything you want.
Delete what you want
and resort by column A.

Alternatively, you could apply data|filter|autofilter
filter by the columns you need:
contains: ~*
the ~ is important. It tells excel that you're looking for the asterisk--not a
wildcard.

Then you can delete the visible rows.



Richard wrote:

I downloaded info from another program to a spreadsheet. I am trying to
clean up the data so I can use it. Please let me know if there is a way to
do the following preferably without VBA. Post either solution but I'm just
not too comfortable with VBA yet. What I want to do is to seek out every
cell with an "*" and have Excel delete the entire row. Doing a sort would
not be an option because the order of the data is important for my needs.
Thank -RA

--

Dave Peterson