Removing BLANK rows in Excel

[Guest]

WinXP Pro with Excel XP:
How can I remove blank rows where there's nothing in any of the 12 columns that might contain data? The data has one row of valid data and then a blank row, alternating for about 5000+ rows. I'm receiving a file that, apparently, has a CRLF and giving me an extra row for each row with valid (useable) data. The supplier of the data can't strip off the CRLF. Without manually removing each blank row (row #s: 2,4,6,8 etc) each import from the *.csv file how can this be done automatically from within Excel? [The file is used weekly to migrate/update data from one application to another. Or alternatively, is there a shareware utility to strip out blank entries (rows) in a *.csv file? [Obviously, I can also convert the file to *.dbf in Excel, if this is necessary].
TIA
Tom

 

[Frank Kabel]

Hi
see: http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows

 

[Ken Wright]

Select any column where you can rely on the fact that a blank cell means delete
the row, then do Edit / Go To / Special / Blank Rows, then do Edit / Delete /
Entire row

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

WinXP Pro with Excel XP:
How can I remove blank rows where there's nothing in any of the 12 columns

that might contain data? The data has one row of valid data and then a blank
row, alternating for about 5000+ rows. I'm receiving a file that, apparently,
has a CRLF and giving me an extra row for each row with valid (useable) data.
The supplier of the data can't strip off the CRLF. Without manually removing
each blank row (row #s: 2,4,6,8 etc) each import from the *.csv file how can
this be done automatically from within Excel? [The file is used weekly to
migrate/update data from one application to another. Or alternatively, is there
a shareware utility to strip out blank entries (rows) in a *.csv file?
[Obviously, I can also convert the file to *.dbf in Excel, if this is
necessary].