Find & Sort

[skyholden]

Hi All

Very casual Excel user here.

I'm trying to accomplish two tasks with a spreadsheet containing roughl
2k email addresses: find & sort by company name(via @companyemai
address).

I don't have the company name listed in a separate cell, so I can't sor
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 al
email address from a specific company

Hope this make sense.

Thanks in advance

 

[Spencer101]

Hi All,

Very casual Excel user here.

I'm trying to accomplish two tasks with a spreadsheet containing roughl
2k email addresses: find & sort by company name(via @companyemai
address).

I don't have the company name listed in a separate cell, so I can't sor
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 al
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 pun
a guess at you needing to extract the company names from email addresse
in a list.

If this is the case you could either use the "text to columns" optio
with the @ as the separator or use a formula to extract the part of th
email address between the @ and the . to give you just the compan
name.

If I've completely missed the point here then feel free to explain
little more.

If either of the above sound like what you need then just say and I'l
help out further