delete row corrupt data (Excel 2002)

Topic

New Reply

[indent]

---

one column is volts, currents, time and Amphours

---

[/indent]

Is volts, currents, time, and amphours all in one column or is that 4 different column? If those are in different columns, the data you posted makes it look like there are 5 or 6 columns of data not four.

What do you mean by “corrupt”? Normally corrupt is used to mean that the worksheet contains some corruption which causes Excel to malfunction. Is that what you mean, or do you mean that some rows contain incorrect data? If so, how is the incorrect data to be recognized?

If the data is in 5 or 6 columns, and the rows with incorrect data have one or more of those columns empty, could you just sort the worksheet on one of those columns to put all the rows with empty columns together and then just select and delete those rows?

Reply | Quote

Replies

Edited by HansV to add

 and 

tags

The following is just a snippet of about 7 000 entires, I didn’t notice this until now….The original file is corrupt with about 4 or 5 of these little miscues of information. I am graphing this information, one column is volts, currents, time and Amphours. Is there a post that can help with finding an empty cell then deleting the entire row?
Thanks Darryl.

Full	NoChg			3:34:50	1.6	3.18	-0.04
Full	NoChg			3:35:00	1.6	3.18	-0.04
Full	NoChg			3:35:10	1.6	3.18	-0.04
Full	NoChg			3:35:20	1.6	3.18	-0.04
49.7'				,NoChg,4	-48		
Full	NoChg			3:35:30	1.6	3.18	-0.04
Full	NoChg			3:35:40	1.6	3.18	-0.04
Full	NoChg			3:36:00	1.7	3.18	-0.14
Full	NoChg			3:36:10	1.7	3.18	-0.14

Reply | Quote

Legare,

Thanks, some times the easiest way is the best way.

Reply | Quote