Quote:
Originally Posted by skyholden
Hi All,
Very casual Excel user here.
I'm trying to accomplish two tasks with a spreadsheet containing roughly 2k email addresses: find & sort by company name(via @companyemail address).
I don't have the company name listed in a separate cell, so I can't sort by company name. I only have First, Last, and email address.
Ideally, I want my Find query to be easily sorted so I can access all email address from a specific company.
Hope this make sense.
Thanks in advance!
|
Hi, I'm not 100% sure what you're trying to do with this, but I'll punt a guess at you needing to extract the company names from email addresses in a list.
If this is the case you could either use the "text to columns" option with the @ as the separator or use a formula to extract the part of the email address between the @ and the . to give you just the company name.
If I've completely missed the point here then feel free to explain a little more.
If either of the above sound like what you need then just say and I'll help out further.