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 <atyahoo<dotcom
----
"Paulo Baptista" <Paulo
wrote in message
...
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