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
If you want to get the domains dynamically, use a formula like:
= RIGHT(A1, LEN(A1) - FIND("@", A1))
@chez_jay started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
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