Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
In this case I have based presence of email simply by searching for existence of @ character in the Info field
the two part solution consists of
1) filtering for all records that contain @ character in the Info field ... in Sheet2
2) then extracing in an adjacent column only the email address from the filtered Info field
------------------------------------
In this case I have based presence of email simply by searching for existence of @ character in the Info field
the two part solution consists of
1) filtering for all records that contain @ character in the Info field ... in Sheet2
2) then extracing in an adjacent column only the email address from the filtered Info field
------------------------------------
No comments:
Post a Comment