@Companies.com to extract

[Anonymous]

Hi,

Have column with list of email id's

need to have only the text between @ and .com Example: AAA@gmail.com. Need formula to extract only 'Gmail' from this email id.

Not only Gmail have many list of companies ID.

I have tried with mid(EmailIdcolumn,Find("@",EmailIdColumn+1),Find(".com",EmailIdColumn)-Find("@",EmailIdColumn)-1) 

But getting error :the  Text provided to function 'FInd' could not be found in the given text.

[v-shex-msft · Accepted solution]

Hi @Anonymous,

You can simply use SUBSTITUTE and PATHITEM function to find out email name from email address.

Calculate column formula:

Middle =
PATHITEM ( SUBSTITUTE ( SUBSTITUTE ( [Email], "@", "|" ), ".", "|" ), 2 )

Result:

Regards,

Xiaoxin Sheng