Separate domain name

[Murad_]

Hi All,
I want to ask how can I separate in excel sheet the domain name after "@" and before ".", I have table of email addresses as follows:

john@xyz.com
john123@yah.org
raw348@zyx.com

let say for the first one, how can I separate xyz in separate column??

Appreciate your advise.
Thank you.

 

[Aladin Akyurek]

You might get away with:

=REPLACE(LEFT(A2,FIND(".",A2)-1),1,FIND("@",A2),"")

 

[Murad_]

Thank you Aladin,

what in case there is "." in the first part, like:

xyz.abc@all.com
appreciate your help.

 

[Aladin Akyurek]

Thank you Aladin,

what in case there is "." in the first part, like:

xyz.abc@all.com
appreciate your help.

Try...

=LEFT(REPLACE(A2,1,FIND("@",A2),""),FIND(".",REPLACE(A2,1,FIND("@",A2),""))-1)

 

[Murad_]

Thank you Aladin
I have tried it but got the following message:
" We found a problem with this formula. Try clicking Insert Function on the Formulas tab to fix it, or click Help for more info on common formula problems.
Not trying to type a formula?
When the first character is an equal (=) or minus (-) sign, Excel thinks it’s a formula:
.you type: =1+1, Cell shows: 2
To get around this, type an apostrophe (‘) first:
.you type: ‘=1+1, cell shows: =1+1"

I have checked the iterative calculation, it is enabled.

Appreciate your help

 

[Aladin Akyurek]

Here again...

=LEFT(REPLACE(A2,1,FIND("@",A2),""),FIND(".",REPLACE(A2,1,FIND("@",A2),""))-1)

 

[lwcorp]

FYI, FIND(".", ...) means it will extract sub domains if such exist. this@foo.bar.com will output foo, not bar.