Finding strings in an excel cell and deleting the entire row

Hi,

i have an excel sheet that contains plethora of cells, I want to check the complete sheet for the cells with strings eg:"0.66ttw" or "ter" like that and delete the complete row. can anyone help me with that?

Answer 1

[dpb]

<Answers/347460-how-do-i-delete-an-entire-row-from-excel-from-matlab?>

Hint for future -- check out the "SEE ALSO" links Answers pops up to your Q?.

Of course, you'll still have to identify the row(s) to be deleted which means reading the sheet anyway.

Remember that when you delete a one row, the row numbers from that point on change so if deleting more than one row you'll need to work from rear to front.