Posted to microsoft.public.excel.misc

swell estimator[_2_] swell estimator[_2_] is offline

external usenet poster

Posts: 13

gang remove blank rows

I have a large amount of data that is composed of a text row followed by 2
blank rows. This pattern repeats itself in the entire worksheet.

I want to gang remove the blank rows so that I end up with single spaced data.

Any help out there. Thank you.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove Blank and Non Data Rows	UT	Excel Discussion (Misc queries)	3	June 12th 07 10:01 PM
HOW CAN I EASILY REMOVE MULTIPLE BLANK ROWS FROM A SPREADSHEET?	sandman832	Excel Discussion (Misc queries)	2	March 9th 06 08:31 PM
formula to remove blank rows	Bryan	Excel Discussion (Misc queries)	1	January 25th 06 03:52 PM
remove or hide blank rows	Erik Beijlen via OfficeKB.com	Excel Discussion (Misc queries)	1	February 1st 05 01:17 PM
How do I remove blank rows in Excel?	m28leics	Excel Discussion (Misc queries)	2	November 29th 04 11:56 PM

All times are GMT +1. The time now is 01:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us