Wild card filtering ...

[adambc]

I have a (long) list that contains email addresses in the formats ...

firstname.surname@domain.com

... and ...

initialsurname@domain.com

I want to separate them into two separate lists, but filtering doesn't support wildcards, so filtering (both ways) on *.*@domain.com doesn't work ...

Is there another way?

Thanks ...

 

[johnny51981]

What method are you looking to use? Auto Filter, VBA, Power Query?

 

[RoryA]

Filters do support wildcards, so I'm not sure what the issue is.

 

[adambc]

Filters do support wildcards, so I'm not sure what the issue is.

@RoryA

Hhhmmm, it sort of worked this time!!!

But ...

*.*@domain.com gave me the firstname.surname@domain.com list

*.domain.com gave me both

Got any thoughts how I can get the initialsurname@domain.com list?

Thanks ...

 

[adambc]

What method are you looking to use? Auto Filter, VBA, Power Query?

I was trying simple filtering in Excel first ...

 

[RoryA]

Filter for does not contain *.*@domain.com

 

[adambc]

Filter for does not contain *.*@domain.com

@RoryA

Sorry, should have added, the original list contains multiple domain names - but I've already worked out how to do it ie filter out @domain.com first, then apply contains/does not contain *.*

Thanks ...