Text
Extract display name and company domain from an email address
Split mailbox handles and domains around "@" with TEXTBEFORE and TEXTAFTER, and turn dot/underscore usernames into Proper Case names.
Split around "@" and clean separator punctuation
Every valid email contains a local mailbox handle before "@" and a domain after "@". TEXTBEFORE(A2, "@") isolates "elena.petrova", and TEXTAFTER(A2, "@") isolates "arte-soft.com".
Replacing dots "." and underscores "_" in the handle with spaces and wrapping in PROPER converts "elena.petrova" and "liam_chen" into readable CRM contact names ("Elena Petrova", "Liam Chen").
These examples assume a simple unquoted address with one @. They are not email validation: missing @ is only one invalid case. The generated name is a guess, and the domain does not establish a person’s employer. Quoted local parts, aliases and complex address syntax require a proper parser.
| Email (A) | Cleaned Name | Domain |
|---|---|---|
| elena.petrova@arte-soft.com | Elena Petrova | arte-soft.com |
| liam_chen@sub.example.org | Liam Chen | sub.example.org |
Name and domain extraction formulas
Wrap in IFERROR(..., "Invalid email") when auditing raw signup forms that may omit "@".
=PROPER(SUBSTITUTE(SUBSTITUTE(TEXTBEFORE(A2, "@"), ".", " "), "_", " "))Normalized lowercase domain extractor
IFERROR(TEXTAFTER(LOWER(A2), "@"), "Invalid email") normalizes mixed-case domains first and catches missing "@" delimiters directly.
=IFERROR(TEXTAFTER(LOWER(A2), "@"), "Invalid email")Try the example
Use the original values or change them to test your understanding.