You are reading a single comment by @MTB-Idle and its replies.
Click here to read the full conversation.
-
text to columns using @ as the criteria?
-
If you want to get the domains dynamically, use a formula like:
= RIGHT(A1, LEN(A1) - FIND("@", A1)) -
If your data is consistent it should be easy enough. Either use text to columns or
=RIGHT(A1,LEN(A1)-SEARCH("@",A1))should extract the domain from an email in A1.
hurricane_run
chez_jay
aggi
@MTB-Idle
probably a basic query but that is about my level.
I have a list of 1,000 email addresses and want to pivot them on the domain name. Is there a relatively easy way of doing this?
I don't VBA