Extracting Email Address

[KamenRider]

Hi,

I attached a file where it consist of owner names and its email address in one cell being separated by a semi-colon. I have provided different scenarios and would like results to be like this:

 

Please advise.

Thanks,

Kamen

[DataNath · Accepted solution]

Hey @KamenRider there's a bunch of ways to do this but here's one. First we just split the records to a row each using Text To Columns, with semicolon as the delimiter. After that you just need to take your pick on how you want to parse really, I've used the following:

Left([Email],STRCSPN([Email],'<')-1)

REGEX_Replace([Email], '.*<([^>]+).*', '$1')

For the [Name] and [Email Add] respectively. Hope this helps!

[KamenRider]

Thanks @DataNath . You nailed it.

Kamen