Need only comapny name from email add

Closed
sittanshu Posts 1 Registration date Tuesday March 29, 2016 Status Member Last seen March 29, 2016 - Mar 29, 2016 at 11:14 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 29, 2016 at 11:31 AM
n excel sheet, i want only company name separately from email address column. Ex. from" mike@edwardstelecom.com " i want the company name i.e edwardstelecom in separately column

1 reply

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Mar 29, 2016 at 11:31 AM
Hi Sittanshu,

Give the following formula a try:
=MID(A2,FIND("@",A2)+1,LEN(A2)-FIND("@",A2)-4)

Best regards,
Trowa
0