Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-30-2013, 06:38 PM
jolinchew jolinchew is offline remove blank lines in between Windows 7 32bit remove blank lines in between Office 2010 32bit
Novice
remove blank lines in between
 
Join Date: Jul 2013
Posts: 11
jolinchew is on a distinguished road
Default remove blank lines in between

I have more than 20000 lines in one excel, including some blank lines, i want to remove those blank lines, any way? thanks
Attached Images
File Type: png excel_blank.PNG (74.5 KB, 7 views)
Reply With Quote
  #2  
Old 07-31-2013, 12:33 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline remove blank lines in between Windows 7 64bit remove blank lines in between Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,747
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Use the filter to filter on blank rows then delete the resulting rows
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 07-31-2013, 09:11 AM
BobBridges's Avatar
BobBridges BobBridges is offline remove blank lines in between Windows 7 64bit remove blank lines in between Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Or just sort them. I don't use filters much, so I usually think of sorting the lines first.
Reply With Quote
  #4  
Old 08-01-2013, 04:44 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline remove blank lines in between Windows 7 64bit remove blank lines in between Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,747
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by BobBridges View Post
Or just sort them. I don't use filters much, so I usually think of sorting the lines first.

If some cells contain non printable characters or spaces, etc... sorting can give some odd results...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 08-01-2013, 06:09 AM
BobBridges's Avatar
BobBridges BobBridges is offline remove blank lines in between Windows 7 64bit remove blank lines in between Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Hm, you're probably right. And really filters are probably better. I should get used to them.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
remove blank lines in between Macro to remove blank column netchie Word VBA 4 03-14-2013 02:22 PM
remove blank lines in between Getting blank lines instead of supressed lines. Welshie82 Mail Merge 2 11-14-2011 01:41 AM
remove blank lines in between Blank lines in standard letters AlteDäne Mail Merge 5 06-29-2011 05:32 PM
remove blank lines in between How to remove blank rows from a specified range? Learner7 Excel 1 04-19-2011 02:45 AM
remove blank lines in between How to turn all blank lines into non-blank for legal forms sieler Word 3 04-12-2009 01:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft