Forum

Microsoft Excel Usage Question
 

I know it's not the right forum to ask this but I hope some of the members are aware with excel usage.

I would like to know how I could remove a row that contains a cell where you can find letters.
I scrap some sites and sometimes in the upc field it's letters. I want to drop the entire product(row)if the upc field contains letters.

Thank you if you have any solution.

Re: Microsoft Excel Usage Question
 

You can delete the entire row if you just click the number of the row on the left. Click it and you will get a 'delete row' (or words to that effect) option pop up. If you delete row 5 then row 6 becomes row 5. All excel calculations will be automatically adjusted to take account of the new row numbers (from memory!)

Re: Microsoft Excel Usage Question
 

thanks james but I need a kind a formula or something, it's going to be around 100k rows and probably 20-30k rows that have cells with wrong upcs (containing letters)
I need a way to avoid doing this manually.

Re: Microsoft Excel Usage Question
 

hmm.. this will be a little tedious what i'm about to suggest, but a good solution if there's no alternative.

1. Get a filter setup on the UPC column
2. Using the filter function, search each letter of the alphabet, "A", "B"...
3. Deselect them, then click add current selection to filter (with the UPC/header cell selected).

This will (one alphabet at a time) filter out all the rows that happen to have an alphabet within it.

Then simply copy and paste the remaining rows into a new sheet and you should (technically speaking) have all the rows where the UPC doesn't have letters within it.

Once yot get the hang of it, it wont take you more than a minute to do.

Hope that helps :thumb:

Re: Microsoft Excel Usage Question
 

Play you're the men, I'll try it in a day or two when I finish scrapping. :bounce:

Re: Microsoft Excel Usage Question
 

Ha that is a whole lot larger than I was expecting!

Re: Microsoft Excel Usage Question
 

don't know if anyone will be faced with the same problem in here but my fastest solution was this formula:

=ISNUMBER(A2) where you replace the A2 with the cell number you want to check
Then you sort by true or false. True contains only numbers and false mixed ( letters and numbers ). Then you delete the one you like easily.