Finding the Country from an Email address.

[jony663]

I have an email list that I am trying to extract the country information. How do I extract the information after the @ symbol and the last "."

me@myemail.co.in
I am looking to have the .in pulled

me@myemail.se
I am looking to have the .se pulled

<style> <!-- /* Font Definitions */ @font-face {font-family:Times; panose-1:2 0 5 0 0 0 0 0 0 0; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 0 0 0 1 0;} @font-face {font-family:"ＭＳ 明朝"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:128; mso-generic-font-family:roman; mso-font-formatther; mso-font-pitch:fixed; mso-font-signature:1 134676480 16 0 131072 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 0 0 0 1 0;} @font-face {font-family:Cambria; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 0 0 0 1 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"ＭＳ 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"ＭＳ 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} --> </style> [FONT=&quot]Any help is appreciated.[/FONT]

 

[Gerald Higgins]

Hi, welcome to the board.

Is it ALWAYS the last 2 characters ?
If it is, then

=right(a1,2)

 

[jony663]

Thank you but that does not solve also having the .com shown as well.

Hi, welcome to the board.

Is it ALWAYS the last 2 characters ?
If it is, then

=right(a1,2)

 

[Gerald Higgins]

Well like I said, is it always the last 2 characters ?
If not, you need something else.

IF it's always the last two characters, but you want to exclude COM, then try this

=if(right(a1,3)="COM","",right(a1,2))

This will return a blank if the address ends in COM, and otherwise will return the last 2 columns.

But I'm guessing there are other examples of endings that you don't want to show, so why don't you tell us what they are ?

 

[jony663]

Thank you very much.
Jon