Remove blank lines

[Guest]

Hi,

I regularly download data from SAP into Excel, however the problem I have is
that SAP inserts a blank line between each line of data.

Is there a quick way for me to remove these blank lines in Excel?

Many thanks
Pete

 

[flashing frank]

i don´t know how your table and data looks like,
but an easy way to delete the empty rows would be:

1. data>sort (choose any colummn)
2. all the empty lines should be on top or at the bottom.
3. highlight and delete them.


hope this helps
f

 

[ElsiePOA]

Here's one way which will remove the blank lines and keep your data i
the original order. If your data is in column A, insert a helpe
column and enter the following formula: =IF(A1="","",ROW(A1). Thi
will put numbers only in the cells in the helper column which are i
non-blank rows. Then sort all of your data using the helper column a
the sort field. This will place all of the non-blank rows at the to
and the blanks at the bottom. Then delete the helper column

 

[Debra Dalgleish]

Select a column that contains an entry in each row of data.
Choose Edit>Go to
Click the Special button
Select Blanks, click OK
Choose Edit>Delete
Select 'Entire row', click OK

 

[Guest]

Many clever ideas. many thanks
Pete

 

[flashing frank]

you can find a professional solution for your problem in the excel-ti
area of this page.

'excel tip delete empty row' (http://tinyurl.com/5oz6h)

you will only need Sub DeleteEmptyRows(DeleteRange As Range