0

I need to extract a part of an excel cells, but the starting chars is not always in the same position.

The rule is that I need to extract the text at the right of a determined char.

For example I need to extract the last part of email address (so after char @)

0

1 Answer 1

4

If the email address is in B1 you can use this -

=RIGHT(B1,(LEN(B1)-FIND("@",B1)))

What this does is take the number of characters in B1 (LEN) and subtracts the position of the @ character (FIND) - this gives you the number of characters to the right of the @. Now you can use the Right function to get those characters.

You can change it based on the location of your data.

3
  • 2
    It isn't required, but for the sake of improvement and value to the community, can you explain what the formula does? Per the help center: Brevity is acceptable, but fuller explanations are better.
    – CharlieRB
    Sep 3, 2015 at 16:30
  • @Tyson it works but I have to modify with " ; " instead of " , " (maybe it is cause by my regional version)
    – Ale
    Sep 4, 2015 at 9:33
  • That required substitution need does sound like it's caused by a different regional setting. @ale
    – Tyson
    Sep 4, 2015 at 14:06

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .