Deleting Empty Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I converted a file from .txt format to excel.

In the orginal text file, there are spaces in between rows so when I converted to excel format, there are empty rows in between each line.

How can I get rid of the empty rows without having to manually choosing & deleting them

Thanks
Dolphinv4
 
Hi

Another way is to select a column. Then Edit / Go to / Special / Blanks.
Then Edit / Delete and select 'Entire Row'.

Make sure the column you select only contains blank cells from the rows you
don't need!!

Andy.

Dolphinv4 said:
Hi,
I converted a file from .txt format to excel.

In the orginal text file, there are spaces in between rows so when I
Click to expand...
converted to excel format, there are empty rows in between each line.
 
Back
Top