Formula to search for specific sign

[markus_dreuw]

Good morning

I would like to evaluate a column by controlling if it contains an e-mail addresses respectively an “@”. Before and after the “@” different content can be given, numbers, letters etc. It just has to be controlled if there is an “@” in it.

Is there any formula to do so? Maybe working with an if clause?

Thank you in advance

[jonathandienst · Accepted solution]

I'm not sure where/how you want to use this logic, but

Implicit:

(Index(MailAddress, '@') > 0)

Explicit:

If(Index(MailAddress, '@') > 0, true(), false())

[markus_dreuw]

thanks it works