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 " [email protected]" 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