0

I'm looking for a formula to help return the below from an email domain.

Email domain: xyzcompany.co.uk

Return: "xyzcompany"

Formula I have gives me the mid and returns "co."

MID(
Email_Domain__c,
FIND(".", Email_Domain__c)+1,
FIND(".",
RIGHT( Email_Domain__c , LEN(Email_Domain__c) - FIND(".", Email_Domain__c))
)
)

1 Answer 1

1

you can try using this formular:

LEFT(Email_Domain__c, FIND(".", Email_Domain__c) - 1)

it returns everything before the first dot. Hope it helps.

1
  • Yes thank you so much
    – user114562
    Commented May 9, 2022 at 15:55

You must log in to answer this question.

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