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 @)

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.

  • 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 '15 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 '15 at 9:33
  • That required substitution need does sound like it's caused by a different regional setting. @ale – Tyson Sep 4 '15 at 14:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.