Results 1 to 6 of 6

Remove Blank Lines

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-04-2009
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    127

    Remove Blank Lines

    Hello,

    I have a massive list of Business names & Addresses.

    like:

    Business Name A
    address 1
    address 2
    Address 3
    postcode
    opening times



    Business Name B
    address 1
    etc
    etc


    Between each company, there is 3 blank rows.
    How can I remove 2 of the blank rows and just leave 1

    I started doing it manually, but there is over 14000 rows...

    please help.



    Thanks
    Last edited by NBVC; 08-16-2010 at 12:56 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1