MS Excel / VBA help thread

You are reading a single comment by @aggi and its replies. Click here to read the full conversation.

•

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

•

aggi in reply to @MTB-Idle
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.

About

@aggi started