get information in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.
Imagine that i have from a1:a1000 cells with email adress.
I want get all domains in that cells.

supose in A1: (e-mail address removed) A2: (e-mail address removed) A3: (e-mail address removed)

I want one formula that could me give all information after the "@". lik
tes.com, pl.com and kon.org

Because i want manager the domains in my antispam and need to know that kind
of information.

its possible ?
 
=RIGHT(A1, LEN(A1)-FIND("@",A1,1)) if A1 contains your email address.

Priya
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Excel formula referencing cells 4
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 2
Copy & Paste 1
Building closed workbook file path within an Index Function 6
excel formula 1
How to get cell coordinates? 3

Back
Top