I have a similar issue - however the part that makes my issue a little more complicated is there is not a uniform length for the text to be extracted Example

joe@place1.com

scott@place2group.com

sally.a.person@abcd.comWhat I want is to pull all information from between the @ and the . to a separate column for say company name. So basically to come back with

place1

place2group

abcdIs this possible?

Thanks

Try this =MID(A1,FIND("@",A1,1)+1,FIND(".com",A1,FIND("@",A1,1))-FIND("@",A1,1)-1)

This will work for address that use the .COM extension only.

MIKE

message edited by mmcconaghy

Here is an updated formula that does not have the .COM restriction.

Should work with any email address:=MID(A1,FIND("@",A1,1)+1,FIND(".",A1,FIND("@",A1,1))-FIND("@",A1,1)-1)

MIKE

Ask Your Question

Weekly Poll