Hello,
I need to build a formula which looks up a cell in which there is an email address and if the prefix is E followed by 6 digits and the suffix @gmail.com it returns "TRUE".
For example if in A1 we have E123456@gmail.com the Formula returns true but if it contains E12345k@gmail.com it returns "FALSE".
Thank you for your help.
I need to build a formula which looks up a cell in which there is an email address and if the prefix is E followed by 6 digits and the suffix @gmail.com it returns "TRUE".
For example if in A1 we have E123456@gmail.com the Formula returns true but if it contains E12345k@gmail.com it returns "FALSE".
Thank you for your help.