Extract first name and Last name from email ID

Anonymous — Thu, 25 Jun 2020 22:39:21 GMT

Hi ,

How do I extract First name and last name from the email Id below mentioned into one column.

Re: Extract first name and Last name from email ID

mahoneypat — Fri, 26 Jun 2020 01:11:52 GMT

You can make a custom column in the query editor like this:

=Text.BetweenDelimiters(Text.AfterDelimiter([emailcolumn], "|"), "|", "@"))

If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.

Regards,

Pat