Extrat server address Email

azerty64
azerty64 ✭✭
edited 10/28/22 in Formulas and Functions

Hello,

I cannot extract the server address from an email address. Can you help me ?

Ex : xxxx.xxxx@grdf-txt.com

I want to extract "grdf-txt"

My formula : =UPPER(MID(LEFT(Email@row; FIND("."; Email@row) - 1); FIND("@"; Email@row) + 1; LEN(Email@row)))

This formula works but only for the following format xxxxxx@grdf-txt.com

Thank you


Cordialy,

azerty64

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓

    @azerty64

    Here's another version which deals with both .com and .org email addresses in case someone has a .org email address:

    =IFERROR(MID(email@row, FIND("@", email@row) + 1, FIND(".com", email@row) - FIND("@", email@row) - 1), MID(email@row, FIND("@", email@row) + 1, FIND(".org", email@row) - FIND("@", email@row) - 1))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!