Thursday, October 6, 2011

yogi_Search For @ Character And Extract Company Name And Email Address In Another Sheet

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
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