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 December 27, 2022 - 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

Need only comapny name from email add
2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
No email no password - Guide
How to add @ in laptop - Guide
How to add songs to sound picker - Guide
Hotmail email - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Subscribe To Our Newsletter!