Delete row with empty cell in Column A?

[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

[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.

In article <epn13akPGHA.648@TK2MSFTNGP14.phx.gbl>,
"SteveK" <sk-reeemovethis@dolby-reeemovethis.com> wrote:

> 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

[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

On Thu, 2 Mar 2006 14:14:45 -0800, "SteveK"
<sk-reeemovethis@dolby-reeemovethis.com> wrote:

>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
>

[SteveK]

Thank you.


"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-6176BA.15192602032006@msnews.microsoft.com...
> 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.
>
> In article <epn13akPGHA.648@TK2MSFTNGP14.phx.gbl>,
> "SteveK" <sk-reeemovethis@dolby-reeemovethis.com> wrote:
>
> > 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