I have a field that captures a list of emails from a User like so:

[email protected]; [email protected]; [email protected]

I'd like to capture the first email only in a separate formula field from this list (there may not be a semicolon if only one email is entered). Each email will always have a '.com' at the end. How can I grab only the first value?

  • is this a text field, text area field, or long text field?
    – cropredy
    Jan 3, 2022 at 23:21
  • Text field of 255 characters
    – Al K
    Jan 3, 2022 at 23:24
  • 2
    so -- have you tried using the FIND and LEFT operators?
    – cropredy
    Jan 3, 2022 at 23:25

1 Answer 1


This expression in formula will work in the condition and data points provided in query,

LEFT(TextArea__c, FIND('.com', TextArea__c, 0)+3)
  • 2
    What about emails ending with anything than .com? Why not search for the delimiter instead? Jan 4, 2022 at 6:53

Not the answer you're looking for? Browse other questions tagged .