Solved Copy Data from one Excel Cell to another column

June 23, 2017 at 14:32:46
Specs: Windows 10
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.com

What 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
abcd

Is this possible?

Thanks


See More: Copy Data from one Excel Cell to another column

Reply ↓  Report •

#1
June 23, 2017 at 15:55:53
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

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •

#2
June 23, 2017 at 16:20:40
✔ Best Answer
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

http://www.skeptic.com/


Reply ↓  Report •
Related Solutions


Ask Question