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 t
do.

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

1) Instead of clicking on each one and deleting them one by one, i
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 emai
address?

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

Appreciate the help,

J

--
Jethea
-----------------------------------------------------------------------
Jetheat's Profile: http://www.excelforum.com/member.php...fo&userid=1007
View this thread: http://www.excelforum.com/showthread.php?threadid=39511