Email from Specific Term

[Blessy Clara]

Hi

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

Example

Col1	Col2	Col....	Col120	Col130	Col150
principal@alphass.eq.edu.au	0517_PandC@eq.edu.au	EQInternational@dete.qld.gov.au	nmcca106@eq.edu.au	accounts@helpinghandsnetwork.com.au
the.principal@wondaiss.eq.edu.au	admin@wondaiss.eq.edu.au	InternationalStudy@murrumbassc.eq.edu.au	UniformShop@tannsandss.eq.edu.au
		the.principal@redlynchsc.eq.edu.au/principal@redlyncsc.eq.edu.au
	oakleighoshc@gmail.com		the.principal@nundahss.eq.edu.au

<tbody>
</tbody>

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

Col1	Col2	Col....	Col120	Col130	Result
principal@alphass.eq.edu.au	0517_PandC@eq.edu.au	EQInternational@dete.qld.gov.au	nmcca106@eq.edu.au	accounts@helpinghandsnetwork.com.au	principal@alphass.eq.edu.au
the.principal@wondaiss.eq.edu.au	admin@wondaiss.eq.edu.au	InternationalStudy@murrumbassc.eq.edu.au	UniformShop@tannsandss.eq.edu.au		the.principal@wondaiss.eq.edu.au <tbody> </tbody>
		the.principal@redlynchsc.eq.edu.au/principal@redlyncsc.eq.edu.au			the.principal@redlynchsc.eq.edu.au/principal@redlyncsc.eq.edu.au
	oakleighoshc@gmail.com		the.principal@nundahss.eq.edu.au		the.principal@nundahss.eq.edu.au <tbody> </tbody>

<tbody>
</tbody>

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!