Delete row with empty cell in Column A?

S

SteveK

I have a .CSV file exported from our parts control application that needs a
bit of tweeking to make it presentable.

I would like to delete any row that has an empty cell in Column A. How can
I do this? Does it require a macro?

STeveK
 
J

JE McGimpsey

Doesn't require a macro. Select column A. Choose Edit/Go To.../Special.
Select Blanks. Choose Edit/Delete... and choose Entire Row from the
dialog that opens.
 
G

Gord Dibben

Steve

If the cells in column A are truly empty, no macro is needed.

Select column A and F5>Special>Blanks>OK.

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP
 
S

SteveK

Thank you.


JE McGimpsey said:
Doesn't require a macro. Select column A. Choose Edit/Go To.../Special.
Select Blanks. Choose Edit/Delete... and choose Entire Row from the
dialog that opens.
Click to expand...
 
Top