I have a string that contains one or more email addresses, for example:
I want to select just the first email address, which is doable with something like
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@example.com then that formula throws an error on the find. Is there a better formula?