Formula parsing string, sometimes by comma sometimes not

Question

I have a string that contains one or more email addresses, for example:

[email protected], [email protected]

I want to select just the first email address, which is doable with something like

LEFT(EmailString(FIND(",",EmailString,1)-1)

That formula searches for a comma, but what do I do when there is only one value and no comma? If the email is simply [email protected] then that formula throws an error on the find. Is there a better formula?

Answer 1

You can incorporate the IF and CONTAINS functions here:

IF(
    NOT(CONTAINS(EmailString, ',')),
    EmailString, /*your existing formula here*/
)

Basically, if there is no comma, just use the value, otherwise use the formula you already have.