Ask Your Question
0

Filter text (email) before @

asked 2016-06-17 17:45:48 +0200

MatthijsG gravatar image

I've to comparise 2 columns of email-addresses with different domains (the top-level, like google.com and yahoo.com).

have the same text before the @.

should give an error. How can i filter only the text before the @, when the length is different. =left isn't working on this.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-06-17 23:28:52 +0200

m.a.riosv gravatar image

Something like

=LEFT("foobar@google.com";FIND("@";"foobar@google.com")-1)

extract up to character before the first @ in the email address.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-06-17 17:45:48 +0200

Seen: 176 times

Last updated: Jun 17 '16