And there is any easier way.

Select all the used rows in a single column (where the empty cells are
representative of all the data)
goto the Edit menu and select GoTo, select Special, select Blanks.
Than go to the Edit menu and select Delete, select Entire Rows.

This is pretty quick and works great....

--
steveB

Remove "AYN" from email to respond
"Jetheat" wrote in
message ...

I have a list of email addresses in one single column.

This list is large so I need some way of shortcutting what I need to
do.

This entire column of email addresses is separated by 2 empty rows
between each email address.

1) Instead of clicking on each one and deleting them one by one, is
there a quicker method to delete all empty rows?

2) The list of email addresses is imported.
All the emaill addresses have a space in front of them. For example "
" Do you see the extra space in front of the email
address?

How do I remove that single space with some sort of shortcut for the
entire column?

Appreciate the help,

JH


--
Jetheat
------------------------------------------------------------------------
Jetheat's Profile:
http://www.excelforum.com/member.php...o&userid=10073
View this thread: http://www.excelforum.com/showthread...hreadid=395116