Spreadsheet cleaning

[Richard]

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]

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

[Ron Coderre]

Try this:
Select your data range
Data>Filter>AutoFilter
Click the dropdown list on the column that contains the asterisks and
select the asterisk from the list.
(Now you should only see rows with the asterisk in that column)

Starting with the 1st displayed asterisk, select all the way down to the
last asterisk.

Then, Edit>Delete
(You will only be able to delete an entire row when in filter mode.)

Then Data>Filter> uncheck Autofilter to turn it off

Does that help?

***********
Regards,
Ron


"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

[CLR]

ASAP Utilities, a free Add-in available from www.asap-utilities.com has a
feature that will conditionally delete rows based upon cell content.......

Vaya con Dios,
Chuck, CABGx3



"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