Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet cleaning
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet cleaning
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet cleaning
Try this:
Select your data range DataFilterAutoFilter 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, EditDelete (You will only be able to delete an entire row when in filter mode.) Then DataFilter 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet cleaning
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to handle multiple currencies with one spreadsheet | Excel Discussion (Misc queries) | |||
Using Excel spreadsheet as input to Access | Excel Discussion (Misc queries) | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
Linkage data between two spreadsheet | Excel Worksheet Functions | |||
Linking formula to external spreadsheet | Excel Discussion (Misc queries) |