Wednesday, October 5, 2011

yogi_Extract In A Separate Sheet Records With Valid Email Addresses

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
a user said:
Delete rows that don't contain email addresses
I have 4,000 rows with 2 columns. Column A contains the name. Column B contains cells that contain an email address amongst other data. I want to delete rows that don't contain email addresses. Also I want to delete everything but the email address in that cell of Column B. Can you help?
-------------------------------