Formula to Extract a Certain Text

[Francoloco23]

Good day team, 

I would like to ask let's say for example I have these email addresses and I want to use a formula to get "ABC" to "ABC Company Philippines." What would be the correct formula?

For your reference, this is the formula that I am using right now. 

IF(RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email})))="abc", "abc company Philippines",IF(RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email})))="bcd","bcd",IF(RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email})))="cde",
"cde", RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email}))))))

[TheTimeSavingCo]

Sorry, I don't really understand what we're trying to do.  Could you provide an example of what you'd like the data output to be?

For example, if your input text is `name@ibex.co`,  what would you want the output to be?

[Francoloco23]

Hi Adam,

The output should be if "ibex","IBEX Global Philippines"

[TheTimeSavingCo · Accepted solution]

Hm okay, if so, try this:

IF(
  FIND(
    "ibex",
    LOWER(Name)
  ),
  "IBEX Global Philippines"
)

Link to base

[Alexey_Gusev · Accepted solution]

Hi,

you need to extract part between @ and . , then substitute it with company name if it match name from list and show unchanged email for non-matches?

that should work:

SWITCH(LOWER(
MID(Email,1+FIND('@',Email),FIND('.',Email)-FIND('@',Email)-1)),
'ibex','IBEX Global Philippines',
'alorica','Alorica',
'infosys','Infosys',
Email)

[Francoloco23]

Thank you for all the help! It worked!