Formula in Excel 2002

  • Thread starter Thread starter Christophe Bauters
  • Start date Start date
C

Christophe Bauters

Dear,

When I make a column in Excel with E-mail adresses, I want to have a formula
in the column next to it to take the domain name out of the E-mail adress
and put it in the second column. What is the formula fot that?

Thank you, Christophe
 
This doesn't work, because I have the Dutch version of Excel, does somebody
know what the formula is in Dutch?

Thank you, Christophe
 
If you want to get rid of the >COM or .WHATEVER, then use
=MID(A1,FIND("@",A1)+1,FIND(".",A1)-FIND("@",A1)-1)

best wishes
Bernard
 
In Help, look up the function equivalent to MID - text function that
extracts part of text
and FIND - text function that locates position of character within a text
You may need to replace commas (,) by semicolons (;)
Bernard
 
Back
Top