Hi,
I was wondering if there was an easy way to extract the first part of an email address?
john.smith@abc.com.au
rita.jones@abc.com.au
helen.blow@abc.tv.com.au
I am currently using formula that cuts off the 11 characters from the right, then have to go over them, incase there was a longer email in thre (ie 3rd example).
I am pretty sure that someone I worked with last job, could extract the first part of the email.
--btw: the firstpart of the email (before @) is part of the unique login details, hence why trying to extract.
Thanks
I was wondering if there was an easy way to extract the first part of an email address?
john.smith@abc.com.au
rita.jones@abc.com.au
helen.blow@abc.tv.com.au
I am currently using formula that cuts off the 11 characters from the right, then have to go over them, incase there was a longer email in thre (ie 3rd example).
I am pretty sure that someone I worked with last job, could extract the first part of the email.
--btw: the firstpart of the email (before @) is part of the unique login details, hence why trying to extract.
Thanks