Using a single line of text for email addresses are tricky, as there’s no checks. If you use column validation it can at least do a couple of checks for you. See how we can validate whether an address includes “@”, the “@” shouldn’t be in the beginning, no spaces, full stop after the “@” and at least one character after the “@” before the full stop. You can find the formula below the video:
ISERROR(FIND(” “, [Email],1)),
ISERROR(FIND(“@”,[Email], FIND(“@”, [Email],2)+1)),
IF(ISERROR(FIND(“.”, [Email], FIND(“@”, [Email],2)+2)),
FIND(“.”, [Email], FIND(“@”, [Email],2)+2) < LEN([Email])
Purpose of this blog challenge: I will write 365 blogs in 365 days around Microsoft 365. I did a similar challenge with Office 365, blogs can be found https://atomic-temporary-35693276.wpcomstaging.com/microsoft-365/ . I won’t just be talking about the new Microsoft 365 subscription model. I will be sharing any news, tips and tricks around Office / Office 365 / Windows / Mobility and Security. And let’s not forget all the great new Apps & services available. A lot of what I’ll share on Office and SharePoint will also be applicable to none “Office 365” versions.
“You can also find me contributing to REgarding 365. I’m a member of a group of enthusiasts, sharing their stories, thoughts and opinions about Microsoft 365. Catch us at https://regarding365.com | @regarding365 on Twitter and regarding365 on YouTube https://www.youtube.com/regarding365 ”
Disclaimer: I create content about Office / Microsoft 365. Content is accurate at time of publication, however updates and new additions happen daily which could change the accuracy or relevance. Please keep this in mind when using my blogs as guidelines.
Leave a Reply