I need help with Excel, again

 

I split the Wal-Mart file into Sam's and Walmart. Is there a clever way of selecting and then deleting all the Sam's entries?

--
1490LMT 1450LMT 295w

.

spokybob wrote:

Is there a clever way of selecting and then deleting all the Sam's entries?

- Sort by column C ascending.

- Scroll down to row 609, then click the row number to select the whole row.

- Scroll back up to row 1, then [Shift]-click the row number to select rows 1 through 609.

- Right-click any one of the selected row numbers, then choose "Delete".