Embarrassed to say I haven't worked with excel in a while and forgotten a few things. I have a list of about 4k customers with all the common headings -- lname, fname, address, email, etc.
Some of the customers don't have an email address. I've forgotten how to clean the list and just have the ones with emails. I know it's using find and replace, but how do I search for a blank in the email column, and then delete the whole row?
Any help is appreciated. Thanks
Some of the customers don't have an email address. I've forgotten how to clean the list and just have the ones with emails. I know it's using find and replace, but how do I search for a blank in the email column, and then delete the whole row?
Any help is appreciated. Thanks
New WSO - Coming Soon...
STOP Using PBNs - Get Better SEO and FREE Traffic!