Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 201
Hi
I have an excel sheet with Columns Running from 1 to 150 - First row is header
Example
<tbody>
</tbody>
I want to pull out emails with specific terms - Example Principal Email
<tbody>
</tbody>
Thank you in advance
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 |
<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 |
<tbody> </tbody> | ||||
<tbody>
</tbody>
Thank you in advance