Row Delete Question

**martymoose** · 06-13-2008, 12:10 PM

Hi all,

I was searching the net for some help and stumbled upon this forum.

I've used Excel for years, but recently due to the fact that we're setting up a new POS system at my company and I'm needing to edit and import large product spreadsheets, some of this suff I'm needing to do I haven't attempted before with Excel.

Basically what I'm trying to do is this: I have a spreadsheet with 28,000 rows. In column "C" I'm trying to isolate cells that contain the words "postform" OR "vertical" and then delete the entire row. Column "C" contains a description and these words are at the end of the description, so I don't see an easy way to group them and delete all at once.

Any help would be greatly appreciated! Thanks!

**bsanford79** · 06-13-2008, 12:20 PM

Hi there

ok i am still new to this myself but i encountered the same senario and found that you can get a text editor like UltraEdit, open your xls file or you might have to convert it to a CSV. then when its open do a "find" on the words you want to find, you can tag all those lines then cut them out or delete them.......... this might be a simple solution for you, but im still learning myself so im just tryin to help good luck

Brad

**Stuie** · 06-13-2008, 12:25 PM

Hi martymoose,

I way to do this would be to run a formula down col "D" (If its available) and then sort it by col "D" so you know which ones to delete.

I know that doesnt make much sense so i will show you.

in coloum "D" enter this formula and drag it down to the last row

=IF(ISERROR(FIND("postform",C1)),IF(ISERROR(FIND("vertical",C1)),0,1),1)

once the forumla has finished calculating, highlight cols C and D and click Data>Sort and then sort by col D Desending

all cells in range D with the number 1 in have either the word postform or vertical in that cell (please note that this will detect that word even if it part of another word).

also you will need to change the C1 part of the formula to the cell where it starts