Extract first name and Last name from email ID

[Anonymous]

Hi ,

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

[mahoneypat · Accepted solution]

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