View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

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