Advertisement

03.27.2007 at 11:38AM PDT, ID: 22475733
[x]
Attachment Details

How to remove blank lines between records on my Excel sheet?

Asked by bemara57 in Microsoft Excel Spreadsheet Software

Tags: , , ,

I brought in a text file into my Excel spreadsheet, but I always have blank lines in between records. My spreadsheet is a few thousand records long. Is there an easy way to remove the blank lines? My spreadsheet is presorted by the text file, so I can't mess with the sorting feature to get rid of the blank lines. Any ideas?Start Free Trial
[+][-]03.27.2007 at 11:41AM PDT, ID: 18802384

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.27.2007 at 11:56AM PDT, ID: 18802531

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Tags: excel, lines, blank, remove
Sign Up Now!
Solution Provided By: zorvek
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32