Extrat server address Email

azerty64

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

Mike TV

@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))

Mike TV

@azerty64

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

Mike TV

@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))

azerty64

https://community.smartsheet.com/discussion/comment/349222#Comment_349222

Hello @Mike TV ,

Thank's it's perfect.

Have a nice day !!!