Email from Specific Term

[Blessy Clara]

Hi

I have an excel sheet with Columns Running from 1 to 150 - First row is header

Example [TABLE="width: 500"]
<tbody>[TR]
[TD]Col1[/TD]
[TD]Col2[/TD]
[TD]Col....[/TD]
[TD]Col120[/TD]
[TD]Col130[/TD]
[TD]Col150[/TD]
[/TR]
[TR]
[TD]principal@alphass.eq.edu.au[/TD]
[TD]0517_PandC@eq.edu.au[/TD]
[TD]EQInternational@dete.qld.gov.au[/TD]
[TD]nmcca106@eq.edu.au[/TD]
[TD]accounts@helpinghandsnetwork.com.au[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]the.principal@wondaiss.eq.edu.au[/TD]
[TD]admin@wondaiss.eq.edu.au[/TD]
[TD]InternationalStudy@murrumbassc.eq.edu.au[/TD]
[TD]UniformShop@tannsandss.eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]the.principal@redlynchsc.eq.edu.au/principal@redlyncsc.eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]oakleighoshc@gmail.com[/TD]
[TD][/TD]
[TD]the.principal@nundahss.eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I want to pull out emails with specific terms - Example Principal Email

[TABLE="width: 500"]
<tbody>[TR]
[TD]Col1[/TD]
[TD]Col2[/TD]
[TD]Col....[/TD]
[TD]Col120[/TD]
[TD]Col130[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]principal@alphass.eq.edu.au[/TD]
[TD]0517_PandC@eq.edu.au[/TD]
[TD]EQInternational@dete.qld.gov.au[/TD]
[TD]nmcca106@eq.edu.au[/TD]
[TD]accounts@helpinghandsnetwork.com.au[/TD]
[TD]principal@alphass.eq.edu.au[/TD]
[/TR]
[TR]
[TD]the.principal@wondaiss.eq.edu.au[/TD]
[TD]admin@wondaiss.eq.edu.au[/TD]
[TD]InternationalStudy@murrumbassc.eq.edu.au[/TD]
[TD]UniformShop@tannsandss.eq.edu.au[/TD]
[TD][/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]the.principal@wondaiss.eq.edu.au

[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]the.principal@redlynchsc.eq.edu.au/principal@redlyncsc.eq.edu.au[/TD]
[TD][/TD]
[TD][/TD]
[TD]the.principal@redlynchsc.eq.edu.au/principal@redlyncsc.eq.edu.au[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]oakleighoshc@gmail.com[/TD]
[TD][/TD]
[TD]the.principal@nundahss.eq.edu.au[/TD]
[TD][/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]the.principal@nundahss.eq.edu.au

[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thank you in advance

 

[Blessy Clara]

Thanks for the code and your patience in guiding me through this entire requirement - Yes

 

[DanteAmor]

You're welcome!