delete empty rows between rows with text

's Computer Specifications

Please anybody can help me

Ia have a data base with email's but between rows with emails the ecxel file
have a empty fields I want remove this empty rows.

Best regards

Paulo Baptista

's Computer Specifications

One way .. (try on a spare copy)

Assume the key data col is col A

Select col A
Press F5 > Special > Blanks > OK
Right click on the selection > Delete > Shift cells up > OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Paulo Baptista" <Paulo (E-Mail Removed)> wrote in message
news:55A2CA5D-97EE-41D3-8EA7-(E-Mail Removed)...
> Please anybody can help me
>
> Ia have a data base with email's but between rows with emails the ecxel
file
> have a empty fields I want remove this empty rows.
>
> Best regards
>
> Paulo Baptista

's Computer Specifications

Select the range, press F5, special and select blanks, press ctrl and -
(minus/dash), select entire row
or shift cells up depending on whether the whole row is empty

--

Regards,

Peo Sjoblom

"Paulo Baptista" <Paulo (E-Mail Removed)> wrote in message
news:55A2CA5D-97EE-41D3-8EA7-(E-Mail Removed)...
> Please anybody can help me
>
> Ia have a data base with email's but between rows with emails the ecxel
file
> have a empty fields I want remove this empty rows.
>
> Best regards
>
> Paulo Baptista

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hpw do I delete multiple empty rows found between filled rows?	Bill	Microsoft Excel Worksheet Functions	1	15th Nov 2009 12:52 AM
How to Delete empty rows in excel in b/w rows with values	=?Utf-8?B?RGVubmlz?=	Microsoft Excel Worksheet Functions	3	28th Aug 2007 04:15 PM
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows	Scott	Microsoft Excel Worksheet Functions	0	13th Dec 2006 01:25 AM
Delete Rows with Empty Cells with empty column 1	Scott	Microsoft Excel Programming	6	2nd Oct 2006 11:57 PM
Delete rows with numeric values, leave rows with text	=?Utf-8?B?R1NwbGluZQ==?=	Microsoft Excel Programming	5	11th Oct 2005 12:44 AM