condensing an email list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of customers. I have three columns: email address, First
name, and last name. I have 2380 rows. In between each customers record in
a blank row.

What I would like to do is create/run a macro that would condense this list
so it gets rid of the empty row between customers and also customers that do
not have an email address.

Thanks in advance!!!!

Tricia Gall
 
You don't need a macro for that, select the range, press F5, click special,
select blanks and press enter. Press Ctrl and - (meaning Ctrl and a
hyphen/dash/minus sign) then select entire row and click OK

Select the column with email address, repeat.

Note, in case if I misunderstood you might want to try this out on a copy
first
 
Back
Top